Question

6
Replies
1259
Views
DPSSingh Member since 2009 53 posts
JPMC
Posted: January 21, 2016
Last activity: February 16, 2016
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)

 

        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)

 

Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn