Home » Developer & Programmer » Forms » Can't create file with CLIENT_TEXT_IO.FOPEN
Can't create file with CLIENT_TEXT_IO.FOPEN [message #321888] Wed, 21 May 2008 13:59 Go to next message
jasper11
Messages: 2
Registered: May 2008
Junior Member
Hi, I am using WebUtil CLIENT_TEXT_IO to build a txt file...
I am getting the following error : "FRM-92101: There was a failure in the forms server during startup. This could happen due to invalid configuration."
However, a file is produced when I limit the extraction to 10,900 records, anything over this number of records and it fails with the error above. This worked fine with a client server app...text_io but webutils client_text_io seems to be limited to a maximum of 10,900 records....any suggestions on how to resolve this are greatly appreciated....thanks
Re: Can't create file with CLIENT_TEXT_IO.FOPEN [message #321937 is a reply to message #321888] Wed, 21 May 2008 19:59 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
How 'big' is 10,900 records?

What operating system and version of Forms are you using? IS this using a Develoepr Server or an Application Server?

Consider closing the file every 1,000 records and reopening it with 'write append'.

David
Re: Can't create file with CLIENT_TEXT_IO.FOPEN [message #322417 is a reply to message #321888] Fri, 23 May 2008 07:51 Go to previous message
jasper11
Messages: 2
Registered: May 2008
Junior Member
Hello David,
Thanks very much for your prompt reply. I have changed my code to close and re-open the file every 1000 records as you suggested and it is working great now.
Thanks again!
PS. It is XP, with Forms 10.1.2.0.2
Previous Topic: Forms 6i : unable to query the Employee(EMP) Details, Based on Department Name(DEPT.DNAME),
Next Topic: how can i implement the icon in form6i
Goto Forum:
  


Current Time: Sat Feb 15 01:46:53 CST 2025