Discussion 4 Replies 218 Views × Close popover vamsi bollimeru (vamsib16) Incessant Technologies Pvt Ltd Incessant Technologies Pvt Ltd IN View Profile Send Message vamsib16 Member since 2015 2 posts Incessant Technologies Pvt Ltd Posted: July 6, 2015 Last activity: July 7, 2015 Posted: 6 Jul 2015 2:51 EDT Last activity: 7 Jul 2015 5:28 EDT Closed 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. System Administration Installation and Deployment Share × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion. Posted: 5 years ago Posted: 6 Jul 2015 7:44 EDT × Close popover Veera Gangababu Gollapalli (Gangababu) PEGA Principal Technical Solutions Engineer PEG IN View Profile Send Message Gangababu PEGA replied to vamsib16 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 Posted: 5 years ago Posted: 6 Jul 2015 8:06 EDT × Close popover Ravi Padwal (RaviP@incessant) NIIT Technologies Limited NIIT Technologies Limited AU View Profile Send Message RaviP@incessant NIIT Technologies Limited replied to vamsib16 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. Posted: 5 years ago Posted: 6 Jul 2015 10:33 EDT × Close popover Fawzi Karachi (karaf) PEGA VP of Cloud Engineering Pegasystems Inc. US View Profile Send Message karaf PEGA replied to vamsib16 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. Posted: 5 years ago Posted: 7 Jul 2015 5:28 EDT × Close popover vamsi bollimeru (vamsib16) Incessant Technologies Pvt Ltd Incessant Technologies Pvt Ltd IN View Profile Send Message vamsib16 Incessant Technologies Pvt Ltd replied to vamsib16 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.