Troubleshooting tips for Windows environment

Troubleshooting tips are provided for some of the common issues that might occur during installation of Sterling B2B Integrator.

Table 1. Troubleshooting tips for Windows environment
Situation Message or Symptom Explanation/Resolution
Installing You encounter errors or problems during installation. Explanation

The installation creates several log files that you can use to diagnose problems like the failure of an installation.


Examine the log files generated during installation:
  • ant.install.log (in the <install_dir> directory)
  • \<install_dir>\PreInstallSI.log
  • \<install_dir>\InstallSI.log
Installing When you entered an absolute path during installation, a message indicated that the command was not found. Explanation

You entered an incorrect path. Check the information entered.


Enter the correct path.

Installing IM is installed successfully, but SI Fails to install. Go to Start Open IM select Help and then Export logs to a file for analysis.
Installing a desktop tool or resource Cannot download any of the following:
  • Map Editor and associated standards
  • Graphical Process Modeler
  • Web Template Designer

When you install Sterling B2B Integrator, system files are created that contain an internal IP address. If you install Sterling B2B Integrator behind a firewall, and your firewall is configured to accept an external IP address from a client computer, you may not be able to download the desktop tools and resources. The firewall will reject the internal IP address from a client residing outside of the firewall.


Modify the system files that contain the invalid IP address. Follow these steps:

  1. Navigate to \<install_dir>\bin.
  2. Stop Sterling B2B Integrator.
  3. Enter the following command followed by the external IP address:
    patchJNLP.cmd <external_IP_address>
  4. Restart Sterling B2B Integrator.
Cluster Installation or Upgrade When configuring TCPS the following warning can be found in the activemqbroker.log: SunCertPathBuilderException: unable to find valid certification path to requested target


Add the system certificate to the trust store using the KeyTool command.

Cluster Installation or Upgrade When configuring TCPS the following warning can be found in the activemqbroker.log:

Do not mention any SSL cipher in the ActiveMQconfig. xml. Invalid cipher suites specified.


Do not mention any SSL cipher in the ActiveMQconfig.xml.

e-Invoice Upgrade: Oracle Add Constraint Error When you upgrade Sterling e-Invoicing and are using an Oracle database, if the upgrade fails with the error message name is already used by an existing object, this occurs because the default behavior for the drop constraint command changed in Oracle 10. Explanation

The index that is used to support the constraint is now only removed if the index was generated by the create constraint command. The indexes for Sterling e-Invoicing are always generated from constraints during an install. If you receive this error during a Sterling e-Invoicing upgrade, it is because of how the database was restored, the version of Oracle you are using, and because the Oracle imp command exported the indexes and constraints separately. There is no way to determine when the imp command will not add a create index command to the export file if it was generated by a constraint – but if it does add the command, the database restore process loses the association of the constraint and its underlying index. The database script that runs during a Sterling e-Invoicing upgrade executes two steps: 1. First, it drops the unique constraint so the next step can redefine it using additional columns. However, the drop constraint command does not remove the underlying index if the association with its index was lost. 2. The next command that redefines this constraint requires a different index definition, but in this scenario the name of the index the constraint wants to use already exists, which causes the name is already used by an existing object error.


If you receive this error message, the solution for this problem is to drop the index and rerun the Sterling e-Invoicing upgrade. The drop index command you should use is: drop index UNQ_EINV_CANON

Apply a fix pack or Upgrade The \<install_dir>\installed_data directory is created (if clustered, on each node) during an upgrade or applying a fix pack.

This directory can become very large and take up needed space on the file system.


The information in this directory is used during upgrade or applying a fix pack, but is not required afterward. The deployment/cleanup tasks for the upgrade or fix pack do not remove this directory.


The directory can be manually removed to increase the available space for the file system:
  1. Navigate to \<install_dir>
  2. Enter rd /S installed_data
  3. If prompted to confirm deletion, enter Y for yes.