cancel
Showing results for 
Search instead for 
Did you mean: 

[17.0.11.7236] alter database Upgrade gives assertion fail

awitter
Participant
886

Please help on this upgrade thet is not working!

Error on dbgrad:
SQL Anywhere Upgrade Utility Version 17.0.11.7236
Database upgrade started
Creating system views
Creation of system views completed
Error in file upgrade.sql at line 1195 with sqlcode -300
SQL error (-300) -- Run time SQL error -- *** ERROR *** Assertion failed: 115101 (17.0.11.7236)[DemStuks]
unexpected special domain type
Upgrade failed

Here is the syshistory of the database:

  'operation'  ,'object_id','version'   ,'platform'            ,'first_time'             
  'INIT'       ,0          ,'17.0.4.218','W10 #17134  X86'     ,'2019-03-15 09:51:41.000'
  'START'      ,0          ,'17.0.4.218','W10 #17134  X86'     ,'2019-03-15 09:51:41.000'
  'START'      ,0          ,'17.0.4.218','W2008R2 #7601 SP 1 X','2019-03-15 10:11:08.000'
  'START'      ,0          ,'17.0.9.485','W10 #17134  X86_64'  ,'2019-07-31 12:47:06.000'
  'UPGRADE'    ,0          ,'17.0.9.485','W10 #17134  X86_64'  ,'2019-07-31 12:47:20.000'
  'START'      ,0          ,'17.0.9.485','W2008R2 #7601 SP 1 X','2019-08-06 13:06:43.000'
  'START'      ,0          ,'17.0.9.485','W10 #18363  X86'     ,'2020-01-22 11:26:35.000'
  'LAST_BACKUP',0          ,'17.0.9.485','W10 #18363  X86'     ,'2020-01-22 12:34:35.000'
  'START'      ,0          ,'17.0.10.59','W10 #17134  X86_64'  ,'2020-05-01 12:29:54.000'
  'UPGRADE'    ,0          ,'17.0.10.59','W10 #17134  X86_64'  ,'2020-05-01 12:29:59.000'
  'LAST_BACKUP',0          ,'17.0.10.59','W10 #17134  X86_64'  ,'2020-06-02 09:07:50.000'
  'START'      ,0          ,'17.0.10.60','W10 #17134  X86_64'  ,'2020-07-02 12:22:32.000'
  'UPGRADE'    ,0          ,'17.0.10.60','W10 #17134  X86_64'  ,'2020-07-02 12:22:33.000'
  'LAST_BACKUP',0          ,'17.0.10.60','W10 #17134  X86_64'  ,'2020-07-07 09:07:48.000'
  'START'      ,0          ,'17.0.10.60','W10 #17134  X86'     ,'2021-05-28 11:48:03.000'
  'START'      ,0          ,'17.0.10.60','W10 #19043  X86_64'  ,'2021-11-03 14:38:17.000'
  'START'      ,0          ,'17.0.10.60','W10 #19044  X86_64'  ,'2021-11-18 12:18:06.000'
  'LAST_BACKUP',0          ,'17.0.10.60','W10 #19044  X86_64'  ,'2022-01-05 10:31:01.000'
  'START'      ,0          ,'17.0.10.60','W10 #19042  X86_64'  ,'2022-03-07 11:34:52.000'
  'START'      ,0          ,'17.0.10.60','W10 #19044  X86'     ,'2022-04-20 13:14:14.000'
  'START'      ,0          ,'17.0.10.60','W10 #19045  X86_64'  ,'2022-10-20 05:19:27.000'
  'LAST_BACKUP',0          ,'17.0.10.60','W10 #19045  X86_64'  ,'2022-10-20 11:19:00.000'
  'START'      ,0          ,'17.0.11.72','W10 #19044  X86'     ,'2022-12-02 13:01:47.000'
  'LAST_START' ,0          ,'17.0.11.72','W10 #19044  X86'     ,'2022-12-02 13:01:47.000'

The same error happens with the ALTER DATEBASE UPGRADE command

View Entire Topic
awitter
Participant
0 Kudos

I think I have narrowed the problem to any database that has been created or upgraded with version 17.0.10.5923. I can upgrade any (well, to a certain extent) database except when the syshistory has version 17.0.10.5923 as upgrade/init in it.