SQL Errors are shown in the Application Logs for Queries Generated by Application

(Doc ID 559862.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.04 , SQL Errors are shown in the Application and system logs

ERROR
2008-03-05 13:08:38.834 411861 Error Exception java.sql.SQLException: ORA-00933: SQL command not properly ended

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Review the exception and system logs and see the error being reported quite often

-- Business Impact:
The issue has the following business impact:
Due to this issue, users are concerned what queries cause this error

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms