Common IBM Sterling B2B Integrator errors

Unavailable – Too many non indexed BPs in the system.

This error occurs when you open the Troubleshooter page. Business Process Usage:

Unavailable – Too many non indexed BPs in the system. Please run the index BP service, manually terminate BPs or change ui.properties::MaxNonIndexBPs property value

To increase the number of processes displayed in the BP usage troubleshooter screen:

In customer_overrides.properties add ui.MaxNonIndexBPs=20000

The default value is 5000.
The maximum value is 100000.

This entry in customer_overrides.properties will override the value in
ui.properties.

The change will take effect after restarting the IBM Sterling B2B Integrator ISBI application.

Excessive errors in noapp.log: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (“SFGUSER”.”CD_STEP_INFO”.”STEP_ID”)

Check the CD_STEP_INFO Database trigger and sequence. If missing create with the following commands:

CREATE SEQUENCE CD_STEP_INFO_SEQUENCE
       INCREMENT BY 1
       START WITH 1
       NOMAXVALUE ;


     CREATE OR REPLACE TRIGGER CD_STEP_INFO_TRIGGER
       BEFORE INSERT ON CD_STEP_INFO
       FOR EACH ROW
       BEGIN
         SELECT CD_STEP_INFO_SEQUENCE.NEXTVAL INTO :NEW.STEP_ID FROM DUAL;
       END;