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

    BefExport script error




      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)



      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??