Follow

Coresuite Dashboard: Error in Crystal Printer. Message: Database logon failed

 

Issue description

When trying to preview, print, email or generate pdf documents from within SAP Business One with coresuite designer, the layout is not generated, instead  the message "Database logon failed" is displayed and this might lead to a crash.  
This error happens randomly as not always the connection to the SQL server fails.

 

000.jpg

 

Search terms

Crystal Reports, preview, print, email, pdf, print definition, layout definition, database, logon, failed, crash, CR.

 

Solution

As this error is due to a drop or an unsuccessful connection to the SQL server the only workaround that can be provided is to review or change the connection settings used in the Crystal Report file in order to improve the communication between coresuite, Crystal Reports and SQL Server.

This may be due to the fact that the .rpt file is setup with an SAP Business One datasource connection type. To solve the issue, you may:

-          Replace the SAP Business One datasource connection from the .rpt file with an XML export (ADO .NET XML) from coresuite designer

-          Replace the SAP Business One datasource connection from the .rpt file with an OLE DB (ADO) connection.

 

 

Connection update:

Inside Crystal go to: Database – Set Datasource location and follow the next steps:

1)      Select the current connection of your report
2)      Select the connection that will replace the original connection
3)      Press Update

 001.png       

 

4)      Depending on the type of connection selected

      - ADO.NET (XML) – Select the xml which contains the datasource. The default datasource for coresuite will be  ..\dataschema.xml

002.png 

 

      - OLE DB (ADO) – Select SQL Native Client as your connection, press next, input the correct credentials and press Finish.

  003.png 004.png

 

5)      A warning message might be displayed that some of the tables were not found in the new datasource.

005.png



In case this warning message appears the fields and tables will need to be added again to the report.

       - In case of OLE DB (ADO) in Database – Database expert.  It might be necessary to redesign the report using now the data out of the new datasource.

       - In case of ADO.NET (XML) it is possible to pass all the required information as queries inside the layout definition.

 

Please review the coresuite country package manual (http://helpfiles.coresystems.ch/help/country_package/manual/en/index.html) for further details.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.