cognos model测试报RQP-DEF-0177错误

xiaoerp

This query contains an error and can not be executed.
It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-69'.

UDA-SQL-0107 A general exception has occurred during the operation "prepare".

UDA-SQL-0445 The Sybase server: DGTPX_80 returned the following message:
"Select expression results in more than one column having same name. Column name '' is specified more than once".

UDA-SQL-0445 The Sybase server: DGTPX_80 returned the following message: "Select expression results in more than one column having same name. Column name '' is specified more than once

各位大哥大姐 ：请问这个是什么问题啊，开发环境可以，部署到客户那里就出现问题了A。
连接的是sybase 12.5 的数据库。cognos 8.4

xiaoerp

问题已经解决，ODBC版本太低，造成了这些错误信息。
友情提示：以后只要是连接数据仓库的连接建议使用ODBC连接。不要使用别的方式。

datasource 注意不要使用database only。这个选项，选择另外的选项。