Navigate not functioning with rehosted system (12->13, 9.3.4->9.7)

[avillanueva]

I might not be doing things proper but trying to learn and do an upgrade in place (kind of) of Navigate while upgrading Windchill. Goal is to get to 9.7 and WC 13.0.2.  I have a clone on my test Navigate system and my upgrade target Windchill at 13.02. DB is SQLServer if that matters for Navigate. Thingworx appears to function and I can authenticate (which is to Windchill). I can see main page and Composer. I made sure all of the Odata connectors, integration connectors and proxy connectors map to the new temp hostname (-upgrade for my rehearsal 1). At the current time, I have not upgraded Navigate since I wanted to validate its functioning properly first.

I have some custom apps which their own Odata connections and they seem to function fine. Its just the OOTB navigate apps that do not work. If it just as simple a running upgrade to bring it to 9.7 which would be supported with 13.02,  I can do that but its a one way street. If something else was wrong or it should work as is, I would like to know that first. 

Here are some of the errors I've seen in application.log:

Unable to Invoke Service ConstructFilterCriteria on NavigateSearchThing : null
ErrorCode(c6efe2f8-4f5c-46f7-8877-c4fde567be7d), Cause(null), Reason(Access was attempted on a null reference variable.), Possible Resolutions(Remove the reference to the null variable within your extension code.)
Transaction has been marked as a failure for request /Thingworx/Things/NavigateSearchThing/Services/ConstructFilterCriteria

[avillanueva · Accepted solution]

Tried running the upgrade script but its failing on the database step. I think I am going to abandon this instance, delete and start clean, This means creating fresh 9.7 install, and importing custom apps, users and group over. PITA but I think more straight forward. Stinks since I was very close. I've gotten a clone working before and it was just a matter of a few locations to change hostnames. PTC, please improve your documentation around Thingworx and Navigate. Its almost impossible to follow since each document and page is out of date or throws you to other pages that are poorly written and lack details and screen shots. No solution here, just closing out.