on 09-29-2015 4:15 AM
Hi Experts,
We are facing below exception in Production portal default trace.
com.sap.sql.log.OpenSQLException#Cannot assign a java.lang.String object of length 290 to host variable 1 which has JDBC type VARCHAR(105).#com.sap.sql.log.OpenSQLException: Cannot assign a java.lang.String object of length 290 to host variable 1 which has JDBC type VARCHAR(105).
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)
at com.sap.sql.types.GenericResultColumn.checkLength(GenericResultColumn.java:213)
at com.sap.sql.types.VarcharResultColumn.setString(VarcharResultColumn.java:63)
at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:511)
at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:355)
at com.sapportals.portal.pcd.pl.ShortStringTable.select(ShortStringTable.java:111)
at com.sapportals.portal.pcd.pl.ShortStringConverter.shortToLong(ShortStringConverter.java:120)
at com.sapportals.portal.pcd.pl.PlFactory.convertShortNameToName(PlFactory.java:1155)
at com.sapportals.portal.pcd.gl.PcdObjectFactory.convertShortNameToUrl(PcdObjectFactory.java:176)
at com.sap.portal.unification.LocalScenarioHelper.fetchIPortalRole(LocalScenarioHelper.java:314)
at com.sap.portal.unification.LocalScenario.getDefaultTarget(LocalScenario.java:95)
at com.sap.portal.unification.ObjectBasedNavigation.getDefaultTarget(ObjectBasedNavigation.java:95)
at com.sap.portal.unification.ObjectBasedNavigation.getDefaultTarget(ObjectBasedNavigation.java:78)
at com.sap.portal.navigation.ObjBasedNavigation.resolveOBN(ObjBasedNavigation.java:326)
at com.sap.portal.navigation.ObjBasedNavigation.doContent(ObjBasedNavigation.java:530)
at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:207)
at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:112)
at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)
at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136)
at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189)
at com.sapportals.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:215)
at com.sapportals.portal.prt.pom.PortalNode.service(PortalNode.java:645)
at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)
at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136)
at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189)
at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:753)
at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:249)
at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:561)
at java.security.AccessController.doPrivileged(Native Method)
at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:434)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)
at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1064)
at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)
at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)
at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)
at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)
at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)
Kindly help us in resolving the above issue.
Thanks and Regards,
Devi
Dear Devi,
This exception usually indicates a bug, so a patch or an SP level upgrade is recommended.
This note is talking about an issue like this: 1382283 - Longer like match pattern causes unexpected exception.
But further investigation may be required to determine the root cause based on where you get the exception, what your release/version is and what else is in the defaultTrace.
Best Regards,
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Peter,
Thanks for the quick response.
We are using Portal 7.02 SP16, other than this we are also facing below exception in default trace.
java.lang.NullPointerException#
10E4F092#0ec89fd6567411e58c9f000010e4f092-0#0ec89fd6567411e58c9f000010e4f092#SAPEngine_Application_Thread[impl:3]_6##0#0#Error##Plain###
at java.lang.StringBuffer.<init>(StringBuffer.java:146)#
at com.sap.portal.pcm.admin.util.StringListTokenizer.<init>(AttributeValueList.java:117)#
at com.sap.portal.pcm.admin.util.AttributeValueList.<init>(AttributeValueList.java:41)#
at com.sap.portal.pcm.admin.util.AttributeValueList.stringToValueList(AttributeValueList.java:55)#
at com.sap.portal.unification.obntargetcreator.ParameterMappingHelper.getRelevantPersistedParametersForSpecificOperation(ParameterMappingHelper.java:414)#
at com.sap.portal.unification.obntargetcreator.ParameterMappingHelper.getRelevantPersistedParametersForSpecificOperation(ParameterMappingHelper.java:414)#
at com.sap.portal.unification.obntargetcreator.ParameterMappingHelper.loadPersistedParametersForOperation(ParameterMappingHelper.java:366)#
at com.sap.portal.unification.obntargetcreator.ParameterMappingAccess.loadParameterMappingData(ParameterMappingAccess.java:58)#
at com.sap.portal.navigation.mapping.OBNParametersMapping.getMappingDesignTimeData(OBNParametersMapping.java:297)#
at com.sap.portal.navigation.mapping.OBNParametersMapping.getMappedDynamicParameter(OBNParametersMapping.java:106)#
at com.sapportals.portal.appintegrator.template_processor.ModifierImpl.getOBNMappedParameters(ModifierImpl.java:305)#
at com.sapportals.portal.appintegrator.template_processor.ModifierImpl.getMappedParameters(ModifierImpl.java:297)#
at com.sapportals.portal.appintegrator.template_processor.TemplateProcessor.processModifier(TemplateProcessor.java:304)#
at com.sapportals.portal.appintegrator.template_processor.compiler.ProcessModifierAction.execute(ProcessModifierAction.java:16)#
at com.sapportals.portal.appintegrator.template_processor.compiler.ProcessTemplateAction.execute(ProcessTemplateAction.java:39)#
at com.sapportals.portal.appintegrator.template_processor.TemplateProcessor.processImpl(TemplateProcessor.java:416)#
at com.sapportals.portal.appintegrator.template_processor.TemplateProcessor.process(TemplateProcessor.java:390)#
at com.sapportals.portal.appintegrator.template_processor.TemplateProcessor.process(TemplateProcessor.java:402)#
at com.sapportals.portal.appintegrator.template_processor.TemplateProcessorService.processTemplate(TemplateProcessorService.java:54)#
at com.sapportals.portal.appintegrator.template_processor.TemplateProcessorService.processTemplate(TemplateProcessorService.java:107)#
at com.sapportals.portal.appintegrator.layer.AbstractIntegrationLayer.processTemplate(AbstractIntegrationLayer.java:464)#
at com.sapportals.portal.appintegrator.layer.URLTemplateProcessLayer.processLayer(URLTemplateProcessLayer.java:33)#
at com.sapportals.portal.appintegrator.LayerProcessor.processActionPass(LayerProcessor.java:161)#
at com.sapportals.portal.appintegrator.AbstractIntegratorComponent.doActionPass(AbstractIntegratorComponent.java:68)#
at com.sapportals.portal.appintegrator.AbstractIntegratorComponent.doOnPOMReady(AbstractIntegratorComponent.java:54)#
at com.sapportals.portal.prt.component.AbstractPortalComponent.handleEvent(AbstractPortalComponent.java:394)#
at com.sapportals.portal.prt.pom.ComponentNode.handleEvent(ComponentNode.java:249)#
at com.sapportals.portal.prt.pom.PortalNode.fireEventOnNode(PortalNode.java:368)#
at com.sapportals.portal.prt.pom.PortalNode.processEventQueue(PortalNode.java:799)#
at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:652)#
at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:249)#
at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:561)#
at java.security.AccessController.doPrivileged(Native Method)#
at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:434)#
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)#
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)#
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)#
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)#
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)#
at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1064)#
at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)#
at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)#
at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)#
at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)#
at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)#
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)#
at java.security.AccessController.doPrivileged(Native Method)#
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)#
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)#
Thanks and Regards,
Devi
Hello Devi,
For this exception please check out this note:
1556854 - EP: Error: NullPointerException using OBN Navigation
For the original issue, I would make sure the patch levels are up to date as well.
Best Regards,
Peter
Hi Peter,
I have some query on note 1556854 - EP: Error: NullPointerException using OBN Navigation.
If we implement the above note by setting the OBNParameterMapping Property from true to false.
Is there any business impact??
Thanks and Regards,
Devi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Devi,
The system will not need to be restarted, so there will be no major service impact. But as you can see the OBN service (Object Based Navigation) will need to be restarted. Whatever uses OBN will be affected by this.
Best Regards,
Peter
Hello Devi,
This is not specific enough. Wherever OBN is involved the users will experience the impact since the service will be restarted.
Regards,
Peter
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.