RE: [sqr-users] SQR Error while opening file - Urgent please help!

["the dragon" <ceprn@hotmail.com>]

What is the usual file size?  How much available RAM do you have on the 
server?  Your system admin may need to set your file size memory allocation 
larger.  Or, he may need to allocate some more hard drive space to the 
tempory file areas, or swap areas.

If nothing else, if possible, break the file into smaller parts and see if 
you can process then that way.

clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

Hi everybody,

We have a Unix/Solaris environment. We are using PeopleSoft ver 8.3 tools. 
We are running an SQR that reads a flat file and inserts data into the 
PeopleSoft Oracle database. We have been running this program successfully 
for a while until today.

Today, the program failed with an unable to open file error. The file is 6.4 
GB. The status on the OPEN command is unsuccessful. However, this runs fine 
on the client with the same file.

Other smaller files are being processed. We are stumped!! Any help would be 
appreciated.



Charu Srinivas
PeopleSoft Benefits Renewal
Ph: (313) 20-68330
Email: csriniva@ford.com

_________________________________________________________________
Free up your inbox with MSN Hotmail Extra Storage. Multiple plans available. 
http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users