Troubleshooting the Cognos® Transformer
If you encounter problems when you deploy or configure the IBM® Cognos® Transformer component or when you are using the Metrics application, use this information to help resolve the problem.
- UnstisfiedLinkError
-
When you configure Cognos® Transformer with the Cognos® Configuration Tool, you see the following error message:
UnstisfiedLinkError:JCAM_Crypto_JNI(Not found in java.library.path)
This error indicates that the Java™ library might not be found by the Cognos® Configuration Tool. Correct the problem with the following steps:
- Set the LD_LIBRARY_PATH environment variable to point to the Cognos® BI /bin64 folder by running the following
command:
LD_LIBRARY_PATH=/opt/IBM/CognosBI/bin64
- Set the JAVA_HOME environment variable to point to the 64-Bit Java™ JRE by running the following
command:
JAVA_HOME=/opt/IBM/WebSphere/AppServer/java
- Start the Cognos® Configuration Tool with the following command:
- AIX® or Linux™:
cogconfig.sh
- Windows™:
cogconfigw.exe
- AIX® or Linux™:
- Set the LD_LIBRARY_PATH environment variable to point to the Cognos® BI /bin64 folder by running the following
command:
- PowerCube is not built
-
The Cognos® Transformer fails to build the PowerCube and returns the following errors messages:
MetricsAuditCube build error message: (TR0220) The temporary file for PowerCube 'MetricsAuditCube' is empty. Check that your source file contains data MetricsTrxCube build error message: (TR0793) Time-based partitioned PowerCube 'MetricsTrxCube' is empty. Check the data sources and the exclusion status of the categories in the target level.
It is likely that the Metrics database was not created correctly when you ran the database wizard, so there is no data to build into the PowerCube. This issue is caused by a mismatch on the date format, the SQL statement that inserts records used the default date format. However, the database was configured to use a different date format so records were never inserted into the database and the PowerCube cannot be built.
To correct this problem, follow the instructions in the IBM® technote, Metrics database creation with error message and Cognos® cube build failed.
- Cube build script hangs
-
Cube build script hangs after it posts the message Reading source data to the Cognos® Transformer Cube build log (called trxschelog.log).
The Transformer is not properly configured. Correct the problem by running the configuration tool silently:
Linux™
export JAVA_HOME=WAS_install_path/java/jre export LD_LIBRARY_PATH=$Cognos_BI_Server_install_path/bin64:$LD_LIBRARY_PATH Cognos_Transformer_install_path/bin/cogconfig.sh -config
Windows™
Cognos_Transformer_install_path\bin\cogconfig.bat -config
- \bin directory not be found
-
On Linux™ or AIX®, messages appear in the cognos-setup.log, indicating that the \bin directory cannot be found; for example:
mv: cannot start ’/Cognos/c10/bin/cogconfig.sh': No such file or directory
Or
cp: cannot create regular file `/Cognos/c10/bin': No such file or directory
Such a message indicates that the installed Cognos® Transformer software is corrupted.
The
cognos.transformer.issetup
property value was incorrectly set to the same value as thecognos.biserver.issetup
property in the cognos-setup.properties file. These properties must not be identical. Modify thecognos.transformer.issetup
property and run the cognos-setup.sh script again. - Configuration log contains both ERROR and SUCCESS messages
-
The cognos-configure.log file contains the following messages:
ERROR: The system cannot find the file specified.
SUCCESS: The scheduled task "MetricsCubeDailyRefresh" has successfully been created.
ERROR: The system cannot find the file specified.
SUCCESS: The scheduled task "MetricsCubeWeeklyRebuild" has successfully been created. Finished Cube refresh scheduler.
These messages are generated from the section of the cognos-configure.sh|.bat script that sets up the cube refresh scheduler. The first error message can be disregarded, provided a success message follows it for the "MetricsCubeDailyRefresh" task and for the "MetricsCubeWeeklyRebuild" task, as shown in the example.
Proceed with the installation.
- AIX: PowerCube build script fails with code TR0154
-
On AIX®, the PowerCube’s build script fails with following message in the build log:
(TR0154) Transformer could not set the application locale.
Possible causes for this problem are as follows:
- Changes to the Cognos® Configuration tool were saved and
applied after the Transformer was installed and configured:
- Open the Cognos® Configuration tool.
- Provide the Cognos® BI Server's gateway information.
- Save and Apply the change.
- The locale is set incorrectly. Set the application locale manually before you run the build
script again, and update the cron job for future builds.
- Set the application locale before you run the build script again by running following commands:
export LANG=en_US.UTF-8 export LC_ALL=en_US.ISO8859-1
- For future builds, update the cron jobs in the system crontab and insert same commands before
the cube build
command:
For example, change the existing cron job from:export LANG=en_US.UTF-8; export LC_ALL=en_US.ISO8859-1;
to:05 00 * * 1-6 /opt/IBM/CognosTF/metricsmodel/daily-refresh.sh
05 00 * * 1-6 export LANG=en_US.UTF-8; export LC_ALL=en_US.ISO8859-1; /opt/IBM/CognosTF/metricsmodel/daily-refresh.sh
- Set the application locale before you run the build script again by running following commands:
- Changes to the Cognos® Configuration tool were saved and
applied after the Transformer was installed and configured:
- PowerCube build script fails with code TR3001
-
The Cognos® cube build script fails and the following error message appears in the cube build log:
(TR3001) The Cognos gateway is unable to connect to the Cognos BI server. The server might be unavailable or the gateway might not be correctly configured. Try again or contact your administrator.
(TR0116) Transformer can't open the file Data_source_name.
Possible solutions to this problem are as follows:- Verify that the Cognos® BI server is available.
- Verify the following settings in the Cognos® Transformer
configuration point to the correct Cognos® BI Server host
and port:
- Gateway URI
- Dispatcher URI for external applications
- Verify that the WebSphere®
setting contains only the following entries:
*:cognos_bi_server_http_port
*:cognos_bi_server_https_port
Cognos_BI_Server_host:Cognos_BI_Server_port
- PowerCube build script fails with code TR3703
-
The Cognos® cube build script fails and the following error message appears in the cube build log:
(TR3703) The user ID or password is either missing or invalid. Please re-enter the credentials.
Verify that the Cognos® administrator user name and password that is specified in the cognos-setup.properties file were correct during the Cognos® configuration step and are still valid. If the user name and password are wrong or no longer valid, enter the correct values in the cognos-setup.properties file and then rerun the cognos-configuration.sh|bat script to configure the Cognos® server again.
- PowerCube build script fails with code QE-DEF-0285
-
The Cognos® cube build script fails and the following error message appears in the cube build log:
QE-DEF-0285 The logon failed.
QE-DEF-0321 The userID or password is either missing or invalid.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: METRICS_CUBE_DS
Verify that the METRICS database settings (db name, user name, and password) specified in the cognos-setup.properties file were correct during the Cognos® configuration step and are still valid. If any of the values are wrong or no longer valid, enter the correct values in the cognos-setup.properties file and then rerun the cognos-configuration.sh|bat script to configure the Cognos® server again.
- PowerCube build script fails with code RQP-DEF-0068
-
The Cognos® cube build script fails and the following error message appears in the cube build log:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: METRICS_CUBE_DS
More messages might appear indicating that the native database libraries cannot be loaded.
Possible solutions to this problem are as follows:- Verify that the database client is installed on this server and is configured correctly to connect to the METRICS database. 2.
- For DB2® on Linux™,
source the DB2® profiles before you run the cube build script
again. Add the source command into the user profiles who run the daily and weekly cube build cron
jobs. For example:
. ~db2inst1/sqllib/db2profile
- PowerCube fails to update
-
The cube failed to update due to a logon issue where a Cognos administrative user name includes a space.
Refreshing cube fails when it runs the following operations:
build-all.sh
daily-refresh.sh
weekly-rebuild.sh
In trxschelog.log the following error message is logged:
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: METRICS_CUBE_DS.
- Check the MetricsAuditCube.mdl and MetricsTrxCube.mdl files found in the Cognos_Transformer_install_path/metricsmodel folder with a text editor.
- Find the line in each file that begins with: Signon #### "LCUSER".
- Check the UserId item in these lines.
- If the Cognos admin user name is truncated, for example if John Smith appears as John, then enter the correct full name.
- PowerCube refresh fails
-
Refreshing cube fails when it runs the following operations:
build-all.sh
daily-refresh.sh
weekly-rebuild.sh
In trxschelog.log the following error message is logged:
End processing 0 records from data source 'MetricsCubeDS~1'.
Timing, READ DATA SOURCE,00:00:02
End cube update.
Timing, TOTAL TIME (CREATE CUBE),00:00:02
(TR0162) Package or report is not accessible. [->OK]
Closing model file /opt/IBM/Cognos/temp/ppd07835.qyj
- Open the MetricsAuditCube.mdl file found in the Cognos_Transformer_install_path/metricsmodel/ folder with a text editor.
- Find and delete the line: PackageTimeStamp "/content/folder[@name='IBMConnectionsMetrics']/package[@name='MetricsCubeDS']/model[@name='2012-05-02T02:09:03.848Z']".
- Save the mdl file and run cube refresh again.
- build-all script fails to complete
-
The build-all script fails to complete, even if the build process for some months has completed successfully.
The build-all process will build cubes by month, hence we can see messages like the following one in the console:
Build data for Year_Month success
Use the following script to resume the build-all process:
incremental-rebuild
To run this script, provide a starting month. The data builds from this month.
For example, if the build-allprocess failed for May 2014, use the following command to resume the build process:
incremental-rebuild-build.start.month=201405
This process can be repeated until all data is successfully completed.