1 Reply Latest reply on Jun 28, 2019 10:05 AM by Gustavo del Gerbo

    Spoon job error in CMDBOutput step

    Luis Matos
      Share:|

      Greetings, i'm having a problem with a job execution in the Spoon. The job retrieve data from a sql server database. The connection between database and spoon it's ok. The connection between AR System it's fine. But when the CMDBOutput step execute, The data is not inserted in the CMDB dataset. in the environment we have 2 User Facing, another 2 Back end and 2 Mid tier servers.

       

      In the screenshot below you can see the steps that are execute in the transformation.

       

       

      Here's a result of the job:

       

      2019/06/18 15:54:22 - mapeo_Computer system - Adding new record into CMDB.

      2019/06/18 15:54:22 - mapeo_Computer system - Converting to ENUM

      2019/06/18 15:54:22 - CMDBOutput.0 - Adding new record into CMDB.

      2019/06/18 15:54:22 - mapeo_Computer system - Converting to ENUM

      2019/06/18 15:54:22 - CMDBOutput.0 - Converting to ENUM

      2019/06/18 15:54:22 - ReadResponseVariable.0 - Finished processing (I=0, O=0, R=40, W=40, U=0, E=0)

      2019/06/18 15:54:22 - CMDBOutput.0 - Adding new record into CMDB.

      2019/06/18 15:54:22 - CMDBOutput.0 - Converting to ENUM

      2019/06/18 15:54:22 - mapeo_Computer system - TID:2 Complete. [mapeo_Computer system] :CI's Inserted:  0:CI's Updated:0

      2019/06/18 15:54:22 - CMDBOutput.0 - TID:0 Complete. [mapeo_Computer system] :CI's Inserted:  0:CI's Updated:0

      2019/06/18 15:54:22 - mapeo_Computer system - Finished processing (I=13, O=0, R=13, W=0, U=0, E=0)

      2019/06/18 15:54:22 - CMDBOutput.0 - Finished processing (I=14, O=0, R=14, W=0, U=0, E=0)

      2019/06/18 15:54:22 - mapeo_Computer system - TID:1 Complete. [mapeo_Computer system] :CI's Inserted:  0:CI's Updated:0

      2019/06/18 15:54:22 - mapeo_Computer system - Finished processing (I=13, O=0, R=13, W=0, U=0, E=0)

      2019/06/18 15:54:22 - Table Source.0 - Finished processing (I=40, O=0, R=0, W=40, U=0, E=0)

      2019/06/18 15:54:22 - Spoon - The transformation has finished!!