Technote (troubleshooting)
Problem(Abstract)
Business Center allows the arrangement of categories into the order they are to be displayed on the web channel. When multiple categories have the same sequence number in the database, the categories can no longer be moved.
Symptom
The issue is noticed when the catalog administrator is unable to arrange/move categories in the catalog using Sterling Business Center.
Cause
The display of categories is controlled by the YFS_CATEGORY.SEQUENCE_NO column. When categories belonging the same parent category (PARENT_CATEGORY_KEY) have the same sequence number (SEQUENCE_NO) the categories can not be arranged using Sterling Business Center.
Diagnosing the problem
The is problem can be diagnosed by running the following SQL on the database to determine which categories have the same sequence number as the one you are unable to move.
SELECT CATEGORY_ID, SEQUENCE_NO FROM YFS_CATEGORY WHERE SEQUENCE_NO = (SELECT SEQUENCE_NO FROMYFS_CATEGORY WHERE CATEGORY_ID = '<Your Category Id>') AND PARENT_CATEGORY_KEY = (SELECT PARENT_CATEGORY_KEY from YFS_CATEGORY WHERE CATEGORY_ID = '<Your Category Id>')
Note: Substitute <Your Category Id> with the category id which can not be moved.
Resolving the problem
This issue is resolved by either manually updating the YFS_CATEGORY.SEQUENCE_NO column using SQL or running the manageCategory API to change the sequence number for the affected categories.
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Commerce | Sterling Selling and Fulfillment Suite | AIX, HP-UX, Linux, Solaris, Windows | 9.0 |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.