Buy or Renew
Buy or Renew
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
1177
Views
0
Helpful
1
Replies

how to initialize reporting (bundled) DB for CM (SCE)

Martin Kyrc
Level 3
Level 3

‎08-05-2011 02:37 AM - edited ‎03-01-2019 02:28 PM

hello,

our reporting DB is corupted (see log report bellow). where can I founde ASE errorlog?

Aug  5 10:17:50 SCEserver-01-BB1 sybase_init: 00:00000:00001:2011/08/05 10:17:50.54 server  Error: 926, Severity: 14, State: 1

Aug  5 10:17:50 SCEserver-01-BB1 sybase_init: 00:00000:00001:2011/08/05 10:17:50.54 server  Database 'apricot' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the ASE errorlog for information as to the cause.

Aug  5 10:17:50 SCEserver-01-BB1 sybase_init: 00:00000:00001:2011/08/05 10:17:50.54 server  Unable to proceed with the recovery of dbid <4> because of previous errors.

If it's corrupted, is it possible reinitialize it?

martin

Labels:
0 Helpful
1 Reply 1

martinas
Level 1
Level 1

‎08-11-2011 07:27 PM

Hi Martin,

The sybase logs should be found under: "~sybase/ASE_/install/pqbsyb1.log"

Have you tried restarting both sybase and the CM?

Have you checked the database size and amount of disk space? Quite a lot of CM and database errors are related to this.

If your DB size and amount of disk space is OK, and restarting has not helped, then I would recommend you open a TAC service request for further troubleshooting.

Cheers,

Martin

0 Helpful
Customers Also Viewed These Support Documents