Encountered internal error in SQL ENGINE at 391 in Z:/vobs_s

Posted by Vel murugan on 01-Aug-2016 08:50

While running the below query am getting the following error.

Query : UPDATE PUB."customer" SET UNIQ_ID = PRO_PARTN_ROWID

Error:

[DataDirect][OpenEdge JDBC Driver][OpenEdge] Encountered internal error in SQL ENGINE at 391 in Z:/vobs_sql/sql/src/progstub/stub_tid.cxx. Contact Progress Technical Support

All Replies

Posted by Dileep Dasa on 02-Aug-2016 02:28

This is a bug. Please contact technical support and log a bug for the issue

Posted by ChUIMonster on 02-Aug-2016 10:44

I'm not a SQL guy but...  isn't the problem that you are trying to store a ROWID in a db field?

It's possible that I need more coffee -- but the last I knew that was a forbidden act.  And if it isn't it should be.

Posted by ezequielmontoya on 03-Aug-2016 10:24

"...And if it isn't it should be."

Totally agree. In a previous job I found they were storing the RECID (it was Progress 8.3) in a field, and using it as an index.

I knew about it the day after a dump&load, when, of course, the stored RECID didn't work.

I had to add a better new index, modify the programs that used it, etc.


This thread is closed