Page 1 of 1

Error = 3125; Database Open Failed

Posted: Fri Aug 07, 2009 12:44 pm
by ConvertFromOldNGs
by Cameron Lindsay >> Thu, 2 Dec 2004 0:17:01 GMT

Hello,

I have just reinstalled Jade and copied all of the backup files straight into the system folder.

When I try to run Jade, I get the following message:

"Error = 3125; A required tansaction journal was not found.
Database Open Failed;

Has anyone come across this problem before?

Re: Error = 3125; Database Open Failed

Posted: Fri Aug 07, 2009 12:44 pm
by ConvertFromOldNGs
by cnwjhp1 >> Thu, 2 Dec 2004 1:47:52 GMT

Did the database crash beforehand? If it did not shut down cleanly, it will look for audit journals so it can do recovery. They are named db000....log, usually in logs\current. The journals matching the BACKUP are the ones required. Backups should always include the audit journals, especially if the database did not stop cleanly. I normally start and stop the database (using singleUser or jadrap) before doing a backup, to ensure it doesn't need recovery on startup.

Cheers,
John P

Re: Error = 3125; Database Open Failed

Posted: Fri Aug 07, 2009 12:44 pm
by ConvertFromOldNGs
by allistar >> Thu, 2 Dec 2004 4:50:46 GMT

The error messaage (or the jommasg.log file) should say what the name of the required journal file is. It is likely sitting in the system directory and will need ot be moved to the logs directory (usually syatem/logs/current).

Regards,
Allistar.
--
------------------------------------------------------------------
Allistar Melville
Software Developer, Analyst allistar@silvermoon.co.nz
Auckland, NEW ZEALAND

Silvermoon Software
Specialising in JADE development and consulting
Visit us at: http://www.silvermoon.co.nz
*NEW* Simple web access to Jade at: www.silvermoon.co.nz/jhp.html ------------------------------------------------------------------