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 <<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) Data Exchange Log: [Mon Apr 29 2013 09:36:19.2530] - <TID: 001> <API > + ARSetEntry -- Form [EIE:Exchange_Runs] for Entry [000000000000733] [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <API > - ARSetEntry OK [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Process command: select c1,C1000000017,c1000000048 from T1190 Where c1000000048='USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Data obtained from Source for mappings: 'iSYS AssetPeopleForm' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 1 : 'FORM', Value: 'People' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 2 : 'ROLE', Value: 'Used by' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 3 : ''Full Name'', Value: 'USER'S NAME' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 4 : 'TargetSQL|select c1 from T1190 Where c1000000048='$Unique_Users_EmployeeEmail$' ', Value: 'PPL000000011996' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 5 : 'CellNumber', Value: '20226XXXXX' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Key Rule 1 : 'Unique_Users_EmployeeEmail', Value: 'USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Setting field values of Target for mappings 'iSYS AssetPeopleForm' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 1 : <Form Type (id: 260100013)> set to 'People' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 2 : <PersonRole (id: 260100005)> set to '6000' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 3 : <Full Name (id: 260100003)> set to 'USER'S NAME' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 4 : <PeopleGroup Form Entry ID (id: 260100006)> set to 'PPL000000011996' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Rule 5 : <Asset ID+ (id: 260100008)> set to '20226xxxxx' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Key Rule 1 : <Assigned To (id: 4)> set to 'USER'S EMAIL ADDRESS' [Mon Apr 29 2013 09:36:19.2680] - <TID: 001> <DTL > Adding 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> <ERR > 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] - <TID: 001> <API > - ARCreateEntry Failed [Mon Apr 29 2013 09:36:19.2840] - <TID: 001> <ERR > 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
