AnsweredAssumed Answered

Job assignment error!

Question asked by helenchu on Apr 11, 2017
Latest reply on Nov 30, 2018 by MBroadbent-esristaff


When creating new job assignment I run to error "Underlying DBMS error [Microsoft][ODBC Driver 11 for SQL Server][SQL Server] Cannot insert the NULL into column'OBJECTID', table 'mytablename'; column does not allow nulls.  INSERT fails.


Note that this table is in different database, not in the workflow database that used for Data Workspaces.  This table has nothing to do with this workflow.  In the past, new job created is written to the system tables in (workflow) database only.  I do not recall I did any modifications to my WF since the last time it was working fine.  All of the sudden, I got this error.  

My job assignment work flow is very simple, just JTXDesktopSteps.DefineAOI-> JTXSteps.CreateJob (arguments: jobtypeid/jobtypename/assigngroup/assignuser)

Has anyone had this issue before ?  

I spent the whole day hunting down where it could go wrong but couldn't come up with anything.