Symptom
After upgrading ASE server from 16 SP02 PL06 to 16 SP04 PL01 for Linux_x86_64, it's failed to create historyDumps table using sp_dump_history command.
1> use saptools
2> go
1> drop table historyDumps
2> go
Msg 3701, Level 11, State 1:
Server 'XXX', Line 1:
Cannot drop the table 'historyDumps', because it doesn't exist in the system catalogs.
1> exec sybsystemprocs..sp_dump_history @operation='create_table', @name='saptools.dbo.historyDumps'
2> go
sp_dump_history [ @operation = {'list' | 'purge' | 'listfiles' | 'help'}]| 'listpurgefiles' | 'purgefiles' | 'upgrade' | 'downgrade'}][, @until_time = 'date'] [, @name = '<database or file name>'][, @dump_type = {'DATABASE' | 'TRAN[SACTION]' | 'CONFIG[URATION]' | 'CUM[ULATIVE]' | 'ALTERDB'}][,
@status = {'success' | 'fail' | 'deleted'}][, @file = '<filename>'][, @version = '1.0']
(return status = 1)
1> select @@version
2> go
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/16.0 SP04 PL01/EBF 29704 SMP/P/x86_64/SLES 12.4/ase160sp04pl01x/3473/64-bit/FBO/Tue Jul 20 07:58:11 2021 (1 row affected)
1>
Read more...
Environment
SAP ASE 16 SP04 PL01 for Linux_x86_64
Product
Keywords
sp_dump_history, historyDumps , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview