Can you attach the arsysteminstall_log.txt file?
Looks RIK is failed. Probably there must be a RIK command few lines before the error is reported.
If you could attach AR System Maintenance Logs then it would be pretty useful.
There are two separate errors recorded there. The FTS migration is one but it looks like it was not considered fatal as the install progressed to importing workflow and it's one of these that also failed and aborted the install. Check the ARSystem\Logs directory where there should be an ARServer-RIK_PostUpgrade.log with more details of which def failed and why.
I have a support call logged for this.
What was identified is the following files did not import during the upgrade:
BMC Software\ARSystem\ARServer\installforms\en\VisualizerModule701.arx is returned with code 1025
BMC Software\ARSystem\ARServer\installforms\en\VisualizerModule.arx is returned with code 1025
BMC Software\ARSystem\ARServer\installforms\en\RSSFeed.arx is returned with code 1025
BMC Software\ARSystem\ARServer\installforms\en\ChatModule.arx is returned with code 1025
BMC Software\ARSystem\ARServer\installforms\en\Share_Application_Report.arx is returned with code 1025
The advise was to import these manually and try again but I see they are not there, more than likely why it failed. Will update when I have more info.
So after a call with BMC, turns out we needed to clean up any old server group rows of data and ranks and clear out any data in ft_pending even though we are not using server groups, I believe v9 automatically puts you in a server group.
Here is what I did in SQL before running the installer.
Change the Live server to the POC server, port and set the ranks
SET serverName = 'POCServer1.mydomain.com'
,serverPort = 1000
,opFlags = '0;0;0;0;0;0;0;0;0;0;0;0;0;0;0'
WHERE serverName = 'LiveServer1.mydomain.com'
Remove the other servers (old servers, DR servers, etc) if not in the server group
WHERE serverName IN ('OldServer2.mydomain.com','DRServer3.mydomain.com')
Clean out pending FTS items
TRUNCATE TABLE ft_pending
After doing all of this, we were able to do a clean upgrade.