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. Resolution 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. Resolution 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	Explanation 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. Resolution Modify the system files that contain the invalid IP address. Follow these steps: Navigate to \<install_dir>\bin. Stop Sterling B2B Integrator. Enter the following command followed by the external IP address: `patchJNLP.cmd <external_IP_address>` Restart Sterling B2B Integrator.
Cluster Installation or Upgrade	When configuring TCPS the following warning can be found in the activemqbroker.log: `sun.security.provider.certpath. SunCertPathBuilderException: unable to find valid certification path to requested target`	Resolution 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. oracle.net.ns.NetException: Invalid cipher suites specified.`	Resolution 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. Resolution 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.	Explanation 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. Resolution The directory can be manually removed to increase the available space for the file system: Navigate to \<install_dir> Enter `rd /S installed_data` If prompted to confirm deletion, enter `Y` for yes.