IBM Support

DB2 SQL error from Sterling B2B Integrator: SQLCODE: -1585, SQLSTATE: 54048

Troubleshooting


Problem

This DB2 SQL error occurs with Sterling B2B Integrator: SQLCODE: -1585, SQLSTATE: 54048

Symptom

com.sterlingcommerce.woodstock.profile.ProfileFinderException: listAllByEntityName: Finder Exception occurred:
SQLState: 54048
Message: DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null
Vendor: -1585

Cause

The DB2 instance did not have all 4 sizes of Temp tablespace defined.
DBA had manually created the Temp tablespaces but only the 8k and 32k size.

Resolving The Problem

The DB2 instance must have all 4 sizes of Temp tablespace created: 4k, 8k, 16k, and 32k.

In addition, these must be set as System Temp tablespaces, and not as User Temp tablespaces.

[{"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF012","label":"IBM i"},{"code":"PF010","label":"HP-UX"},{"code":"PF002","label":"AIX"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Historical Number

PRI26178;SCI94737

Document Information

Modified date:
11 February 2020

UID

swg21529563