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

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

Postby 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:
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

Postby alexa » Tue 07 Mar 2017 14:07

Could you please provide us the full name of the product and its version?
alexa
Devart Team
 
Posts: 2135
Joined: Fri 24 Jun 2011 14:17

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

Postby 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.
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

Postby 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?
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

Postby 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.
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

Postby 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
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

Postby 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?
Shalex
Devart Team
 
Posts: 7839
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

Postby 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..........
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

Postby 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..........
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

Postby 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.
Shalex
Devart Team
 
Posts: 7839
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

Postby dcoracle600pro » Mon 26 Jun 2017 10:35

We have the same problem with our version (see our post http://forums.devart.com/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 !!!
dcoracle600pro
 
Posts: 43
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

Postby Shalex » Fri 30 Jun 2017 17:39

Is a stack trace in the described scenario exactly the same like specified at http://forums.devart.com/viewtopic.php?f=1&t=33504#p120070? We still cannot reproduce the issue in our environment.
Shalex
Devart Team
 
Posts: 7839
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

Postby 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.
dcoracle600pro
 
Posts: 43
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

Postby Shalex » Thu 06 Jul 2017 10:54

Thank you for confirming the fix.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle