On the Aveksa database, any idea where to find the rejected data from the data collectors?
On the Aveksa database, any idea where to find the rejected data from the data collectors?
Thanks Boris. However, these views doesn’t shows the data that Aveksa reject to collect.
New, Updated, Changed, Missing is the changes that is on the source (file, DB table, AD…)
Rejected however is a status defined by Aveksa when a data record is available in the source but can’t be collect by Aveksa
Regards
Armel Lupapi
Access Management | armel.lupapi@investec.co.za<mailto:armel.lupapi@investec.co.za> | Tel: +27 11 286 8063 | Cell: +27 76 920 8549
Client Support Centre: +27 11 286 9663 / 0860 110 161 | www.investec.co.za <https://www.investec.co.za/>
“The best way to get started is to quit talking and begin doing.”
I think it's a combination of more than one table together. First the you'll get the T_DC_SOURCEDATA_XXX table to get your raw data, then T_DC_SOURCEDATA_REJECT_LOG to find all IDs that are rejected, then T_EXCEPTIONS to get the details of the rejection itself.
See if this helps data storage wile collection