I would try to debug the recon job itself. >From the CMDB:Console (The old console) open the Reconciliation Manager tab, >then open settings and set the Logging Level to Debug.
Run the job and the log will show you every rule, substitution, and action it took against each CI from the sandbox. I'm sure you'll find your answer in there. .: Mike T :. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: Tuesday, July 16, 2013 7:38 AM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine and New Records The reconciliationidentity value doesn't get generated until after it runs through Reconciliation. For some reason, it just sits in the sandbox (there are no errors in the recon logs even after I set the logging to debug). I guess I would like to go back to my original question, I'd like to follow the workflow (SQL, API Calls) when the recon engine runs the job so I can see exactly what is happening. Why is it skipping these records? Would it show that it's checking everything with a dataset of BMC.ASSET.SANDBOX and then let me know why it skipped it? (by showing me the SQL query?). Any assistance would be great. Thanks! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kiran Patil Sent: Thursday, July 11, 2013 11:55 PM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine and New Records Hi Lisa, 1- Are indentification ids getting generated for manual created CI in sandbox? 2- If yes, copy reconID of any of manual created And search on BASE_Element form and check Check how many records your getting? 3- do you have any other datasource integrated With cmdb to populate CI? Regards Kiran On Thu, 11 Jul 2013 20:24:24 +0550, arslist@ARSLIST.ORG wrote: > Yep, doing the debug now. But if there are no errors, I'm not sure > what it's going to show me. > > I'm going to check the logs in a few minutes and see what I can find. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Downing, Ryan > Sent: Thursday, July 11, 2013 10:28 AM > To: arslist@ARSLIST.ORG > Subject: Re: Reconciliation Engine and New Records > > ** > > Hi again Lisa, > > > > Also, you may want to set your log level to "Debug" in the settings > > > > > > > > Ryan. > > > > From: 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 > directory>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" _______________________________________________________________________________ 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"
