Troubleshooting
In order to speed up the error search in the RDB there are two diagnostics scripts provided:
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.