OpenSQLException in Production Portal

[Former Member]

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

[former_member198633 · Accepted solution]

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

[Former Member · Accepted solution]

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

[former_member198633 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Peter,

Thanks alot for your help.

We will follow the steps to resolve the null pointer exception and OpenSQLException we will discuss with basis team.

Regards,

Devi

[Former Member]

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.

[former_member198633]

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

[Former Member]

Hi Peter,

Is there any impact with the navigation when we click on role??

Thanks and Regards,

Devi

[former_member198633]

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

[Former Member]

Hi Peter,

Thanks for providing information in detail.

Regards,

Devi.

[Former Member]

Hi Peter,

As you mentioned wherever OBN is involved the users will experience the impact. Can I know what will be the impact.

Regards,

Devi