Article - CS362067

The DownloadID for user imports is conflicting with the DownloadID for the overnight runs in Servigistics

Modified: 23-Oct-2024   


Applies To

  • Servigistics Service Parts Management 11.0 to 13.1.0.1
  • Servigistics Service Parts Pricing 13.0.0.0

Description

  • Unable to load data using UI Import feature
  • Unique Constraint error while importing File Template
    • org.springframework.dao.DuplicateKeyException:StatementCallback;SQL [insert into IPCSDD_DOWNLOAD_PROCESS (DownloadID,BeginDate,BeginTime,Status,PlannerID,PartMasterBT) values (xxx,'yyyymmdd',xxx,x,xxx,x)]; ORA-00001:unique constraint(xxx.PK_IPCSDD_d_xxx) violated;nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001:unique constraint (xxx.PK_IPCSDD_D_xxx) violated 
This is a printer-friendly version of Article 362067 and may be out of date. For the latest version click CS362067