Status/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Bon Ku / Bon Ku (Bon Ku)
Created: 09/22/2016
Components: Database
Versions: 11.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Win 2012 Server x64
Vote Count: 0
Problem Description: Upgrading from CF9 WAS7 ojdbc6.jar to CF11 WAS855 ojdbc7.jar, cfquery getting ORA-00933 (VENDORERRORCODE 933, SQLSTATE 42000)
Steps to Reproduce:
1. Log on gats3-dev.usps.gov
2. Select "Grievance/Appeals" and "Update Grievance/Appeal" drop downs
3. Enter 10000082 Griev Nbr and click Edit
4. Click Edit Issue Codes
5. Error Executing Database Query page
Actual Result: Error Executing Database Query. ORA-00933: SQL command not properly ended
Expected Result: Edit Issues Codes page
Any Workarounds: Creating data source in CF11 admin console works, but requirement is to use WebSphere data source
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4192033
External Customer Info:
External Company:
External Customer Name: Bon Ku
External Customer Email:
External Test Config: My Hardware and Environment details: Development, Windows 2012 VMAttachments:
- September 22, 2016 00:00:00: 1_gats_ORA-00933.txt
Comments: