Max Open Cursors

[jdetechie07]

Hi All,
I have done some custom code to transfer data into the configuration cache.I am manipulating the Configurator cache using BSFNS B3200350 and B3200370.My code is being called on a button click.
My code works fine intially but if press the button 3-4 times continuosly it fails and clears up the entire cache.
The JDE.Log says -
" 344/5324 Fri Dec 24 09:31:02.130 jdecache.c1432
CAC0001017 - (jdeCacheOpenCursor) Attempt to exceed total number of simultaneously open cursors (100) per cache failed "

I dont know much about C as such.How could i avoid this situation ??????
Need Help urgently !!!!!!
Thanks in advance.

JDE 8.9 , SQL Server

 

[K J A]

Every corresponding Open Cursor must have a Close Cursor. JDE would error
out if more than 100 such open cursor exists.
Refer to Jdedebug.log it detail the no.of cursors [1] [2] ...[99] so forth.
Identify the bsfn and try fixing it.

Good Luck.
Anand

 

[jdetechie07]

Re: RE: Max Open Cursors

Thanks Anand for your reply.
I checked in SAR search and there is a SAR related to this -SAR # 740816.We are trying to get this SAR.
One more question for my understanding - Does it mean that every time you open a cursor you have to close the cursor before exiting ? So if i call a BSFN repetitively in a while loop what happens ? It opens and closes the cursor each time the BSFN is called ?

Thanks.

JDE 8.9 , SQL Server