Question

6
Replies
1344
Views
Dhirendra Pal Singh (DPSSingh)
JPMC

JPMC
US
DPSSingh Member since 2009 53 posts
JPMC
Posted: January 21, 2016
Last activity: February 16, 2016
Posted: 21 Jan 2016 16:43 EST
Last activity: 16 Feb 2016 15:32 EST
Closed
Solved

Getting ORA-00904: invalid identifier error while running generateddl.sh

Hi All - Can you guys please help me resolve the error which I am getting this while executing the below command for 7.1.9: (FYI--same settings in setupDatabase properties file worked well for older 7.1.4 system but we used only basic command :- generateddl.sh --action upgrade without any dbSchema parameters)

 

>generateddl.sh --action upgrade --dbSchema MY_PEGA_RULES --dbDataSchema MY_PEGA_DATA --outputDirectory /xxx/bbb..

 

Below is the exception details

 

com.pega.pegarules.data.ddl.SchemaGenerator main

SEVERE: Error generating ddl for oracledate, MY_PEGA_RULES

 

ORA-00904: : invalid identifier

 

java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

 

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

 

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

 

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

 

Show More

Hi All - Can you guys please help me resolve the error which I am getting this while executing the below command for 7.1.9: (FYI--same settings in setupDatabase properties file worked well for older 7.1.4 system but we used only basic command :- generateddl.sh --action upgrade without any dbSchema parameters)

 

>generateddl.sh --action upgrade --dbSchema MY_PEGA_RULES --dbDataSchema MY_PEGA_DATA --outputDirectory /xxx/bbb..

 

Below is the exception details

 

com.pega.pegarules.data.ddl.SchemaGenerator main

SEVERE: Error generating ddl for oracledate, MY_PEGA_RULES

 

ORA-00904: : invalid identifier

 

java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

 

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

 

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

 

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

 

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

 

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

 

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

 

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

 

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)

 

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)

 

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)

 

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)

 

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)

 

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)

 

        at com.pega.pegarules.data.ddl.SchemaManager.readObjectBodies(Unknown Source)

 

        at com.pega.pegarules.data.ddl.SchemaManager.readViews(Unknown Source)

 

        at com.pega.pegarules.data.ddl.SchemaManager.<init>(Unknown Source)

 

        at com.pega.pegarules.data.ddl.SchemaManager.<init>(Unknown Source)

 

        at com.pega.pegarules.data.ddl.SchemaGenerator.saveCurrentSchemaState(SchemaGenerator.java:547)

 

        at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1638)

 

Show Less
System Administration Installation and Deployment
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.