Page 1 of 1
DMLRefresh, Unknown Error 1 in Direct mode
Posted: Mon 11 May 2015 13:07
by sasha_p
Delphi XE7 + ODAC 9.5, database version 11.2.0.4 or higher (in lower database version - no error)
In OraQuary set property DMLRefresh = True
I try update/insert data (new data is duplicated) in DBGrid.
After this operation:
- in Not Direct mode - "Unique constraint violated";
- in Direct mode - "Unknown Error 1" and crash with "TTC protocol intenal error ....".
On other constraint errors I got "Unknown Error 1" too.
Can you help me?
Thanks!
Re: DMLRefresh, Unknown Error 1 in Direct mode
Posted: Wed 13 May 2015 09:36
by AlexP
Hello,
The 'Unique constraint violated' error means, that you have a unique field in your table, and you are trying to insert identical records to this field. Please check the DDL of your table.
Re: DMLRefresh, Unknown Error 1 in Direct mode
Posted: Wed 13 May 2015 14:11
by sasha_p
You do not understand me. I don't get "Unique constraint violated" error in
Direct mode, i get "Unknown Error 1" and "TTC protocol intenal error ....".
Database version 11.2.0.4 or higher (when database version < 11.2.0.4 - everything work well)
In ODAC 9.4 everything work well. Problem with new version ODAC and only in Direct mode.
Example src:
https://drive.google.com/file/d/0B7MTE6 ... sp=sharing
Try update data in grid:
https://drive.google.com/file/d/0B7MTE6 ... sp=sharing
Thanks!
Re: DMLRefresh, Unknown Error 1 in Direct mode
Posted: Tue 19 May 2015 07:26
by AlexP
Thank you for the sample. We have reproduced the problem and will try to fix it as soon as possible.
Re: DMLRefresh, Unknown Error 1 in Direct mode
Posted: Fri 19 Jun 2015 06:39
by a-s-z
Hi,
any news in this issue? We are facing the same problems here.
ODAC version : Odac: 9.5.15 ,Dac: 9.5.16, using Direct, Unicode connection.
Here are some examples:
Code: Select all
exception class : EOraError
exception message : ORA-03137: Interner TTC-Protokollfehler: [opiexe: protocol violation] [1] [3] [] [] [] [] [] ORA-00001: Unique Constraint (TEST.XAK2TEST) verletzt.
00fe6f06 +1ce test.exe OraClasses 2481 +48 TOCIConnection.OraError
00ff2da3 +03f test.exe OraClasses 7083 +2 TOCICommand.Check
00ff579b +23b test.exe OraClasses 8271 +58 TOCICommand.InternalExecute
00ff5bd7 +1cf test.exe OraClasses 8404 +43 TOCICommand.Exec
00ffbc55 +045 test.exe OraClasses 10560 +7 TOCICommand.DoExecute
00ffbdc4 +114 test.exe OraClasses 10599 +23 TOCICommand.Execute
Code: Select all
exception class : EOraError
exception message : Unknown error 1.
00fe6f06 +1ce test.exe OraClasses 2481 +48 TOCIConnection.OraError
0100ca66 +01e test.exe OraClasses 17784 +2 TOCITransaction.Check
0100d460 +098 test.exe OraClasses 17975 +12 TOCITransaction.CommitLocal
0100d008 +020 test.exe OraClasses 17914 +1 TOCITransaction.StartTransactionLocal
0100daa3 +0fb test.exe OraClasses 18116 +14 TOCITransaction.StartTransaction
00f7747b +10b test.exe DBAccess 17517 +25 TDATransaction.StartTransaction
01023c3d +079 test.exe OraTransaction 369 +12 TOraTransaction.StartTransaction
01023bbd +005 test.exe OraTransaction 353 +1 TOraTransaction.StartTransaction
010321e0 +050 test.exe Ora 2513 +7 TOraSession.StartTransaction
01032189 +009 test.exe Ora 2500 +1 TOraSession.StartTransaction
Best regards,
Andre
Re: DMLRefresh, Unknown Error 1 in Direct mode
Posted: Fri 19 Jun 2015 09:27
by AlexP
The problem is already fixed. The new ODAC version 9.5.16 with the fix is already available at our website for download now.