If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Error when a user attempts to run a report

Started by dmgerber, 03 Jun 2008 10:39:27 AM

Previous topic - Next topic

dmgerber

Myself and an additional user can run this report correctly.  Any suggestions?

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 timestampadd is not available as an external, database or built-in function.

Ty Clabbers

I guess you either have more rights to database objects (you have several connections for your datasource), more rights to connections objects (chech the permission tabs) or more capabilities in connections (tools/capabilities).

IT_STN

have u got any soln. to ur problem even i m stucked with the same problem please share if u get any soution.

vijayab

The timestampadd function is an ODBC specific function which cannot be used while connecting natively to database.
Modify the report by replacing the timestampadd function with a similar function, that is available while connecting natively to the database.  Each report that was referencing the timestampadd function will need to be modified.

hope it will help u

regards,
vijayab :)