I am using Crystal reports 2008 to design reports for IDM 7.1.The DB is SQL Server 2005.
I am able to design and fetch correct data from the databases and things work fine in the Crystal report tool. But when I try to call the task from IDM-UI , I am getting a strange error and the job fails.
The error message goes like tis:
Failed generating report BasicRoleComposition85837.pdf
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Unexpected database connector error---- Error code:-2147467259 Error code name:failed
putNextEntry failed storing85731
I checked the constants and the its all set correctly. I checked the SQL too,it also seems to be ok.
I really cant make out what went wrong.It would be great if someone can help me out with this.