Maintaining RPS up-time
Posted: Wed May 28, 2014 11:53 am
Is it possible when RPS Halts due to an error like the following;
I could have RPS continue, log the error, I could come in later fix the problem in the production system and then;
Instead of re-creating the entire RPS database, I could drop the problem table and use the RPS manager to do a selective extract on that individual table.
Unhandled SystemException on 2014/05/24 08:19:14
Computer= ZZZZZ, Application= ZZZRpsLogin, Schema= ZZZSchema
SystemException: 1295 (not continuable, resumable)
* Cannot update a non-environmental object on a Secondary database
Caused By:
Receiver: ZZZStockItemLink/11916.17521
Method: ZZZStockItemLink::getZZZStockItem(268) -- create o;
Call Stack History:
<<JadeRpsDataPump/31633.1 (t)>> JadeRpsDataPump::dataPumpGlobalExceptionHdlr(542) -- source position: 542
<<ZZZStockItemLink/11916.17521>> ZZZStockItemLink::getZZZStockItem(268) -- create o;
...
*** Current action and database transaction ABORTED ***
I could have RPS continue, log the error, I could come in later fix the problem in the production system and then;
Instead of re-creating the entire RPS database, I could drop the problem table and use the RPS manager to do a selective extract on that individual table.
Unhandled SystemException on 2014/05/24 08:19:14
Computer= ZZZZZ, Application= ZZZRpsLogin, Schema= ZZZSchema
SystemException: 1295 (not continuable, resumable)
* Cannot update a non-environmental object on a Secondary database
Caused By:
Receiver: ZZZStockItemLink/11916.17521
Method: ZZZStockItemLink::getZZZStockItem(268) -- create o;
Call Stack History:
<<JadeRpsDataPump/31633.1 (t)>> JadeRpsDataPump::dataPumpGlobalExceptionHdlr(542) -- source position: 542
<<ZZZStockItemLink/11916.17521>> ZZZStockItemLink::getZZZStockItem(268) -- create o;
...
*** Current action and database transaction ABORTED ***