Data Caching Error

In my package, we are caching PONUMBERS using
      gnv_app.inv_dwcache.of_Register ("pono", "dddw_po_no", SQLCA)
in pfc_open event of n_cst_appmanager.

In window w_critiria,
          gnv_app.inv_dwcache.of_GetRegistered ("pono", ids_datastore)
in cb_po clicked event.

In pfc_open event, first statement is returning code -3 (-3 if there is a retrieve error).  But when we retrieve datawindow ddw_po_no directly, it retrieves rows without any error.

In package also if the data is reduced by giving extra condition, package works fine. I suspect huge data ( > 33000 records) is causing problem.  Please tell me how to increase the cache memory or what may be the other problem.
bssoftwareAsked:
Who is Participating?
 
Vikas_DixitConnect With a Mentor Commented:
Hi,
The of_Refresh() of pfc_ncst_dwcache Function returns integer for pfc v 6.0 or below... so can't handle rows more than 32767... change the function and it's calling places to use long instead... if you have PB 7/8 you can refer the same there..

Regards,
VIkas
0
 
namasi_navaretnamCommented:
Vikas is right on the money... I have had this issue. Also some functions that retruned number of rows had retrun code defined as integer instead of long.

Regards-
0
 
bssoftwareAuthor Commented:
Hi,

I have changed integer to long in pfc_n_cst_dwcache, it is working fine.

Thank you very much.

Regards,

Nagendra S
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.