IBM Support

Shipper release gives SqlCode 1403 Oracle error No data found cannot release wave shipper

Troubleshooting


Problem

Shipper release gives SqlCode 1403 Oracle error No data found cannot release wave shipper

Symptom

PART: Outbound 6.2 SP2 DCS
COMPONENT: <None>
OS: <None> - <None>
DATABASE: <None> - <None>
WEB SERVER: <None> - <None>
WEB BROWSER: Internet Explorer - 5.5 sp2

Cause

Resolving The Problem

Find out if any changes made recently to the system such as whse schema.
Both the whse_schema.map and the whse_schema.map.ded file should have the correct schema name in UPPER CASE.

In one situation the whse schema was changed from DCS to DCS78. Checked the whse_schema.map.ded which is used by wh132. the schema had been wrongly changed to dcs78, wheras in the whse_schema.map file the schema was entered correctly as the DCS78. The entry in whse_schema.map.ded had to be changed before shippers could be released.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI49037

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21534298

Page Feedback