Article - CS291757

Error" java.sql.SQLIntegrityConstraintViolationException" while running stock level job on pasing -baseDate variable while executing runAPC.bat in Servigistics Service Parts Management

Modified: 08-Oct-2018   


Applies To

  • Servigistics Service Parts Management 11.4.0.1

Description

  • Error "java.sql.SQLIntegrityConstraintViolationException" while running stock level job on pasing -baseDate variable while executing runAPC.bat
  • Autopilot.log contains 
    • Error :
      2018-08-22 12:03:43,750[main] INFO com.svg.core.spring.HttpClientFactoryBean - Proxy information is not provided or incomplete , HttpClient will be used without proxy.
      org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into IPCS_TASK_CRITERIA (TaskID, CriteriaIndex, CriteriaData) values (391218, ?, ?)]; ORA-01400: cannot insert NULL into ("TRANESB"."IPCS_TASK_CRITERIA"."CRITERIADATA")
      ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("TRANESB"."IPCS_TASK_CRITERIA".
This is a printer-friendly version of Article 291757 and may be out of date. For the latest version click CS291757