Question Re: Database logon either incomplete or incorrect in Technology Q&A

Database logon either incomplete or incorrect

nscheaffer — Fri, 08 Aug 2014 03:39:24 GMT

I seem to have hit a roadblock with some Crystal Reports 2013 reports. Our primary BusinessObjects environment is 4.1 SP1 Patch 2. Let's call that BOBJ-1. We have a new secondary BusinessObjects environment that is 4.1 SP3. Let's call that BOBJ-2. I have 21 Crystal Reports that I need to move from BOBJ-1 to BOBJ-2. All of these reports relate to one application that is being moved to a new database.

So here is what I have done so far. Using Promotion Management in BOBJ-2 I pulled the 21 reports and their corresponding folder structure from BOBJ-1. I then opened one report from BOBJ-2 in Crystal Reports 2013 on my machine and switched the connection. I had been using OLE DB with SQL Server Native Client 10.0 as the provider so I used that for the connection to the new database as well. I should also mention that all of these reports have raw SQL in a command object. Anyway, everything worked fine in Crystal and I thought I was on my way. I saved my report out to my BOBJ-2 environment, set the password in Database Configuration and ran the report.

Unfortunately I got this error (the full details of the error are at the end of this post)...

The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. []
---- Error code:0 [CRWEB00000119]

I tried changing my connection to use Microsoft OLE DB Provider for SQL Server as the provider. Same error. I tried using an ODBC connection. I created a 32-bit ODBC connection on my desktop and it works fine. I created a 64-bit ODBC connection on the server. Same error.

I can ping the database server from BOBJ-2.

One other thing. Crystal Reports 2013 on my desktop is SP1 Patch 2. Is that a problem? I haven't upgraded my Crystal Reports on my desktop because I still have the 4.1 SP1 Patch 2 environment to support.

I am stumped. Any suggestions?

Thanks,

Noel

Full error detail...

2014-08-07 21:56:12

com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. [CRSDK00000955] ---- Error code:0 [CRWEB00000119]

at com.businessobjects.report.web.shared.WebReportingException.throwWebReportingException(WebReportingException.java:71)

at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1439)

at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:353)

at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:255)

at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:106)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerUpdater._processHttpRequest(CrystalReportViewerUpdater.java:61)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(ServerControl.java:345)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doUpdate(CrystalReportViewerServlet.java:206)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doPost(CrystalReportViewerServlet.java:194)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)

at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)

at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)

at com.businessobjects.bip.core.web.filter.BrowserRenderingModeFilter.doFilter(BrowserRenderingModeFilter.java:32)

at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)