The EAR files do not deploy within the permitted time in JBoss environments.
As you increase the number of Operational Reference Stores, the EAR file deployment time increases. If the EAR file deployment time exceeds the permitted deployment time in JBoss environments, the upgrade fails.
To resolve the issue, increase the permitted deployment time to accommodate the EAR file deployment time. The default permitted deployment time is 600 seconds.
Increase the value of the
deploy.wait.time
property in the
build.properties
file in the following directory:
<infamdm installation directory>/hub/server/bin
Navigate to the following directory:
<JBoss installation directory>/standalone/configuration
Configure the following code in the
standalone-full.xml
file to increase the timeout value:
<subsystem xmlns="urn:jboss:domain:deployment-scanner:1.1">
<deployment-scanner path="deployments" relative-to="jboss.server.base.dir" scan-interval="5000" deployment-timeout="1200"/>
</subsystem>
The Hub Server upgrade fails.
To resolve the issue, redeploy the EAR file to retry the Hub Server upgrade.
In JBoss environments, if you manually change the configuration of data sources in the
standalone-full.xml
file when JBoss is running, you lose the configuration changes when you run the
patchInstallSetup
script.
Navigate to the following directory:
<
MDM Hub installation directory
>/hub/server
Run the following command to deploy the Hub Server application and apply changes to the application server configuration.
If you do not have embedded ActiveVOS in your environment, you do not need to include the ActiveVOS user names and passwords in the command.
On UNIX
patchInstallSetup.sh -Dweblogic.password=<WebLogic password> -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
WebSphere with security enabled
patchInstallSetup.sh -Dwebsphere.password=<WebSphere password> -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
WebSphere with security disabled
patchInstallSetup.sh -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
patchInstallsetup.sh -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
On UNIX, if you include an exclamation mark (!) character in the password, you must include a backslash before the exclamation mark (!) character. For example, if the password is
!!cmx!!
, enter
\!\!cmx\!\!
.
On Windows
patchInstallSetup.bat -Dweblogic.password=<WebLogic password> -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
WebSphere with security enabled
patchInstallSetup.bat -Dwebsphere.password=<WebSphere password> -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
WebSphere with security disabled
patchInstallSetup.bat -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
patchInstallsetup.bat -Ddatabase.password=<MDM Hub Master database password> -Davos.username=<ActiveVOS Console username> -Davos.password=<ActiveVOS Console password> -Davos.jdbc.database.password=<ActiveVOS database password>
The ActiveVOS Console credentials are the same credentials as the administrative user in the application server.
The ActiveVOS database credentials are the same credentials that were used to run the create_bpm script.
The Process Server upgrade fails in a WebLogic environment.
When you upgrade the Process Server in a WebLogic environment, the upgrade might fail with the following error:
Unable to start application, deployment error msg: weblogic.management.ManagementException: [Deployer:149196]Rejecting start request for application siperian-mrm-cleanse.ear because stop request is running for the application.
To resolve the issue, use the WebLogic Administrative Console to manually deploy the
siperian-mrm-cleanse.ear
file, and then restart the application server.
The Process Server upgrade fails.
To resolve the issue, redeploy the EAR file to retry the Process Server upgrade.
If you manually change the configuration of data sources in the
standalone-full.xml
file when JBoss is running, you lose the configuration changes when you run the
patchInstallSetup
script.
Navigate to the following directory:
<
MDM Hub installation directory
>/hub/cleanse
Run the following command to deploy the Process Server application and apply changes to the application server configuration.
On UNIX
patchInstallSetup.sh -Dweblogic.password=<
WebLogic password
> -Ddatabase.password=<
your database password
>
patchInstallSetup.sh -Ddatabase.password=<
your database password
>
patchInstallsetup.sh -Ddatabase.password=<
your database password
>
On Windows
patchInstallSetup.bat -Dweblogic.password=<
WebLogic password
> -Ddatabase.password=<
your database password
>
patchInstallSetup.bat -Ddatabase.password=<
your database password
>
patchInstallsetup.bat -Ddatabase.password=<
your database password
>
On UNIX, if you include an exclamation mark (!) character in the password, you must include a backslash before the exclamation mark (!) character. For example, if the password is
!!cmx!!
, enter
\!\!cmx\!\!
.
The Informatica Platform Upgrade fails.
When I upgrade an Operational Reference Store, Oracle generates error ORA-20005.
If you encounter error ORA-20005 when you run
sip_ant updateorsdatabase
, perform the following steps:
Run the following command to grant the required permissions:
exec dbms_java.grant_permission(upper('ORS_USER'),'SYS:java.net.SocketPermission','*',
'connect,resolve');
Run the following command to confirm that the Java classes are loaded in Oracle:
select dbms_java.longname(object_name), status from user_objects where object_type='JAVA CLASS';
If the classes are not loaded, run the following command to reload the classes:
loadjava -verbose -force -resolve -oracleresolver -user &ors_name/&ors_passwd@&tns_name siperian-cleansecaller.jar
loadjava -verbose -force -resolve -oracleresolver -user &ors_name/&ors_passwd@&tns_name siperian-dbutil.jar
The Hub Store upgrade fails.
You cannot rerun the Hub Store upgrade on a partially upgraded schema. If the upgrade fails, restore the database from a full backup, and then rerun the Hub Store upgrade.
If the Hub Store upgrade fails because column names contain reserved words, contact Informatica Global Customer Support for scripts to migrate the data to renamed columns.
After upgrading from a non-English locale, some tables are in English and some are in the language of the locale.
If your Hub Store database environment is set to a non-English locale, you must change the character set to Unicode before you run the upgrade scripts to upgrade the MDM Hub Master Database and Operational Reference Stores. During the upgrade, all table metadata is translated to English with a translation key. If you did not select a Unicode character set, only some tables are translated.
Hub Console fails to launch
The Hub Console fails to launch in a JBoss environment
In JBoss environments, if the JBoss application server does not restart, you cannot launch the Hub Console. The MDM Hub generates an error to indicate that the repository layer did not initialize.
To resolve the issue, run the following code in a batch file to restart JBoss:
rmdir C:\<JBoss installation directory>\standalone\tmp /s /q
mkdir C:\<JBoss installation directory>\standalone\tmp
C:\<JBoss installation directory>\bin\standalone.bat -c standalone-full.xml -b 0.0.0.0
Hub Console fails to launch in a DB2 environment
In an MDM Hub environment with DB2 datasources, the Hub Console fails to launch with the following errors:
SIP-09070: SIP-10318: Couldn't get users due to data access error.
SIP-10324: There was an unexpected exception when attempting to load data object(s). java.lang.NullPointerException
This issue is caused by a mismatch in the case used for the administrative user name in the MDM Hub and in the application server. For example, the MDM Hub has the administrative user DB2ADMIN (uppercase) while the application server has db2admin (lowercase).
To resolve the issue, ensure that the user name in the application server exactly matches the user name in the MDM Hub.
To avoid issues related to case-sensitivity, Informatica recommends using all uppercase letters when defining user names for DB2.
For example, if you are using WebSphere, set the user name in the WebSphere Console.
Open the WebSphere Console.
Navigate to
Resources > Data sources > siperian-cmx_system-ds > Custom properties
.
In the User field, type in uppercase:
DB2ADMIN
In the Password field, type the password for this user.
Click
Apply
, and then click
Save
.
Restart WebSphere.
Launch the Hub Console and log in.
In IDD, users cannot use the legacy Data View to view records that are based on subject areas.
The default page to view records in IDD is the Entity View that is based on business entities.
To use the legacy Data View, set
dataview.enabled
to
true
in the
cmxserver.properties
file.
For more information, see the following How-to article:
Migrating IDD Applications to the Business Entity Data Model
.
IDD fails with the error SIP-BV-11500.
IDD can fail with the following error:
SIP-BV-11500 Fatal Error Operational Reference Store localhost-orcl-MDM_SAMPLE does not have a workflow engine configured. Each Operational Reference Store must have a workflow engine configured for use with the IDD even if workflow will not be used.
To resolve this issue, ensure that the primary workflow adapter is configured.
When you validate the metadata, an error states that the object exists in the metadata but not in the database.
When you use the Repository Manager to fix the issue, the following error occurs: ORA-00955 Name is already used by an existing object.
To resolve the issue, ensure that the correct privileges for the proxy role are granted for the tables that encounter the error. Refer to a table that does not encounter the error to get the list of permissions that are required.
On Windows, when match tokens are generated, an error occurs.
The Generate Match Tokens process returns an error that says that the class
ssa.ssaname3.jssan3cl
cannot be initialized.
Verify that the PATH environment variable includes the path to the following directory, which contains the dynamic linked library (DLL) files for SSA-NAME3:
<MDM installation directory>/hub/cleanse/lib
Verify that Microsoft Visual C++ Redistributable for Visual Studio 2015 is installed on the Process Server that performs search and match for the MDM Hub.
If Microsoft Visual C++ Redistributable for Visual Studio 2015 is installed, use a dependency checker, such as Dependency Walker (depends.exe), to load
jssan3cl.dll
and confirm that the Visual C++ Redistributable was successfully applied.
Visual C++ Redistributable for Visual Studio 2015 requires that Windows Server has operating system patches installed. Check the operating system requirements before installing Visual C++ Redistributable. For example, from a baseline version of Windows Server 2012, you must apply around 100 patches (totalling approximately 2 GB) to the operating system before you can successfully install Visual C++ Redistributable.
After you upgrade in a Microsoft SQL Server environment on a WebLogic application server, you cannot log in to the Hub Console.
A null pointer exception occurs when you log in to the Hub Console.
To resolve the issue, comment out the drop commands, create schema commands, and any role commands in the
xa_install.sql
script located in
<Microsoft SQL Server installation directory>\sqljdbc_4.0\enu\xa
. Run the script, and then restart the application server.
The upgrade component patchInstallSetup fails when you install the Hub Server on a WebSphere Application Server.
To resolve the issue, open the file
<WebSphere profile home>/properties/soap.client.props
and increase
com.ibm.SOAP.requestTimeout
, and then restart the WebSphere server profile. Run
patchInstallSetup.bat
again.
The entity360view.ear file fails to deploy when you upgrade the Hub Server in IBM AIX environments.
To resolve the issue, run the
patchInstallSetup.sh
script.
