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" <[email protected]> To: [email protected] 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 à[email protected]'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:[email protected]] On Behalf Of Joe Newmark Sent: Monday, April 29, 2013 12:49 PM To: [email protected] 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 (PPL00000000XXXX) 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) (10000) Data Exchange Log: [Mon Apr 29 2013 09:36:19.2530] - + ARSetEntry -- Form [EIE:Exchange_Runs] for Entry [000000000000733] [Mon Apr 29 2013 09:36:19.2680] - - ARSetEntry OK [Mon Apr 29 2013 09:36:19.2680] - Process command: select c1,C1000000017,c1000000048 from T1190 Where c1000000048='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 c1000000048='$Unique_Users_EmployeeEmail$' ', Value: 'PPL000000011996' [Mon Apr 29 2013 09:36:19.2680] - Rule 5 : 'CellNumber', Value: '20226XXXXX' [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 'PPL000000011996' [Mon Apr 29 2013 09:36:19.2680] - Rule 5 : set to '20226xxxxx' [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] - + ARCreateEntry -- Form[AST:AssetPeople] [Mon Apr 29 2013 09:36:19.2840] - 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) (10000) [Mon Apr 29 2013 09:36:19.2840] - - ARCreateEntry Failed [Mon Apr 29 2013 09:36:19.2840] - Entry [email protected]'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 _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"
