Help need--->Error Number -239

[anumala28]

Hi,
One reports already developed before. Now i am modifying this reports. While opening one report it is giving error, I could not find where this error, If any body got this error, please give the solution for this error.

Error Details:

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request with options'.
DMS-E-RGE_FUNC_NOT_AVAIL, The function decode is not available as an
external, database or built-in function.

Thanks,
Sreenivas

 

[Kaiaualad]

What is your Impromptu version and what version is your Database?

 

[anumala28]

Database Oracle8i
Impromptu 7

 

[drlex]

anumala28,
Sounds like you have a similar problem to that which tizzyb had last week - Oracle and CASE (IFTHENELSE statements) becoming DECODE.
Take a back-up copy of the cogdmor.ini file first and then change the relevant "Case_To_Decode=T" to "Case_To_Decode=F" under headers[Exceptions General ORACLE *.*] (*.* being version no.s) and try with that.
(Restore backup copy if it doesn't help)
HTH,
lex

 

[donafran]

drlex,
we have a VERY similar problem using Impromptu v7.1 MR2 on a WIN 2003 machine.

But we use SQL server 2000 database.

Is there a similar file for SQL settings as the .ini you mention in your response ?

Thanks

 

[drlex]

Donafran,
There's the cogdmod.ini file for the ODBC connection, which I understand is the .ini file for SQL server. However, I haven't found the need to modify it with a similar set up (Win2K/Win2K Server, 7.1MR2 and SQLserver2000).
Did it work before an upgrade? If so, what got changed?
What is the exact error message?
lex

Subliminal Thought for the Day: