Pega 7.1.7 Installation Failure
Hi ,
Trying to install Pega 7.1.7 using JBOSS EAP 6.3 Application Server & DB2 LUW
During Pega installation getting the below error .
====================================================
[java] Jul 06, 2015 10:48:40 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Failed to execute SQL in file udb_udf07300.sql
[java] Jul 06, 2015 10:48:40 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Statement: CREATE FUNCTION PEGARULES.pr_read_from_stream
[java] (property varchar(255), insKey varchar(512), stream blob(5m))
[java] returns varchar(1000)
[java] language java
[java] parameter style java
[java] no sql
[java] fenced threadsafe
[java] deterministic
[java] no external action
[java] external name
[java] 'PEGARULES.PRREADSTREAM:com.pega.pegarules.data.udf.directstreamreader.DirectStreamReaderDB2LUW.get'
[java] com.ibm.db2.jcc.am.mo: DB2 SQL Error: SQLCODE=-454, SQLSTATE=42723, SQLERRMC=PEGARULES.PR_READ_FROM_STREAM, DRIVER=4.7.85
=================================================================
Tried with dropping and recreating of schema , but getting the same issue.
PEG
IN
What are the db priviliges the db user has?
Is it single/split schema configuration?
Please refer below PDN link for db priviliges and installation guidelines.
https://pdn.pega.com/documents/pega-717-installation-guide-for-jboss-red-hat-eap-on-db2-luw
NIIT Technologies Limited
AU
Looks like it is failed while instaling UDFs.
So please also check if there is any specific database configuration required for installing UDFs on DB2 LUW.
Pegasystems Inc.
US
A SQLCODE=-454 error indicates that the function already exists. Please see DB2 documentation here: https://www-304.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.codes/src/tpc/n454.dita
It looks like the schema was not fully clean prior to running the installation script. Try running $distribution\schema\generated\udb\install\drop_udf_udb.sql first before running the ddl.
Incessant Technologies Pvt Ltd
IN
Thanks Karaf , will try with running the "$distribution\schema\generated\udb\install\drop_udf_udb.sql " and let you know the update on the same.