cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1030
Views
0
Helpful
1
Replies
Martin Kyrc
Participant

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

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

1 REPLY 1
martinas
Beginner

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