Unable to upgrade from 5032 to 5034
I'm running build 5032 and trying to upgrade to build 5034.
It fails and roll back to build 5032.
During the upgrade precess I get an error message :
Nov 4, 2006 12:22:57 PM com.adventnet.servicedesk.updatemgr.util.SCPostProcessor updateReportColumnDetailsTable
INFO: Exception while trying to update ReportColumnDetails table
java.sql.SQLException: null, message from server: "Duplicate entry '5024' for key 1"
The table ReportColumnDetails contains record with "COLUMN_ID" = 5024 as you can see in the attachment file reportcolumndetails.html.
To solve this problem:
1) I deleted all the records from the table ReportColumnDetails where "COLUMN_ID" >= 5024
2) I started again the update procedure and this time I succeeded.
3) After the update I saved again the Account additional fields.
Look how it looks the same table reportcolumndetails after update and save account additional fields, in the attachment file reportcolumndetails_UPD.html.
It is my update procedure correct ?
Or you have to fix update package ?
Regards,
It fails and roll back to build 5032.
During the upgrade precess I get an error message :
Nov 4, 2006 12:22:57 PM com.adventnet.servicedesk.updatemgr.util.SCPostProcessor updateReportColumnDetailsTable
INFO: Exception while trying to update ReportColumnDetails table
java.sql.SQLException: null, message from server: "Duplicate entry '5024' for key 1"
The table ReportColumnDetails contains record with "COLUMN_ID" = 5024 as you can see in the attachment file reportcolumndetails.html.
To solve this problem:
1) I deleted all the records from the table ReportColumnDetails where "COLUMN_ID" >= 5024
2) I started again the update procedure and this time I succeeded.
3) After the update I saved again the Account additional fields.
Look how it looks the same table reportcolumndetails after update and save account additional fields, in the attachment file reportcolumndetails_UPD.html.
It is my update procedure correct ?
Or you have to fix update package ?
Regards,