How to initialize the configuration history?

The configuration history is limited to a defined number of records (16777216 records). If the limit is reached you can initialize the configuration history with the following procedure. In case of a redundant system you would have to stop the project on both servers at the same time. The initialization is only necessary at one server, the other one will copy the corrected database parts during the recovery:


-- Make an ASCII-export (export_configs.asc) for the configs (filter P for the ASCII-manager)
If the ASCII manager is started from a command shell the following command is started. Before starting the command you have to go to the dplist-directory of the project. On Linux operating systems is has to be ensured that the environment variables PATH and LD_LIBRARY_PATH are set correctly and include the bin-directory for the WinCC OA installation.
<PVSS installation>/bin/PVSS00ascii -proj <project name> -filter P -out export_configs.asc
<WinCC OA installation>/bin/WCCOAascii -proj <project name> -filter P -out export_configs.asc

-- Stop the project
-- Make a backup of the database excluding the directories for the value-archives (VA_ + 4-digit-number)
-- Open a command-shell
-- Change into the directory <project-path>/db/pvss or <project-path>/db/wincc_oa
-- Start the command <WinCC OA-installation>/bin/initdb –y ConfHist
-- Wait until the process is finished
-- Start the project in minimum configuration: Data-Manager, Event-Manager, simulation-drivers instead of the real drivers
-- Make an ASCII-import of the file with the configs (export_configs.asc)
If the ASCII manager is started from a command shell the following command is started. Before starting the command you have to go to the dplist-directory of the project. On Linux operating systems is has to be ensured that the environment variables PATH and LD_LIBRARY_PATH are set correctly and include the bin-directory for the WinCC OA installation.
<PVSS installation>/bin/PVSS00ascii –proj <project name> -in export_configs.asc -inactivateAlert
<WinCC OA installation>/bin/WCCOAascii –proj <project name> -in export_configs.asc -inactivateAlert

-- Wait until the import is finished
-- Start the project in normal configuration

 

The historical alerts/events are not modified during this procedure. This information is still available in the system after the initialization of this part of the database.
Please note that you can get errors when reading historical alerts for a timespan before the initialization was made.
For detailed information please have a look at the FAQ for the log-message “ PVSS00data PARAM/WARNING - workProcAlert, Cannot get attribute - will use dummy”.

If you have additional questions please get in contact with your common WinCC OA support.

Date added:
Last revised:
Hits:
11.757
Rating:
Rating: 3.4. 49 vote(s).
49 anonymous votes
No rating done at all.
Your vote was '' (0 of 5) You are an anonymous user.
You may log on to do personalized votings
Click the rating bar to rate this item Please log on to do ratings
  • Notification

    FE user cannot be identified! (1403201096)