Page 1 of 1
Cannot Run Report from Control File
Posted: Wed Jan 18, 2006 9:42 am
by jmiskey
We have a DOS Report Writer (*.RP1) report that runs from a control file and produces a text file. It is running against database files (dbf) created from Clipper (PowerPlus).____It has been running fine for a few years now. All of a sudden last week, it stopped working. I am getting an error saying that "Cannot open database: P2FSAEE.DBF" (which is the database that it runs from). This problem has also popped up on another Report.____The odd thing is that if we manually run this report from Report Writer, it runs without a hitch. However, it will not run from the Control file. We tried re-indexing the database, and it did not make a difference.____Does anyone one what may be causing this or how to fix it?____Thanks.
=> Cannot Run Report from Control File
Posted: Wed Jan 18, 2006 12:02 pm
by kfleming
Is P2FSAEE.DBF the control table or is the master file used in the report? If used in the report, do you override it in the control file? Does runtime run from the same directory as rr.exe? What is the default data directory in the CNF file?____Kathleen__R&R Support
==> Cannot Run Report from Control File
Posted: Wed Jan 18, 2006 1:54 pm
by jmiskey
P2FSAEE.DBF is the master file that the control file (WC.DBF) is calling/setting/using. These files are found in my _H_ drive. ____The rr.exe file is found under _R:RR\_. In my _H_ drive, there is a _RR_ speed dial file, whatever that is. The _RRUN.exe_ file is also found in this _H_ drive. The "P2FSAEE.DBF" file being called is found under "R:PPLUSPPDB0005".____Where do I find this CNF file? I don_t think we are using one.____The odd thing is that we have been using this process for a few years without any problems, and there are many other similar processes that we are using that do not have this problem. This one just seemed to go bad all of a sudden.__
===> Cannot Run Report from Control File
Posted: Wed Jan 18, 2006 4:32 pm
by kfleming
If you are hiding known file types that RR speed dial is probably RR.CNF.____Run the program RRSETUP.EXE and then select Configuration and then choose this RR.CNF. Then look at Files-Directories and see where the Data Directory points to.____Kathleen__R&R Support
====> Cannot Run Report from Control File
Posted: Wed Jan 18, 2006 5:29 pm
by jmiskey
I browsed that CNF file, and it appears that the Default Data Directory is blank.
=====> Cannot Run Report from Control File
Posted: Thu Jan 19, 2006 12:15 pm
by jmiskey
OK. I have seemed to have fixed the problem, though I am not sure what happened.____The Control file which runs is built "on the fly" by another Control file and a Report Writer report. It appears that there must have been some corruption to the Control file used to build the other other control file, as when I deleted the offending record and then re-added it, it started working fine again.____Odd.