Hi Lisa, I have seen in some cases when there entries with a "0" ReconciliationIdentity that it can freeze up the processing of sandbox records.
Since you are in a staged environment try deleting these records and re-running the sandbox job manually from the cmdb:console form --> under the reconciliation tab --> then job history. Highlight the sandbox job and press the "Start" button I hope this helps. Regards, Ryan. -----Original Message----- 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 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine and New Records OK, on some of the records the ReconciliationIdentity is ZERO. What does that mean? Also, what do you mean by backing up these records, deleting and then retry running the job? Or I could delete them all together (this is only staging so we are just testing here) and restart recon processes and try to create another CI. Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Downing, Ryan Sent: Thursday, July 11, 2013 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine and New Records ** 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 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_ _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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"