Question

3
Replies
103
Views
AnimeshD6938 Member since 2015 32 posts
Accenture Services Pvt Ltd
Posted: June 24, 2016
Last activity: June 24, 2016
Closed

Pega 7.1.9 rulebase installation on DB2 failed

Hi,

I was trying to install PRPC7.1.9 rulebase on DB2 10.5. This is a fresh installation, not an upgrade. But while running the installation I got the below error. Please suggest.

java] 2016-06-24 05:28:55,069 (                          SQLLoader)    INFO - CREATE INDEX PRPCUSER.PR_DATA_TOKEN_IDX1

     [java] 2016-06-24 05:28:55,172 (                          SQLLoader) WARNING - Failed to execute SQL in file udb06660.sql

     [java]

     [java] com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-614, SQLSTATE=54008, SQLERRMC=PR_DATA_TOKEN_IDX1, DRIVER=4.8.86

     [java]  at com.ibm.db2.jcc.am.gd.a(gd.java:679)

     [java]  at com.ibm.db2.jcc.am.gd.a(gd.java:60)

     [java]  at com.ibm.db2.jcc.am.gd.a(gd.java:127)

     [java]  at com.ibm.db2.jcc.am.wm.c(wm.java:2510)

     [java]  at com.ibm.db2.jcc.am.wm.d(wm.java:2498)

     [java]  at com.ibm.db2.jcc.am.wm.b(wm.java:1918)

     [java]  at com.ibm.db2.jcc.t4.fb.h(fb.java:221)

     [java]  at com.ibm.db2.jcc.t4.fb.b(fb.java:47)

     [java]  at com.ibm.db2.jcc.t4.t.b(t.java:38)

     [java]  at com.ibm.db2.jcc.t4.ub.h(ub.java:114)

     [java]  at com.ibm.db2.jcc.am.wm.gb(wm.java:1913)

     [java]  at com.ibm.db2.jcc.am.wm.a(wm.java:3004)

     [java]  at com.ibm.db2.jcc.am.wm.e(wm.java:1016)

     [java]  at com.ibm.db2.jcc.am.wm.execute(wm.java:1000)

     [java]  at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:266)

     [java] 2016-06-24 05:28:55,188 (                          SQLLoader) WARNING - Statement: CREATE INDEX PRPCUSER.pr_data_token_idx1

     [java] ON PRPCUSER.pr_data_token

     [java] (

     [java]     pzClientID asc,

     [java]     pyUserIdentifier asc,

     [java]     pyScope asc,

     [java]     pyGrantType asc

     [java] )

     [java] Exception in thread "main" com.pega.pegarules.install.SQLLoader$SQLLoaderException:

     [java] ********************************************************************************

     [java]

     [java] Encountered a SQL Exception, clean schema before running again.

     [java]

     [java] ********************************************************************************

     [java]  at com.pega.pegarules.install.SQLLoader.fail(SQLLoader.java:359)

     [java]  at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:316)

I tried to run the sql what is there in "udb06660.sql" directly in DB2 and got the below error.

CREATE INDEX PRPCUSER.pr_data_token_idx1

ON PRPCUSER.pr_data_token

(

  pzClientID asc,

  pyUserIdentifier asc,

  pyScope asc,

  pyGrantType asc

)

The index or index extension "PR_DATA_TOKEN_IDX1" cannot be created or altered because the combined length of the specified columns is too long.. SQLCODE=-614, SQLSTATE=54008, DRIVER=3.68.61

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