Hi ,
I am facing the following error when run KPI Scheduler:
org.quartz.JobExecutionException: org.quartz.JobExecutionException: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection [See nested exception: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection] [See nested exception: org.quartz.JobExecutionException: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection [See nested exception: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection]]
at it.eng.spagobi.kpi.job.ProcessKpiJob.computeKpis(ProcessKpiJob.java:672)
at it.eng.spagobi.kpi.job.ProcessKpiJob.computeKpis(ProcessKpiJob.java:395)
at it.eng.spagobi.kpi.job.ProcessKpiJob.computeKpis(ProcessKpiJob.java:376)
at it.eng.spagobi.kpi.job.ProcessKpiJob.internalExecute(ProcessKpiJob.java:372)
at it.eng.spagobi.tools.alert.job.AbstractSuspendableJob.execute(AbstractSuspendableJob.java:27)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: org.quartz.JobExecutionException: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection [See nested exception: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection]
at it.eng.spagobi.kpi.job.ProcessKpiJob.computeKpi(ProcessKpiJob.java:822)
at it.eng.spagobi.kpi.job.ProcessKpiJob.computeKpis(ProcessKpiJob.java:662)
... 6 more
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection
at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:97)
at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.loadData(ConfigurableDataSet.java:153)
at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.test(ConfigurableDataSet.java:241)
at it.eng.spagobi.kpi.job.ProcessKpiJob$AggregateMeasureQuery.executeQuery(ProcessKpiJob.java:292)
at it.eng.spagobi.kpi.job.ProcessKpiJob$AggregateMeasureQuery.execute(ProcessKpiJob.java:253)
at it.eng.spagobi.kpi.job.ProcessKpiJob.computeKpi(ProcessKpiJob.java:686)
... 7 more
Caused by: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Cannot get connection to datasource
at it.eng.spagobi.tools.datasource.bo.DataSource.getConnectionByUserProfile(DataSource.java:199)
at it.eng.spagobi.tools.datasource.bo.DataSource.getConnection(DataSource.java:186)
at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:95)
... 12 more
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (IO Error: Got minus one from a read call)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2327)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2056)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
at it.eng.spagobi.tools.datasource.DataSourceManager.getConnection(DataSourceManager.java:46)
at it.eng.spagobi.tools.datasource.bo.DataSource.getDirectConnection(DataSource.java:275)
at it.eng.spagobi.tools.datasource.bo.DataSource.getConnectionByUserProfile(DataSource.java:196)
... 14 more
Caused by: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:711)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:558)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:260)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2337)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2323)
... 19 more
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.Packet.receive(Packet.java:314)
at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:153)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
