Solved

Data Caching Error

Posted on 2004-03-29
3
315 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

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. …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
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 synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
Suggested Courses

734 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