Issue in Framework manager with progress openedge11.4

[jeeva.nimma]

Hi,

we are using progress openegde 11.4 database and cognos10.2, when we are importing tables (consist of underscore(_) like Emp_Info) from progress to cognos frameworkmanager tool, it is giving the below error

RQP-DEF-0177 An error occured while performing operation 'sql open' status -9
UDA-SQL-0107 general exception occured during the operation 'AOpen'
[DataDirect].[ODBC Progress openedge wire protocol driver].[OPENEDGE]Syntax Error in sql statement at or about "Emp_Info" AND Sysprogress.sysindexes(10713)

if we dont have any underscore in the table names,it is working fine...

please give the suggestions to solve this issue.

Thanks.

[MFGF]

Hi,

we are using progress openegde 11.4 database and cognos10.2, when we are importing tables (consist of underscore(_) like Emp_Info) from progress to cognos frameworkmanager tool, it is giving the below error

RQP-DEF-0177 An error occured while performing operation 'sql open' status -9
UDA-SQL-0107 general exception occured during the operation 'AOpen'
[DataDirect].[ODBC Progress openedge wire protocol driver].[OPENEDGE]Syntax Error in sql statement at or about "Emp_Info" AND Sysprogress.sysindexes(10713)

if we dont have any underscore in the table names,it is working fine...

please give the suggestions to solve this issue.

Thanks.

Looks like you're not using a version of OpenEdge supported in Cognos 10.2. The 10.2 version of Cognos BI supports only OpenEdge 10.1C, according to the IBM Cognos Supported Environments page:

http://www-969.ibm.com/software/reports/compatibility/clarity-reports/report/html/prereqsForProduct?deliverableId=1283262749193#sw-5

Cognos 10.2.1 supports OpenEdge 10.1C and 10.2A, and the same is true of Cognos 10.2.2. I'm not seeing any support for OpenEdge 11.4 listed anywhere.

MF.

[jeeva.nimma]

Looks like you're not using a version of OpenEdge supported in Cognos 10.2. The 10.2 version of Cognos BI supports only OpenEdge 10.1C, according to the IBM Cognos Supported Environments page:

http://www-969.ibm.com/software/reports/compatibility/clarity-reports/report/html/prereqsForProduct?deliverableId=1283262749193#sw-5

Cognos 10.2.1 supports OpenEdge 10.1C and 10.2A, and the same is true of Cognos 10.2.2. I'm not seeing any support for OpenEdge 11.4 listed anywhere.

MF.

Thanks for your reply MFGF.