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

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"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":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

PRI26178
SCI94737

Document Information

More support for:
IBM Sterling B2B Integrator

Software version:
All

Operating system(s):
Windows, Solaris, Linux, IBM i, HP-UX, AIX

Document number:
439759

Modified date:
11 February 2020

UID

swg21529563

Manage My Notification Subscriptions