Return
-
Title
Numeric Overflow when resolving execution plan in SQL PI for SQL Server -
Description
Numeric Overflow error thrown during resolving execution plan
ERROR [Resolver Manager_113 []] com.dell.dsgi.spi.common.utils.logger.LogUtils - OraclePlanBeansConsumer.java:84:com.dell.dsgi.spi.engine.oracle.olap.resolving.plan.OraclePlanBeansConsumer.consume(): Error during parsing of Resolving Plan Query result set, keys: [{Plan identifiers: plan hash [2801240189], sql ID [aq4xpcta2kbwc], Submission time [1718966040000]}, {Plan identifiers: plan hash [2995648404], sql ID [aucscf9p39wzs], Submission time [1718966040000]}, {Plan identifiers: plan hash [733948485], sql ID [2j5h3sh6x0a47], Submission time [1718966040000]}, {Plan identifiers: plan hash [2030816892], sql ID [fj1968mtbb2h2], Submission time [1718965980000]}, {Plan identifiers: plan hash [2622571781], sql ID [1xwh342ctp7cj], Submission time [1718965980000]}, {Plan identifiers: plan hash [3908817288], sql ID [2qsw9hgsyh79f], Submission time [1718965980000]}, {Plan identifiers: plan hash [5221835], sql ID [89azv7aqy51bf], Submission time [1718965980000]}, {Plan identifiers: plan hash [998545158], sql ID [gk7gdv89x49v2], Submission time [1718966040000]}, {Plan identifiers: plan hash [4207610396], sql ID [6j12hmnmqzu1h], Submission time [1718965980000]}, {Plan identifiers: plan hash [1272211380], sql ID [2a8ry4uujbxsf], Submission time [1718966040000]}] java.sql.SQLException: Numeric Overflow -
Resolution
WORKAROUND
Contact Support for hotfix HFIX-487 for this issue.
STATUS
This issue has been logged as defect FOG-9471 and will be fixed in an upcoming release of the SQL Server cartridge.
-
Defect ID
FOG-9471