Archive DB Backup issue

[vince2e]

Hello all,

I configured an automatic archive for ValueArchive_006, but there was an error while archiving and now I can't access the data. The error messages I get when I try to access the data is




WCCOAvalarch6: 18:39:01.081[1696](ArchivSet.cpp:1510) Assertion '[asetConfig_.compressionLevel == 0]' failed !! - asetConfig_.compressionLevel=2
WCCOAvalarch6:ACE_ASSERT: time 11/28/2017 18.39.01.082000 file D:\\workspaces\\3.15\\workspace\\Exe\\DataNew\\ValueArchive\\ArchivSet.cpp, line 1510 assertion failed for 'asetConfig_.compressionLevel == 0'.
WCCILdata (0), 2017.11.28 18:39:05.644, SYS, WARNING, 39, Connection lost, MAN: (SYS: 2 Data -num 8 CONN: 1), Connection reset by peer (10054)
WCCILdata (0), 2017.11.28 18:39:05.646, PARAM,INFO, 2, Manager Stop, HistOrgMain, archive is now offline, archive number is:6
WCCILpmon (1), 2017.11.28 18:39:05.683, SYS, INFO, 11/pmon, Detected stopped manager WCCOAvalarch(6) - restarting it #1
WCCILpmon (1), 2017.11.28 18:39:05.692, SYS, INFO, 1, Manager Start, C:\\Siemens\\Automation\\WinCC_OA\\3.15\\bin\\WCCOAvalarch.exe -PROJ V_HMI02 -pmonIndex 16 -num 6 -repair
WCCOAs7plus (2), 2017.11.28 18:39:05.811, SYS, WARNING, 5/s7plus, Ignoring poll request for Pollgroup _Poll1S because last request did not finish yet
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._value, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._status64, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._value, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._status64, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._value, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._status64, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.FCV.CombustionAir.Status.Position:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._value, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAui (1), 2017.11.28 18:39:05.646, IMPL, SEVERE, 143, Query aborted with the following error: HistQuery, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._status64, constructAnswerMsg, Connection lost, DP: V_HMI02:Furnace02.PLC.OperationalTemp.ActualTempEU:_offline.._status64, MAN: (SYS: 2 Data -num 0 CONN: 1), (SYS: 2 Data -num 8 CONN: 1) Waiting for answer from closed connection
WCCOAvalarch (6), 2017.11.28 18:39:06.001, SYS, INFO, 1, Manager Start, PROJ, V_HMI02, V 3.15 - 3.15 platform Windows AMD64 linked at Jan 15 2017 22:10:59
WCCOAvalarch (6), 2017.11.28 18:39:06.019, SYS, INFO, 3, Trying to connect to (SYS: 0 Data -num 0 CONN: 1) @ localhost:4897
WCCOAvalarch (6), 2017.11.28 18:39:06.022, SYS, INFO, 4, Connected to (SYS: 0 Data -num 0 CONN: 1) @ Furnace02-HMI-PC (::1)
WCCILdata (0), 2017.11.28 18:39:06.033, SYS, INFO, 4, Connected to (SYS: 2 Data -num 8 CONN: 1) @ Furnace02-HMI-PC (::1)
WCCILdata (0), 2017.11.28 18:39:06.035, PARAM,INFO, 1, Manager Start, HistOrgMain, connection from archive received - initializing, archive number is: 6
WCCILdata (0), 2017.11.28 18:39:06.040, SYS, INFO, 0, , Manager (SYS: 2 Data -num 8 CONN: 1) initialised
WCCOAvalarch (6), 2017.11.28 18:39:07.019, IMPL, SEVERE, 54, Unexpected state, Found file AR_0006_2017.09.15.20.43.42 for set 2, but the state in header is set to 1, so file is ignored even though it's present , [D:\\workspaces\\3.15\\workspace\\Exe\\DataNew\\ValueArchive\\Archive.cpp:705]
WCCOAs7plus (2), 2017.11.28 18:39:07.997, SYS, WARNING, 5/s7plus, Ignoring poll request for Pollgroup _Poll1S because last request did not finish yet
WCCOAs7plus (2), 2017.11.28 18:39:08.295, SYS, WARNING, 5/s7plus, Ignoring poll request for Pollgroup _Poll1S because last request did not finish yet
WCCOAvalarch (6), 2017.11.28 18:39:09.067, SYS, INFO, 6, Initialization by Data Manager finished
WCCILdata (0), 2017.11.28 18:39:09.073, SYS, INFO, 0, , Sending initial values to archive
WCCOAvalarch (6), 2017.11.28 18:39:10.069, SYS, INFO, 0, , Ready for operation.





The message that stuck out to me was

".....54, Unexpected state, Found file AR_0006_2017.09.15.20.43.42 for set 2, but the state in header is set to 1, so file is ignored even though it's present ,..."



Any idea on how to change the state in header, and what should the state be changed to?
Note: I've tried running the DBrepair tool and that didn't fix the issue


Thanks!

[leoknipp]

It looks like the archive is stopped when trying to read data. The log entries in the beginning are the interesting ones.
Please get in contact with your common WinCC OA support for further analysis of this problem.

An explanation for the log message which is written during startup you can find in FAQ --> Log-Messages:
https://portal.etm.at/index.php?view=it ... &Itemid=54

Best Regards
Leopold Knipp
Senior Support Specialist

[vince2e]

Thanks! That link helped a lot. I’ll follow the steps and try to restore the file manually.

[vince2e]

Manual restore didn't help. The file was the same....


Any idea on how to change the state in header, and what should the state be changed to?

[leoknipp]

"State in header 1" is the information that the file is marked as deleted.
If you remove the file from the VA database folder you will not get the log message again during startup.

There is no possibility to change the state of the header.

Best Regards
Leopold Knipp
Senior Support Specialist