Database logon either incomplete or incorrect

[nscheaffer]

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)

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

    at com.businessobjects.bip.core.web.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:35)

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

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

    at com.businessobjects.bip.core.web.supportabilty.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38)

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

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

    at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)

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

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

    at com.businessobjects.bip.core.web.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26)

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

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

    at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)

    at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)

    at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)

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

    at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)

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

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

    at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:168)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)

    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

    at java.lang.Thread.run(Thread.java:761)

Caused by: com.businessobjects.report.web.shared.WebReportingException: The database logon information for this report is either incomplete or incorrect.---- Error code:0 [CRSDK00000955]

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

    at com.businessobjects.report.web.component.ParamComponent.applyParameters(ParamComponent.java:427)

    at com.businessobjects.report.web.event.ParamListener.setParams(ParamListener.java:78)

    at com.businessobjects.report.web.event.SetParamsEvent.processListener(SetParamsEvent.java:70)

    at com.businessobjects.report.web.event.ViewerBroadcaster.broadCastEvent(ViewerBroadcaster.java:136)

    at com.businessobjects.report.web.event.ViewerBroadcaster.broadcast(ViewerBroadcaster.java:110)

    at com.businessobjects.report.web.event.EventQueue.processEvents(EventQueue.java:53)

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

    ... 52 more

Caused by: com.crystaldecisions.sdk.prompting.PromptingException: The database logon information for this report is either incomplete or incorrect. Error code name:ProcessPromptingFail

    at com.crystaldecisions.sdk.prompting.PromptingException.throwPromptingException(PromptingException.java:78)

    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.processPrompting(CacheReportSource.java:2995)

    at com.businessobjects.report.web.component.ParamComponent.applyParameters(ParamComponent.java:421)

    ... 58 more

Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: The database logon information for this report is either incomplete or incorrect.---- Error code:-2147215357 [] Error code name:internal

    at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(ReportSDKException.java:120)

    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.SendRequestHelper.sendRequest(SendRequestHelper.java:141)

    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.sendRequest(CacheReportSource.java:1796)

    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.processPrompting(CacheReportSource.java:2976)

    ... 59 more

[nscheaffer]

I tried a 32-bit ODBC connection on the BOBJ-2 server and that seems to work.  I thought all of the client tools were 32-bit and the server components were 64-bit.  Maybe I have that backwards or it just doesn't matter in this case.

So then I thought I would try the OLE DB connection again.  I got it to work using the Microsoft OLE DB Provider for SQL Server, but not the SQL Server Native Client.  So I guess at least I have some options.  However, I wonder if I am doing something else in the way I am saving the report or setting the password that is causing some types of connections to work, but not others.

Noel

[nscheaffer]

I after multiple attempts to get the SQL Server Native Client provider working I am going to give up on that an go with the Microsoft OLE DB Provider for SQL Server provider.  Initially, it didn't work.  However, I think that might have been some sort of strange caching issue.  I just switched a report to the Microsoft OLE DB Provider for SQL Server provider and it did not work right away.  So I restarted the SIA and it worked!  Yeah!  Restarting the SIA did not help when I switched to the SQL Server Native Client provider.

Thanks for all your help. 

Seriously though, writing this here helped me think things through and find some workable options.

Noel

[DellSC]

Even though BO is 64-bit software, the parts of it that handle "classic" (i.e., not CR4E) Crystal are all still 32-bit and require 32-bit connections.

-Dell

[amitsdotcom]

Hi Noel,

Thank you 8 years after you posted this I have come across same issue during a server migration and your advice of defining 32 Bit ODBC worked for me as well.

Thanks again for sharing your experience!

Appreciate it.

Amit

[former_member11696]

Try using a new MS Client, the MS 2012 Native 11 client works but the latest one also works.

CR 2013 may not be aware of the newer/older clients so you'll have to test or upgrade to the latest SP available.

If you go into the the Archive section on our managed Support site you should be able to get the latest SP's for your BOE Server updates:

SAP ONE Support Launchpad

You can patch CR 2013 from here also:

https://origin.softwaredownloads.sap.com/public/site/index.html

As you know BOE 4.1 is end of support which is likely why you are posting here so if you can discuss with your team to upgrade to a supported version that can support the latest Clients and have the latest Security updates.

[former_member784925]

This is a problem for me as well with several reports that were moved to a different database. 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]

We have dynamic parameter lists that are used to pick details of the generated report for several of the reports. This selection list always refreshes/populates with a request to login to the database. I've done this, used Verify Database, set Datasource Location etc. In the Field Explorer "Edit Parameter: XXX: dialog, the "Existing" datasource list has countless numbers of datasources that have been setup. I can't seem to find anyplace to actually edit these items and fix the database parameters up, or otherwise prune or inspect the entries.

Where is the editing of these datasource parameters performed at? This is v14.1.8.2060 of Crystal Reports 2013 SP 8

[former_member751591]

Thanks for coming to SAP Community for answers. Please post your question as a new question here:

Since you're new in asking questions here, check out our tutorial about asking and answering questions (if you haven't already), as it provides tips for preparing questions more effectively, that draw responses from our members.

Please note, that your post here won't be answered.