Errors when trying to get a Database connection

[Former Member]

We resolved the JSP page not found issue and now the Iview seems to be able to access the JSP page . Now we are getting a Portal runtime error when we try to access the Iview :

An exception occurred while processing a request for :

iView : pcd:portal_content/HistPerf

Component Name : ProfitAnalysis.HistoricalPerformance

invalid arguments in call.

#1.5#0007E904947000400000027600000A680003ED6C4B216995#1105474302842#com.sap.portal.portal#sap.com/irj#com.sap.portal.portal#Administrator#271##LABTEST01_P66_4818350#Administrator#77dbe2d0640a11d9a50f0007e9049470#SAPEngine_Application_Thread[impl:3]_17##0#0#Error#1#/System/Server#Java###Exception ID:12:11_11/01/05_0008_4818350

[EXCEPTION]

#1#com.sapportals.portal.prt.component.PortalComponentException: Error in service call of Portal Component

Component : pcd:portal_content/HistPerf

Component class : jsp._sapportalsjsp_maxager

User : Administrator

at com.sapportals.portal.prt.core.PortalRequestManager.handlePortalComponentException(PortalRequestManager.java:969)

at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:343)

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:627)

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:232)

at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:522)

at java.security.AccessController.doPrivileged(Native Method)

at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:405)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:153)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:337)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:315)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:815)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:238)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

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:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:151)

Caused by: com.sapportals.portal.prt.component.PortalComponentException: Original exception:

at jsp._sapportalsjsp_maxager.doContent(_sapportalsjsp_maxager.java:250)

at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:209)

at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:114)

at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)

... 29 more

Caused by: java.sql.SQLException: invalid arguments in call

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)

at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:183)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.maxager.pct.profitanalysis.util.DatabaseUtilities.getConnection(DatabaseUtilities.java:103)

at com.maxager.pct.profitanalysis.util.DatabaseUtilities.getConnection(DatabaseUtilities.java:38)

at com.maxager.pct.profitanalysis.util.User.init(User.java:44)

at jsp._sapportalsjsp_maxager.doContent(_sapportalsjsp_maxager.java:108)

... 32 more

#

#1.5#0007E904947000400000027800000A680003ED6C4B217317#1105474302842#com.sap.portal.portal#sap.com/irj#com.sap.portal.portal#Administrator#271##LABTEST01_P66_4818350#Administrator#77dbe2d0640a11d9a50f0007e9049470#SAPEngine_Application_Thread[impl:3]_17##0#0#Info##Plain###UserAgentHook: component com.sap.portal.runtime.system.hooks.ErrorComponent supports (*, *, *) #

#1.5#0007E904947000400000027900000A680003ED6C4B217683#1105474302842#com.sap.portal.portal#sap.com/irj#com.sap.portal.portal#Administrator#271##LABTEST01_P66_4818350#Administrator#77dbe2d0640a11d9a50f0007e9049470#SAPEngine_Application_Thread[impl:3]_17##0#0#Info##Plain###------PRT AbstractPortalComponent: calling doContent for portal component: com.sap.portal.runtime.system.hooks.ErrorComponent#

Can anyone offer any help on this problem ?

Thanks

Ravi

[Former Member · Accepted solution]

Hi Ravi,

The problem could be because of a wrong JDBC url or user id or password. Check whether the entries are the correct one.

Check out "java.sql.SQLException: invalid arguments in call" in google.

Regards,