2 Replies Latest reply on Jan 5, 2018 8:18 AM by Mark Hodge

    Remedyforce LDAP Integration in Pentaho

    Mark Hodge

      When I try and run the recommended BMC scripts I am getting errors on the log file. Any idea what the issue is? 2018/01/03 10:28:38 - Update client user import table with LDAP user information - Loading transformation from XML file [file:///C:/Users/cnesler/Desktop/remedyforce/TransferLDAPInfo.ktr] 2018/01/03 10:28:38 - Update client user import table with LDAP user information - Using legacy execution engine 2018/01/03 10:28:38 - TransferLDAPInfo - Dispatching started for transformation [TransferLDAPInfo] 2018/01/03 10:28:38 - LDAP input.0 - Connected to server [10.1.1.53] with username [fmb\cnesleradmin] 2018/01/03 10:28:40 - Delta timestamp.0 - Opening file: file:///C:/Users/cnesler/Desktop/remedyforce/LDAPTransferTimeStamp.txt 2018/01/03 10:28:40 - Text Input[For Profile].0 - Opening file: file:///C:/Users/cnesler/Desktop/remedyforce/LookupData/Profile.csv 2018/01/03 10:28:40 - Text Input[For User Account Link].0 - Opening file: file:///C:/Users/cnesler/Desktop/remedyforce/LookupData/UserAccountLink.csv 2018/01/03 10:28:40 - Text Input[For Account].0 - Opening file: file:///C:/Users/cnesler/Desktop/remedyforce/LookupData/Account.csv 2018/01/03 10:28:40 - Text Input[For UserRole].0 - Opening file: file:///C:/Users/cnesler/Desktop/remedyforce/LookupData/Role.csv 2018/01/03 10:28:40 - Text Input[For User Account Link].0 - Finished processing (I=0, O=0, R=0, W=0, U=1, E=0) 2018/01/03 10:28:40 - Text Input[For UserRole].0 - Finished processing (I=3, O=0, R=0, W=2, U=1, E=0) 2018/01/03 10:28:40 - Text Input[For Profile].0 - Finished processing (I=20, O=0, R=0, W=19, U=1, E=0) 2018/01/03 10:28:40 - Text Input[For Account].0 - Finished processing (I=21, O=0, R=0, W=20, U=1, E=0) 2018/01/03 10:28:40 - Delta timestamp.0 - Finished processing (I=2, O=0, R=0, W=1, U=1, E=0) 2018/01/03 10:28:40 - Create time based LDAP filter string.0 - Optimization level set to 9. 2018/01/03 10:28:40 - Create time based LDAP filter string.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - Optimization level set to 9. 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Unexpected error 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - Javascript error: 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - TypeError: Cannot read property "length" from null (script#26) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:475) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:541) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at java.base/java.lang.Thread.run(Unknown Source) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - Caused by: org.mozilla.javascript.EcmaError: TypeError: Cannot read property "length" from null (script#26) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3785) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3763) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3791) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3810) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ScriptRuntime.undefReadError(ScriptRuntime.java:3823) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ScriptRuntime.getObjectProp(ScriptRuntime.java:1508) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.gen.script_26._c_script_0(script:26) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.gen.script_26.call(script) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.gen.script_26.call(script) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.mozilla.javascript.gen.script_26.exec(script) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:388) 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - ... 3 more 2018/01/03 10:28:40 - Dynamic account and profile assignment.0 - Finished processing (I=0, O=0, R=3, W=2, U=0, E=1) 2018/01/03 10:28:40 - LDAP input.0 - Disconnected from server 2018/01/03 10:28:40 - TransferLDAPInfo - Transformation detected one or more steps with errors. 2018/01/03 10:28:40 - LDAP input.0 - Finished processing (I=85, O=0, R=1, W=84, U=0, E=0) 2018/01/03 10:28:40 - TransferLDAPInfo - Transformation is killing the other steps! 2018/01/03 10:28:40 - Stream lookup[For UserRole].0 - Finished processing (I=0, O=0, R=2, W=0, U=0, E=0) 2018/01/03 10:28:40 - TransferLDAPInfo - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Errors detected! 2018/01/03 10:28:40 - Sort.0 - Finished processing (I=0, O=0, R=2, W=0, U=0, E=0) 2018/01/03 10:28:40 - Stream lookup[For Profile].0 - Finished processing (I=0, O=0, R=19, W=0, U=0, E=0) 2018/01/03 10:28:40 - Stream lookup[For Account].0 - Finished processing (I=0, O=0, R=20, W=0, U=0, E=0) 2018/01/03 10:28:41 - TransferLDAPInfo - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Errors detected! Thanks

        • 1. Re: Remedyforce LDAP Integration in Pentaho
          Jennifer Schertz

          Hi Mark,

          It seems your first unexpected error occured with the "Dynamic account and profile assignment."  Suggest you submit a case to BMC Support Central to troubleshoot further.

          • 2. Re: Remedyforce LDAP Integration in Pentaho
            Mark Hodge

            Hi Jennifer,

             

            I do have a case opened. Case 00453933. They are reviewing the files. I have not heard back in a couple of days.

             

            Thanks,

            Mark

             

            From: Jennifer Schertz <forums@developer.bmc.com>

            Reply: jive-440805289-2d1b-2-fxip@bmc-sdn-v8.hosted.jivesoftware.com <jive-440805289-2d1b-2-fxip@bmc-sdn-v8.hosted.jivesoftware.com>

            Date: January 4, 2018 at 11:50:04 AM

            To: Mark Hodge <mark.hodge@nimbus-now.com>

            Subject:  Re:  - Remedyforce LDAP Integration in Pentaho 

             

            BMC Communities

             

            Remedyforce LDAP Integration in Pentaho

            reply from Jennifer Schertz in Remedyforce - View the full discussion

             

            Hi Mark,

             

            It seems your first unexpected error occured with the "Dynamic account and profile assignment."  Suggest you submit a case to BMC Support Central to troubleshoot further.

             

            Reply to this message by replying to this email, or go to the message on BMC Communities

            Start a new discussion in Remedyforce by email or at BMC Communities

            Following Remedyforce LDAP Integration in Pentaho in these streams: Inbox

            This email was sent by BMC Communities because you are a registered user.

            You may unsubscribe instantly from BMC Communities, or adjust email frequency in your email preferences

             

            Thanks,

             

            Mark Hodge

            Solution Architect

             

             

             

            601 Cleveland St., Suite 501, Clearwater, Florida  33755 U.S.A.

            Mobile: 727-251-4167  @NimbusNow  |  www.nimbus-now.com

             

            This electronic message transmission, including all attachments, is for the addressee only. 

            It should be presumed to contain proprietary, confidential and/or privileged information.  

            If you believe you have received this message in error, you should delete it and notify the 

            sender immediately by reply e-mail.Thank you.