"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 JUNE 29, 2017

Applies to:

Hyperion Financial Management - Version 11.1.2.4.204 and later
Information in this document applies to any platform.

Symptoms

IF 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 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]]

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