Discussion

3
Replies
183
Views
PrakashKaragi Member since 2011 5 posts
PEGA
Posted: 4 years ago
Last activity: 3 years 1 month ago
Closed

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

  1. 00000 - "cannot enable (%s.%s) - 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

  1. 00000 - "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

  1. 00000 - "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

  1. 00000 - "column to be modified must be empty to decrease precision or scale"

*Cause:

*Action:

***Edited by moderator, Maryrita: removed proprietary company information***

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn