Question

5
Replies
1360
Views
Close popover
Bin Xu (GAVINHSU)
Mediatek Inc. China

Mediatek Inc. China
CN
GAVINHSU Member since 2011 24 posts
Mediatek Inc. China
Posted: November 10, 2015
Last activity: November 12, 2015
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
System Administration Installation and Deployment Upgrades Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.