Rational Common Reporting XML ODBC driver

Using the Rational® Common Reporting XML ODBC driver.
Windows When configuring system DSN, you encounter one of the following errors: The setup routines for the Rational Common Reporting XML ODBC Driver could not be loaded due to system error 126
ratlxml_resources ures_openU fail!
  1. Verify the settings in the Windows® registry:
    1. Click Start, click Run, type regedit and click OK.
    2. In the registry, go to My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM® Rational Common Reporting XML ODBC Driver and make sure the Driver and Setup properties point to the correct file path of ratlxml.dll.
    3. In the registry, go to My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers and make sure IBM Rational Common Reporting XML ODBC Driver is found to be installed.
    4. In the registry, go to My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources and make sure the system DSN you are configuring is using IBM Rational Common Reporting XML ODBC Driver.
  2. Verify the setting of the JDBC driver path:
    1. On the desktop, right-click My Computer and click Properties,
    2. On the System Properties page, click Advanced and click Environment Variables.
    3. Make sure that $INSTALLDIR\dataconfig\jdk\bin\classic appears at the beginning of the PATH and Path variables of user variables and system variables.
Linux When Testing the Connection of an ODBC data source in IBM Cognos® BI Server, you get the following error: Data name not found, and no default driver specified
When you use the helper application of driver manager, e.g., the isql application of unixODBC, to access a system DSN, you get the following error:Data name not found, and no default driver specified
  1. Check the odbcinst.ini file:
    1. Open the odbcinst.ini file in a text editor.
    2. Go to the [Rational Common Reporting XML ODBC Driver] slot.
    3. Make sure the Driver property points to the correct file path of libratlxml.so
  2. Check the odbc.ini file:
    1. Open the odbc.ini file in a text editor.
    2. Make sure the desired system DSN exists and the value of its Driver property is IBM Rational Quality Manager Report Authoring XML ODBC Driver. If the DSN does not exist, add it as shown in the example:
      [RationalQualityManager]
         Driver = IBM Rational Common Reporting XML ODBC Driver
         DataSource = Rational Quality Manager
         Description = A DSN example
         Configuration = /opt/ibm//dataconfig/Configuration/rationalqualitymanager.xdc
  3. Verify the JVM path
    1. On the console, run the export command.
    2. Make sure the variable "LD_LIBRARY_PATH" includes the path of IBM Java™ Virtual Machine carried by Rational Common Reporting. An example is /opt/ibm//AppServer/java/jre/bin;/usr/local/lib.
    3. Make sure the variable "PATH" includes the path of IBM Java Virtual Machine carried by Rational Common Reporting. An example is /opt/ibm/RationalInsight/AppServer/java/jre/bin/classic.
If the JDBC driver throws a Premature EOF exception
Increase the write timeout for the HTTP inbound channel for the HTTP port for the data service. To do so:
  1. Determine the server and port for the data service being used for the collection by looking for the URL in the XML data configuration.
  2. Open the WebSphere® Application Server administrative console for the WebSphere Application Server instance for the data service.
  3. Click Servers > Application servers.
  4. Click Rational Common Reporting Server.
  5. Expand Container Settings > Web Container Settings and click on the Web container transport chains.
  6. Click the transport chain for the port used by the data service.
  7. Click the HTTP inbound channel.
  8. Increase the length of the Write timeout. This determines how long WAS will wait when attempting to write to a client stream. The default value is 60 seconds.
  9. Click OK and click Save directly to the master configuration.
  10. Stop and restart the Rational Common ReportingWebSphere Application Server profile.
If you get a ParseException message
Make sure the modifiedsince clause in the SQL query confirm to the time format Like #dd-MMM-yyyy hh:mm:ss Z#.
If you get a CRREE2416E message
Make sure the where clause in the SQL query contains values with the associated column names in the queried table.
If you get a CRREE2403E message
Make sure the where clause in the SQL query does not contain column names that are not valid for the queried database.
If you get a CRREE1401E message
Make sure the data service is accessible and the URL of the resource group is defined correctly in the XML data configuration file.
If you get a CRREE1406E message
Make sure the user name and password of the queried resource group is correct.
If you get a HTTP 4XX message in the JDBC log file
In the XML data configuration file:
  1. Make sure the user name, password, and URL of the queried resource group are correct and pass the Test Connection test.
  2. Make sure the URL and schema of the resources being used are correct.
  3. Open the data mapping table editor being used and click Modify an existing data mapping template. Make sure there are no errors.
If you get a HTTP 5XX message in the JDBC log file
Verify your network connection status. Make sure the network configuation in the data service server is correct. For more information, see the data service server log.

Feedback