Discussion
Pegasystems Inc.
IN
Last activity: 6 Apr 2018 19:26 EDT
SIPayments.jar Failed to import because of errors thrown while applying SI Payments 7 changes manually
Issue while importing the SI Payment 7 Jar file
PRPC62 Sp1/Oracle >> Pega 719 and SI payments
SQL Script error Log:
SQL Statement |
Errors |
ALTER TABLE DATA.WORKACTIONS MODIFY RecDate VARCHAR2 (35) NOT NULL |
SQL Error: ORA-02296: cannot enable (DATA.) - null values found
*Cause: an alter table enable constraint failed because the table contains values that do not satisfy the constraint. *Action: Obvious |
ALTER TABLE DATA.WORKACTIONS ADD CONSTRAINT WORKACTIONS_PK PRIMARY KEY (RecDate) |
SQL Error: ORA-01449: column contains NULL values; cannot alter to NOT NULL
*Cause: *Action: |
ALTER TABLE DATA.WORKACTIONS MODIFY pzInsKey VARCHAR2 (255) |
SQL Error: ORA-01439: column to be modified must be empty to change datatype
*Cause: *Action: |
ALTER TABLE DATA.INTERESTRATES MODIFY INTERESTRATE NUMBER (5, 3) |
SQL Error: ORA-01440: column to be modified must be empty to decrease precision or scale
*Cause: *Action: |
***Edited by moderator, Maryrita: removed proprietary company information***