Troubleshooting
Problem
IBM Information Server thick and thin clients cannot be accessed due to errors in WAS logs:
[8/30/24 3:56:00:598 UTC] 00003a59 SandboxServic E Unexpected runtime error: Unhandled type 2011 for column 4
org.apache.ojb.broker.OJBRuntimeException: Unhandled type 2011 for column 4
at org.apache.ojb.broker.metadata.JdbcTypesHelper.getObjectFromColumn(JdbcTypesHelper.java:227)
at com.ibm.xmeta.persistence.query.OjbSqlExecuter.executeQuery(OjbSqlExecuter.java:96)
at com.ibm.xmeta.pm.query.sql.SqlQueryPlan.execute(SqlQueryPlan.java:107)
at com.ibm.xmeta.query.impl.engine.RemoveAddedColumns.execute(RemoveAddedColumns.java:43)
at com.ibm.xmeta.query.impl.engine.DataConversionPlan.execute(DataConversionPlan.java:61)
at com.ibm.xmeta.pm.query.sql.SqlQuery.getResultCollection(SqlQuery.java:203)
at com.ibm.xmeta.pm.query.sql.SqlQuery.execute(SqlQuery.java:233)
at com.ibm.xmeta.persistence.basic.BasicPersistence.executeQuery(BasicPersistence.java:5528)
at com.ibm.xmeta.repository.QueryHelper$LegacyQueryExecuter.execute(QueryHelper.java:75)
at com.ibm.xmeta.repository.QueryHelper.executeQuery(QueryHelper.java:180)
at com.ibm.xmeta.repository.QueryHelper.executeQuery(QueryHelper.java:141)
at com.ibm.xmeta.repository.AbstractSandbox.executeQuery(AbstractSandbox.java:105)
at com.ibm.xmeta.service.SandboxServiceSupport.executeQuery(SandboxServiceSupport.java:130)
at com.ibm.xmeta.binding.impl.EObjectSandboxBinding.executeQuery(EObjectSandboxBinding.java:149)
at com.ibm.xmeta.client.impl.DefaultSandboxClient.query(DefaultSandboxClient.java:1344)
at com.ibm.xmeta.client2.AbstractSandboxClient.executeValueQuery(AbstractSandboxClient.java:384)
at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at com.ibm.xmeta.client2.WrapperHandler.invoke(WrapperHandler.java:97)
at com.sun.proxy.$Proxy145.executeValueQuery(Unknown Source)
at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at com.ibm.xmeta.client2.WrapperHandler.invoke(WrapperHandler.java:97)
at com.sun.proxy.$Proxy145.executeValueQuery(Unknown Source)
at com.ibm.iis.common.event.impl.EventServiceImpl.executeCEValueQuery(EventServiceImpl.java:1031)
at com.ibm.iis.common.event.impl.EventServiceImpl.executeCEValueQuery(EventServiceImpl.java:1024)
at com.ibm.iis.common.event.impl.EventServiceImpl.getEventVOByRid(EventServiceImpl.java:3594)
at com.ibm.iis.common.event.impl.EventServiceImpl.processSingleSubscription(EventServiceImpl.java:1996)
at com.ibm.iis.common.event.impl.EventServiceImpl.processSubscriptions(EventServiceImpl.java:1961)
at com.ibm.iis.common.event.impl.EventServiceImpl.processInstantNotifications(EventServiceImpl.java:1892)
at com.ibm.iis.common.event.local.LocalEventService$24.run(LocalEventService.java:615)
at com.ibm.iis.isf.j2ee.impl.common.transaction.DefaultTransactionManagerImpl$WASUOWAction.run(DefaultTransactionManagerImpl.java:185)
at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderCurrentUOW(EmbeddableUOWManagerImpl.java:994)
at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:381)
at com.ibm.iis.isf.j2ee.impl.common.transaction.DefaultTransactionManagerImpl.runUnderTransaction(DefaultTransactionManagerImpl.java:71)
at com.ibm.iis.common.event.local.LocalEventService.processInstantNotifications(LocalEventService.java:612)
at com.ibm.iis.common.event.impl.EventHandlerTaskExecutionServiceImpl.runTask(EventHandlerTaskExecutionServiceImpl.java:87)
at com.ibm.iis.common.event.impl.local.LocalEventHandlerTaskExecutionService$1.run(LocalEventHandlerTaskExecutionService.java:39)
at com.ibm.iis.isf.j2ee.impl.common.transaction.DefaultTransactionManagerImpl$WASUOWAction.run(DefaultTransactionManagerImpl.java:185)
at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUOW(EmbeddableUOWManagerImpl.java:798)
at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableUOWManagerImpl.java:377)
at com.ibm.iis.isf.j2ee.impl.common.transaction.DefaultTransactionManagerImpl.runUnderTransaction(DefaultTransactionManagerImpl.java:71)
at com.ibm.iis.common.event.impl.local.LocalEventHandlerTaskExecutionService.runTask(LocalEventHandlerTaskExecutionService.java:36)
at com.ibm.iis.isf.scheduling.server.impl.quartz.ASBJob.executeImpl(ASBJob.java:458)
at com.ibm.iis.isf.scheduling.server.impl.quartz.ASBJob.execute(ASBJob.java:318)
at org.quartz.core.JobRunShell.run(JobRunShell.java:223)
at com.ibm.iis.isf.scheduling.server.impl.quartz.J2EEThreadPool$RunnableWrapper.run(J2EEThreadPool.java:261)
at com.ibm.iis.isf.j2ee.impl.was.thread.WASScheduledExecutorService$RunnableWorkAdapter.run(WASScheduledExecutorService.java:875)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:281)
at java.security.AccessController.doPrivileged(AccessController.java:690)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:747)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
This issue may be encountered in 11.7.1.1 SP2 or IS 11.7.1.3 and above.
Symptom
Users may report accessibility issues to IBM Datastage Designer/Director/Administrator clients.
The launchpad may open. But, none of the thin clients would work.
Look for above errors in the WAS logs.
Default log location:
For WAS ND, see SystemOut.log and SystemError.log under /opt/IBM/WebSphere/AppServer/profiles/<profileName>/logs/server1 directory.
For WebSphere Liberty, please see messages.log file located under /opt/IBM/InformationServer/wlp/usr/servers/iis/logs directory.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m500000008XILAA2","label":"Xmeta Repository Database"}],"ARM Case Number":"TS017058722","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.1"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
29 October 2025
UID
ibm17167072