TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
heidenbluth
Posts: 56
Joined: Mon 08 Nov 2004 19:01
Location: Germany

TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by heidenbluth » Tue 07 Jan 2020 21:01

Hello,

There is a serious problem with ODAC 11.1.2 that did not exist with ODAC 10.3.9.
You can reproduce it easily by following these steps:
* Use Delphi XE 10.3.3 and Oracle 19c (SQL*Net connection)
* Create a new application
* Add a TOraSession, TLoginDialog, TSmartQuery, TOraDatasource and TDBGrid component and connect components with each other.
* Connect to HR schema
* Set SQL to SELECT COUNTRY_ID, COUNTRY_NAME, REGION_ID FROM COUNTRIES

Add a TButton and implement the Button.OnClick event as follows:

Code: Select all

  OraSession1.Connect;
  SmartQuery1.NonBlocking := True;
  SmartQuery1.ObjectView := True;
  SmartQuery1.FetchRows := 2000;
  SmartQuery1.Prepare;
  SmartQuery1.Active := True;
Run the application, and click the button
==> It produces ORA-01002 fetch out of sequence error!

Please help.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by MaximG » Sat 11 Jan 2020 14:14

Thank you for the information. We will investigate the described issue and let you know the results shortly.

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by dados » Wed 29 Jan 2020 12:00

I have the same issue with version 11.1.2 on Delphi 10.2.3
Downgraded to version 11.0.1 and that version does not throw this error

I'm using TOraQuery - Direct connect / NET
FetchAll := true;
ReadOnly := true;
NonBlocking := true;
Open; -> Error, but not everytime but more than 50%
This error only occurs for me when compiled as Release, newer in Debug

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by MaximG » Fri 31 Jan 2020 16:13

Please create and send us the source code of example that results in an error when you run it in your test environment. This will help us reproduce the behavior and find a solution. For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

heidenbluth
Posts: 56
Joined: Mon 08 Nov 2004 19:01
Location: Germany

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by heidenbluth » Fri 31 Jan 2020 17:23

Sample has been sent.

sbslavonac
Posts: 35
Joined: Mon 02 Apr 2007 09:14

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by sbslavonac » Wed 05 Feb 2020 07:46

Same here, Delphi 10.3.2 ODAC 11.1.2., Oracle 12c
From what I know it happens on 12c, users on Oracle 11 are not complaining.

From error log:
Exception class: EOraError
Exception message: ORA-01002: fetch out of sequence
.
Exception address: 00D5EEB1
------------------------------------------------------------------------------
Main thread ID = 3576
Exception thread ID = 3576
------------------------------------------------------------------------------
Exception stack
Stack list, generated 05.02.2020 5:24:10
[00D5EEAC]{TouchPos.exe} OraClasses.TOCIConnection.OraError
[00D6B748]{TouchPos.exe} OraClasses.TOCICommand.Check
[00D70631]{TouchPos.exe} OraClasses.TOCICommand.InternalFetch
[00D7F19E]{TouchPos.exe} OraClasses.TOCIRecordSet.FetchArray
[00D7D2AE]{TouchPos.exe} OraClasses.TOCIRecordSet.InternalFetch
[00C9688E]{TouchPos.exe} CRAccess.TCRRecordSet.GetNextRecord
[00C1D168]{TouchPos.exe} MemDS.TMemDataSet.GetRecord
[0094650C]{TouchPos.exe} Data.DB.TDataSet.GetNextRecord
[009463E3]{TouchPos.exe} Data.DB.TDataSet.UpdateBufferCount
[00DB8638]{TouchPos.exe} Ora.TOraDataSet.OpenCursor
[00CC1421]{TouchPos.exe} DBAccess.TCustomDADataSet.SetActive

heidenbluth
Posts: 56
Joined: Mon 08 Nov 2004 19:01
Location: Germany

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by heidenbluth » Wed 12 Feb 2020 21:00

Any news regarding a fix?
It is more than 3 months ago now that I reported the bug including step by step instructions to reproduce.
Could you please provide an update that fixes the problem?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by MaximG » Fri 21 Feb 2020 17:04

We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night ODAC build including the required changes. For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by MaximG » Mon 19 Jul 2021 09:23

Kindly note that have released a new version of ODAC that contains the fix: https://www.devart.com/odac/download.html

heidenbluth
Posts: 56
Joined: Mon 08 Nov 2004 19:01
Location: Germany

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by heidenbluth » Mon 19 Jul 2021 09:30

Thank you

Post Reply