1 Reply Latest reply on Dec 14, 2018 7:58 AM by John Wisdom

    Spoon CMDB job fails with System.NullPointerException error

    John Wisdom

      We have a Spoon job in Pentaho that pulls server information from a txt file and updates the Remedyforce CMDB. This was working in a sandbox until recently but now it fails with an,

      "Attempt to de-reference a null object BeforeInsert caused by: System.NullPointerException: Attempt to de-reference a null objectTrigger.BMCServiceDesk.UpdateBaseElementName: line 266, column 1;;SalesforceUpsert001" error. I am unable to find anything about this specific to a Spoon job on Salesforce's pages.



      The trigger is managed and I am unable to see the code that is referenced to get a clue as to what is going on.


      Has anyone else ran in to this?



        • 1. Re: Spoon CMDB job fails with System.NullPointerException error
          John Wisdom

          Worked with Jim Dubcak in BMC Support yesterday and he resolved by:


          Fixed Trigger Error: 

          Configure Remedyforce to Skip InstanceID Suffix:
          1. Click the Remedyforce Administration tab.
          2. Click the Application Settings | Click Custom Settings.
          3. In the Action column for Remedyforce Settings, Click Manage.
          4. On the Custom Setting Remedyforce Settings page, Click New.
          5. In the Name field, type Staging_SkipInstanceIDSuffix.
          6. Leave the Sequence Id field blank.
          7. In the Value field: Enter True.
          8. Click Save.
          9. Verify when importing CIs nothing is appended to the Instance Name


          So Cis will show up in the Remedyforce CMDB UI:

          Added the ID for CMDB_Class for Software Server which is a15E0000000PWQ1


          I then changed the className variable in the Transform from "BMC_Software Server" to  "a15E0000000PWQ1".