Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

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

https://forums.devart.com/viewtopic.php?f=1&t=35080

Page 1 of 2

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

Posted: Tue 07 Mar 2017 13:45
by bharaniKumar
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:

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

Posted: Tue 07 Mar 2017 14:07
by alexa
Could you please provide us the full name of the product and its version?

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

Posted: Wed 08 Mar 2017 05:42
by bharaniKumar
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?

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

Posted: Wed 08 Mar 2017 05:43
by bharaniKumar
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?

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

Posted: Thu 09 Mar 2017 10:02
by bharaniKumar
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>

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

Posted: Thu 09 Mar 2017 10:04
by bharaniKumar
sample data first call works fine second call throws error

like Input string was not correct format
or
value cannot be null

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

Posted: Tue 14 Mar 2017 17:24
by Shalex
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?

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

Posted: Mon 27 Mar 2017 12:44
by bharaniKumar
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..........

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

Posted: Mon 27 Mar 2017 12:44
by bharaniKumar
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..........

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

Posted: Tue 28 Mar 2017 13:40
by Shalex
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.

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

Posted: Mon 26 Jun 2017 10:35
by dcoracle600pro
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 !!!

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

Posted: Fri 30 Jun 2017 17:39
by Shalex
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.

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

Posted: Thu 06 Jul 2017 10:05
by dcoracle600pro
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.

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

Posted: Thu 06 Jul 2017 10:54
by Shalex
Thank you for confirming the fix.

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

Posted: Fri 08 Jun 2018 07:55
by dcoracle600pro
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
All times are UTC
Page 1 of 2
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/