Skip to Content
0

I'm trying to remove an existing database from BI4_CMS.db. Any thoughts about this error?

Mar 16, 2017 at 02:30 PM

110

avatar image
Former Member

I'm trying to remove an existing database from BI4_CMS.db. Any thoughts about this error?

error.jpg (74.1 kB)
10 |10000 characters needed characters left characters exceeded

Transaction Log utility(dblog) is a command line tool.
At a command prompt, using the dblog command.

Please see below.
http://dcx.sap.com/index.html#1201/en/dbadmin/dblog.html

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Mar 16, 2017 at 03:55 PM
0

Hi again.

I have recreated the same issue using a different environment. someone know where is the sybase log file to see this issue.

Thanks.


error2.jpg (147.9 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

As Atsushi noted, try running the command from a command prompt. This should give you a better description of the reason for the error.

I reproduced the behavior and when I ran the command, this is what was reported:

SQL Anywhere Transaction Log Utility Version 16.0.0.2546
Database quit abnormally last time it was used. Database recovery must be performed before proceeding.

Please post the error that you encounter if you are not sure what it means or what is needed to correct it. In my case, I simply needed to start the database to allow for the automatic recovery at start up.

0
Atsushi Asano
Aug 28, 2017 at 01:35 AM
0

Hi Vin,

I have something I'd like you to try.
You can copy a command with "Copy to Clipboard" button of the Wizard.

dblog "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db"

You can execute this command that you copied on Command Prompt.
Do you get the same error message?

Thanks,
Atsushi

Share
10 |10000 characters needed characters left characters exceeded
Denis Konovalov
Oct 03, 2017 at 01:13 PM
0

What are you trying to achieve exactly ?

"trying to remove an existing database from BI4_CMS.db" - what does that mean ?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

He meant to say that he wants to stop using the transaction log.

0

but why ?
SQL Anywhere DB that comes with BOE install is provided as is. For the single purpose to be CMS DB holder.
There shouldn't be any mods to it.

0