Problem with gateway restore file - invalid END header

Ignition
1

We had a Windows Server 2012 crash, have reinstalled it, upgraded to Ignition 8.1.15 and are restoring our gateway backups. We’re getting a message:

Error writing to restore file: java.util.zip.ZipException: 
invalid END header (bad central directory offset)

Invalid END header

A web search shows that the message is common on Java systems and is not unique to Ignition.

Has anyone any suggestions we can try while waiting for Oregon to get to work?

Thanks.

Further info:

  • We rename the .gwbk to .zip and open with 7-Zip.
  • We find a .gwbk inside our renamed file. (Why? This is a bit like Russian dolls.)
  • Inside that we find db_backup_sqlite.idb.
  • Extracting that file we get CRC failed db_backup_sqlite.idb.
2

Sounds like this zip file is corrupt or truncated :grimacing:

3

Did the storage location for your automatic backups run out of space?

4

Thanks, Phil.
The nightly backups are by FTP to a NAS box with almost 2 TB free space. The .gwbk files are a little over 109 MB.

5

The server had been saving backups locally until 26th January and we have successfully restored the most recent of those.

Our backup task calls the command line ftp utility taking its instructions from a script file.

:: Run DailyFTP txt file
ftp -s:DailyFTP.txt

:: Delete new backup
del *.gwbk

The ftp -s script file contents are,

FTP
open 10.11.12.13
ftp_ignition
ftp_password
cd homes/ftp_Ignition_Gateway/IgnitionDailyBackups
send IgnitionDailyBackup_*
bye

One thing I notice here is that we haven’t specified binary transfer and that it may have defaulted to ASCII transfer. Is this likely to be the problem?

The locally saved files are 104 MB. Those on the FTP backup are 109 MB which would be expected due to the additional work done since January.

Are the FTPed .gwbk files useless? 7-Zip is able to go two levels deep into the files before returning the CRC error. That suggests that the FTP may have worked to some extent.

6

I don't think there is supposed to be 2 levels to go into in a backup that isn't b0rked somehow. When you open the older ones in 7zip is it 2 levels?

image
image1559×1114 81.3 KB

7

I think “b0rked” is right!

We have a backup of the drive contents. Can we just restore folders such as C:\Program Files\Inductive Automation\Ignition\data?
That would give me the latest projects. What else do I need to restore to get the IdPs, tags, OPC devices, database connections, transaction groups, etc.?

Many thanks.

8

The data folder probably has everything that matters. I’m not sure if the crashed system is 7.9 or 8.x, but either way it has the internal DB and projects folder if it’s 8.x.

9

Thanks, Kevin. It was 8.1.10 and we’ve taken the opportunity to upgrade to 8.1.15 while we fix this.

I’ll try copying in the data file in the morning.