SAP Knowledge Base Article - Preview

2523027 - Errors 3906 and 3501 after renaming a database - SAP ASE 15.7

Symptom

Getting Errors 3906 and 3501 after renaming a user database:

1> sp_dboption myDB, single, true
2> go
Database option 'single user' turned ON for database 'MyDB'.
Running CHECKPOINT on database 'myDB' for option 'single user' to take effect.
(return status = 0)
1> use myDB
2> go
1> CHECKPOINT
2> go
1> sp_renamedb myDB, DBmy
2> go
Msg 3906, Level 16, State 1:
Server 'myASE', Procedure 'sp_renamedb', Line 173:
Attempt to BEGIN TRANSACTION in database 'DBmy' failed because database is READ ONLY.
(return status = -6)
1> sp_dboption myDB,'read only',false
2> go
Database option 'read only' turned OFF for database 'myDB'.
Running CHECKPOINT on database 'myDB' for option 'read only' to take effect.
Msg 3501, Level 21, State 1:
Server 'myASE', Procedure 'sp_dboption', Line 649:
Could not get sysdatabases row for database '99' at checkpoint time.
(1 row affected)
CHECKPOINT command failed. Run the CHECKPOINT command in database 'myDB' for the change to take effect.
(return status = 0)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Replication Server 15.7

Keywords

CR#639813, CR639813, 639813, master , 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.