SAP Knowledge Base Article - Preview

3149635 - table historyDumps missing in ACM database.

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

SAP Adaptive Server Enterprise 16.0

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.