APAR status
Closed as program error.
Error description
When trying to update the already existing data and the change is run via quick publish tooling the error ORA-01747 error appears. The steps to reproduce is as follow: 1) Go to management center 2) Create task group under Emergency workspace 3) Create task under above created task group. 4) Activate task group and right click show task list . 5) Select task and work on that particular task. 6) Go to management center tools and select catalog. 7) Upload shipping jurisdiction data csv file through upload catalog functionality. 8) Mark as complete task after successfully uploads. 9) Approve the task group to push changes on live database. Observed Results: [9/16/13 15:27:04:248 IST] 00000038 MSConfigLooku E com.mns.commerce.common.registry.helper.MSConfigLookupHelper getRedirectURLValue CMN0417E: The following SQL exception has occurred during processing: "{0}". java.sql.SQLSyntaxErrorException: ORA-00904: "KEY": invalid identifier which could comes from SQL: PSTMT: SELECT REDIRECT_FROM, REDIRECT_TO FROM XREDIRECTURL WHERE KEY=?
Local fix
Problem summary
USERS AFFECTED: Websphere Commerce users on v7.0 who use the quick publish tooling. PROBLEM ABSTRACT: When the quick publish task is run the error java.sql.SQLSyntaxErrorException: ORA-00904 is generated. BUSINESS IMPACT: Unable to run the quick publish task RECOMMENDATION:
Problem conclusion
The code for quick publish mechanism has been enhanced within the APAR JR47985 to avoid "java.sql.SQLSyntaxErrorException: ORA-00904: "KEY": invalid identifier" error. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Temporary fix
Comments
APAR Information
APAR number
JR47985
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Pervasive
Submitted date
2013-10-04
Closed date
2014-11-03
Last modified date
2014-11-03
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
WC BUS EDITION
Fixed component ID
5724I3800
Applicable component levels
R700 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 November 2014