Solved

Data Caching Error

Posted on 2004-03-29
3
310 Views
Last Modified: 2013-12-26
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.
0
Comment
Question by:bssoftware
3 Comments
 
LVL 8

Accepted Solution

by:
Vikas_Dixit earned 50 total points
ID: 10703074
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
 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 10704356
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
 

Author Comment

by:bssoftware
ID: 10710459
Hi,

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

Thank you very much.

Regards,

Nagendra S
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now