Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

There was a change made in hot fix 32RO04 that affects the following Oracle sequence keys:

To fix the problem, reinitialize the keys by issuing the following Oracle commands where desired number is the maximum current _sk value plus 1 (the desired next sequence number):

DROP SEQUENCE SEQ_VEHICLE_SK;
CREATE SEQUENCE SEQ_VEHICLE_SK START WITH desired number;

DROP SEQUENCE SEQ_VEHICLE_ATTR_SK;
CREATE SEQUENCE SEQ_VEHICLE_ATTR_SK START WITH desired number;

Rerun the failed job following the reinitialization.

Operating System and Release Information

A fix for this issue for SAS Merchandise Intelligence 3.2 is available at: