Posted: 29 May 2017 10:12 EDT Last activity: 6 Apr 2018 19:26 EDT
Errors thrown while applying SI Payments 7.11 changes manually
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 .