Error when trying to save a CDT to DB

I am getting the following error when trying to save a CDT to DB:

There is a problem with task “Write to Request Detail” in the process “WMG GBL Save Request Details”. An error occurred while trying to write to the entity “WMG_GBL_FEE_SETUP” [id=566906b6-f383-47f2-97ed-7bd271f36013@164611, type=WMG_GBL_FEE_SETUP (id=1675)] (data store: PCS_DS). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIAN_WMG_BD.SYS_C0084174) violated Data: TypedValue[it=1675,v={266,417569,666666666,2016-08-11 21:05:56.08,badram01,2016-08-11 21:05:56.08,badram01,In Progress,999.0,999.0,999.0,999.0,Negotiated with client,No,999.0,999,999,2016-08-08,2016-08-19,Monthly,,2016-08-08,<null>,<null>,,,<null>,,,,,Fee Exception,,<null>,{}}]
Problem: An error occurred in executing an Activity Class.
Recommended Action: Examine the activity class to correct the error a...

OriginalPostID-228736

OriginalPostID-228736

  Discussion posts and replies are publicly visible

Parents
  • ...nd then resume.
    Priority of this problem: High Priority

    The CDT allows all fields to be Nillable except for the primary key.

    It also has two columns:
    <xsd:element name="insAllocationIncome_int" nillable="true" type="xsd:int" />
    <xsd:element maxOccurs="unbounded" minOccurs="0" name="methodOfChargingFee_txt" nillable="true" type="xsd:string" />

    Not sure if they are causing the problem.

    Have anyone encountered the same problem?
Reply
  • ...nd then resume.
    Priority of this problem: High Priority

    The CDT allows all fields to be Nillable except for the primary key.

    It also has two columns:
    <xsd:element name="insAllocationIncome_int" nillable="true" type="xsd:int" />
    <xsd:element maxOccurs="unbounded" minOccurs="0" name="methodOfChargingFee_txt" nillable="true" type="xsd:string" />

    Not sure if they are causing the problem.

    Have anyone encountered the same problem?
Children
No Data