Article - CS261186
Error "ORA-00933:SQL command not properly ended" while selecting all and approving best fit recommendations in Servigistics Parts Planning
Modified: 25-Apr-2017
Applies To
- Servigistics Service Parts Management 11.0.1.4.1
Description
- Error ORA-00933:SQL command not properly ended while selecting all and approving best fit recommendations
- WebUI screen displays the error message as below
- org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [delete from IPCS_BESTFIT_ACTION from IPCS_BESTFIT_ACTION, IPCS_LOC_TREE where IPCS_BESTFIT_ACTION.LocID=IPCS_LOC_TREE.ChildLocID and IPCS_LOC_TREE.LocID=7419]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
This is a printer-friendly version of Article 261186 and may be out of date. For the latest version click CS261186