Devart Forums

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

Problem with Nonblocking mode

https://forums.devart.com/viewtopic.php?f=5&t=13519

Page 1 of 1

Problem with Nonblocking mode

Posted: Thu 27 Nov 2008 13:44
by djast
From time to time I receive an error when opening OraQuery.
The problems are only in NonBlocking mode. Belowe are some examples.
Have you got any suggestions?
I'm using D7 Ent, ODAC v.6.50.0.39.
Exception class: EAccessViolation
Exception message: Access violation at address 40006E78 in module 'rtl70.bpl'. Read of address

00000790.
Exception address: 40006E78
------------------------------------------------------------------------------
Stack list, generated 27/11/2008 12:27:11
(00005E78){rtl70.bpl } [40006E78] System.@LStrAsg + $4
(0000E432){dbrtl70.bpl } [4033F432] Db.TFieldDef + $42
(00022825){dac70.bpl } [00B43825] Memds.TMemDataSet.CreateFieldDefs + $15D
(000054E2){rtl70.bpl } [400064E2] System.@HandleFinally + $2A
(00021AFA){dac70.bpl } [00B42AFA] Memds.TMemDataSet.InternalOpen + $42
(0003C2BE){dac70.bpl } [00B5D2BE] Dbaccess.TCustomDADataSet.InternalOpen + $C6
(000054E2){rtl70.bpl } [400064E2] System.@HandleFinally + $2A
(0006B364){odac70.bpl } [00AAC364] Ora.TOraDataSet.InternalOpen + $14
(0001B155){dbrtl70.bpl } [4034C155] Db.TDataSet.DoInternalOpen + $19
(0001B20E){dbrtl70.bpl } [4034C20E] Db.TDataSet.OpenCursor + $1E
(00021DF2){dac70.bpl } [00B42DF2] Memds.TMemDataSet.OpenCursor + $A
(00036A22){dac70.bpl } [00B57A22] Dbaccess.TCustomDADataSet.OpenCursor + $1A2
(00036B31){dac70.bpl } [00B57B31] Dbaccess.TCustomDADataSet.OpenCursor + $2B1
(0006ABA8){odac70.bpl } [00AABBA8] Ora.TOraDataSet.OpenCursor + $0
(0001B0C9){dbrtl70.bpl } [4034C0C9] Db.TDataSet.SetActive + $55
(0003686D){dac70.bpl } [00B5786D] Dbaccess.TCustomDADataSet.SetActive + $3D
(0001AF14){dbrtl70.bpl } [4034BF14] Db.TDataSet.Open + $4
(000D4EE5){iforce1.exe } [004D5EE5] Transactions.TfrmTransactions.FormCreate (Line 350,

"Transactions.pas" + 26) + $6
(0009C9A1){vcl70.bpl } [0097D9A1] Forms.TCustomForm.DoCreate + $31
(0009C681){vcl70.bpl } [0097D681] Forms.TCustomForm.AfterConstruction + $11
(000050E7){rtl70.bpl } [400060E7] System.@AfterConstruction + $7
(0009C658){vcl70.bpl } [0097D658] Forms.TCustomForm + $174
(0003D038){rtl70.bpl } [4003E038] Classes.TDataModule.WriteHeight + $20
(000A1F67){vcl70.bpl } [00982F67] Forms.TScreen.GetForm + $B
(0009DE3E){vcl70.bpl } [0097EE3E] Forms.TCustomForm.GetMDIChildCount + $32
(0000A727){IFUtils.bpl } [00CAB727]
(000D4B77){iforce1.exe } [004D5B77] Transactions.ShowForm (Line 260, "Transactions.pas" + 8) + $11
(00147A83){iforce1.exe } [00548A83] main.TMainForm.aTransViewEditExecute (Line 684, "main.pas" + 1) +

