Hi Lisa, A couple of questions:
1. What is the ReconciliationIdentity value of the SANDBOX records? Is it a zero "0" (If so.....backup these records and then delete them and retry running the job). 2. Does a BMC.ASSET record already exist for the CI with the same Name value or ReconciliationIdentity 3. Have you looked at the reconciliation log files in <install directory>\ AtriumCore\Logs....see if there is a merge or identification specific issue there (this should tell you something about each of the records having an issue) 4. Is the delete dataset active or Inactive [cid:image001.png@01CE7E1E.2707E2F0] Regards, Ryan. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: Thursday, July 11, 2013 9:41 AM To: arslist@ARSLIST.ORG Subject: Reconciliation Engine and New Records ** Recon Engine is running, no errors, but when adding new records to Asset Management, they are not moving over to the BMC.ASSET dataset, they are stuck in the Sandbox. I'd like to see what's happening so I believe I would turn on API and SQL logging. But when I turn this on for 5 or 10 minutes, there's about 20,000 lines to wade through. What am I looking for? A simple SQL statement that's changing the DatasetID field on the Base Element form from BMC.ASSET.SANDBOX to BMC.ASSET? (I can get the Base Element form id from AR Schema form and search on that). Checked Reconciliation Job Events table and everything looks good (no errors). The only thing I can see that's sort of weird is that in Identification is modifies 198 records, but no merges (0) and no deletes (0). Lisa Kemes _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.png>>