Question

Sequence and Sub-sequence Error when creating packages in FSM

  • 12 February 2020
  • 2 replies
  • 79 views

Badge +1

I am getting an error while creating a package in fsm. The error message states that the sequence and sub sequence is already exists. Could any one help me on this.


2 replies

Userlevel 7
Badge +24

Hi @manivirat2512,

Are you able to provide details of the package you are attempting to create an the specific steps you are taking that lead to the error? Also, is there a option to view more details on the error? If so these extra details may also assist.

Lastly, are you certain that the sequence and sub sequence does not, indeed, already exist as a package in the system?

Kind regards,

Lee Pinchbeck

Userlevel 6
Badge +20

Hi @manivirat2512 ,

 

We got the same issue reported by another customer and below are one of our technical consultant’s recommendation.

There is apparently a problem with the upgrade scripts’ handling of the Primary Key Index on the package_detail table.  We suggest that all the indexes should be rebuilt to solve this.

We would recommend that you look at rebuilding all the indexes.  This can be done using the FSM6_IndexRebuilderAll.sql script found in the \DatabaseData\SQLServer\Upgrade folder in the delivery package.

 

Hope this helps.

 

Kind Regards,

Kalpani

Reply