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
Reply
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
Reply
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.

Reply
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
Files are pending for approval
Reply
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.
Reply
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.
Reply
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
Reply
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
ligação ao servidor
ConsulBiotech, Investigação e Desenvolvimento, Unipessoal, LDA
Boa tarde, O Standard accounts aparentemente não liga ao servidor CIEDUL e consequentemente as mi...
14:42 24 Oct 2024
Re: Formulários
HC
Boa tarde, uma vez mais solicitamos resposta à questão colocada. ...
15:13 21 Oct 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.