System Admin
can't start ERP on ubuntu 16
moses
2018-04-11
Hi all
can someone help, we had power issues and the server shutdown. the ERP can not start giving below error

10:25: 36 last session was not properly terminated

10:25: 38 JOURNAL: error: last sequence in journal (1475721) is before the database sequence (1475722)

[2] Quit (core dumped)


any advise.
This answer was correct
Created byTomas J.11:47 12 Apr 2018
Hello,


./StandardERPServer (path to backup) >> to restore backup
./StandardERPServer --apply-journal >> to apply
The StandardERPServer is executable name which can be different

More info:
http://www.hansaworld.com/en/university/booking/courses/global/HW_SYS

Hansaworld support
Tomas J.
2018-04-11
Hello,

Please check the log, if it has "this pointer is outside of..." or similar, than it might be you have a damaged database.

If the power cut was during some data writing to DB than it might be damaged. So you need to restore it from last backup.

Best regards,

Hansaworld support
Tomas J.
2018-04-11
Also you can try to move journal file to different location and try to start the server.


If the DB is not damaged, than it should start. If it fails, you need to restore Database from backup and apply journal till 1475720 record.

moses
2018-04-11
Created byTomas J.11:57 11 Apr 2018
Hello, Please check the log, if it has "this pointer is outside of..." or similar, than it might be you have a damaged database. If the power cut was during some data writing to DB than it might be damaged. So you need to restore it from last backup.
from the log cant seem to get any damage. if i move the journal i get error. Journal bad file present. attached is the log before the issue occurred and after trying to restart
Please log in to view the files
moses
2018-04-12
i had to recreate DB and import data from a txt backup. have lost data for one day.is it possible to apply previous journal to get back lost data for the day? the crash happened before end of day backup.
moses
2018-04-12
Created byTomas J.13:38 11 Apr 2018
Also you can try to move journal file to different location and try to start the server. If the DB is not damaged, than it should start. If it fails, you need to restore Database from backup and apply journal till 1475720 record.
how do i apply journal, have any documentation you can share.
This answer was correct
Tomas J.
2018-04-12
Hello,


./StandardERPServer (path to backup) >> to restore backup
./StandardERPServer --apply-journal >> to apply
The StandardERPServer is executable name which can be different

More info:
http://www.hansaworld.com/en/university/booking/courses/global/HW_SYS

Hansaworld support
Login to Reply
Back to the list
Latest Posts
Grupos de Acesso
Boa tarde, Após a última atualização (8.5 2024-10-16) os grupos de acesso deixaram de existir. Agr...
14:06 3 Dec 2024
Re: Standard Accounts
Monica Amado
Bom dia, Sónia, Por favor efetuar o download e importe o ficheiro em anexo através de: Sistema &...
11:48 26 Feb 2024
You can subscribe to notifications for any post in this forum by selecting the 'star' icon on the top right corner of the topics list. You have to log in to use this functionality.