Skip to main content
M
md'ambrosio1-Visitor
1-Visitor
March 30, 2017
Solved

Upgrading from 2009 SP2 to Integrity Lifecycle Manager 10.7 fails with NullPointerException During Database Schema Update.

  • March 30, 2017
  • 1 reply
  • 1176 views

We found this article which seems to match the problem we are facing: 

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS209167&lang=en_US

e run the SQL against our Integrity Lifecycle Manager Server's database:

SELECT ID, Name FROM Fields WHERE Content=null;

and we found 2 records with null content.

Suggested workaround is:

For each Field that is returned, set a Description on the Field in the Admin GUI.

Confirm that no fields remain affected by re-running the SQL statement above prior to upgrading to 10.7 in Production.

But that workaround is not feasible, as we can't longer use the ADMIN GUI. We have to solve in other way.

We need to know which fields we have to update and how , from the SQL database interface.

Thanks to Everyone!!

Best answer by MichaelChatel

Hi Martina,

It looks like you may have a Support case open for this already, so they will confirm for you too (if they haven't already), but you would need to roll back the migration and do the article workaround (updating the descriptions manually) first, then you can proceed with the migration again.  But a roll-back is required.

1 reply

M
MichaelChatel5-Regular MemberAnswer
5-Regular Member
April 4, 2017

Hi Martina,

It looks like you may have a Support case open for this already, so they will confirm for you too (if they haven't already), but you would need to roll back the migration and do the article workaround (updating the descriptions manually) first, then you can proceed with the migration again.  But a roll-back is required.

Terms & ConditionsCookie settingsAccessibility statement