Skip to Content
avatar image
Former Member

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Failed to open the connection. Failed to open the connection.

Use the sample program for connecting crystal report by passing database connecting parameters, its giving

Error 10884_9404_{0F3C851E-1913-40C5-8403-94B834395DF6}.rpt---- Error code:-2147482892 [CRSDK00000000] Error code name:failed

  at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException.

4.0 BI server version.

Code.

//Obtain collection of tables from this database controller. Tables tables = databaseController.getDatabase().getTables();

//Set the datasource for all main report tables. for (int i = 0; i < tables.size(); i++) {

ITable table = tables.getTable(i);

//Keep existing name and alias. table.setName(table.getName()); table.setAlias(table.getAlias()); //Change properties that are different from the original datasource. table.setQualifiedName(TABLE_NAME_QUALIFIER + table.getName()); //Change connection information properties. IConnectionInfo connectionInfo = table.getConnectionInfo(); //Set new table connection property attributes. PropertyBag propertyBag = new PropertyBag(); //Overwrite any existing properties with updated values. propertyBag.put("Trusted_Connection", "false"); propertyBag.put("Server Name", SERVERNAME); //Optional property. propertyBag.put("Connection String", CONNECTION_STRING); propertyBag.put("Database Name", DATABASE_NAME); propertyBag.put("Server Type", "JDBC (JNDI)"); propertyBag.put("URI", URI); propertyBag.put("Use JDBC", "true"); propertyBag.put("Database DLL", DATABASE_DLL); connectionInfo.setAttributes(propertyBag); //Set database username and password. //NOTE: Even if these the username and password properties don't change when switching databases, the //database password is *not* saved in the report and must be set at runtime if the database is secured.  connectionInfo.setUserName(DBUSERNAME); connectionInfo.setPassword(DBPASSWORD); connectionInfo.setKind(ConnectionInfoKind.SQL); table.setConnectionInfo(connectionInfo); //Update old table in the report with the new table. databaseController.setTableLocation(table, tables.getTable(i)); }

can anybody help on this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 12, 2015 at 11:09 AM

    Hi John,


    Please specify BusinessObjects product version(with patches if any)?

    Are the reports managed or unmanaged?
    What is the behaviour from CR designer, are you able to refresh report after changing datasource from Cr designer?

    Try to run the attched code and let me know if it works.


    Thanks,

    Prithvi


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Prithviraj Shekhawat

      Hello Prithivi,

      I am using Managed reports, reports are published to BO system.

      Yes, I am able to connect reports from crystal report designer with new database connection.

      can you let me know which way is beneficial unmanaged reports or managed reports, our purpose to have reports are on demand reports from different server.

      how the licensing handle on unmanaged reports.