Discussion
Pegasystems Inc.
IN
Last activity: 6 Apr 2018 19:26 EDT
SQL Script syntax errors in DDL for Page 7 SI Payments framework Upgrade in SI Payments 7 Build
seeing Syntax errors while running DDL script file shipped with Pega 7 SI for Payments build
Error starting at line 1 in command:
alter table INTERTESTRATES Add column ID VARCHAR(20)
Error report:
SQL Error: ORA-00904: : invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error starting at line 1 in command:
Update INTERTESTRATES set ID = Row_Number() Over()
Error at Command Line:1 Column:31
Error report:
SQL Error: ORA-30483: window functions are not allowed here
30483. 00000 - "window functions are not allowed here"
*Cause: Window functions are allowed only in the SELECT list of a query.
And, window function cannot be an argument to another window or group
function.
*Action:
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
IN
Fix all syntax errors in the DDL script file and apply relevant updated statements without syntax errors. This should solve the issue
ALTER TABLE INTERESTRATES ADD ID VARCHAR(20);
UPDATE INTERESTRATES SET ID= ROWNUM;
ALTER TABLE INTERESTRATES ADD CONSTRAINT INTERESTRATES_PK PRIMARY KEY (ID);
ALTER TABLE INTERESTRATES MODIFY ID VARCHAR(20) NOT NULL ;
ALTER TABLE PAYMENTTXN MODIFY FEDIMAD VARCHAR(22);
ALTER TABLE WORKACTIONS MODIFY PZINSKEY NVARCHAR2(255);