1656907 - There are database logon errors generated in trace log file of database at database server side when using Java Reporting Component SDK via JDBC

SAP Knowledge Base Article - Public

1656907 - There are database logon errors generated in trace log file of database at database server side when using Java Reporting Component SDK via JDBC

Symptom

There are database logon errors at database server side when using JRC SDK via JDBC.

Environment

  • Crystal Reports 2008.
  • Crystal Reports for Eclipse 2.0.

Reproducing the Issue

  1. Configure the JDBC connection from JRC project to database server.
  2. Deployed the attached JRC application code under Crystal Reports for Eclipse 2.0 .
  3. Refresh the report data and check the error log at database server side , you will see the errors like below :

        ----------------------------------------------------------------------------------------------   

        2010-12-10 10:20:25.03 Logon       Error: 18456, Severity: 14, State: 8.
        2010-12-10 10:20:25.03 Logon       Login failed for user 'sa'. [CLIENT: 127.0.0.1]
        ----------------------------------------------------------------------------------------------  

    Note, it might take a few minutes before the error is flushed to the log file, try the workflow several time to make it happen.

Cause

The issue has been identified and logged under Problem Report ID ADAPT01512930.

 

Resolution

This issue has been fixed in Gemini Service Pack 10 for Crystal Reports for Java(CRJ).

Keywords

JAVA, CRJ , JRC , Logon , KBA , BI-BIP-ADM , BI Servers, security & CrystalReports viewing in BI platform , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; Crystal Reports, version for Eclipse 2.0

Attachments

Code for Reproduce.zip