There is another bug that affect this upgrade, found out the hard way
Unity Connection Upgrade to 11.5(1)SU1 fails
CSCvb02774
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:
1) Delete the users returned by the command output.
2) Cop file "ciscocm.cuc_11.5SU1_pre_upgrade.cop.sgn" released for the defect fix.
Please refer to upgrade guide for 11.x:
"For successful upgrade to Unity Connection 11.5.1 SU 1, make sure to download and install an additional COP file ciscocm.cuc_11.5SU1_pre_upgrade.cop.sgn. To install the COP file, you must follow the instructions given in the ReadMe of the COP file available at http:/?/?www.cisco.com/?web/?software/?282204704/?18582/?CUC_?CSCvb02774_?ReadMe.docx?
http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/connection/11x/install_upgrade/guide/b_11xcuciumg/b_11xcuciumg_chapter_010.html
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
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:
1) Delete the users returned by the command output.
2) Cop file "ciscocm.cuc_11.5SU1_pre_upgrade.cop.sgn" released for the defect fix.
Please refer to upgrade guide for 11.x:
"For successful upgrade to Unity Connection 11.5.1 SU 1, make sure to download and install an additional COP file ciscocm.cuc_11.5SU1_pre_upgrade.cop.sgn. To install the COP file, you must follow the instructions given in the ReadMe of the COP file available at http:/?/?www.cisco.com/?web/?software/?282204704/?18582/?CUC_?CSCvb02774_?ReadMe.docx?
http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/connection/11x/install_upgrade/guide/b_11xcuciumg/b_11xcuciumg_chapter_010.html
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
Customer Visible
Was the description about this Bug Helpful?
(5)
Last Modified:
Jun 21,2017
Status:
Fixed
Severity:
3 Moderate
| Product: |
(1)
|
Support Cases:
194
| Known Affected Releases: |
(1)
|