$0
(0003C37B){rtl70.bpl } [4003D37B] Classes.TBasicAction.Execute + $F
(0008C4A9){vcl70.bpl } [0096D4A9] Actnlist.TContainedAction.Execute + $31
(0008D16B){vcl70.bpl } [0096E16B] Actnlist.TCustomAction.Execute + $4F
(0003C24F){rtl70.bpl } [4003D24F] Classes.TBasicActionLink.Execute + $13
(0009396F){vcl70.bpl } [0097496F] Menus.TMenuItem.Click + $8F
(00094E33){vcl70.bpl } [00975E33] Menus.TMenu.DispatchCommand + $13
(0009F86F){vcl70.bpl } [0098086F] Forms.TCustomForm.WMCommand + $1F
(00080A98){vcl70.bpl } [00961A98] Controls.TControl.WndProc + $188
(00083C97){vcl70.bpl } [00964C97] Controls.TWinControl.WndProc + $157
(00083BC9){vcl70.bpl } [00964BC9] Controls.TWinControl.WndProc + $89
(0009D87D){vcl70.bpl } [0097E87D] Forms.TCustomForm.WndProc + $421
(0002EE98){rtl70.bpl } [4002FE98] Classes.TThreadList.UnlockList + $4
(0000A2D8){vcl70.bpl } [008EB2D8] Graphics.FreeMemoryContexts + $98
(00083914){vcl70.bpl } [00964914] Controls.TWinControl.MainWndProc + $2C
(00083929){vcl70.bpl } [00964929] Controls.TWinControl.MainWndProc + $41
(0003D038){rtl70.bpl } [4003E038] Classes.TDataModule.WriteHeight + $20
(00083C97){vcl70.bpl } [00964C97] Controls.TWinControl.WndProc + $157
(0009D87D){vcl70.bpl } [0097E87D] Forms.TCustomForm.WndProc + $421
(0002EE98){rtl70.bpl } [4002FE98] Classes.TThreadList.UnlockList + $4
(0000A2D8){vcl70.bpl } [008EB2D8] Graphics.FreeMemoryContexts + $98
(00083914){vcl70.bpl } [00964914] Controls.TWinControl.MainWndProc + $2C
(0003D038){rtl70.bpl } [4003E038] Classes.TDataModule.WriteHeight + $20
(00045B72){rtl70.bpl } [40046B72] Contnrs.TComponentList.GetItems + $A
(000CF6AD){vcl70.bpl } [009B06AD] Appevnts.TCustomApplicationEvents.DoMessage + $D
(000A468B){vcl70.bpl } [0098568B] Forms.TApplication.ProcessMessage + $83
(000A46C2){vcl70.bpl } [009856C2] Forms.TApplication.HandleMessage + $A
(000A48F2){vcl70.bpl } [009858F2] Forms.TApplication.Run + $96
(0016CEAB){iforce1.exe } [0056DEAB] iforce1.iforce1 (Line 223, "C:\projekty\iforce1_2300\iforce1.dpr"

+ 17) + $2
qrTransLst: Field 'PORTFOLIO_ID' not found.

Exception class: EDatabaseError
Exception message: qrTransLst: Field 'PORTFOLIO_ID' not found.
Exception address: 4033E93C
------------------------------------------------------------------------------
Stack list, generated 27/11/2008 12:24:40
(0000D937){dbrtl70.bpl } [4033E937] Db.DatabaseError + $5F
(0000D9B5){dbrtl70.bpl } [4033E9B5] Db.DatabaseErrorFmt + $31
(0001BB74){dbrtl70.bpl } [4034CB74] Db.TDataSet.CheckFieldCompatibility + $2DC
(0001BCA5){dbrtl70.bpl } [4034CCA5] Db.TDataSet.BindFields + $2D
(00021BDC){dac70.bpl } [00B42BDC] Memds.TMemDataSet.InternalOpen + $124
(0003C2BE){dac70.bpl } [00B5D2BE] Dbaccess.TCustomDADataSet.InternalOpen + $C6
(0003C2E3){dac70.bpl } [00B5D2E3] Dbaccess.TCustomDADataSet.InternalOpen + $EB
(0006B364){odac70.bpl } [00AAC364] Ora.TOraDataSet.InternalOpen + $14
(0001B155){dbrtl70.bpl } [4034C155] Db.TDataSet.DoInternalOpen + $19
(0001B20E){dbrtl70.bpl } [4034C20E] Db.TDataSet.OpenCursor + $1E
(00021DF2){dac70.bpl } [00B42DF2] Memds.TMemDataSet.OpenCursor + $A
(00036A22){dac70.bpl } [00B57A22] Dbaccess.TCustomDADataSet.OpenCursor + $1A2
(00036B31){dac70.bpl } [00B57B31] Dbaccess.TCustomDADataSet.OpenCursor + $2B1
(0006ABA8){odac70.bpl } [00AABBA8] Ora.TOraDataSet.OpenCursor + $0
(0001B0C9){dbrtl70.bpl } [4034C0C9] Db.TDataSet.SetActive + $55
(0003686D){dac70.bpl } [00B5786D] Dbaccess.TCustomDADataSet.SetActive + $3D
(0001AF14){dbrtl70.bpl } [4034BF14] Db.TDataSet.Open + $4
(000D4EE5){iforce1.exe } [004D5EE5] Transactions.TfrmTransactions.FormCreate (Line 350,

"Transactions.pas" + 26) + $6
(0009C9A1){vcl70.bpl } [0097D9A1] Forms.TCustomForm.DoCreate + $31
(0009C681){vcl70.bpl } [0097D681] Forms.TCustomForm.AfterConstruction + $11
(000050E7){rtl70.bpl } [400060E7] System.@AfterConstruction + $7
(0009C658){vcl70.bpl } [0097D658] Forms.TCustomForm + $174
(0003D038){rtl70.bpl } [4003E038] Classes.TDataModule.WriteHeight + $20
(000A1F67){vcl70.bpl } [00982F67] Forms.TScreen.GetForm + $B
(0009DE3E){vcl70.bpl } [0097EE3E] Forms.TCustomForm.GetMDIChildCount + $32
(0000A727){IFUtils.bpl } [00CAB727]
(000D4B77){iforce1.exe } [004D5B77] Transactions.ShowForm (Line 260, "Transactions.pas" + 8) + $11
(00147A83){iforce1.exe } [00548A83] main.TMainForm.aTransViewEditExecute (Line 684, "main.pas" + 1) +

