We are currently running Crystal Enterprise 9.0 and we are looking for a method of querying the CE database in order to do analysis on our reports that we currently have in production (the canned reports in the launchpad are not customizable to the best of our knowledge). I have identified how to query reports, determine statuses of those reports, etc. (Thanks to this forum). However what we are now trying to do is query against failed instances and determine "why they failed" If I run the canned Instance Manager report it provides information such as "incorrect logon parameters" or "information is needed". Using the APS_InfoObjects table I can find the failed instances however cannot determine "why" they failed. Is there any method of doing this? Or of altering the canned Launchpad reports? Any help on this subject would be greatly appreciated. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Enterprise 9.0 Querying against Report Instances
- Thread starter flatfile
- Start date
- Thread starter
- #3
Not sure where I could use that. I should have been more specific. I am currently using MS SQL Server's Query analyzer to pull this information and hope to create a report in crystal that gathers this information. How would i utilize this: "MyInstance.SchedulingInfo.ErrorMessage" in that format?
Sorry. I assumed from what you were retrieving you were familiar with the object model and just missing a property. I took the property from a csp file where I am using the query...
For each instance in the collection (MyInstance), I get the status (Success, Fail, Recurring, etc.) with MyInstance.Properties.Item("SI_UISTATUS"). When the status is 3 (Failed), I display the error with MyInstance.SchedulingInfo.ErrorMessage.
Hopefully you can correlate my approach with yours. I was afraid SchedulingInfo might need the Scheduling plugin, which may not be accessible to the Query analyzer, but I don't see where my code is using it.
Code:
SELECT * FROM CI_INFOOBJECTS WHERE SI_PARENTID = ' & ThisReport.ID & ' AND SI_PROGID = 'CrystalEnterprise.Report'For each instance in the collection (MyInstance), I get the status (Success, Fail, Recurring, etc.) with MyInstance.Properties.Item("SI_UISTATUS"). When the status is 3 (Failed), I display the error with MyInstance.SchedulingInfo.ErrorMessage.
Hopefully you can correlate my approach with yours. I was afraid SchedulingInfo might need the Scheduling plugin, which may not be accessible to the Query analyzer, but I don't see where my code is using it.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question