Running sqr2xml on Unix server
Brought to you by:
achalprabhakar,
vandiverhouse
Menu
▾
▴
I have successfully written a sqr program to create excel ss reports. I don't have any problems when I run them from my PC. However, when I move the program to our Unix server, I get the following error: "(SQR 7601) Cannot access the Java file (/sqr/common/SQR/lib/spf.jar). No such file or directory".
The "/sqr/common/" does exist on our server but the "SQR/lib..." directory does not.
The xml_writer.sqc function has been copied to /usr/local/bin directory and I have qualified the sqc function's directory path within the sqr program as "#include '/usr/local/bin/xml_writer.sqc'.
Have you seen this error before? Any suggestions will be very helpful. Thanks....
I do not believe this is an sqr2xml issue, but a possible install issue of SQR on your Unix.
I found the following thread on SQRUG which leads me to this thinking:
http://www.sqrug.org/sqr-users/sqrusers_01q2/msg00624.html
Perhaps your SQRDIR variables are not set up; I have not had the opportunity to install SQR on a server, so I'm unfamiliar with all of the setup. Are there any other SQRs having issues on Unix?
Also, the xml_writer.sqc file (or whatever name you choose) should reside with the other SQC files (in a custom folder perhaps) on Unix. If the Unix SQR program could not find the SQC right away without having a path in the #include, then that points to the issue of more setup tasks that did not get completed, such as where the include files can be found.
David Vandiver (creator of SQR2XML)
www.DavidVandiver.com
In doing some more testing, I removed the -printer: command in my script which seems to have solved the problem!