Solved

Data Caching Error

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
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 column That will then direct you to their download page. From that p…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

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