Translate

Monday, March 3, 2014

MSCCLRFS : APS Collections Refresh Snapshot Thread Ends With Error ORA-12034: Materialized View Log On INV.MTL_TXN_REQUEST_LINES Younger Than Last Refresh

In  case of error like "ORA-12034: materialized view log on "INV"."MTL_TXN_REQUEST_LINES" younger than last refresh ", 
you need to a  complete/automatic refresh of the problem snapshot.
.
In this case, there were 2 snapshots that had this issue:
MTL_TXN_REQUEST_LINES_SN
MTL_ITEM_CATS_SN
.
1. Please perform an automatic refresh of these snapshots INDIVIDUALLY. 
The concurrent request : "Refresh Collection Snapshots", can be launched individually also.
Log into "Advanced supply Chain Planner" responsibility on the source instance.
Then from tools menu, choose View->Requests.
Click on the button, Submit a new request.
Type in "Refresh Collection Snapshots".
In the parameters choose the following:

Refresh Mode: Automatic
Snapshot Name: MTL_TXN_REQUEST_LINES_SN
Threshold for Truncating Logs: 0
Degree: 0

Click OK and submit the request.


Please repeat the same steps for the other snapshot: MTL_ITEM_CATS_SN


2. Do a fast refresh of ALL snapshots and ensure that it completes fine.

3. Please run data collection and is should complete successfully. 

No comments:

Post a Comment