Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi,

I have a SQL Anywhere database that is used by SAP Business Objects for its repository database.

I've tried to move the db files but couldn't get the db started again. So I moved the db files back to their original location. However, the database service that was created by SAP Business Objects keeps stopping now.

Do I need the db with a different start line, could that be the problem? I can get the database to start, it just stops after some time.

In the EventViewer I get this message:

The description for Event ID 1 from source SQLANY 12.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

SQLANYs_BOE120SQLAW Cannot access "C:Program Files (x86)Business ObjectsSQLAnyWhere12BinBOE120_AUDIT.db": another process may be using the file

asked 06 Jun '12, 04:55

Galactico076's gravatar image

Galactico076
76338
accept rate: 0%

edited 06 Jun '12, 05:14

Besides Dan's suggestion, using -o on the server command line might be worthwhile - cf. this answer...

(06 Jun '12, 09:34) Volker Barth

To troubleshoot this I suggest retrieving the command line that the service is trying to start, then run that manually from the command line, to get more details about what is happening.

To get the names of the installed SA services you can use:

dbsvc -l

The name of the service above appears to be "BOE120SQLAW". You can retrieve the command line being run by that SA service using something like the following:

dbsvc -cm -g BOE120SQLAW

HTH, Dan

permanent link

answered 06 Jun '12, 09:22

Dan%20Cummins's gravatar image

Dan Cummins
511614
accept rate: 41%

SQLANYs_BOE120SQLAW Cannot access "C:\Program Files (x86)\Business Objects\SQLAnyWhere12\Bin\BOE120_AUDIT.db": another process may be using the file

This error is suggesting that the database server can't access the database file (e.g. the permissions have changed or another process is already reading the database file - another database service, perhaps?), thus you can't start the requested database service.

You can see which process may have a lock on this file by checking with an OS file-locking utility, such as:

Otherwise, you should trace the database start-up activities with Process Monitor to see if there are any logged permission errors in that output trying to access the database file on the file system.

permanent link

answered 07 Jun '12, 10:06

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

edited 07 Jun '12, 10:10

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×40

question asked: 06 Jun '12, 04:55

question was seen: 11,101 times

last updated: 07 Jun '12, 10:10