CR XI R2: Database logon failed. Database Vendor Error Code: 1005

[Former Member]

Hi:

I am trying to incorporate Crystal Reports XI R2 with in-house application - Windows platform, Oracle9i, Websphere Studio Application Development 5.1, and JVM 1.4.2 with OCI8 driver and JNDI connection.

I am not getting any error while running it in the project where I first implemented. If I import a EAR file from that project and deploy it in another project and run it, I am getting error in the new project as follows:

[10/23/08 18:43:11:843 IST] 40994099 SystemOut O ERROR - JRCAgent4 detected an exception: Database logon failed. Database Vendor Error Code: 1005

at at java.lang.Throwable.<init>(Throwable.java)

at at java.lang.Throwable.<init>(Throwable.java)

at at com.crystaldecisions.sdk.occa.report.lib.ReportSDKExceptionBase.<init>(Unknown Source)

at at com.crystaldecisions.sdk.occa.report.lib.ReportSDKLogonException.throwReportSDKLogonException(Unknown Source)

at at com.businessobjects.reports.sdk.b.i.if(Unknown Source)

at at com.businessobjects.reports.sdk.b.i.a(Unknown Source)

at at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)

at at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

at at com.crystaldecisions.proxy.remoteagent.r.a(Unknown Source)

at at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

at at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)

...

...

...

[10/23/08 18:43:27:234 IST] 40994099 SystemOut O ERROR - JRCAgent4 detected an exception: Some parameters are missing values

at at java.lang.Throwable.<init>(Throwable.java)

at at java.lang.Throwable.<init>(Throwable.java)

at at com.crystaldecisions.sdk.occa.report.lib.ReportSDKExceptionBase.<init>(Unknown Source)

at at com.crystaldecisions.sdk.occa.report.lib.ReportSDKParameterFieldException.throwReportSDKParameterFieldException(Unknown Source)

at at com.businessobjects.reports.sdk.b.i.a(Unknown Source)

at at com.businessobjects.reports.sdk.b.i.a(Unknown Source)

at at com.businessobjects.reports.sdk.b.i.byte(Unknown Source)

at at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at at com.crystaldecisions.proxy.remoteagent.y.a(Unknown Source)

...

...

...

[10/23/08 18:43:28:359 IST] 40994099 SystemErr R Exception at EPFPageFactory.getPage: java.lang.Exception: Error in EPFImapgeObjectInstancesBase.getInstanceProperties: null epfImage.

Any help or suggestions would be highly appreciated.

thanks,

Prakash

[Former Member · Accepted solution]

I suspect it is probably just a WSAD configuration issue. If you have simply moved the EAR from one project to another, it might be missing some libraries or the some of the libraries may have been corrupted in the move, or it might be a problem with the build path. Try deleting and readding the JRC libraries to the project. If you are deploying to the test server within WSAD, try creating a new instance of it and deploying the project on the new instance.

[Former Member]

Hi Merry:

You were right about it. We had that issue becuase of WSAD config itself. Thanks for your response.

regards,

Prakash Kayastha