1. Home
  2. Support
Article - CS388952

MEO Calculation is failing with error message "unable to translate sqlexception with error code '1652', will now try the fallback translator" in Servigistics Service Parts Management (SPM)

Modified: 30-May-2024   


Applies To

  • Servigistics Service Parts Management 13.0.0.0
  • SQLException with Error code '1652' related to IPCS_TEMP tablespace Issue

Description

  • MEO Calculation fails with error:
    • Unable to translate SQLException with Error code '1652', will now try the fallback translator
  • Autopilot log contains:
    • DEBUG com.svg.core.database.exception.CustomSQLExceptionTranslator - Unable to translate SQLException with Error code '1652', will now try the fallback translator
      2023-03-10 02:26:30,559[pool-18-thread-1] ERROR com.svg.core.database.BasicDataSource - There are still open resources on the pooled connection but is being closed by caller: /n    at com.svg.core.database.BasicDataSource$PooledConnection.invoke(BasicDataSource.java:299)
          at com.sun.proxy.$Proxy173.close(Unknown Source)
          at com.svg.core.database.Connection.closeConnection(Connection.java:178)
          at com.svg.core.database.Connection.close(Connection.java:169)
          at com.svg.planning.process.meo.dao.sql.MeoSkuInputSqlCache$PartBatchLoader.call(MeoSkuInputSqlCache.java:346)
          at java.util.concurrent.FutureTask.run(FutureTask.java:266)
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
          at java.util.concurrent.FutureTask.run(FutureTask.java:266)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
          at java.lang.Thread.run(Thread.java:750)
      /nAll resources should have been closed prior to closing the connection.
      2023-03-10 02:26:30,559[pool-18-thread-1] ERROR com.svg.core.database.BasicDataSource - Closing -> oracle.jdbc.driver.OraclePreparedStatementWrapper@1612016c  at com.svg.planning.process.meo.dao.sql.MeoSkuInputSqlCache$AsynchronousQueryExecuter.call(MeoSkuInputSqlCache.java:127)
      2023-03-10 02:26:30,559[pool-18-thread-1] ERROR com.svg.core.util.Closeable - Closed Connection
      java.sql.SQLRecoverableException: Closed Connection
This is a printer-friendly version of Article 388952 and may be out of date. For the latest version click CS388952