Troubleshooting
Problem
Running the view script in IBM Sterling Ordre Management 9.5 leads to error invalid database object.
Cause
Dropped column (Allocate_Date) is getting referred in the views. yfs_order_release_line and yfs_order_release_line_vw.
Diagnosing The Problem
yfs_order_release_line,yfs_order_release_line_vw are invalid database objects because of Allocate_Date column is missing from YFS_ORDER_LINE.
Resolving The Problem
Steps to resolve
- Edit the view definition sql files for the corresponding views available in <INSTALL_DIR>/database\<dbtype>/scripts/CustomDBViews/transaction and remove the reference to column Allocate_Date.
- Recreate the views
[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.5","Edition":"All Editions","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Product Synonym
Sterling OMS
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21999984