IBM Support

Error creating Reporting Schema on DB2

Troubleshooting


Problem

When trying to create a Reporting Schema in OpenPages using DB2, and error occurs.

Symptom

An error similar to the following will be displayed in the log for creating the reporting schema:

Create Reporting Schema: completed with errors
Oct 23, 2015 02:20 PM CDT Create Reporting Schema: ERROR Object =
General_; Parameters = [-727, SQL0727N An error occurred during
implicit system actio] The requested operation could not be completed.
Please contact your system administrator.

Oct 23, 2015 02:20 PM CDT Error: SQL0438N Application raised error or
warning with diagnostic text: "-722|21|-727|SQL0727N An error occurred
during implicit system actio". SQLSTATE=UD555

Oct 23, 2015 02:20 PM CDT Error: SQL0727N An error occurred during
implicit system action type "3". Information returned for the error
includes SQLCODE "-20481", SQLSTATE "429C3" and message tokens
"OPENPAGES.PKG_MASTER_CATEGORY_ID". SQLSTATE=56098

[{"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS4PJS","label":"IBM OpenPages on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data 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.

Document Information

Modified date:
15 June 2026

UID

swg21969947