Hello,
On one ( SLES 10 SP1 32 bits Lotus Connections 2.0.1 Fresh install )of our Lotus Connections setups we encounter the
following error with activities when we try to open the Activities page.
invoke0 CLFRA0091E: internal error
com.ibm.openactivities.exception.OpenActivitiesException: Error adding profile: login names = [marco ensing, marco.ensing@e-office.com] may possibly match an existing database record
at com.ibm.openactivities.internal.service.core.MemberProfileBo._daoInsertWrapper(MemberProfileBo.java:963)
Below is our SystemOut.log and snap of our trace.log ( trace state is *=info:com.ibm.openactivities.*=finest:com.ibm.ws.rsadapter.*=finest:com.ibatis.common.*=finest:com.ibatis.sqlmap.*=finest. )
Things that I tried to fix, but didn't help
- Recreate the OPNACT db2 database
- Reinstall Activities
- Run rebind scripts for the OPNACT db2 database.
Found this forum post at the Connections forum
http://www-10.lotus.com/ldd/lcforum.nsf/PlatformAllThreadedweb/ef5d16dcd485c369852573bb0083a350?OpenDocument
It shows similair error messages, but he was facing the error with Communities part and it's an 1.0 version of Connections.
Nonetheless I tried a some things with the answer given in this post.
We also have a Lotus Connections 2.0.0.1 setup configured to use the same user repository. On this setup Activities is working fine.
I compared the both wimconfig.xml files with each other ( diff ) but I couldn't find any differences, also tried to compare the directory.services.xml but
this file has changed in the 2.0.1 setup so this was no posibility.
Anybody who can help me with this one?
Kind regards,
Marco Ensing
SystemOut.log
____________________________________________________________________________________________________________________
[11/12/08 17:25:57:262 CET] 0000002f OpenActivitie E sun.reflect.NativeMethodAccessorImpl invoke0 CLFRA0091E: internal error
com.ibm.openactivities.exception.OpenActivitiesException: Error adding profile: login names = [marco ensing, marco.ensing@e-office.com] may possibly match an existing database record
at com.ibm.openactivities.internal.service.core.MemberProfileBo._daoInsertWrapper(MemberProfileBo.java:963)
at com.ibm.openactivities.internal.service.core.MemberProfileBo.openByLoginName(MemberProfileBo.java:285)
at com.ibm.openactivities.internal.service.core.MemberProfileBo.openByLoginName(MemberProfileBo.java:233)
at com.ibm.openactivities.internal.service.OpenActivitiesServiceImpl$39.retWorker(OpenActivitiesServiceImpl.java:1962)
at com.ibm.openactivities.internal.service.OpenActivitiesServiceImpl$39.retWorker(OpenActivitiesServiceImpl.java:1960)
at com.ibm.openactivities.internal.service.OpenActivitiesServiceImpl$RetServiceMethod.worker(OpenActivitiesServiceImpl.java:177)
at com.ibm.openactivities.internal.service.OpenActivitiesServiceImpl$ServiceMethod.dowork(OpenActivitiesServiceImpl.java:146)
at com.ibm.openactivities.internal.service.OpenActivitiesServiceImpl$RetServiceMethod.returnValue(OpenActivitiesServiceImpl.java:181)
at com.ibm.openactivities.internal.service.OpenActivitiesServiceImpl.getMemberProfileByLoginName(OpenActivitiesServiceImpl.java:1957)
at com.ibm.openactivities.security.auth.subject.SubjectBuilder.buildSubject(SubjectBuilder.java:255)
at com.ibm.openactivities.security.auth.subject.SubjectBuilder.buildSubject(SubjectBuilder.java:151)
at com.ibm.openactivities.web.coreui.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.openactivities.auth.basic.ClientAuthenticationFilter.doFilter(ClientAuthenticationFilter.java:316)
at com.ibm.openactivities.auth.basic.ClientAuthenticationFilter.doFilter(ClientAuthenticationFilter.java:134)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.lconn.core.web.auth.LCBasicAuthFilter.doFilter(LCBasicAuthFilter.java:79)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.lconn.core.web.auth.LCUserDataConstraintFilter.doFilter(LCUserDataConstraintFilter.java:80)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
==SNAP==
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
Caused by: com.ibatis.dao.client.DaoException: Error inserting MemberProfile: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/ibm/openactivities/internal/service/store/sqlmapdao/sql/MemberProfile.xml.
--- The error occurred while applying a parameter map.
--- Check the MemberProfile.insertMemberProfile-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.c.SqlException: The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
at com.ibm.openactivities.internal.service.store.sqlmapdao.MemberProfileSqlMapDao.insert(MemberProfileSqlMapDao.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:64)
at $Proxy11.insert(Unknown Source)
at com.ibm.openactivities.internal.service.core.MemberProfileBo._daoInsertWrapper(MemberProfileBo.java:960)
... 68 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/ibm/openactivities/internal/service/store/sqlmapdao/sql/MemberProfile.xml.
--- The error occurred while applying a parameter map.
--- Check the MemberProfile.insertMemberProfile-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.c.SqlException: The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
==SNAP==
at com.ibm.openactivities.internal.service.store.sqlmapdao.MemberProfileSqlMapDao.insert(MemberProfileSqlMapDao.java:64)
... 75 more
Caused by: com.ibm.db2.jcc.c.SqlException: The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
at com.ibm.db2.jcc.c.kh.b(kh.java:1367)
at com.ibm.db2.jcc.c.kh.c(kh.java:1354)
at com.ibm.db2.jcc.b.db.k(db.java:352)
at com.ibm.db2.jcc.b.db.a(db.java:60)
at com.ibm.db2.jcc.b.t.a(t.java:52)
at com.ibm.db2.jcc.b.tb.b(tb.java:202)
at com.ibm.db2.jcc.c.lh.X(lh.java:1842)
at com.ibm.db2.jcc.c.lh.d(lh.java:2411)
at com.ibm.db2.jcc.c.lh.d(lh.java:2507)
at com.ibm.db2.jcc.c.lh.U(lh.java:1401)
at com.ibm.db2.jcc.c.lh.execute(lh.java:1385)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:735)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:503)
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)
... 80 more
TRAS0017I: The startup trace state is *=info:com.ibm.openactivities.*=finest:com.ibm.ws.rsadapter.*=finest:com.ibatis.common.*=finest:com.ibatis.sqlmap.*=finest.
trace.log
____________________________________________________________________________________________________________________
[11/13/08 13:39:26:227 CET] 00000032 WSRdbManagedC < enforceAutoCommit Exit
[11/13/08 13:39:26:227 CET] 00000032 WSRdbManagedC 3 No Matching Prepared Statement found in cache
[11/13/08 13:39:26:227 CET] 00000032 WSJccPrepared > <init> Entry
com.ibm.db2.jcc.c.lh@d9e0d9e
com.ibm.ws.rsadapter.jdbc.WSJccSQLJConnection@543c543c
CLOSE CURSORS AT COMMIT (2)
PSTMT: INSERT INTO ACTIVITIES.OA_MEMBERPROFILE ( EXID, MEMBERID, MEMBERDISP, EMAIL, MEMBERTYPE, LOCALE, CREATED, LASTLOGIN ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) 1003 1007 2 0 2
[11/13/08 13:39:26:227 CET] 00000032 WSJccPrepared 3 current fetchSize is 0
[11/13/08 13:39:26:227 CET] 00000032 WSJccPrepared < <init> Exit
com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement@f5e0f5e
[11/13/08 13:39:26:227 CET] 00000032 WSJdbcPrepare > setInternalHelper Entry
[11/13/08 13:39:26:227 CET] 00000032 WSJdbcPrepare < setInternalHelper Exit
[11/13/08 13:39:26:227 CET] 00000032 WSJdbcConnect < prepareStatement Exit
com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement@f5e0f5e
[11/13/08 13:39:26:227 CET] 00000032 WSJdbcPrepare 3 setString #1
[11/13/08 13:39:26:227 CET] 00000032 WSJdbcPrepare 3 setString #2
[11/13/08 13:39:26:227 CET] 00000032 WSJdbcPrepare 3 setString #3
[11/13/08 13:39:26:228 CET] 00000032 WSJdbcPrepare 3 setString #4
[11/13/08 13:39:26:228 CET] 00000032 WSJdbcPrepare 3 setInt #5
[11/13/08 13:39:26:228 CET] 00000032 WSJdbcPrepare 3 setNull #6
VARCHAR (12)
[11/13/08 13:39:26:228 CET] 00000032 WSJdbcPrepare 3 setTimestamp #7
[11/13/08 13:39:26:228 CET] 00000032 WSJdbcPrepare 3 setNull #8
TIMESTAMP (93)
[11/13/08 13:39:26:228 CET] 00000032 WSJdbcPrepare > execute Entry
com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement@f5e0f5e
[11/13/08 13:39:26:228 CET] 00000032 WSRdbManagedC 3 isEnlistmentDisabled() returning:
false
[11/13/08 13:39:26:228 CET] 00000032 WSJdbcConnect 3 Local Transaction is active.
[11/13/08 13:39:26:293 CET] 00000032 WSJdbcPrepare < execute Exit
SQLException
[11/13/08 13:39:26:317 CET] 00000032 WSJdbcUtil 3 mapException
SQL STATE: 22001
ERROR CODE: -302
com.ibm.db2.jcc.c.SqlException: The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
at com.ibm.db2.jcc.c.kh.b(kh.java:1367)
at com.ibm.db2.jcc.c.kh.c(kh.java:1354)
at com.ibm.db2.jcc.b.db.k(db.java:352)
Return to top
Print this page
