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.