Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aloha 6.4.39 Trans Log error

Status
Not open for further replies.

ER_IT guy

Technical User
Jul 24, 2018
4
US
We had a power outage last night around 8:30pm and had issues with eod and it was in a grind loop all night. I checked it this morning and to stop the loop, i copy and pasted the DBF file from the previous day and it stopped the loop. I am not however able to get my transactions back. It appears to be a corruption in the trans log. I will see how it goes tonight but I'd like to recoup all the transactions from yesterday. I've attached the debout portion:

23-Jul 21:23:09 [628] [INFO] Command=C:\Aloha\BIN\.\FOHAdm.exe
23-Jul 21:23:09 [628] [INFO] WARNING: in ConditionRunRserScan() - File Not Found: C:\Aloha\BIN\.\AtgRserScan.exe
23-Jul 21:23:09 [628] [INFO] Don't need to start AtgRserScan.exe
23-Jul 21:23:09 [628] [INFO] ConvertTransLog(): Analysing TRANS.LOG for conversion...
23-Jul 21:23:10 [628] [INFO] Iber(): No log conversion required.
23-Jul 21:23:10 [628] [INFO] Done reading data.
23-Jul 21:23:10 [628] [INFO] Entering CreateFilenamesFromIberdir
23-Jul 21:23:10 [628] [INFO] First time New printer log name is Z:\Aloha\DATA\PRT1.LOG
23-Jul 21:23:10 [628] [INFO] First time New printer log name is Z:\Aloha\DATA\PRT2.LOG
23-Jul 21:23:10 [628] [INFO] First time New printer log name is Z:\Aloha\DATA\PRT3.LOG
23-Jul 21:23:10 [628] [INFO] First time New printer log name is Z:\Aloha\DATA\PRT4.LOG
23-Jul 21:23:10 [628] [INFO] First time New printer log name is Z:\Aloha\DATA\PRT5.LOG
23-Jul 21:23:10 [628] [INFO] First time New printer log name is Z:\Aloha\DATA\PRT6.LOG
23-Jul 21:23:10 [628] [INFO] Exiting CreateFilenamesFromIberdir
23-Jul 21:23:10 [628] [INFO] firing 00:00:00 SET TIP SHARE
23-Jul 21:23:10 [628] [INFO] firing 00:00:00 SET TIP SHARE
23-Jul 21:23:10 [628] [INFO] firing 00:00:00 SET BAR MENU 2
23-Jul 21:23:10 [628] [INFO] firing 00:00:00 SET SERVER MENU 1
23-Jul 21:23:10 [628] [INFO] Begin reading transaction log...
23-Jul 21:23:11 [628] [INFO]
23-Jul 21:23:11 [628] [INFO] WARNING - Corruption detected at offset 234151 for Z:\Aloha\DATA\TRANS.LOG, seeking to next txn...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:12 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed EOF. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0, Retrying...
23-Jul 21:23:13 [628] [INFO] FileRead() failed. File Z:\Aloha\DATA\TRANS.LOG, BytesToRead=1, BytesRead=0
23-Jul 21:23:13 [628] [INFO] picking back up at offset 257900
23-Jul 21:23:13 [628] [INFO]
23-Jul 21:23:13 [628] [INFO] ** WARNING, Local Computer Date may be Incorrect, Year is 2018
 
did you check the time and date on PC. Last line on log shows wrong date
Did you run translog repair
bin\grind.exe/fixlog trans.log
rename files and see if it grinds

AlohaRoss
An Aloha POS 3rd Party support Solution company.
reddit : rossabout
 
Aloha Ross,

I have been having trouble with the terminals switching the hour back like once a week. It has the correct time on the BOH but I have to go in manually change it and hit apply and it will change the terminals back to the correct time. I'm not sure why it does this. To run the translog, how would i do so? Do i need to open a command line from my aloha folder? Or from inside the dated folder with the corrupted trans log which was yesterdays log 20180723?
 
C:\bootdrv\Aloha\20180723

this is the folder for the date that has the problem
 
for the time issue
In aloha manager set to international time in store settings. Enable DST if required
close Aloha manager
Stop ctlsvr service
del timezone.ini in data folder
set correct time, and time zone in windows
start ctlsvr
set time and timezone on master term in FOH. all others will adjust to Master

for translog
open cmd
navigate to dated folder
then run bin\grind.exe/fixlog trans.log
rename trans.log to trans.xxx
rename fixed.log to trans.log
regrind dated folder. If it grinds you fixed log. If not then Log is not repairable with limited tools in Aloha

AlohaRoss
An Aloha POS 3rd Party support Solution company.
reddit : rossabout
 
So the grind.exe file is in my BIN folder where all my other folders are such as TMP, DATA, ect plus the actual dated folders. There is no grind.exe inside the dated folder so do i just run it from the BIN folder? After running the grind.exe, will it give me the option to change the name of the trans log or do I have to manually change in the the directory?
 
from within the dated folder
c:\bootdrv\aloha\20180724>c:\bootdrv\aloha\bin\grind.exe /fixlog trans.log

AlohaRoss
An Aloha POS 3rd Party support Solution company.
reddit : rossabout
 
If grind.exe /fixlog does not fix. I may be able to fix it for you with my tools.
 
Sheerdyn, I could use your help with an edit of a trans.log file. Can you call me. Number is on my website or if you use reddit send me pm their

AlohaRoss
An Aloha POS 3rd Party support Solution company.
We answer when they don't
reddit : rossabout
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top