Symantec Management Platform (Notification Server)

 View Only
  • 1.  There is no row at position x. Data Connector: Import Rule Error

    Posted Feb 29, 2012 03:02 AM

    Hi,

    I am trying to update the Asset's owner of Computers using an Import rule and a excel file and have encounter some errors.

    I had already apply the fix found in this article http://www.symantec.com/docs/TECH164571 as I used to have the errors  "Error "'Row x skipped for data class ''. Data class foreign key lookup on column '' failed." occurs when using a Data Connector import rule that has a foreign key data class mapping".

    However after applying the fix, I get these errors instead "Exception Details: System.IndexOutofRangeException: There is no row at position x.."

    I been trying ways to resolve the errors and found out that using the resource GUID of the owner instead of the name would properly update the ownership.

    My question is: Is there anyway to update the ownership using name instead of GUID? And is there anyway to undo the fixes?

    Thanks



  • 2.  RE: There is no row at position x. Data Connector: Import Rule Error

    Posted Feb 29, 2012 09:27 AM

    You need to perform the lookup on the unique key, the GUID -- Owner name or asset name is non-unique.  You are going to see names later, because that's what the database presents, but whenever you're talking to the NS, you need to talk in GUIDs, because that's what the NS speaks in.

    Remember, if you're seeing a Name somewhere, the NS asked the SQL database, "What is the value of the Name column in this table where the Guid column's value is '12ed47fa1-bc34-ae91-ab3c5ed'?"  



  • 3.  RE: There is no row at position x. Data Connector: Import Rule Error

    Posted Feb 29, 2012 09:25 PM

    Is there no way to mass update all my assets eg. computer/printers/etc using an imported file without the fuss of looking at the GUID of each user that I want to update?



  • 4.  RE: There is no row at position x. Data Connector: Import Rule Error

    Posted Feb 29, 2012 09:49 PM

    You can, but only if the data is unique.  If you want to update records in the CMDB, and you choose Active Directory usernames as your key, those are going to be unique, so no problem -- the data from your spreadsheet that matches the record in the CMDB whose username is 'mclemson' is updated.

    But if you want to update values in the CMDB that are non-unique, such as records based on Company Asset Tag, and your techs happened to accidentally enter two computers whose Company Asset Tag are both set to 048938, and you want to match that to a physical inventory you performed in a spreadsheet where Column A - Company Asset Tag is 048938 and Column B - Owner is 'mclemson', Altiris won't know whether you want to set one company's owner to mclemson or the other's.

    So likely your data is non-unique.  Because you're using a spreadsheet, you're right -- GUID is not an option. Instead, look at what you are using as the foreign key.  Check for duplicate foreign keys in the CMDB or in the spreadsheet, and resolve them.

    Does this help?



  • 5.  RE: There is no row at position x. Data Connector: Import Rule Error

    Posted Feb 29, 2012 10:04 PM

    I just tried updating via names on a fresh install of NS and it worked.

    Can you tell me how I can undo the changes describe in http://www.symantec.com/business/support/index?page=content&id=TECH164571?

    It will still have the null value errors but I can live with it.

     



  • 6.  RE: There is no row at position x. Data Connector: Import Rule Error

    Posted Mar 01, 2012 12:17 PM

    If it works, what changes do you need to make?  I may not be following you.  What's not working where a change is needed?



  • 7.  RE: There is no row at position x. Data Connector: Import Rule Error

    Posted Mar 01, 2012 09:08 PM

    Before I applied the fix described in the article. I was able to update the ownership with names but I would receive null value errors. This error is caused by having blank ownership names .

    In order to fix it, I applied the patch in the article. The null value errors are resolved however I am only able to update the ownership names using GUID.

    Is there anyway to undo the changes? I can live with the null value errors if I can update using names.

    I ran the command to config aexconfig.exe to dataconnector2.config and ran the missing_stored_procs.sql as described in TECH164571. 

    Thanks for trying to help me so far!