Hi,
We have a problem with Oracle archiving after upgrading WinCC OA project from 3.11 to 3.15. We use the same Oracle DB on the same server as before...we haven't even turned it off while migration. DB schema version is 8.13.
The problem is that EVENTHISTORY_* table does not get replaced by a new one, not even after ~70milion rows. MAX_SIZE_MB is set to 2048. Older tables were replaced after ~12million rows. We do not have a problem of archiving and retrieving the data (yet). ARC_LOG table holds no information about any error.
What could be a cause of this issue? I guess that table EVENTHISTORY_* cannot grow indefinitely and we might have some issues sooner or later.
Alberto Milla
Oracle DB problem after upgrading WinCC OA from 3.11 to 3.15
- amilla
- Posts:2
- Joined: Fri Aug 18, 2017 4:22 pm
Oracle DB problem after upgrading WinCC OA from 3.11 to 3.15
- agruber
- Posts:147
- Joined: Tue Sep 07, 2010 2:52 pm
Re: Oracle DB problem after upgrading WinCC OA from 3.11 to 3.15
Hello,
The current DB schema version in 3.15 P006 is 8.15. I suggest to upgrade to this. There might be issues if you don't. Also make sure to run a supported Oracle client on the WinCC OA 3.15 machine.
Afterwards try a manual switch of the archive set. If it does not work, look at errors in PVSS_II.log and in the ARC_LOG table of the database.
If you need help with that log data, you can contact us directly.
BR, Andreas
Customer Care
The current DB schema version in 3.15 P006 is 8.15. I suggest to upgrade to this. There might be issues if you don't. Also make sure to run a supported Oracle client on the WinCC OA 3.15 machine.
Afterwards try a manual switch of the archive set. If it does not work, look at errors in PVSS_II.log and in the ARC_LOG table of the database.
If you need help with that log data, you can contact us directly.
BR, Andreas
Customer Care