3 Replies Latest reply on Feb 13, 2017 10:38 PM by Francisco Amores

    BefExport script error

    1003344

      Hello,

       

      I am trying to run a Jython script that will change the CURKEY in the TDATASEG_T table using this script

      query = """UPDATE TDATASEG_T set CURKEY = 'QAR' """

      params = [ fdmContext["LOADID"] ]

      fdmAPI.executeDML(query, params, True)

      fdmAPI.commitTransaction()

       

      to export the data to the GL_INTERFACE as QAR not Local

       

      but when i execute the script the following error occurs

       

        File "/data/scripts/event/BefExportToDat.py", line 3, in <module>

          fdmAPI.executeDML(query, params, True)

      SQLException: java.sql.SQLException: Invalid column index

       

      Any Help??