Question

5
Replies
748
Views
GAVINHSU Member since 2011 19 posts
Mediatek Inc. China
Posted: 4 years ago
Last activity: 4 years 10 months ago
Closed

DB2 SQL Error: SQLState 42884, Error code -440 after upgraded to 7 (split schemas)

Brief Description
DB2 SQL Error: SQLState 42884, Error code -440 after upgraded to 7
Detailed Description
We have upgraded our PRPC from 6.1 SP2 to 7.1.8 with split schemas.
The server can be started successfully when we using PegaRULES as both rule and data sources in prconfig.
But when we try to use PegaDATA as data source of data in prconfig, we've got "DB2 SQL Error: SQLCODE=-1477, SQLSTATE=55019" when server started.
Steps to Reproduce
Config prconfig.xml as below, start the server and errors come out.<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaDATA"/>
Error Message
2015-11-06 09:00:59,069 [aRULES LicenseDaemon] [ STANDARD] [ ] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 4 for database "pegadata" to the pool as it previously encountered the following error
User ID:
Last SQL: {call DB2BPMD.sppr_aggregate_usage ()}
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=MIDNIGHT_SECONDS;FUNCTION, DRIVER=3.61.75
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.gn.b(gn.java:2239)
at com.ibm.db2.jcc.am.gn.c(gn.java:2222)
at com.ibm.db2.jcc.t4.cb.k(cb.java:369)
at com.ibm.db2.jcc.t4.cb.e(cb.java:97)
at com.ibm.db2.jcc.t4.q.e(q.java:81)
at com.ibm.db2.jcc.t4.rb.k(rb.java:160)
at com.ibm.db2.jcc.am.gn.jb(gn.java:2188)
at com.ibm.db2.jcc.am.hn.b(hn.java:3917)
at com.ibm.db2.jcc.am.in.gc(in.java:113)
at com.ibm.db2.jcc.am.in.execute(in.java:96)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:105)
at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:581)
at com.pega.pegarules.data.internal.access.SQLGenerator.callStoredProc(SQLGenerator.java:3276)
at com.pega.pegarules.data.internal.access.DatabaseImpl.callStoredProc(DatabaseImpl.java:10165)
at com.pega.pegarules.data.internal.access.DatabaseImpl.callAggregateUsageSP(DatabaseImpl.java:10230)
at com.pega.pegarules.monitor.internal.license.LicenseDaemonImpl.callUsageAggregationStoredProcedure(LicenseDaemonImpl.java:351)
at com.pega.pegarules.monitor.internal.license.LicenseDaemonImpl.run(LicenseDaemonImpl.java:313)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:828)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:795)
at com.pega.pegarules.monitor.internal.license.LicenseDaemonImpl.takeSnapshot(LicenseDaemonImpl.java:271)
at com.pega.pegarules.monitor.internal.license.LicenseDaemonImpl.run(LicenseDaemonImpl.java:228)
at java.lang.Thread.run(Thread.java:744)
2015-11-06 09:00:59,070 [aRULES LicenseDaemon] [ STANDARD] [ ] [ ] (rnal.license.LicenseDaemonImpl) ERROR - problem while running the procedure in License Daemon:com.pega.pegarules.pub.database.DatabaseException: Database-General Problem encountered executing a stored procedure -440 42884 DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=MIDNIGHT_SECONDS;FUNCTION, DRIVER=3.61.75
From: (B1B310D70712C1C2B34456F745A746A59:(License Daemon))
SQL: {call DB2BPMD.sppr_aggregate_usage ()}
SQL Inserts:Caused by SQL Problems.
Problem #1, SQLState 42884, Error code -440: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=MIDNIGHT_SECONDS;FUNCTION, DRIVER=3.61.75
Properties of PegaDATA datasource:
user=db2bpmd
progressiveLocators=2
currentFunctionPath=SYSIBM,SYSFUNC,DB2BPMD
fullyMaterializeInputStreams=true
useJDBC4ColumnNameAndLabelSemantics=2
progressiveStreaming=2
databaseName=BPMD2
driverType=4
fullyMaterializeLobData=true
Low-Code App Development Installation and Deployment Low-Code App Development Upgrades Data Integration
Moderation Team has archived post
Share this page LinkedIn