APAR status
Closed as program error.
Error description
In Oracle when there is a complex structure or program package defined within a schema, and there is a public synonym defined to all allow global access to the structure and program package, DataPower will return the following error if the SQL Data Source object has a schema/user name that is not the owning schema of the artifacts. [sql][error] sql-source(sqlMyTest): tid(55480): Database reported query error: User defined type not found: DP.MYLIST Here user "Bob" owned the artifacts while schema/user of ?DP? on the DataPower SQL Data Source object resulted in this error.
Local fix
Utilize the userid/schema name in the SQL Data Source Object that owns the complex structure.
Problem summary
Affected is the use of DataPower with an Oracle database. Under certain circumstances, stored procedures invoked using public synonyms would fail to run properly.
Problem conclusion
Stored procedures can be run using public synonyms to refer to a schema, package, or stored procedure itself in DataPower fixpacks 4.0.2.8, 5.0.0.1, and follow on fixpacks. This fix only applies to invoking the stored procedure itself; synonyms are not supported for procedure parameter types. Fix is available in 4.0.2.8 and 5.0.0.1
Temporary fix
Invoke the stored procedure directly using its fully qualified name.
Comments
APAR Information
APAR number
IC82429
Reported component name
DATAPOWER BLAD
Reported component ID
DPBLADE01
Reported release
382
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-02
Closed date
2012-06-25
Last modified date
2012-11-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DATAPOWER BLAD
Fixed component ID
DPBLADE01
Applicable component levels
R402 PSY
UP
R500 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFGB5","label":"WebSphere DataPower Integration Blade XI50B"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.8.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
15 November 2012