9 Replies Latest reply: Jun 6, 2014 5:56 AM by Urbain Virnot RSS

    BMC Atrium Integrator 7.6.04 - Error 120076 for field DatasetID when running the Import-Job

    Katrin Pinczesi

      Hi Guys,

       

      for a WS I installed and set up the BMC Atrium Integrator. Defining DataSources, the Import file (csv) and the Job itself worked fine.

       

      I want to import CIs into the class Computer Systems and with DataSet ID = VI.IMPORT.

      Class and DatasetID are fine, I have already CIs in there with this data. And for the mapping I copied and pasted data from the existing CI wherever possible. So there are no typos. Also all used values are valid.

       

      Import file and mapping information:

      CIIdentifier --> mapped to Asset ID

      Hostname --> mapped to Hostname

      Hostname --> mapped to Name

      Hostname --> mapped to Short Description

      Manufacturer --> mapped to ManufacturerName

      CIStatus --> mapped to AssetLifeCycleStatus

      ScanDate --> mapped to LastScanDate

      Typ --> mapped to Item

      DatasetID --> mapped to DatasetID

      Category --> mapped to Category

      Type --> mapped to Type

       

      When I now start the import job, I get the following error in the logging output (loggin set to the most detailed level): ERROR (120076): No value supplied for a required attribute.; DatasetId

       

      It is strange, the prior this error message, the DatasetID can be read and is also mapped!!! (please see below):

                          • Start **********************

      Text Source.0 - Opening file: C:\Import\CIImport.csv

      convert line to row - Normal field found:[MS_12345]

      convert line to row - Normal field found:[MS_LT12345]

      convert line to row - Normal field found:[Microsoft Corporation]

      convert line to row - Normal field found:[Deployed]

      convert line to row - Normal field found:[01.10.2011]

      convert line to row - Normal field found:[Laptop]

      convert line to row - Normal field found:[VI.IMPORT]

      convert line to row - Normal field found:[Hardware]

      convert line to row - Normal field found:[Processing Unit]

      Text Source.0 - Found data row: , , , , , , , ,

      Text Source.0 - Putting row: , , , , , , , ,

      Text Source.0 - Signaling 'output done' to 1 output rowsets.

      Text Source.0 - Finished processing (I=4, O=0, R=0, W=3, U=0, E=0)

      Add constants.0 - Wrote row 1 : , , , , , , , ,

      CMDBOutput.0 - Checking row: , , , , , , , ,

      CMDBOutput.0 - Field has nr. 0

      CMDBOutput.0 - Field has nr. 0

      CMDBOutput.0 - Field has nr. 7

      CMDBOutput.0 - Field has nr. 3

      CMDBOutput.0 - Field has nr. 6

      CMDBOutput.0 - Field has nr. 1

      CMDBOutput.0 - Field has nr. 1

      CMDBOutput.0 - Field has nr. 1

      CMDBOutput.0 - Field has nr. 2

      CMDBOutput.0 - Field has nr. 4

      CMDBOutput.0 - Field has nr. 5

      CMDBOutput.0 - Field has nr. 8

      CMDBOutput.0 - Field has nr. 8

      CMDBOutput.0 - Setting preparedStatement to

      CMDBOutput.0 - Values set for lookup: ,

      CMDBOutput.0 - +CMDB findObjects for record with Qualifier :['AssetID' = "MS_12345"  AND 'DatasetId' = "VI.IMPORT" ]

      CMDBOutput.0 - Adding new record into CMDB.

      CMDBOutput.0 - Insert row: ![MS_12345], , , , , , , ,

      CMDBOutput.0 - Converting to ENUM

      CMDBOutput.0 - For input string: "Deployed"

      CMDBOutput.0 - Create Multiple instances

      CMDBOutput.0 - exception:ERROR (120076): No value supplied for a required attribute.; DatasetId

      CMDBOutput.0 - Signaling 'output done' to 0 output rowsets.

      CMDBOutput.0 - ***************PutAll Last Chunk for 0 CI's: 0 seconds ***************

      CMDBOutput.0 - ***************CMDB findObjects time for 1 CI's: 0.0 seconds ***************

      CMDBOutput.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=1)

      Error Logging.0 - Signaling 'output done' to 0 output rowsets.

      Error Logging.0 - Closing output stream: C:\Program Files (x86)\BMC Software\AtriumIntegrator\server\data-integration\ngie\bin\error\EXAMPLE_CIImport_Computersystem_Error.txt

      Error Logging.0 - Closed output stream: C:\Program Files (x86)\BMC Software\AtriumIntegrator\server\data-integration\ngie\bin\error\EXAMPLE_CIImport_Computersystem_Error.txt

      Error Logging.0 - Finished processing (I=0, O=4, R=3, W=3, U=1, E=0)

      ...

                          • END **********************

       

      Also a try to define a constant and assigning the constant to the CMDB field was not successful. Still the same error.

       

      Do you have an idea what goes wrong?

       

      Thanks and regards

      Katrin