cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

During Upgrade from MKS 2009 to PTC 10.5, I faced issues during update in database. Please refer the below screenshot. Can anyone help me on this.

gagarwal
1-Newbie

During Upgrade from MKS 2009 to PTC 10.5, I faced issues during update in database. Please refer the below screenshot. Can anyone help me on this.

GENERAL(5): Starting migration step from 12.101 to 12.102.

SQL(5): ALTER TABLE Issues ADD RevisionIDMajor INTEGER: 1710Ms

SQL(5): ALTER TABLE Issues ADD RevisionIDMinor INTEGER: 1407Ms

SQL(5): ALTER TABLE Issues ADD LiveItemID INTEGER: 1522Ms

SQL(5): INSERT INTO Fields (ID, CreatedDate, ModifiedDate, CreatedUser, ModifiedUser, Name, Content, DataTypeID, DataSize, Active, MultiValue, StorageFormat, Flags, PairedField, TableNumber, BackingType, BackingTextField, TextTable) VALUES(?, GETDATE(), GETDATE(), ?, ?, ?, ?, ?, ?, 1, ?, 0, ?, ?, 0, null, null, ?) [-53,null,null,'Live Item ID',<473 bytes>,0,0,false,0,0,0]: 5ms

SQL(5): INSERT INTO Fields (ID, CreatedDate, ModifiedDate, CreatedUser, ModifiedUser, Name, Content, DataTypeID, DataSize, Active, MultiValue, StorageFormat, Flags, PairedField, TableNumber, BackingType, BackingTextField, TextTable) VALUES(?, GETDATE(), GETDATE(), ?, ?, ?, ?, ?, ?, 1, ?, 0, ?, ?, 0, null, null, ?) [-54,null,null,'Major Version ID',<416 bytes>,0,0,false,0,0,0]: 21ms

SQL(5): INSERT INTO Fields (ID, CreatedDate, ModifiedDate, CreatedUser, ModifiedUser, Name, Content, DataTypeID, DataSize, Active, MultiValue, StorageFormat, Flags, PairedField, TableNumber, BackingType, BackingTextField, TextTable) VALUES(?, GETDATE(), GETDATE(), ?, ?, ?, ?, ?, ?, 1, ?, 0, ?, ?, 0, null, null, ?) [-55,null,null,'Minor Version ID',<416 bytes>,0,0,false,0,0,0]: 548Ms

SQL(5): SQLException: Cannot create a row of size 8092 which is greater than the allowable maximum row size of 8060.: error code=511, state=S1000

SQL(5): UPDATE Issues SET LiveItemID = ID: 3s135ms

GENERAL(0): java.sql.SQLException

SQL(0): SQL Rollback Total Time: 3s172ms

GENERAL(5): Done running isutil -c dbinstall for full server.

1 REPLY 1
KaelLizak
14-Alexandrite
(To:gagarwal)

Guarav,

This is something that should be investigated by PTC Integrity Lifecycle Manager Support.  Could you please open a ticket with them to investigate this?

Regards,

Kael


Kind Regards,
Kael Lizak

Senior Technical Support Engineer
PTC Integrity Lifecycle Manager
Top Tags