Issues running reports

sjaganathan

Member
Hi,

When we run a couple of reports we get error message a cursor with name cXXXXXX not found and fails to update the table. This is how the log looks

336/382 Mon Jul 12 19:32:37 2004 RUNBATCH378
INITIALIZING RUNBATCH job: 248234

336/382 Mon Jul 12 19:32:37 2004 IPCPUB2903
process 336 <Program Name> registered in entry 26

336/382 Mon Jul 12 19:32:37 2004 RUNBATCH618
Startup for User=1192, Env=PD7333, Job#=248234

336/382 Mon Jul 12 19:32:37 2004 RUNBATCH635
bAPListening=0

336/382 Mon Jul 12 19:32:38 2004 JDB_CTL4423
JDB4200003 - OPEN TABLE NOT CLOSED = F986111

336/382 Mon Jul 12 19:32:38 2004 JDB_RQ14131
JDB3700001 - Failed to validate Request handle

336/382 Mon Jul 12 19:32:38 2004 jdbodbc2031
ODB0000183 - SQLExecute failed

336/382 Mon Jul 12 19:32:38 2004 jdbodbc2031
[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with the name 'C3978600' does not exist. - SQLSTATE: 34000

336/382 Mon Jul 12 19:32:38 2004 JDB_DRVM887
JDB9900401 - Failed to execute db request

336/382 Mon Jul 12 19:32:38 2004 JDB_EXET2306
JDB3600011 - Failed to perform Update for F0030

336/382 Mon Jul 12 19:32:38 2004 IPCPUB3215
API ipcSawUnregisterProcV1 : process 336 unregistered in entry 26

Has anyone come across this issue. Please let me know.

Thanks.
 
This could be an ODBC setting. Check your ODBC data sources and make sure that "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings, and warnigs" are checked.
 
Back
Top