$0
(0003C37B){rtl70.bpl } [4003D37B] Classes.TBasicAction.Execute + $F
(0008C4A9){vcl70.bpl } [0096D4A9] Actnlist.TContainedAction.Execute + $31
(0008D16B){vcl70.bpl } [0096E16B] Actnlist.TCustomAction.Execute + $4F
(0003C24F){rtl70.bpl } [4003D24F] Classes.TBasicActionLink.Execute + $13
(0009396F){vcl70.bpl } [0097496F] Menus.TMenuItem.Click + $8F
(00094E33){vcl70.bpl } [00975E33] Menus.TMenu.DispatchCommand + $13
(0009F86F){vcl70.bpl } [0098086F] Forms.TCustomForm.WMCommand + $1F
(00080A98){vcl70.bpl } [00961A98] Controls.TControl.WndProc + $188
(00083C97){vcl70.bpl } [00964C97] Controls.TWinControl.WndProc + $157
(00083BC9){vcl70.bpl } [00964BC9] Controls.TWinControl.WndProc + $89
(0009D87D){vcl70.bpl } [0097E87D] Forms.TCustomForm.WndProc + $421
(0002EE98){rtl70.bpl } [4002FE98] Classes.TThreadList.UnlockList + $4
(0000A2D8){vcl70.bpl } [008EB2D8] Graphics.FreeMemoryContexts + $98
(00083914){vcl70.bpl } [00964914] Controls.TWinControl.MainWndProc + $2C
(00083929){vcl70.bpl } [00964929] Controls.TWinControl.MainWndProc + $41
(0003D038){rtl70.bpl } [4003E038] Classes.TDataModule.WriteHeight + $20
(00083C97){vcl70.bpl } [00964C97] Controls.TWinControl.WndProc + $157
(0009D87D){vcl70.bpl } [0097E87D] Forms.TCustomForm.WndProc + $421
(0002EE98){rtl70.bpl } [4002FE98] Classes.TThreadList.UnlockList + $4
(0000A2D8){vcl70.bpl } [008EB2D8] Graphics.FreeMemoryContexts + $98
(00083914){vcl70.bpl } [00964914] Controls.TWinControl.MainWndProc + $2C
(0003D038){rtl70.bpl } [4003E038] Classes.TDataModule.WriteHeight + $20
(00045B72){rtl70.bpl } [40046B72] Contnrs.TComponentList.GetItems + $A
(000CF6AD){vcl70.bpl } [009B06AD] Appevnts.TCustomApplicationEvents.DoMessage + $D
(000A468B){vcl70.bpl } [0098568B] Forms.TApplication.ProcessMessage + $83
(000A46C2){vcl70.bpl } [009856C2] Forms.TApplication.HandleMessage + $A
(000A48F2){vcl70.bpl } [009858F2] Forms.TApplication.Run + $96
(0016CEAB){iforce1.exe } [0056DEAB] iforce1.iforce1 (Line 223, "C:\projekty\iforce1_2300\iforce1.dpr"

+ 17) + $2

Posted: Fri 28 Nov 2008 09:34
by Plash
We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/