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.
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).
have u got any soln. to ur problem even i m stucked with the same problem please share if u get any soution.
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 :)