2348911 - "(0 rows affected)" message may be shown when dump database command is complete. - SAP ASE

Symptom

A message "(0 rows affected)" may be shown like below when a dump database command finishes.

1> dump database testdb to "/tmp/testdb.dmp"
2> go

Backup Server: 4.172.1.4: The value of 'allocated pages threshold' has been set to 40%.
Backup Server session id is: 22. Use this value when executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'testdb162091027E ' section number 1 mounted on disk file '/tmp/testdb.dmp'
Backup Server: 4.188.1.1: Database testdb: 3322 kilobytes (1%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 17716 kilobytes (2%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 25506 kilobytes (4%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 26448 kilobytes (8%) DUMPED.

.....omitted.....

Backup Server: 4.188.1.1: Database testdb: 33588 kilobytes (94%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 33928 kilobytes (98%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 34098 kilobytes (100%) DUMPED.
Backup Server: 3.43.1.1: Dump phase number 1 completed.
Backup Server: 4.188.1.1: Database testdb: 62244 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 90804 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 119382 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 147330 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 176340 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 204214 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 232774 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 261352 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 268494 kilobytes (100%) DUMPED.
Backup Server: 4.188.1.1: Database testdb: 274136 kilobytes (100%) DUMPED.
Backup Server: 3.43.1.1: Dump phase number 2 completed.
Backup Server: 4.188.1.1: Database testdb: 276414 kilobytes (100%) DUMPED.
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Backup Server: 4.188.1.1: Database testdb: 276418 kilobytes (100%) DUMPED.
Backup Server: 3.42.1.1: DUMP is complete (database testdb).
(0 rows affected)

Environment

SAP Adaptive Server Enterprise 15.7
SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

dump database 0 rows affected nocount , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.