Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
bharaniKumar
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by bharaniKumar » Tue 07 Mar 2017 13:45

System.FormatException was caught
HResult=-2146233033
Message=Input string was not in a correct format.
Source=mscorlib
StackTrace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Int64.Parse(String s, IFormatProvider provider)
at Devart.Data.Oracle.z.aa(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.n.aq(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.n.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.z.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.d7.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.OracleDataReader.GetInt32(Int32 i)
at MaterializeACTIVE_REPORTS_CONTEXT(MaterializerScope )
at Devart.Data.Linq.Engine.ObjectReader`1.a()
at Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
at Devart.Data.Linq.Engine.ObjectReader`1.c()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at G2_BackOffice.Models.ReportsModel.GetExportData(Int64 idFilter, Int64 idLanguage, Decimal idShop) in D:\devart Latest 9.2 version app\G2_BackOffice\G2_BackOffice\G2_BackOffice\Models\ActiveReport\ReportsModel.cs:line 320
InnerException:
Top
alexa

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by alexa » Tue 07 Mar 2017 14:07

Could you please provide us the full name of the product and its version?
Top
bharaniKumar
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by bharaniKumar » Wed 08 Mar 2017 05:42

ADO.NET providers for database dotConnect for Oracle

Devart.Data 5.0.1629.0
Devart.Data.Linq 4.5.1174.0
Devart.Data.Oracle 9.2.172.0 and 9.2.205.0
Devart.Data.Oracle.Entity.EF6 9.2.172.0 and 9.2.205.0


(previously we are using devart 6.0 version. In application have using to mapping with help of system.data dll's
but now when we are upgrade the devart 9.2 version ve using own dll to mapping the tables or rows of the data. Now only we face issue in this type we tried so many ways but we face the same issue)

Scenario is We have calling a package twice in a page first time its never get error works fine later same page click a download link calling the same package using same select with extra data columns it will get error.

We tried another way to create duplicate iqml file call first in one of the iqml(firstdatacontest.iqml) file and another call in duplicate iqml (seconddatacontext.iqml) file its works fine but we are not able to do in our client application

So please can you address me the what's the problem?
Last edited by bharaniKumar on Wed 08 Mar 2017 06:13, edited 1 time in total.
Top
bharaniKumar
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by bharaniKumar » Wed 08 Mar 2017 05:43

alexa wrote:Could you please provide us the full name of the product and its version?
ADO.NET providers for database dotConnect for Oracle

Devart.Data 5.0.1629.0
Devart.Data.Linq 4.5.1174.0
Devart.Data.Oracle 9.2.172.0 and 9.2.205.0
Devart.Data.Oracle.Entity.EF6 9.2.172.0 and 9.2.205.0


(previously we are using devart 6.0 version. In application have using to mapping with help of system.data dll's
but now when we are upgrade the devart 9.2 version ve using own dll to mapping the tables or rows of the data. Now only we face issue in this type we tried so many ways but we face the same issue)

Scenario is We have calling a package twice in a page first time its never get error works fine later same page click a download link calling the same package using same select with extra data columns it will get error.

We tried another way to create duplicate iqml file call first in one of the iqml(firstdatacontest.iqml) file and another call in duplicate iqml (seconddatacontext.iqml) file its works fine but we are not able to do in our client application

So please can you address me the what's the problem?
Top
bharaniKumar
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by bharaniKumar » Thu 09 Mar 2017 10:02

class Program
{
static void Main(string[] args)
{
try
{



string sErrorCode = string.Empty;
string sMessage = string.Empty;

List<ACTIVE_REPORTS> resultset = new List<ACTIVE_REPORTS>();
List<CUSTOMFILTERS> resultCustomFilters = new List<CUSTOMFILTERS>();

Devart.Data.Linq.IMultipleResults result = null;
Devart.Data.Linq.IMultipleResults resultsets = null;
DataSet dataSetExportData = new DataSet("ExportData");
COMPANYSCMDataContext db = null;

try
{
db = new COMPANYSCMDataContext(ConfigurationManager.ConnectionStrings["COMPANYSCMDataContextConnectionString"].ToString());

result = db.GETEMPLOYEEDETAILS(Convert.ToDecimal(2), null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, Convert.ToDecimal(2105), Convert.ToDecimal(2), string.Empty, string.Empty, "SEARCH_REPORT", 0, 0, null, null, null, null, null, out sErrorCode, out sMessage);

if (!string.IsNullOrWhiteSpace(sErrorCode))
{
}
else
{
resultset = result.GetResult<ACTIVE_REPORTS>().ToList();
resultCustomFilters = result.GetResult<CUSTOMFILTERS>().ToList();
List<SUMMARY_DETAILS> resultSummary = result.GetResult<SUMMARY_DETAILS>().ToList();
}

//Converting list to data table

db = new COMPANYSCMDataContext(ConfigurationManager.ConnectionStrings["COMPANYSCMDataContextConnectionString"].ToString());

resultsets = db.GETEMPLOYEEDETAILS(Convert.ToDecimal(2), null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, Convert.ToDecimal(2105), Convert.ToDecimal(2), string.Empty, string.Empty, "EXPORT", 0, 0, null, null, null, null, null, out sErrorCode, out sMessage);

if (!string.IsNullOrWhiteSpace(sErrorCode))
{
}
else
{
resultset = result.GetResult<ACTIVE_REPORTS>().ToList();
resultCustomFilters = result.GetResult<CUSTOMFILTERS>().ToList();
List<SUMMARY_DETAILS> resultSummary = result.GetResult<SUMMARY_DETAILS>().ToList();
}
}
catch (Exception)
{
throw;
}



}
catch (Exception ex)
{

throw;
}
Console.ReadLine();
}
}

---------------------------------------------------------

<?xml version="1.0" encoding="utf-8"?>
<Database Name="COMPANY_SCM" EntityNamespace="COMPANYSCMContext" ContextNamespace="COMPANYSCMContext" Class="COMPANYSCMDataContext" xmlns:ed="http://devart.com/schemas/EntityDeveloper/1.0" ed:Guid="3ba7fe19-35ce-4d9b-952f-c4d91572f1a6" Provider="Devart.Data.Oracle.Linq.Provider.OracleDataProvider, Devart.Data.Oracle.Linq" Extended="true" xmlns="http://schemas.devart.com/linqconnect/mapping">
<Connection Mode="ConnectionString" ConnectionString="User Id=COMPANY_SCM;Server=company;Persist Security Info=False" Provider="Devart.Data.Oracle" />
<Type Name="ACTIVE_REPORTS" ed:Guid="ece84fd8-c2a5-436e-a039-b262991639a0">
<Column Member="ID" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="34515003-fcc2-484a-a988-9b3f7d1b97e9" />
<Column Member="PayMethod" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="58583ad4-1532-401c-b224-59bfc58d1028" />
<Column Member="AutDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="176b3923-1edd-4272-9616-d70868af7593" />
<Column Member="State" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="a25918bf-284d-4658-a63a-68ef016237df" />
<Column Member="ShopID" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="bad936a2-25b1-4b02-9b4e-de51b187be51" />
<Column Member="BankID" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="a9d7c6e4-5d20-4d98-b557-cf8e4d68f3c9" />
<Column Member="Approved" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="276b3643-5c6d-4d3c-88c9-f4ff01295b66" />
<Column Member="AuthorizationCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="7344cafe-ccae-4b64-8a95-929542d988f2" />
<Column Member="CurrencyCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="6e932b24-91b4-4945-a7b0-3df36eca6a1d" />
<Column Member="Country" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f3c27585-4051-4ab7-8561-0fb371e93d8b" />
<Column Member="AutAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="fba0db05-e81e-4d43-84fe-c8a1e44b258b" />
<Column Member="EnvironmentCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="ecdc52bb-01de-4ea5-9999-8ec495a00380" />
<Column Member="PayType" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9c295231-60f7-4d72-8629-14351afdd852" />
<Column Member="PMDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="eea556db-ce35-457f-94ad-48004196dadb" />
<Column Member="FDDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="be0a9433-8814-4271-b7ec-ccc5337242de" />
<Column Member="CurrentAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5d4fe186-d96e-4a3b-8e11-ce720076e783" />
<Column Member="Balance" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="74c42655-56cd-47c7-b25f-ff82565c61cb" />
<Column Member="Alert" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="496660b7-5550-4ed9-9401-dc87a079d43d" />
<Column Member="AlertDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="178c2cb8-ce7c-455d-90c1-3c90efdfcd70" />
<Column Member="VBV" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="383c6a2e-7de3-4eb7-bcd8-6b380fb9278a" />
<Column Member="HolderName" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f46b50ec-c945-4468-97fc-5d652b2cf223" />
<Column Member="HolderEmail" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="0faf02fb-3039-4fc9-82e4-830254c1455b" />
<Column Member="ErrorCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="263e90cd-4072-4025-b1cd-3650cce143fc" />
<Column Member="PercentageFee" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="d780135f-db9b-40f6-9ad2-27a56f852880" />
<Column Member="MovementAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="78a49e4e-2333-4a54-85bf-a0403e6072c9" />
<Column Member="MovementDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="33921a29-db42-40a3-bf06-fae457b678a4" />
<Column Member="MovementEnvironment" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f9166417-c824-4f1a-8461-b89a2b3e32ac" />
<Column Member="CancelledAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="c1fd2111-6e67-4c57-9463-0cf3bf79fb72" />
<Column Member="CancelledDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="724f764b-6e88-47d2-b469-e16c2ecfb706" />
<Column Member="CancelledEnv" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="b43699ca-cfc0-45e5-b483-993a4f5e67d0" />
<Column Member="PayTypeDescr" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="12d54a17-0125-4026-99b3-b0fb10e87127" />
<Column Member="DataAuhonicatet" Type="System.DateTime" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9615f761-b0e1-4c19-b6cf-bb0f85d9bde5" />
<Column Member="VerifyResult" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="3096e000-66ed-4e26-9ce6-2ee885431f0b" />
<Column Member="Event" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5452213e-5025-499b-b973-31c30c9f539c" />
<Column Member="DateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="50451560-3150-4c58-bb67-8b90d60742dd" />
<Column Member="Amount" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="472aa8b1-fe30-4b7c-9d62-45090f41fb5a" />
<Column Member="FraudResponse" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9dde1438-477d-48ad-b6a5-9ae0cb265ea9" />
<Column Member="Percentageamount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="ff2b43e1-43d0-4a3b-8d71-53d8f6435069" />
<Column Member="IMAGE" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="dfe1b410-51e6-471f-a1c0-d28492350d60" />
<Column Member="MethodID" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="31ac8937-d4e5-4d97-b49b-fd71ab3b56bf" />
<Column Member="EnableAlert" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9d1cc127-63f9-4172-9830-76c0b3ac7532" />
<Column Member="ChargeBack" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5ba55e40-a902-47b5-a362-b968ebf71521" />
</Type>
<Type Name="CUSTOMFILTERS" ed:Guid="1df54f77-f09b-4abf-b20d-28bae1cfc0d7">
<Column Member="IDFILTER" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="99559747-2843-451e-bf27-a561b0b2e62f" />
<Column Member="IDFIELD" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="d8800dc9-f6b4-40a7-bf83-ef8fc0b7c025" />
<Column Member="FIELDVALUE" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="57fb3b63-9131-4521-9367-b13c7a38305c" />
<Column Member="IDTRANSACTION" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="375b744f-f6a0-4b54-80e5-4ca5bfa0ee6b" />
<Column Member="FIELDNAME" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="e8083332-5906-450f-a514-8bffc1a734ad" />
<Column Member="FIELDLABEL" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="8c3a1def-0182-455c-a490-cd4af6361dee" />
</Type>
<Type Name="SUMMARY_DETAILS" ed:Guid="c943324e-bbe7-4766-8ec5-d37618f62261">
<Column Member="TotalAutAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="afbd2d1f-4de5-4059-a9d2-3b75b9bd8d4a" />
<Column Member="TotalBalance" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9443e05e-842a-40d7-b4a3-065ab2e0cc59" />
<Column Member="TotalRecords" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="b7a7b571-bf05-40e7-b586-2a2d46871ea3" />
</Type>
<Function Name="ACTIVE_DATA_COMPANY_EMPLOYEE" Method="PRGETCOMPANYDETAILS" ed:Guid="48da574c-34d0-433a-a0b1-10df0500903b">
<Parameter Name="IDFILTER_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="FROMDATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="TODATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="DATERANGE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="AUT_AMOUNT_FROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="MOV_AMOUNT_FROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="AUT_AMOUNT_TO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="MOV_AMOUNT_TO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="TRANSACTIONTYPE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="UICCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="BANKTRXID_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="APPROVEDTRANSACTION_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="SHOPTRXID_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ERRORCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="AUTHORIZATIONCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="PAYMENTMETHOD_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="ALERT_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="TRANSACTIONSTATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="THREEDLEVEL_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="RED_FRAUDRESPONSE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="IDSHOP_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="IDLANGUAGE_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="CUSTOMFIELDSID_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="CUSTOMFIELDSVALUE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="GETRESULTSFOR_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ROWNUMFROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="ROWNUMTO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="CHARGEBACK_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="FRAUD_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="SORTBY_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="SORTDIR_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ROWFILTERDATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="OUT_ERRORCODE" Type="System.String" DbType="VARCHAR2(4000 CHAR)" Direction="Out" />
<Parameter Name="OUT_ERRORMESSAGE" Type="System.String" DbType="VARCHAR2(4000 CHAR)" Direction="Out" />
<ElementType Type="ACTIVE_REPORT" />
<ElementType Type="CUSTOMFILTERS />
<ElementType Type="SUMMARY_DETAILS" />
</Function>
</Database>
Last edited by bharaniKumar on Thu 09 Mar 2017 10:26, edited 2 times in total.
Top
bharaniKumar
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by bharaniKumar » Thu 09 Mar 2017 10:04

sample data first call works fine second call throws error

like Input string was not correct format
or
value cannot be null
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by Shalex » Tue 14 Mar 2017 17:24

Could you please try to localize the issue and send us a small complete test project with the corresponding DDL/DML script for reproducing the problem in our environment?
Top
bharaniKumar
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by bharaniKumar » Mon 27 Mar 2017 12:44

Shalex wrote:Could you please try to localize the issue and send us a small complete test project with the corresponding DDL/DML script for reproducing the problem in our environment?
Hi Shalex,

I will give some sample what we have tried before..........
Top
bharaniKumar
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by bharaniKumar » Mon 27 Mar 2017 12:44

Shalex wrote:Could you please try to localize the issue and send us a small complete test project with the corresponding DDL/DML script for reproducing the problem in our environment?
Hi Shalex,

I will give some sample what we have tried before..........
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by Shalex » Tue 28 Mar 2017 13:40

bharaniKumar wrote:I will give some sample what we have tried before..........
Please notify here after submitting a small complete test project with the corresponding DDL/DML script for reproducing.
Top
dcoracle600pro
Posts: 51
Joined: Mon 09 Apr 2012 09:57

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by dcoracle600pro » Mon 26 Jun 2017 10:35

We have the same problem with our version (see our post viewtopic.php?f=1&t=33504) :
- Devart.Data 5.0.1408.0
- Devart.Data.Linq 4.5.954.0
- Devart.Data.Oracle 8.5.616.0
- Devart.Data.Oracle.Linq 8.5.616.0 EF1

The problem appears on Linq resquest only.
It's very difficult to find the origin, because in our case, it appears sometimes and not everytimes.

When we have this problem, with put the Linq resquest in a var, and after we execute the instruction .ToList() into another variable.

Exemple - Error :

Code: Select all

var q = from a in ObjectContext.Toto
            join b in ObjectContext.Tata on a.Id equals b.Id
            select new CustomObject
            {
                  Id = a.Id,
                  Code = a.Code,
                  Date = b.Date
            };
Exemple - Without error :

Code: Select all

var q1 = from a in ObjectContext.Toto
              join b in ObjectContext.Tata on a.Id equals b.Id
              select new { A1 = a, B1 = b };

var q2 = from a in q1.ToList()
              select new CustomObject
              {
                    Id = a.A1.Id,
                    Code = a.A1.Code,
                    Date = a.B1.Date
              };
// WORKS !!!
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by Shalex » Fri 30 Jun 2017 17:39

Is a stack trace in the described scenario exactly the same like specified at viewtopic.php?f=1&t=33504#p120070? We still cannot reproduce the issue in our environment.
Top
dcoracle600pro
Posts: 51
Joined: Mon 09 Apr 2012 09:57

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by dcoracle600pro » Thu 06 Jul 2017 10:05

I think the bug is solved in 9.4 :
LinqConnect support
The bug with running LINQ queries, which invoke .NET methods on client side during materialization of result set, is fixed
The bug with materializing scalar value collection when converting values on the client side is fixed

I have upgraded my application with 9.4 and I cannot reproduce the problem.
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously

Post by Shalex » Thu 06 Jul 2017 10:54

Thank you for confirming the fix.
Top
dcoracle600pro
Posts: 51
Joined: Mon 09 Apr 2012 09:57

Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previou

Post by dcoracle600pro » Fri 08 Jun 2018 07:55

The problem seams to still here !
In december 2017, I upgraded my version of devart to 9.4.299 (A fix was present in this release for LinqConnect issues) but it is still here.

I open Visual studio 2010. I launch my application and all working !
I stop my debugging, I compile/recompile my program again, I relaunch it, and this issue appears.

In my case, the problem is always on a DateTime properties (TIMESTAMP(6) NOT NULL in my Oracle database).
The framework installed is 4.7.02053.
The framework used on my application is 4.5.

I would like to precise too, that this issue appears in production environnement (application installed and download with clickonce).

https://image.noelshack.com/fichiers/20 ... 094335.jpg
Top
Post Reply

Return to “dotConnect for Oracle”