Re: issue using AIE to populate the AST:AssetPeople form
I am building my 764 and have encountered this quite a bit. Check your BMC.CORE:BMC_Person screen. Is the person’s record there? Probably not. If not you will need to change their status on their CTM:People record. This will create the record in the Person screen. You might have to wait for the reconciliation engine to merge records if you have more than one for the person. But it seems to do that every minute. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Newmark Sent: Monday, April 29, 2013 6:11 PM To: arslist@ARSLIST.ORG Subject: Re: issue using AIE to populate the AST:AssetPeople form ** Sorry about the no newlines. I copied and pasted the post from my issue report to BMC d I guess the formatting was messed up. I will try to relate one of the people to their respective CI tomorrow morning. As far as I know all of the people have been reconciled. I will look at the reconciliation ID field again to make sure. There are records in this flat file that do not have corresponding people populated in the people form, but I expected them to error out when the SQL statement to look up their people ID came back with no results and the AIE job does just that. Thanks, Joe __ There aint no star to guide you while you're looking at the ground. So take some time to breathe, raise your head and look around - Jorma I only have so many heartbeats left. I am not wasting them on things that are not fun. From: Downing, Ryan ryan_down...@bmc.com To: arslist@ARSLIST.ORG Sent: Monday, April 29, 2013 6:09 PM Subject: Re: issue using AIE to populate the AST:AssetPeople form ** Hi Joe, It is a little difficult to follow your message as there is no new lines….but….if I understand correctly the creation of the “AST:AssetPeople” relationship fails…… There is a rule in ITSM/CMDB that requires certain information be available in order to create the “AST:AssetPeople” relationship between a CI and a “CTM:People” record when the type of relationship is a “Used By” type and the CI is a “Computer System”. If I recall correctly the “CTM:People” record must be reconciled. This means that the “ReconciliationIdentity” field on the “CTM:People” record must have a value of other than “0” or NULL. Whenever a ‘People’ record is created ( meaning submit)…a record is created in the BMC_Person class form in the “SANDBOX” dataset. When this record is reconciled to the production dataset (BMC.ASSET) it synchronizes the BMC_Person ReconciliationIdentity field back to the CTM:People record. This is needed so that when an “AST:AssetPeople” relationship is created it can also create the associated BMC_Dependency class record for the same relationship (essentially a synchronization between ITSM and CMDB for both People and CI associations). Can you try manually making a “Used By” relationship from one of the People records to a CI where you get the Error: IE: People record à KENNETH.KREUTTER@DHS.GOVUSER'S EMAIL ADDRESS OR Query the CTM:People form to see which records have a ‘ReconciliationIdentity’ of either NULL or “0”…..if there are any…these people records cannot be properly associated to a “Computer System” CI where the role is “Used By”. The “BMC_Dependency” record created as a result of creating the “AST:AssetPeople” record requires that the “CTM:People” record have a ‘ReconciliationIdentity” value to pass to the dependency class as it is a required field. I am currently not online but will reply back with the exact filter name which give the error in this case…it is something like…”The Person you are attempting to make a relationship to has not been reconciled, please reconcile the person or contact your system administrator” Turn on server side filter logging while running AIE ….look for this message (not verbatim as I am guessing right now at the verbiage of the error). I will get more explicit information by tomorrow. Hope this helps for now J Regards, Ryan. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Newmark Sent: Monday, April 29, 2013 12:49 PM To: arslist@ARSLIST.ORG Subject: issue using AIE to populate the AST:AssetPeople form ** Hi all, I am using Remedy 7.6.04 and I need to import records to the CMDB from a flat file. The CI goes in with no issues, but when I try to create a people relationship between the person the uses the CI (as listed in the flat file) I am getting an error. I have an AIE AR form data exchange that takes the data from the flat file, does a SQL search in the AR database to get the Person ID (PPL) of the user from the people form(which is working correctly) and then I try to create the record on AST:AssetPeople. The error I am getting shows up in the data exchange log
issue using AIE to populate the AST:AssetPeople form
Hi all, I am using Remedy 7.6.04 and I need to import records to the CMDB from a flat file. The CI goes in with no issues, but when I try to create a people relationship between the person the uses the CI (as listed in the flat file) I am getting an error. I have an AIE AR form data exchange that takes the data from the flat file, does a SQL search in the AR database to get the Person ID (PPL) of the user from the people form(which is working correctly) and then I try to create the record on AST:AssetPeople. The error I am getting shows up in the data exchange log as follows: AddAssetToAR: Error processing entry USER'S EMAIL ADDRESS, form AST:AssetPeople AddAssetToAR: AR API returned error during ARCreateEntry rc = 2 Required name parameter (or name field in a parameter) is empty. (102) (1) Data Exchange Log: [Mon Apr 29 2013 09:36:19.2530] - TID: 001 API+ ARSetEntry -- Form [EIE:Exchange_Runs] for Entry [733] [Mon Apr 29 2013 09:36:19.2680] - TID: 001 API- ARSetEntry OK [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLProcess command: select c1,C100017,c100048 from T1190 Where c100048='USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLData obtained from Source for mappings: 'iSYS AssetPeopleForm' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 1 : 'FORM', Value: 'People' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 2 : 'ROLE', Value: 'Used by' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 3 : ''Full Name'', Value: 'USER'S NAME' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 4 : 'TargetSQL|select c1 from T1190 Where c100048='$Unique_Users_EmployeeEmail$' ', Value: 'PPL00011996' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 5 : 'CellNumber', Value: '20226X' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLKey Rule 1 : 'Unique_Users_EmployeeEmail', Value: 'USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLSetting field values of Target for mappings 'iSYS AssetPeopleForm' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 1 : Form Type (id: 260100013) set to 'People' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 2 : PersonRole (id: 26015) set to '6000' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 3 : Full Name (id: 26013) set to 'USER'S NAME' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 4 : PeopleGroup Form Entry ID (id: 26016) set to 'PPL00011996' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLRule 5 : Asset ID+ (id: 26018) set to '20226x' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLKey Rule 1 : Assigned To (id: 4) set to 'USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 DTLAdding entry USER'S EMAIL ADDRESS.to form 'AST:AssetPeople' [Mon Apr 29 2013 09:36:19.2680] - TID: 001 API+ ARCreateEntry -- Form[AST:AssetPeople] [Mon Apr 29 2013 09:36:19.2840] - TID: 001 ERRAddAssetToAR: Error processing entry USER'S EMAIL ADDRESS form AST:AssetPeople AddAssetToAR: AR API returned error during ARCreateEntry rc = 2 Required name parameter (or name field in a parameter) is empty. (102) (1) [Mon Apr 29 2013 09:36:19.2840] - TID: 001 API- ARCreateEntry Failed [Mon Apr 29 2013 09:36:19.2840] - TID: 001 ERREntry KENNETH.KREUTTER@DHS.GOVUSER'S EMAIL ADDRESS was not added to AR I have taken out the user's information. From what I can see the form AST:AssetPeople only has three required fields Request Type, which is character PersonRole, which is a list. I give the AIE job the text Used by and it converts it to the value of 6000 PeopleGroup Form Entry ID, which is the User's Person ID from the People form. Can anybody help me out with this one? I am tired of banging my head against a wall... Thanks, Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: issue using AIE to populate the AST:AssetPeople form
Hi Joe, It is a little difficult to follow your message as there is no new lines….but….if I understand correctly the creation of the “AST:AssetPeople” relationship fails…… There is a rule in ITSM/CMDB that requires certain information be available in order to create the “AST:AssetPeople” relationship between a CI and a “CTM:People” record when the type of relationship is a “Used By” type and the CI is a “Computer System”. If I recall correctly the “CTM:People” record must be reconciled. This means that the “ReconciliationIdentity” field on the “CTM:People” record must have a value of other than “0” or NULL. Whenever a ‘People’ record is created ( meaning submit)…a record is created in the BMC_Person class form in the “SANDBOX” dataset. When this record is reconciled to the production dataset (BMC.ASSET) it synchronizes the BMC_Person ReconciliationIdentity field back to the CTM:People record. This is needed so that when an “AST:AssetPeople” relationship is created it can also create the associated BMC_Dependency class record for the same relationship (essentially a synchronization between ITSM and CMDB for both People and CI associations). Can you try manually making a “Used By” relationship from one of the People records to a CI where you get the Error: IE: People record -- KENNETH.KREUTTER@DHS.GOVUSER'S EMAIL ADDRESS OR Query the CTM:People form to see which records have a ‘ReconciliationIdentity’ of either NULL or “0”…..if there are any…these people records cannot be properly associated to a “Computer System” CI where the role is “Used By”. The “BMC_Dependency” record created as a result of creating the “AST:AssetPeople” record requires that the “CTM:People” record have a ‘ReconciliationIdentity” value to pass to the dependency class as it is a required field. I am currently not online but will reply back with the exact filter name which give the error in this case…it is something like…”The Person you are attempting to make a relationship to has not been reconciled, please reconcile the person or contact your system administrator” Turn on server side filter logging while running AIE ….look for this message (not verbatim as I am guessing right now at the verbiage of the error). I will get more explicit information by tomorrow. Hope this helps for now ☺ Regards, Ryan. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Newmark Sent: Monday, April 29, 2013 12:49 PM To: arslist@ARSLIST.ORG Subject: issue using AIE to populate the AST:AssetPeople form ** Hi all, I am using Remedy 7.6.04 and I need to import records to the CMDB from a flat file. The CI goes in with no issues, but when I try to create a people relationship between the person the uses the CI (as listed in the flat file) I am getting an error. I have an AIE AR form data exchange that takes the data from the flat file, does a SQL search in the AR database to get the Person ID (PPL) of the user from the people form(which is working correctly) and then I try to create the record on AST:AssetPeople. The error I am getting shows up in the data exchange log as follows: AddAssetToAR: Error processing entry , form AST:AssetPeople AddAssetToAR: AR API returned error during ARCreateEntry rc = 2 Required name parameter (or name field in a parameter) is empty. (102) (1) Data Exchange Log: [Mon Apr 29 2013 09:36:19.2530] - + ARSetEntry -- Form [EIE:Exchange_Runs] for Entry [733] [Mon Apr 29 2013 09:36:19.2680] - - ARSetEntry OK [Mon Apr 29 2013 09:36:19.2680] - Process command: select c1,C100017,c100048 from T1190 Where c100048='USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - Data obtained from Source for mappings: 'iSYS AssetPeopleForm' [Mon Apr 29 2013 09:36:19.2680] - Rule 1 : 'FORM', Value: 'People' [Mon Apr 29 2013 09:36:19.2680] - Rule 2 : 'ROLE', Value: 'Used by' [Mon Apr 29 2013 09:36:19.2680] - Rule 3 : ''Full Name'', Value: 'USER'S NAME' [Mon Apr 29 2013 09:36:19.2680] - Rule 4 : 'TargetSQL|select c1 from T1190 Where c100048='$Unique_Users_EmployeeEmail$' ', Value: 'PPL00011996' [Mon Apr 29 2013 09:36:19.2680] - Rule 5 : 'CellNumber', Value: '20226X' [Mon Apr 29 2013 09:36:19.2680] - Key Rule 1 : 'Unique_Users_EmployeeEmail', Value: 'USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - Setting field values of Target for mappings 'iSYS AssetPeopleForm' [Mon Apr 29 2013 09:36:19.2680] - Rule 1 : set to 'People' [Mon Apr 29 2013 09:36:19.2680] - Rule 2 : set to '6000' [Mon Apr 29 2013 09:36:19.2680] - Rule 3 : set to 'USER'S NAME' [Mon Apr 29 2013 09:36:19.2680] - Rule 4 : set to 'PPL00011996' [Mon Apr 29 2013 09:36:19.2680] - Rule 5 : set to '20226x' [Mon Apr 29 2013 09:36:19.2680] - Key Rule 1 : set to 'USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - Adding entry USER'S EMAIL ADDRESS.to form 'AST:AssetPeople' [Mon Apr 29 2013 09:36:19.2680
Re: issue using AIE to populate the AST:AssetPeople form
Sorry about the no newlines. I copied and pasted the post from my issue report to BMC d I guess the formatting was messed up. I will try to relate one of the people to their respective CI tomorrow morning. As far as I know all of the people have been reconciled. I will look at the reconciliation ID field again to make sure. There are records in this flat file that do not have corresponding people populated in the people form, but I expected them to error out when the SQL statement to look up their people ID came back with no results and the AIE job does just that. Thanks, Joe __ There aint no star to guide you while you're looking at the ground. So take some time to breathe, raise your head and look around - Jorma I only have so many heartbeats left. I am not wasting them on things that are not fun. From: Downing, Ryan ryan_down...@bmc.com To: arslist@ARSLIST.ORG Sent: Monday, April 29, 2013 6:09 PM Subject: Re: issue using AIE to populate the AST:AssetPeople form ** Hi Joe, It is a little difficult to follow your message as there is no new lines….but….if I understand correctly the creation of the “AST:AssetPeople” relationship fails…… There is a rule in ITSM/CMDB that requires certain information be available in order to create the “AST:AssetPeople” relationship between a CI and a “CTM:People” record when the type of relationship is a “Used By” type and the CI is a “Computer System”. If I recall correctly the “CTM:People” record must be reconciled. This means that the “ReconciliationIdentity” field on the “CTM:People” record must have a value of other than “0” or NULL. Whenever a ‘People’ record is created ( meaning submit)…a record is created in the BMC_Person class form in the “SANDBOX” dataset. When this record is reconciled to the production dataset (BMC.ASSET) it synchronizes the BMC_Person ReconciliationIdentity field back to the CTM:People record. This is needed so that when an “AST:AssetPeople” relationship is created it can also create the associated BMC_Dependency class record for the same relationship (essentially a synchronization between ITSM and CMDB for both People and CI associations). Can you try manually making a “Used By” relationship from one of the People records to a CI where you get the Error: IE: People record àKENNETH.KREUTTER@DHS.GOVUSER'S EMAIL ADDRESS OR Query the CTM:People form to see which records have a ‘ReconciliationIdentity’ of either NULL or “0”…..if there are any…these people records cannot be properly associated to a “Computer System” CI where the role is “Used By”. The “BMC_Dependency” record created as a result of creating the “AST:AssetPeople” record requires that the “CTM:People” record have a ‘ReconciliationIdentity” value to pass to the dependency class as it is a required field. I am currently not online but will reply back with the exact filter name which give the error in this case…it is something like…”The Person you are attempting to make a relationship to has not been reconciled, please reconcile the person or contact your system administrator” Turn on server side filter logging while running AIE ….look for this message (not verbatim as I am guessing right now at the verbiage of the error). I will get more explicit information by tomorrow. Hope this helps for now J Regards, Ryan. From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Newmark Sent: Monday, April 29, 2013 12:49 PM To: arslist@ARSLIST.ORG Subject: issue using AIE to populate the AST:AssetPeople form ** Hi all, I am using Remedy 7.6.04 and I need to import records to the CMDB from a flat file. The CI goes in with no issues, but when I try to create a people relationship between the person the uses the CI (as listed in the flat file) I am getting an error. I have an AIE AR form data exchange that takes the data from the flat file, does a SQL search in the AR database to get the Person ID (PPL) of the user from the people form(which is working correctly) and then I try to create the record on AST:AssetPeople. The error I am getting shows up in the data exchange log as follows: AddAssetToAR: Error processing entry , form AST:AssetPeople AddAssetToAR: AR API returned error during ARCreateEntry rc = 2 Required name parameter (or name field in a parameter) is empty. (102) (1) Data Exchange Log: [Mon Apr 29 2013 09:36:19.2530] - + ARSetEntry -- Form [EIE:Exchange_Runs] for Entry [733] [Mon Apr 29 2013 09:36:19.2680] - - ARSetEntry OK [Mon Apr 29 2013 09:36:19.2680] - Process command: select c1,C100017,c100048 from T1190 Where c100048='USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - Data obtained from Source for mappings: 'iSYS AssetPeopleForm' [Mon Apr 29 2013 09:36:19.2680] - Rule 1 : 'FORM', Value: 'People' [Mon Apr 29