Hello CR server gurus!
I've been working on setting up a CR Server XI installation to publish my Peachtree Quantum CR reports to the web.
I've installed the CRSXI and everything is working fine EXCEPT the reports are not displaying. This occurs the same way on the localhost as well as remote client systems.
I can connect the objects to the reports via ODBC AND DSN and both bring up the report's options, if I put in the correct credentials and path in the process-->database -->custom login fields. I run the report and then ultimately an error in the Windows Server Application log appears.
First there is an ERROR 42452, "A Failure occurred while the Page Server was processing report, "blah blah" for user "blah blah"
Next there is an information alert 42451 "A Page Server subprocess was forced to terminate"
this is when the report returns the error, "Your request could not be completed because a failure occurred while the report was being processed. Please contact your system administrator "and closes. Well, I'm the system administrator and I don't know anymore about it!
I've run through the CR2008 installed on this system and tested the reports, they work perfectly fine. The logons all check out and if I enter them incorrectly into the CRS object properties, I get "failed to logon" errors or "failed to access ODBC connection" and so on which tell me the reports are authenticating but failing to process.
the path statements in the object properties are NOT UNC paths and all resolve easily. The CRSXI is installed on a C:\ drive and the temp folders are all within the C:\ drive so I'm assuming they access to write the temp files they need to write to generate the report.
I've published the reports manually as well as with the publishing wizard, both return the same problems.
I've reached a wall guys and gals and need your assistance greatly!