B Troubleshooting a Migrated Oracle BI Instance
This appendix provides procedures to troubleshoot a migrated BI instance from 11g to 12c.
- Configuration Failure with TRANSFORMBAREXCEPTION
The 12c configuration might fail with a TRANSFORMBAREEXCEPTION error, if any objects in the catalog are older than Release 11.1.1.7. You can confirm the need to update the catalog items by viewing the metrics in Oracle Enterprise Manager Fusion Middleware Control. In the Catalog folder, find a metric called Reads Needing Upgrade with the description "The number of objects read that required upgrading." If the number is large, then you can resolve this issue by updating objects in the catalog using the Administration page in Presentation Services. - Multiple Y-Axis Highcharts Graphs Not Displayed
Multiple Y-axis highchart graphs likely don't render after migration, because the Oracle BI 12c instance does not include the required JavaScript (.js) files. You must copy the files to the instance manually. - Setting the Evaluate Parameter in the NQSConfig.INI File
The EVALUATE function in your analyses is not enabled by default in Logical SQL queries because it exposes the database to SQL injection attacks. If you encounter any error while generating any views after migrating to Oracle BI 12c, then you must set the value of the EVALUATE_SUPPORT_LEVEL parameter appropriately in the NQSConfig.INI file. - Error: java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment
If you have set the value of the DISPLAY variable manually or the system has manipulated it automatically, you can encounter the java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment error . In case you change the value of the DISPLAY variable to a Windows-client system IP, to run the 64-bit Linux installer through a Windows client, reset it to its original value after the installation is complete. If you generate an analysis that contains graphs without resetting the value of the DISPLAY variable, you can get this error. - Verifying File Data Sources in Oracle BI Publisher
While generating reports, if you encounter an error stating oracle.xdo.XDOException: File does not exist or is not readable:..., you might not have copied the supporting XML files to the 12c system. To solve this issue, manually validate that the path for each data source points to the appropriate directory on the 12c system. - Error on checkSoftLimit Failed
You see the [nQSError: 43119] Query Failed: [nQSError: 46168] Operation RawFile::checkSoftLimit failed, it'll exceed the current limitation. 1073758528 error if the query requires more temporary space to complete than the BI Administrator has allocated. - Act As Configuration Failing in 12c
The Act As functionality allows you to act for another user in Oracle BI EE. This functionality is useful, for example, when you need to work on another user's dashboard or content, or when IT support staff wants to troubleshoot another user's account. If you have migrated from Oracle BI 11g to 12c and cannot configure the Act As functionality on the 12c instance, you must first copy a file from the 11g instance. - Replacing Custom Links in the Global Header
After migrating to Oracle BI 12c, you might notice that links that you had added to the global header in the 11g instance are no longer available. The links are missing because the customlinks.xml file isn't migrated from the 11g to the 12c instance. You must manually copy the file to the 12c instance and enable the Custom Links functionality in the instanceconfig.xml file. - Migrating 11g WebLogic Users to 12c
After migrating from 11g to 12c, you must manually migrate the WebLogic users in to your 12c domain. You can do this by exporting the security data from a security realm and importing it in to another security realm. Security data includes authentication, authorization, credential map, and role data. - View Display Error: Invalid Column Encountered in Orders Outstanding Report
You might see a View Display Error message that states that an invalid column was encountered when loading the Orders Outstanding Report in 12c. This error is displayed because the ID of the column that causes the error exists in the XML definition of the report, but not in the subject area table. You must manually edit the XML definition and remove the invalid column. - View Display Error While Generating Oracle R-based Advanced Analytic Reports
If you see the following error message while generating Oracle R-based Advanced Analytic reports after you have upgraded to Oracle BI 12c, see the procedure in this topic to fix the issue. View Display Error: Odbc driver returned an error (SQLExecDirectW). Error codes: OPR4ONWY, U9IM8TAC, U9IM8TAC, U9IM8TAC, OI2DL65P.
Configuration Failure with TRANSFORMBAREXCEPTION
The 12c configuration might fail with a TRANSFORMBAREEXCEPTION error, if any objects in the catalog are older than Release 11.1.1.7. You can confirm the need to update the catalog items by viewing the metrics in Oracle Enterprise Manager Fusion Middleware Control. In the Catalog folder, find a metric called Reads Needing Upgrade with the description "The number of objects read that required upgrading." If the number is large, then you can resolve this issue by updating objects in the catalog using the Administration page in Presentation Services.
- Regenerating User GUIDs
This task requires that you manually edit the configuration files to instruct Oracle BI Server and Oracle BI Presentation Server to regenerate the GUIDs on restart. Once completed, you edit these files again to remove the modification. - Updating Oracle BI Presentation Services Catalog
When migrating from 11g, you must manually update your Oracle BI Presentation Services Catalog.
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Regenerating User GUIDs
This task requires that you manually edit the configuration files to instruct Oracle BI Server and Oracle BI Presentation Server to regenerate the GUIDs on restart. Once completed, you edit these files again to remove the modification.
Parent topic: Configuration Failure with TRANSFORMBAREXCEPTION
Updating Oracle BI Presentation Services Catalog
When migrating from 11g, you must manually update your Oracle BI Presentation Services Catalog.
Parent topic: Configuration Failure with TRANSFORMBAREXCEPTION
Multiple Y-Axis Highcharts Graphs Not Displayed
Multiple Y-axis highchart graphs likely don't render after migration, because the Oracle BI 12c instance does not include the required JavaScript (.js) files. You must copy the files to the instance manually.
- Change to the
\AnalyticsRes
directory on the 11g system. - Copy the following files from the 11g
\AnalyticsRes
directory to the 12c\AnalyticsRes
directory:- highcharts.js
- exporting.js
- jquery-1.8.2.min.js
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Setting the Evaluate Parameter in the NQSConfig.INI File
The EVALUATE function in your analyses is not enabled by default in Logical SQL queries because it exposes the database to SQL injection attacks. If you encounter any error while generating any views after migrating to Oracle BI 12c, then you must set the value of the EVALUATE_SUPPORT_LEVEL parameter appropriately in the NQSConfig.INI file.
The default value of the EVALUATE_SUPPORT_LEVEL parameter is "0", which means that evaluate is not supported.
# EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manageRepositories permission
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.
EVALUATE_SUPPORT_LEVEL = 0;
Manually set the value of the EVALUATE_SUPPORT_LEVEL parameter same as it is in the 11g NQSConfig.INI file or as required by your organization.
The NQSConfig.INI file is located at the following location:
(UNIX) 12c_DOMAIN_HOME/config/fmwconfig/biconfig/OBISn
(Windows) 12c_DOMAIN_HOME\config\fmwconfig\biconfig\OBISn
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Error: java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment
If you have set the value of the DISPLAY variable manually or the system has manipulated it automatically, you can encounter the java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment error . In case you change the value of the DISPLAY variable to a Windows-client system IP, to run the 64-bit Linux installer through a Windows client, reset it to its original value after the installation is complete. If you generate an analysis that contains graphs without resetting the value of the DISPLAY variable, you can get this error.
- Reset the value of the DISPLAY variable.
- Restart the JavaHost process.
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Verifying File Data Sources in Oracle BI Publisher
While generating reports, if you encounter an error stating oracle.xdo.XDOException: File does not exist or is not readable:..., you might not have copied the supporting XML files to the 12c system. To solve this issue, manually validate that the path for each data source points to the appropriate directory on the 12c system.
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Error on checkSoftLimit Failed
You see the [nQSError: 43119] Query Failed: [nQSError: 46168] Operation RawFile::checkSoftLimit failed, it'll exceed the current limitation. 1073758528 error if the query requires more temporary space to complete than the BI Administrator has allocated.
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Act As Configuration Failing in 12c
The Act As functionality allows you to act for another user in Oracle BI EE. This functionality is useful, for example, when you need to work on another user's dashboard or content, or when IT support staff wants to troubleshoot another user's account. If you have migrated from Oracle BI 11g to 12c and cannot configure the Act As functionality on the 12c instance, you must first copy a file from the 11g instance.
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Replacing Custom Links in the Global Header
After migrating to Oracle BI 12c, you might notice that links that you had added to the global header in the 11g instance are no longer available. The links are missing because the customlinks.xml file isn't migrated from the 11g to the 12c instance. You must manually copy the file to the 12c instance and enable the Custom Links functionality in the instanceconfig.xml file.
See Providing Custom Links in Presentation Services in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Parent topic: Troubleshooting a Migrated Oracle BI Instance
Migrating 11g WebLogic Users to 12c
After migrating from 11g to 12c, you must manually migrate the WebLogic users in to your 12c domain. You can do this by exporting the security data from a security realm and importing it in to another security realm. Security data includes authentication, authorization, credential map, and role data.
Understand when you would want to migrate security data. See Overview of Security Data Migration.
Understand the concepts associated with importing and exporting security data. See Migration Concepts.
Understand which formats and constraints are supported by the WebLogic Security providers. See Formats and Constraints Supported by WebLogic Security Providers.
Note:
You can only export and import security data between security realms in the same WebLogic Server release.Parent topic: Troubleshooting a Migrated Oracle BI Instance
Exporting the Security Data from a Security Provider
Importing the Security Data into a Security Provider
- In the left pane of the Administration Console, select Security Realms.
- Select the name of the security realm into which the security data is to be imported (for example, myrealm).
- Select Providers and then the type of provider into which security data is to be imported (for example, Authentication under Providers).
- Select the security provider in which the security data is to be imported and select Import under Migration.
- Specify the directory and file name of the file that contains the exported security data in the Import File on Server field.
- Click Save.
View Display Error: Invalid Column Encountered in Orders Outstanding Report
You might see a View Display Error message that states that an invalid column was encountered when loading the Orders Outstanding Report in 12c. This error is displayed because the ID of the column that causes the error exists in the XML definition of the report, but not in the subject area table. You must manually edit the XML definition and remove the invalid column.
Parent topic: Troubleshooting a Migrated Oracle BI Instance
View Display Error While Generating Oracle R-based Advanced Analytic Reports
If you see the following error message while generating Oracle R-based Advanced Analytic reports after you have upgraded to Oracle BI 12c, see the procedure in this topic to fix the issue. View Display Error: Odbc driver returned an error (SQLExecDirectW). Error codes: OPR4ONWY, U9IM8TAC, U9IM8TAC, U9IM8TAC, OI2DL65P.
Parent topic: Troubleshooting a Migrated Oracle BI Instance