cati
Active Member
Hi all,
I have got a problem running Sales Update when the records to be processed are more than 3000 (approximately).
When we run R42800 with not so many records everything is ok, but we run it with a lot of records, after approximately a quarter of hour on AS/400 appears a message about cursor "Cursor not Open".
After that moment the message always appears when the system made an SQL. (the preent screen of the message on AS/400).
I tried to active logs on AS/400 but the only thinghs that I noticed is that there are two jdeCloseCursor without the jdeOpenCursor so the system show that message on AS/400.
But there is no reason of that jdeCloseCursor.
I thought about cursor size. Maybe there is a limit of cursor after that the system shows that error.
Anyone knows how can I set this parameter?
I tried to put on jde.ini under
[DB CACHE INFORMATION]
Maximum Request Cache =9999
CACHE_UseCache=1
CACHE_MaximumNodes=50
but without result
Does anyone know something about cursors?
I have got this problem only with Sales Update.
Thank you in advance
Ciao Caterina
[email protected]
One World Release 810 8.94_MI
OS400 Release 5.2
I have got a problem running Sales Update when the records to be processed are more than 3000 (approximately).
When we run R42800 with not so many records everything is ok, but we run it with a lot of records, after approximately a quarter of hour on AS/400 appears a message about cursor "Cursor not Open".
After that moment the message always appears when the system made an SQL. (the preent screen of the message on AS/400).
I tried to active logs on AS/400 but the only thinghs that I noticed is that there are two jdeCloseCursor without the jdeOpenCursor so the system show that message on AS/400.
But there is no reason of that jdeCloseCursor.
I thought about cursor size. Maybe there is a limit of cursor after that the system shows that error.
Anyone knows how can I set this parameter?
I tried to put on jde.ini under
[DB CACHE INFORMATION]
Maximum Request Cache =9999
CACHE_UseCache=1
CACHE_MaximumNodes=50
but without result
Does anyone know something about cursors?
I have got this problem only with Sales Update.
Thank you in advance
Ciao Caterina
[email protected]
One World Release 810 8.94_MI
OS400 Release 5.2