"Unclosed quotation mark after the character string '" or "ORA-00933: SQL command not properly ended" Found in HFM Application Logs (Doc ID 2278801.1)

Last updated on JANUARY 27, 2023

Applies to:

Symptoms

If the Database is Microsoft SQL Server, the following errors will be captured:

[ERROR:1] [EPMHFM-07392] [XFM] [ecid:] [File: XfmODBC.cpp] [Line: 203] [userId: ] [appName: ] [pid: ] [tid: ] [host: ] [nwaddr: [] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = HY000; NATIVE ERROR = 102; MSG = [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 's'.]]
[ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 203] [userId: ] [appName: ] [pid: ] [tid: ] [host: ] [nwaddr: [] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = HY000; NATIVE ERROR = 102; MSG = [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 's'.2 record: SQLSTATE = HY000; NATIVE ERROR = 105; MSG = [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Unclosed quotation mark after the character string ' and ReportType = 6'.]]

IF the Database is Oracle, the following error will be captured:

[ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 203] [userId: ] [appName: ] [pid: ] [tid: ] [host:] [nwaddr: ] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 42000; NATIVE ERROR = 933; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00933: SQL command not properly ended]]

Following the above error references will be the associated query:

[[SELECT EncodedLabel FROM {appName}_RPTS WHERE Label = N'Test's Tasklist' and ReportType = 6]]

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.