Article - CS284574
Error "-1: 'NVL' is not a recognized built-in function name " while running reports on Servigistics Intellicus
Modified: 02-May-2018
Applies To
- Servigistics Service Parts Management 11.4
Description
- Error -1: 'NVL' is not a recognized built-in function name is seen on screen while running any default report
- Error message seen in ReportEngine.log file:
- EDT [HELPER_EXEC Thread 4]:12087444:Could not run SQL query: SELECT pm.PartID, lm.LocID, lm.LocName, pm.PartNumber, pm.PartDescription, (sl.SLDA * sl.SLDS /1000000) As ServiceLevelGoal, (sa.OnHandNew + sa.OnHandFixed)As OnHand, NVL( sk.Price , pm.Price etc..... com.microsoft.sqlserver.jdbc.SQLServerException: 'NVL' is not a recognized built-in function name. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
This is a printer-friendly version of Article 284574 and may be out of date. For the latest version click CS284574