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
Paste Function
Kate Clark
I've never had any issues with the copy/paste function for over 2 years, but as of the last upd...
17:54 18 July 2024
jordi
Hola , estoy muy preocupado por no poder acceder a mi servidor canvie la contrsenya i pude entrar...
14:27 15 July 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.