When running a program (CA Ideal), if the program uses a very old SQL plan, an error can be received:
FATAL ERROR OCCURRED
CLASS=DVW TYPE=SQL RETURN CODE=12
DESCRIPTION: SQLCODE = -999 SQLERRM = INTERNAL ERROR (stmtRbnd LINE 0551): REL 8.0 PLAN STMT SOURCE FOUND
PROGRAM=ppppppp PROCEDURE=xxxxx-xxxxxx-xxxxxxx STATEMENT=014400
DATA-VIEW STATUS: -999 INTERNAL STATUS: N/A DBID: N/A
1-IDAETERR90E - DB Backout successful
In most cases, this error is caused by using a very old plan or by having a corrupt Datadictionary PLAN header. In the case which led to this article, the program was last compiled and the plan created in 1994.
As always, please contact CA Technologies support for CA Datacom if you have further questions.