CUC 8.6.5 upgrade to 11.5 fails | Error detected in post-install phase..

[marcel.pludra]

Hello community,

i get following error message when i want upgrade my 8.6.5 CUC to 11.5 :

"Error detected in post-install phase. Trying to restore the system to active version. Please wait..."

I found this critical error in install log:

IPM|Internal Error, File:ipm.c:2011, Function: ipmReadNormalizedInputLine(), "/opt/cisco/connection/lib/install/cuc-import RU Import 11.5.1.11900-26 8.6.2.22900-9 /usr/local/cm/ /common/component/connection /common/log/install/capture.txt " failed (1)|

What does this error message mean?

Does anyone hava a workaround for me?

Thanks for your help :)

[Mohammed Khan]

Looks like you match below defect

 CSCvb02774    Unity Connection Upgrade to 11.5(1)SU1 fails

[marcel.pludra]

Have no permission to watch this bug :(

"Insufficient Permissions to View Bug

This bug contains proprietary information and is not yet publicly available."

[Mohammed Khan · Accepted solution]

Symptom:
Unity Connection upgrade to 11.5(1)SU1 fails

Issue seen on both L2 and RU upgrades (upgrades from 8.X, 9.X, 10.X, and 11.X).

Conditions:
Issue occurs when there is an admin user created using the Administrator Template.

Run this command to check for such users,
run cuc dbquery unitydirdb SELECT displayname FROM tbl_user WHERE objectid NOT IN (SELECT subscriberobjectid FROM tbl_subscribertimelastcall) AND readonly=0 AND istemplate !=1

Workaround:
Delete the users returned by the command output.

Further Problem Description:
Unity Connection upgrade to 11.5(1)SU1 fails due to the presence of new columns in tbl_subscribertimelastcall.
The system attempts to update the last call time of admin users and it fails

From cuc import logs,


2016-08-23 16:49:12 INFO Running migration.unitydirdb.11_05_0335_update_admin_subscribertimelastcall.up() (migrate:225)
2016-08-23 16:49:12 DEBUG ('SELECT objectid FROM tbl_user WHERE objectid NOT IN (SELECT subscriberobjectid FROM tbl_subscribertimelastcall) AND readonly=0 AND istemplate !=1',) (migration:116)
2016-08-23 16:49:12 DEBUG (u"INSERT INTO tbl_subscribertimelastcall (subscriberobjectid, timelastcall, inactive, tuisessioncount) VALUES ('cb8f1c4d-205d-46e2-b00a-cd30545d194d','2016-08-23 11:19:12', 0, 0)",) (migration:116)
2016-08-23 16:49:12 Traceback (most recent call last):
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/switchover.py", line 460, in
2016-08-23 16:49:12 sys.exit(main())
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/switchover.py", line 163, in main
2016-08-23 16:49:12 start_migration(get_data_directory(), destdbnames)
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/switchover.py", line 184, in start_migration
2016-08-23 16:49:12 migrate_data(data_directory)
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/switchover.py", line 214, in migrate_data
2016-08-23 16:49:12 migration.migrate.run(data_dir, direction=get_switch_direction())
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/migration/migrate.py", line 59, in run
2016-08-23 16:49:12 return main([__name__, base_directory], **kwargs)
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/migration/migrate.py", line 56, in main
2016-08-23 16:49:12 MigrateDatabase(argv[1], os.path.basename(database_path), **kwargs).migrate()
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/migration/migrate.py", line 105, in migrate
2016-08-23 16:49:12 self.run_migration_scripts()
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/migration/migrate.py", line 229, in run_migration_scripts
2016-08-23 16:49:12 getattr(m, self.direction)()
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/migration/unitydirdb/11_05_0335_update_admin_subscribertimelastcall.py", line 16, in up
2016-08-23 16:49:12 execute("INSERT INTO tbl_subscribertimelastcall (subscriberobjectid, timelastcall, inactive, tuisessioncount) VALUES ('%s','%s', 0, 0)" %(subscriberid[0], now))
2016-08-23 16:49:12 File "/opt/cisco/connection/lib/switchover/migration/migration.py", line 117, in execute
2016-08-23 16:49:12 return conn.execute(*args)
2016-08-23 16:49:12 sqlite3.OperationalError: table tbl_subscribertimelastcall has no column named inactive