Knowledge Base Article

Contact Tech Support
excel@excelsystems.com
 (250) 655-1766
 [7:30 - 5:00 PST]
Your Meeting ID will be Provided by a Rep.
Tech Support
Tech Support Home
Software Updates
Knowledge Base
Code Samples
Documentation
Technical News
Software Requirements
Support Testimonials
Contact us to...
Create a Ticket
Request a Free Demo
Suggest a New Feature
Submit Feedback
Upload a Large File
Other Services
Software Training
Professional Services
Product: Catapult Created: 2010/01/18 Back to Search  
Number: 8143 Type: Troubleshooting Rate This Article
 

Article Description

While working with a Catapult program, I'm getting an error that a file is full (The maximum size has been reached for member). How can I address this problem?

Article Details

Problem:
Catapult includes a number of files that have been shipped with a maximum record limit of about 13,000 records. Although a rare occurrence, it's possible that at some point you may run into that upper limit.  

The files on which you could hit this limit include:
  • XL_CATAPLT/SP_REQF - Pending Request file.
  • XL_CATAPLT/SP_REQDF - Request Detail file.
  • XL_CATAPLT/SP_HRQF - Request History file.
  • XL_CATAPLT/SP_EXDTAV - Data Extraction Pairs file.  
  • XL_CATAPLT/SP_GRBF - Grab Rule file.
The typical errors you could get look something like this:
  • I/O is not allowed because the program device or member SP_REQDF file  SP_REQDF in library XL_CATAPLT is in error.
  • I/O error CPF5129 was detected in file SP_REQDF.
  • CPA5305 The maximum size has been reached for member SP_REQDF.
A common reason for running into the upper limit is from having an extremely large history/request list or due to processing an extremely large number of reports regularly. To help prevent these from occurring again see the following KB article:


Solution:
You can avoid running into these limits by doing the following:
  • End the poller to release locks on any files.
  • WRKOBJLCK QSYS/XL_CATAPLT *LIB - Use this command to view which jobs have locks on the file in error and end them.  
  • CHGPF FILE(XL_CATAPLT/SP_REQDF) REUSEDLT(*YES) - SP_REQDF is used as an example of the file needing to be updated.
  • Restart the poller.

 

Rate This Page

Did this knowledge base article help you to achieve your goal?  Yes  No  Don't Know

Enter additional comments below.   If you want to hear back from us, include your contact information.

Email Address:
Comments: