Connecting Pega to external database (DB2)
I have encountered multiple errors
1) User ID: (unknown)
Last SQL: select pzPVStream from rules.pr4_base where pxObjClass = 'Data-Admin-DB-Name'
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=RULES.PR4_BASE, DRIVER=4.24.92
2) 26-Jun-2018 09:52:20.631 SEVERE [http-nio-8080-exec-2] com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega. Problem during method invocation (doPost)
java.lang.ExceptionInInitializerError
at com.pega.pegarules.session.internal.PRSessionProviderImpl.getSimpleURLService(PRSessionProviderImpl.java:2601)
at com.pega.pegarules.web.impl.WebStandardImpl.isHttpSimpleURL(WebStandardImpl.java:1521)
at com.pega.pegarules.web.impl.WebStandardImpl.runStaticContentRequest(WebStandardImpl.java:1502)
at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:369)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)....
Do i need to configure the prbootstrap.properties file?
I have only configure the prconfig.xml file.
Please refer to the attached log file and prconfig file for more informations.
Pegasystems Inc.
IN
Hi,
The erro code
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=RULES.PR4_BASE, DRIVER=4.24.92
at com.ibm.db2.jcc.am.b6.a(b6.java:810) ~[db2jcc4.jar:?]
at com.ibm.db2.jcc.am.b6.a(b6.java:66) ~[db2jcc4.jar:?]
Possible Reason:
"SQLCODE=-204, SQLSTATE=42704" is a DB2 error code indicating 'object does not exist'; in this case, it is indicating that either the USER_TABLES object is not present, or that the <UserID> user does not have access to read this.
Hi,
The erro code
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=RULES.PR4_BASE, DRIVER=4.24.92
at com.ibm.db2.jcc.am.b6.a(b6.java:810) ~[db2jcc4.jar:?]
at com.ibm.db2.jcc.am.b6.a(b6.java:66) ~[db2jcc4.jar:?]
Possible Reason:
"SQLCODE=-204, SQLSTATE=42704" is a DB2 error code indicating 'object does not exist'; in this case, it is indicating that either the USER_TABLES object is not present, or that the <UserID> user does not have access to read this.
- USER_TABLES is an Oracle compatibility feature. Therefore the "SQLCODE=-204, SQLSTATE=42704" error (referencing USER_TABLES) typically implies that Oracle Compatibility was not switched on when the Controller Tablespace was created.
Can you refer below link and see if it fix the issue or not
http://www-01.ibm.com/support/docview.wss?uid=swg21613531
CPF Board
SG
I have done step1 to step8. Do i need to do the following step?
9. Delete the old (bad) Controller application repository database (the one that failed earlier)
10. Create a new DB2 database, to be your Controller application repository database'
which means reinstall my DB2 database?
Please assist....
CPF Board
SG
I have done step1 to step8. Do i need to do the following step?
9. Delete the old (bad) Controller application repository database (the one that failed earlier)
10. Create a new DB2 database, to be your Controller application repository database'
which means reinstall my DB2 database?
Please assist....