Solved

Data Caching Error

Posted on 2004-03-29
3
314 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand columnThat will then direct you to their download page.From that page s…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

820 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