Troubleshooting

rdb_DataCollect.sql

This script collects all known important information about the database schema and WinCC OA such as all installation data, job data, archive information, error messages of the past, etc.

Call the script as follows:

sqlplus user/pwd@db @rdb_DataCollect.sql

You do not need any parameters to execute the script.

rdb_LogCollect.sql

This script contains detailed logging output if rdb_DataCollect did not deliver the necessary data using the fixed settings. The script displays data of scheduler job logs, Java log and ARC_LOG.

Call the script as follows:

sqlplus user/pwd@db @rdb_LogCollect.sql

Enter thereafter in each case what type of messages should be shown (for example errors, warnings, info) and from when to when the messages should be shown.

NOTE

The error message:

WCCOArdb (97), 2018.11.08 14:44:15.329, SYS, INFO, 0, , Error while writing to the DB., DpName: System1:harry_rdb_test_1.:_alert_hdl.1._system_time, ElementID: 8187281665, Time stamp: 2018.11.08 13:44:11.860000, DB Error: ORA-06502: PL/SQL: numerischer oder Wertefehler: Zeichenfolgenpuffer zu klein

is shown when the limit of 4000 characters is exceeded, you can solve this problem by using the extended data types for Oracle. See chapter Parameters for the Oracle DB Setup.