1

I've a Python script for SPSS Modeler that will loop over all rows in a table, perform some basic data processing, and export each row of output into a database. I've included a simplified version of Python my script below.

Unfortunately, I get the following error on the line pipeline_DB.run(results):

Error: AEQMJ0100E: Script error (Server exception: java.lang.IllegalArgumentException) on line 75 column

In the SPSS Legacy version of this script, I've set the database write mode to append. I have difficulty doing the same via Python.

SPSS Modeler Legacy Script

execute 'Pipeline DB table'
set 'Pipeline DB table'.delete_existing_rows = "False"

Python Script

results = []

for i in range(job_rows):
    jobid = job_rowset.getValueAt(i, 0); 

    # set the parameter values and caption of the graph, and the output name
    diagram.setParameterValue ('JOBID_Param', jobid)

    # run the database export node node
    pipeline_DB.run(results)
ad absurdum
  • 19,498
  • 5
  • 37
  • 60
Eugene Yan
  • 841
  • 2
  • 9
  • 23

0 Answers0