Hi there everybody,
we are upgrading from IDS 7.31.ud2 to 7.31.ud6, and after the importing procedures, we are experiencing problems with some SPL's, follows the ISAM error below:
-640 QPlan sanity failure line-number.
Running UPDATE STATISTICS might fix this internal error. If the error recurs, please note all circumstances and contact Informix Technical Support.
We had already run UPDATE STATISTICS on sysprocedures, sysprocbody and sysprocplan with DROP DISTRIBUTIONS clause and UPDATE STATISTICS LOW for re-creation of the distributions on these tables.
We also runned UPDATE STATISTICS FOR PROCEDURES over these SPL's.
Anyone has ever experienced this kind of behaviour ?
Thanks, anything would help me.
FFO
"The only way of knowing is to understand"
we are upgrading from IDS 7.31.ud2 to 7.31.ud6, and after the importing procedures, we are experiencing problems with some SPL's, follows the ISAM error below:
-640 QPlan sanity failure line-number.
Running UPDATE STATISTICS might fix this internal error. If the error recurs, please note all circumstances and contact Informix Technical Support.
We had already run UPDATE STATISTICS on sysprocedures, sysprocbody and sysprocplan with DROP DISTRIBUTIONS clause and UPDATE STATISTICS LOW for re-creation of the distributions on these tables.
We also runned UPDATE STATISTICS FOR PROCEDURES over these SPL's.
Anyone has ever experienced this kind of behaviour ?
Thanks, anything would help me.
FFO
"The only way of knowing is to understand"