Re: Reconciliation Engine and New Records
Looks like another developer set the auto identify settings and this is what happened (I assumed he turned them off). He set them to what is on Production and now it works! Thanks everyone!! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peter Romain Sent: Tuesday, July 16, 2013 3:11 PM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine and New Records It may be that the CI's have got a last modified date that is earlier than the last time the merge job ran. If this is the case then they will never get merged. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tomasiewicz, Mike (Information Technology) Sent: 16 July 2013 15:29 To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine and New Records 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\Logssee if there is a merge or directoryidentification 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
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\Logssee if there is a merge or directoryidentification 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
Re: Reconciliation Engine and New Records
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\Logssee if there is a merge or directoryidentification 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
Re: Reconciliation Engine and New Records
It may be that the CI's have got a last modified date that is earlier than the last time the merge job ran. If this is the case then they will never get merged. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tomasiewicz, Mike (Information Technology) Sent: 16 July 2013 15:29 To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine and New Records 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\Logssee if there is a merge or directoryidentification 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_
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
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\Logssee 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
Re: Reconciliation Engine and New Records
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\Logssee 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
Re: Reconciliation Engine and New Records
1. ReconciliationIdentity is not zero, there is a normal number in there 2. No records already exist (I checked to make sure) these are all new records 3. Looking at the log files and they are 0 KB which means to me no problems (or does it mean that it's not doing what it's supposed to) 4. The delete activity on the BMC Asset Management job is ACTIVE Still digging Thanks! 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\Logssee 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
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\Logssee 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
Re: Reconciliation Engine and New Records
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\Logssee 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
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\Logssee 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