ODS status repair and personal understanding

ODSVery simple and easy to break, especially when doingDeltaDuring the process, the newly imported request may not be activated due to incorrect deletion of some requests.

A program left by the predecessors

Report zdmdeltarepair.
Parameters: l_ods type rsdodsobject.

DataRochelle count type sytabix.
Select count (distinct partid) from rsdmdelta into l_count
Where icname = l_ods.
If l_count> 0.
Write 'status are still set. Delta can not be retried red (note 578150 )'.
Exit.
Endif.

Data l_max type rssid.
Select max (requid) into l_max from rsbodslog
Where odsobject = l_ods.
Update rsbodslogstate set active = l_max
Processed_all = 0
Processed_one = 0
Where odsobject = l_ods.

----------------------

The program itself does not solve anything for me.ProblemBut the rsbodslogstate table here has helped me a lot. I have manually changed the numbers here several times, and the problem has actually been solved.

========================================================== ==================================

The above is an article from a senior. I understand it as follows:

If DSO fails to load, including loading data by itself, and loading data from DSO to another DSO or cube, a new request may be imported due to frequent deletion of the primary request.

1. view the table rsdmdelta (Dataset Delta Management) by DSO name. If the partid field has a value, the incremental loading cannot be repaired. See note 578150.

2. Otherwise, view the rsbodslog table (requests in ODS change logs) and obtain the maximum value of the requid field.

3. Check the rsbodslogstate table (ODS object change log status) to check whether the active value is the same as the requid value found in the previous step, whether processed_all is 0, and whether processed_one is 0, if not, change it.

========================================================== =

Request tables

Rsreqdone: Monitor: saving of the Qm entries record RequestThe status and basic information of rsiccont: Monitor: saving of the updated IC and ODS per request records the status of requests in cube or ODS. In addition, rsbodslogstate: changelog status for ods object records the request activation and Delta requests in ODS.