Products
Webtrends Analytics 9.x
Issue
When attempting to create or restore a backup, the following error occurs:
WARNING: Unable to find the high water mark from \WebTrends\Storage\backup\\Archives\archive_-.zip
ERROR: The following error code was returned from the unzip process 47 : Command syntax error
[In addition to the above message the following error message can occur:
when trying to analyze any profile. (“wtm_wtx.ini not exists” ). The solution is the same here after verifying permissions are correct]
Resolution
There are two places to look in order to resolve the issue. The first is the wtm_wtx.ini file. locate the “profiledir” and “profilepath” settings and ensure they are pointing to the appropriate location. This should be a UNC path unless the Storage Locations settings are using local paths as well.
The second place to check is the wtMaster.dbo.WT_WRCMachine table. There should be two entries in this table, with the first one having “localhost” in the Description field. If there is only one entry with the description set to the actual machine name and the MachineID set to “1”, the configuration is incorrect. Change the description for this entry to “localhost” and create a second entry with the following settings:
MachineID = 2
Description = \\<ServerName>
IsEnabled = True
Then modify the wtMaster.dbo.WT_AccountDataLocation and wtMaster.dbo.WT_WRCVersion tables, changing the MachineID for each record in these tables to “2” in order to reflect the UNC path to the server.
With these corrections the backups should work correctly. Restarting the services should not be necessary.