Oracle insert errors

[leonmf]

This is my first post here and I'm sorry it has to be an intractable bug. I've already run this by the US support group and am at a loss.

I have a client who has a test system up and running with WinCC OA 3.13 Patch 11. It's been running fine for a few weeks and started getting insert errors last weekend.

- The Database connection is good.
- They can create new RDB Archive Groups (e.g. NEWGROUP) and they appear in the ARC_GROUP table.
- No NEWGROUPHISTORY_0010000X table is created.
- No NEWGROUPHISTORY view is created.
- Existing history tables are still available to be queried but no writes are happening.
- I had them do a database dump, I imported the dump into my test server, fixed the permissions and compiled the packages. My copy of their OA code is writing to my OA server, though I'm not 100% certain it is working correctly since the buffer folder has not emptied out.
- I had them try running the win_upgrade process to force refreshing the database utilities and permissions. This did not solve their problem.
- The database password for PVSSRDB has been set to an unlimited expiration date (3 days before this all went bad).

Because this is a test environment, they'll reluctantly let me run the setup script again to re-initialize the database but we are all very worried that it will just break again so I'm hoping someone here knows more than I do.

Here's a log excerpt:
WCCOArdb (97), 2016.02.26 16:06:43.551, SYS, INFO, 0, , Error when inserting the EVENT history with bulk!, ORA-00942: table or view does not exist
WCCOArdb (97), 2016.02.26 16:06:43.554, SYS, INFO, 0, , Error when inserting the EVENT history with bulk!, ORA-00942: table or view does not exist
WCCOArdb (97), 2016.02.26 16:06:43.558, SYS, INFO, 0, , Error when inserting the EVENT history with bulk!, ORA-00942: table or view does not exist
WCCOArdb (97), 2016.02.26 16:06:43.573, SYS, INFO, 0, , Error when writing the history!, ORA-00942: table or view does not exist
ORA-06512: at "PVSSRDB.VALARCH", line 2045
ORA-06512: at "PVSSRDB.VALARCH", line 2119
ORA-06512: at "PVSSRDB.VALARCH", line 2092
ORA-06512: at line 1
WCCOArdb (97), 2016.02.26 16:06:43.720, SYS, WARNING, 0, , Bulk data NOT written into database!, ErrorCode: -1
WCCOArdb (97), 2016.02.26 16:06:43.723, SYS, SEVERE, 0, , Could not insert all Items into DB! Try to write Block again.
WCCOArdb (97), 2016.02.26 16:06:43.725, SYS, SEVERE, 0, , Maximum amount of db writes reached! I'll drop Block and continue with the next!
WCCOArdb (97), 2016.02.26 16:06:43.730, SYS, SEVERE, 0, , Deleting BlockNumber: 50484 from disk! Could not write to DB - DBConnection available
WCCOArdb (97), 2016.02.26 16:06:43.948, SYS, INFO, 0, , Error when inserting the EVENT history with bulk!, ORA-00942: table or view does not exist
WCCOArdb (97), 2016.02.26 16:06:43.961, SYS, INFO, 0, , Error while writing to the DB., DpName: System1:DoorInstall.DDL1-3_RS_Droplift.VFD.Status.DCBusVoltage:_original.._value, ElementID: 13941977601, Time stamp: 2016.02.23 16:01:39.941000, DB Error: ORA-00942: table or view does not exist
, ORA-00942: table or view does not exist

[leoknipp]

I've ssen these log messages or similar ones in a test system I was using the last few days.
The errors have been gone after the RDB manager has been restarted.

Best Regards
Leopold Knipp
Senior Support Specialist