Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OpenSQLException in Production Portal

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 Member
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question