Re: Reconciliation Engine and New Records

2013-07-23 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
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

2013-07-16 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
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

2013-07-16 Thread Tomasiewicz, Mike (Information Technology)
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

2013-07-16 Thread Peter Romain
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

2013-07-11 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
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

2013-07-11 Thread Downing, Ryan
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

2013-07-11 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
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

2013-07-11 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
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

2013-07-11 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
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

2013-07-11 Thread Downing, Ryan
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

2013-07-11 Thread Kiran Patil
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