refresh, reopen error

[Valgardur]

Hi, we had a strange error with refresh and reopening a query with different parameters, not using SmartRefresh.

Occasionally our application would frequently - but not constantly - either hang for up to an hour or cause "Unknown error 1". This would happen at our client's site.

I was using ODAC 9.5.18 with Delphi XE8.. building in 9.4.14 and Delphi XE2 solved this. I just installed ODAC 9.6.19 for Delphi XE8 and released a new test version.

But is this something known?

[AlexP]

Hello,

Please send the full sample demonstrating the problem to alexp*devart*com, and specify the exact versions of Oracle client and server.

[Valgardur]

I am not allowed to send the code.

We are not using Oracle client, only direct mode, but running with Oracle 9.

We have many applications for this client, and have had for many years... this suddenly popped up in new applications - and stopped when we built with older versions.

But this is not constant and difficult to repeat.

[AlexP]

If you can't provide a sample, please provide the script for creating and filling in the table, the executing query, and the Delphi code abstract leading to the error.

[Valgardur]

Again, not so simple, happens with many queries, most of them extracting data from 5-7 tables with compilcated relations.. and no way to reproduce consistently.

I do appreciate it can be difficult to address without better information, but have there been no other similar issues? And no fixes that may have been omitted in the release notes?

[m.ghilardi]

ORA-00001 is "unique constraint violated". I don't know how this could be an "Unknown error".

[Valgardur]

thanks, this is something completely different, not an oracle error, as this is only on refresh.

[m.ghilardi]

related?

[Valgardur]

Probably not, there is no update, only refreshing a query select

[AlexP]

Try to reproduce the problem using the Oracle client and let us know the result.

P.S. Unfortunately, we can't give a more detailed answeк without having reproduced the problem. If you could provide us with access to your server and the query reproducing this error, we will try to reproduce it again.

[Valgardur]

thanks, but we are not using the Oracle client - and there is no way our client will grant access to their system.

This seems to have been fixed in the last two releases, though..

[Valgardur]

Actually, I got a note from the client that this is actually not solved..

But this only happens in a complex situation, and now and "Unknown error 1." message box is followed by ORA-5778 error message. And as far as I can tell, this is not a know Oracle error.

[AlexP]

As I wrote earlier, we can't provide any information concerning this behavior without a sample reproducing the problem.

P.S. Indeed, there is no such error in Oracle. Please provide the complete error text or a screenshot.

[Valgardur]

Finally I have a way to reproduce this - although it seems to require either an idle wait or an external update.

I did have a better look at the link you mentioned earlier (http://forums.devart.com/viewtopic.php? ... wn+error+1), (which I thought was unique key constraint) but according to that thread it should have been fixed.

Delphi Debugger shows EDBError with message "Unknown error 1" and the error message has

EOraError with message 'Unknown error 1'.

Then when I close the form in question..

EOraError with message 'ORA-5778'

But this is the complete message..

[Valgardur]

External update is not enough to reproduce this.. the long idle time (45-50 minutes) seems to be the key factor.