Report writer error E_QE007D

[hermoune]

Hello
I have just made a migration ingres 2.5 / ingres 2006 on a system Solaris.
I have a problem with a report writer which ran without problem.

But with the new version of Ingres, there is an error :

Reading report specifications and preparing query . . .
E_QE007D Error trying to put a record.
(Wed Nov 19 09:46:06 2008)


Thank you for your help

[bilgihan]

Hello,
do you see any related info in errlog.log file?
What is the contents of version.rel file?
Thanks - Bilgihan

[hermoune]

The version is
II 9.1.1 (su9.us5 103)
12886

in the errlog.log there is no info concerning the problem.

Thanks

[magxa01]

Hello,

Please can you try to re-compile your report ? (sreport ....)

Thanks.

[hermoune]

I have already re-compiled it. Always the same error.

[kschendel]

Try running the report query by itself in a terminal monitor. This might be a query specific problem rather than a report writer problem.

[magxa01]

You can also display the parameters passed to the report . Can be also a problem due to parameters with " instead ' for example "abd" instead of 'abd'

[hermoune]

Dear Kschendel, Thanks for your proposition. I tried running the query by itself and .. it works (!?). The problem must be elsewhere.

[bilgihan]

That is quite odd. Do you have any special environment settings or ingprenv?
money format or decimal ....?
If all do not give any hint, please contact your local ingres support team.

[kschendel]

That is extremely interesting, as QE007D generally implies a problem writing to a table (e.g. a temp table). It might also indicate a problem with sorting. I think you need to look carefully at the errlog.log to see if there are more indications as to exactly what is going on. Is there a .SETUP section in this report? If so, have you tried executing the queries in the .SETUP section?