Installation FAQs and Troubleshooting

This section can help you troubleshoot some common error messages that you may receive.

What should I do if the Enterprise Message Service destination creation fails while configuring Fulfillment Order Management?

If TIBCO Enterprise Message Service is not installed on the same machine as Fulfillment Order Management, the destination creation fails. Create the destinations manually using the Enterprise Message Service Administration utility on the machine where Enterprise Message Service is installed.

For details, see $AF_HOME/ems/AF_CreateEMSChannel.txt (for non-OMS component). Another script is used for OMS located at $AF_HOME/ems/OMS_EmsConfiguration.txt.

What should I do when I get the "ORA-00942: table or view does not exist" error. I have created OMS database using the Database Wizard and see the tables created correctly in the database. What could be the problem?

Ensure you have configured the hibernate.default_catalog property correctly. This property can be configured using the Configurator UI and is located at the following path: "Order management System -> Member 1 -> Persistence -> hibernate.default_catalog. The value of this property should be the database user name of the OMS database.

What should I do if I get the following error related to the Oracle driver?

SEVERE: Error while registering Oracle JDBC Diagnosability MBean.

javax.management.MalformedObjectNameException: Invalid character ' ' in value part of property

at javax.management.ObjectName.construct(ObjectName.java:602)

at javax.management.ObjectName.<init>(ObjectName.java:1394)

This could be an Oracle driver issue. Try downloading the drivers from OTN again. A patch has been added for fixing this issue. To know whether you have the patch, run:

java -jar ojdbc6.jar
  • If the ojdbc6.jar contains the patch, the following is displayed:

    Oracle 11.1.0.6.0-Production+ JDBC 4.0 complied with JDK6

  • If the ojdbc6.jar does not contain the patch, the following is displayed:

    Oracle 11.1.0.6.0-Production JDBC 4.0 complied with JDK6

What should I do to get the Hibernate component if the servers where Fulfillment Order Management will be deployed do not have Internet connectivity?

Download the product_tibco_hibernate_3.6.9.001.zip file from the http://public.tibco.com/pub/tibco_oss/hibernate/product_tibco_hibernate_3.6.9.001.zip location.

What should I do if I see the ORACLE related errors during migration?

Set of ORACLE errors are bound to occur if other scripts have already been executed. For example, purge scripts. Such ORACLE errors have been added to the ignore list and they do not cause the migration to fail. However, any error other than the defined list results in the database migration failure.

All the errors are logged in the $AF_HOME/migration/log/DBmigration<<dd-mm-yyhr:min:dec>>.log file:

Error Codes Description
ORA-00942 Table or view does not exist
ORA-00955 Name is already used by an existing object
ORA-01418 Specified index does not exist
ORA-02289 Sequence does not exist
ORA-02442 Cannot drop nonexistent unique key
ORA-02443 Cannot drop constraint - nonexistent constraint

What should I do to upgrade EMS from version X to 8.x.x?

Ensure you back up all the data store and configuration files before performing any upgrade.

For single EMS server, perform the following steps:

Steps to upgrade the EMS server:

  1. Disconnect all your applications connecting to the current EMS versions.
  2. Stop the EMS server.
  3. Back up all the configuration files and the data store for the EMS server.
  4. Uninstall the current version of EMS server.
    Note: You can skip this step if you want to have multiple EMS server versions on the box. It is not recommended.
  5. Install EMS server 8.x.x.
  6. Update the environment variables accordingly on the EMS server box to reflect the new EMS installation path.
    Note: EMS 8.x.x is installed in the $TIBCO_HOME/ems/8.x folder. Ensure that you modify the environment variables set for the EMS servers and other applications accordingly.
  7. Start the EMS server against your old configuration files and data store.
  8. Start all the applications that you want to connect the EMS server.

If you have set up the EMS server to work on Fault Tolerant, perform the following steps:

  1. Back up the .conf and .db files.
  2. Shutdown the standby EMS server (version X) by connecting to it through EMSAdmin and issuing the shutdown command.
    Note: Ensure that you are connected to the standby server by executing the info command and verifying the state before issuing the shutdown command.
  3. Restart the standby version 8.x.x EMS server having the same configuration setup as that of the standby server. This locks the database files and becomes the standby server. The standby server then runs with the EMS version X.
  4. Shutdown active version X EMS server by connecting to it through EMSAdmin and issuing the shutdown command.
    Note: This step activates the standby server, resulting in the shared state conversion to the 8.x.x version. The active server then runs with the 8.x.x version.
  5. View the active server log file to verify that the original standby server has been successfully activated.
  6. To ensure that applications remain connected and they are processing messages, wait for a few minutes.
  7. Restart the previously active EMS server in standby mode with the 8.x.x EMS version with the same configuration file of the previous active EMS server (version X).
  8. To fail back to the original server, shut down the active server.
    Note: This step is optional. To ensure that both the EMS servers are able to become active during failover, start the standby EMS server to make both EMS servers run in FT mode.

What should I do if I get the following error message?"Resource Bundle Not found as per locale - java.util.MissingResourceException: Can't find bundle for base name com.tibco.mdm.properties.activecatalog.HierarchyMessages" in OMS-UI startup logs.

Ignore this message

What should I do if I want to run the spring boot service on IPv4 only?

Set the following parameter in order to change the network interface:
export _JAVA_OPTIONS="-Djava.net.preferIPv4Stack=true"