Patricio M Dorantes Jamarne 16.Nov.10 05:39 PM a Web browser Communities2.5Linux
A little confused how a fresh lc 2.5 installation can have so many errors :S. I patched all that could be patched.... (LC fix pack, db2, etc). Any fix that i forgot?
This errors occur when I click "Request to join this community"
Thanks in advnace.
[11/16/10 10:19:17:723 CST] 0000038b CRUDiBatis E com.ibm.lotus.connections.dashboard.data.dao.impl.ibatis.CRUDiBatis insert CLFRQ0056E: An error occurred while inserting to table NT_NOTIFICATION using this primary key: 4df88d29xaddax4475x87e7xfd451a0e133f.
com.ibm.lotus.connections.dashboard.common.core.exceptions.data.DataAccessCreateException: CLFRQ0056E: An error occurred while inserting to table NT_NOTIFICATION using this primary key: 4df88d29xaddax4475x87e7xfd451a0e133f.
at com.ibm.lotus.connections.dashboard.data.dao.impl.ibatis.CRUDiBatis.insert(CRUDiBatis.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
at $Proxy236.insert(Unknown Source)
at com.ibm.lotus.connections.dashboard.service.notification.impl.NotificationService.addNotification(NotificationService.java:64)
at com.ibm.lotus.connections.dashboard.service.notification.impl.NotificationEventConsumer.forwardNotification(NotificationEventConsumer.java:93)
at com.ibm.lotus.connections.dashboard.service.notification.impl.NotificationEventConsumer.consumeEvent(NotificationEventConsumer.java:81)
at com.ibm.lconn.events.impl.EventRecordConsumerHandler.consumeEventRecord(EventRecordConsumerHandler.java:54)
at com.ibm.lconn.events.consumer.bean.EventRecordConsumerBean.onMessage(EventRecordConsumerBean.java:94)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1014)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy238.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:780)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:586)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibatis.dao.client.DaoException: Failed to insert - id [insert-NT_NOTIFICATION], parameterObject [com.ibm.lotus.connections.dashboard.data.model.Notification@18781878[
id=4df88d29xaddax4475x87e7xfd451a0e133f
source=communities
type=requestToJoin
senderExId=UID=MASTERADMIN,CN=USERS,O=SPS,DC=LOCALABS,DC=NET
notificationRecipients=[com.ibm.lotus.connections.dashboard.data.model.NotificationRecipient@1ab81ab8[
id=b4795129xfda1x41b3xaaa9x5b906ab4b049
notificationId=4df88d29xaddax4475x87e7xfd451a0e133f
recipientExId=UID=CARLOS_HUIDOBRO,CN=USERS,O=SPS,DC=LOCALABS,DC=NET
]]
subject=<null>
message=Mando otro request?
containerName=CEINMODA
containerURL=http://lotuscon25.olympus.sps.com.mx/communities/service/html/communityview?communityUuid=b1109b7f-11fc-486c-bf7b-803ad9d4cd5b
itemName=<null>
itemURL=<null>
dateTimeStamp=Tue Nov 16 10:19:17 CST 2010
]]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in resources/dashboard/NT_Notification.xml.
--- The error occurred while applying a parameter map.
--- Check the insert-NT_NOTIFICATION-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.a.in: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.52.95
at com.ibatis.dao.client.template.SqlMapDaoTemplate.insert(SqlMapDaoTemplate.java:103)
at com.ibm.lotus.connections.dashboard.data.dao.impl.ibatis.CRUDiBatis.insert(CRUDiBatis.java:147)
... 19 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in resources/dashboard/NT_Notification.xml.
--- The error occurred while applying a parameter map.
--- Check the insert-NT_NOTIFICATION-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.a.in: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.52.95
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:59)
at com.ibatis.dao.client.template.SqlMapDaoTemplate.insert(SqlMapDaoTemplate.java:101)
... 20 more
Caused by: com.ibm.db2.jcc.a.in: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.52.95
at com.ibm.db2.jcc.a.ad.a(ad.java:658)
at com.ibm.db2.jcc.a.ad.a(ad.java:60)
at com.ibm.db2.jcc.a.ad.a(ad.java:127)
at com.ibm.db2.jcc.a.rl.b(rl.java:2082)
at com.ibm.db2.jcc.a.rl.c(rl.java:2065)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.a.sl.Xb(sl.java:2420)
at com.ibm.db2.jcc.a.sl.e(sl.java:3262)
at com.ibm.db2.jcc.a.sl.e(sl.java:3393)
at com.ibm.db2.jcc.a.sl.Rb(sl.java:1881)
at com.ibm.db2.jcc.a.sl.execute(sl.java:1865)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:890)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:595)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 24 more
[11/16/10 10:19:17:729 CST] 0000038b NotificationS E com.ibm.lotus.connections.dashboard.service.notification.impl.NotificationService addNotification CLFRQ0314E: An error occurred while creating a notification with this information: CLFRQ0056E: An error occurred while inserting to table NT_NOTIFICATION using this primary key: 4df88d29xaddax4475x87e7xfd451a0e133f.
Return to top
Database errors when clicking Join ... (Patricio M Dora... 16.Nov.10)
. . 
Print this page
