DMLRefresh, Unknown Error 1 in Direct mode

[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!

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

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

Code: Select all

Test.dfm
Test.pas
Test1.tbl

https://drive.google.com/file/d/0B7MTE6 ... sp=sharing

Try update data in grid:
https://drive.google.com/file/d/0B7MTE6 ... sp=sharing

Thanks!

[AlexP]

Thank you for the sample. We have reproduced the problem and will try to fix it as soon as possible.

[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

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