TR0118

Cognos® Transformer cannot read the database database_name defined in PowerCube.

Cognos Transformer cannot open the database specified as the data source.

Procedure

  1. If you used an .iqd file as the data source in your model, do the following:
    • Check the size of the query to see if it exceeds the SQL limit and, if so, try removing some of the columns in the report that the .iqd file is based on.
    • Ensure that the appropriate access was granted, and that the database user ID and password are valid.
    • Confirm that the report that created the .iqd file runs successfully.
  2. If you are using Cognos Transformer to generate a PowerCube on an HP-UX 10 server computer, and the data source is an .iqd file that accesses a Sybase database, ensure that the following requirements are met:
    • Open Client must be installed on the HP-UX server computer.
    • The Sybase and DSQuery environment variables must be set.
    • The Sybase /bin directory must be in the path.