Question

1
Replies
54
Views
Sreenivas Kakuru Member since 2016 6 posts
Capgemini
Posted: 3 years ago
Last activity: 3 years 4 months ago
Closed

Errors thrown while applying SI Payments 7.11 changes manually

Hi All,

We are facing Issue while importing the SI Payment 7.11 Jar file Error message as " The above SQL Statements contain a change to a column type.
Automatic maintenance does not apply Column Type changes
."

Then We Selected Manual option and generated DDL's, Below query are failed due to constraint violation While executing the DDL changes in manually

Issues 1:Added not null condition

ALTER TABLE Schema.WORKACTIONS MODIFY "RECDATE" VARCHAR2 (35) NOT NULL;

ALTER TABLE Schema.WORKACTIONS ADD CONSTRAINT WORKACTIONS_PK PRIMARY KEY ("RECDATE");

Isuue2:Changes the column size and data type

ALTER TABLE Schema.WORKACTIONS MODIFY "PZINSKEY" VARCHAR2 (255);

ALTER TABLE Schema.INTERESTRATES ADD "ID" VARCHAR2 (20) NOT NULL;

ALTER TABLE Schema.INTERESTRATES ADD CONSTRAINT INTERESTRATES_PK PRIMARY KEY ("ID");

Issue3:Changed the data type from float to numeric

ALTER TABLE Schema.INTERESTRATES MODIFY "INTERESTRATE" NUMBER (5, 3);

Note: Thrown Error as :
ORA-01440: column to be modified must be empty to decrease precision or scale

Can you please some one help on this.

Also we need clarifications on below areas.

1) How do we handle alter tables query in Production environment, If will not get permission's on changing(alter)
production DB tables from client end.

2)How do we mange issue No-1(i.e Added not null condition out of 3 issues),due to column has NULL value,so that cannot alter to NOT NULL right ? can any one advice on this .

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