Ganesh_Damisetty Member since 2012 4 posts
Posted: 4 years ago
Last activity: 4 years 8 months ago

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"



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



**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.

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