Posted on 2008-11-19 17:12
沙漠中的鱼 阅读(1715)
评论(0) 编辑 收藏 所属分类:
Cognos开发
今天在修改Framework Manager中对Query Object时，发现了一个不解的问题，现在贴出现，希望有谁能帮忙解决一下
我双击新键的Query Object,弹出如下对话框
我修改SQL对话框中SQL，设置查询其中某一个对象
点击查询,出现了如下错误
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='-56'.
UDA-SQL-0115 Inappropriate SQL request.
UDA-SQL-0564 [Microsoft SQL Native Client]Deferred prepare could not be completed.
UDA-SQL-0564 [Microsoft SQL Native Client]Statement(s) could not be prepared. (SQLSTATE=42000, SQLERRORCODE=8180)
UDA-SQL-0564 [Microsoft SQL Native Client]The multi-part identifier "PRODUCT.PRODUCT_NUMBER" could not be bound. (SQLSTATE=42000, SQLERRORCODE=4104)
我手动修改一下SQL语句，给表加了一个别名,点击test选项卡，没有报错，如下
点击test选择卡页面中的Test Sample没有出现问题,查询出数据
附：我第一次这样测试查询数据时出现如下警告,说有冲突，但是不知道是什么原因
The following warning has been detected. Press OK to continue with the operation.
BMT-MD-0059 The removal of the following objects will impact the objects that directly use them or their children:
PRODUCT_NUMBER
BASE_PRODUCT_NUMBER
INTRODUCTION_DATE
DISCONTINUED_DATE
PRODUCT_TYPE_CODE
PRODUCT_COLOR_CODE
PRODUCT_SIZE_CODE
PRODUCT_BRAND_CODE
PRODUCTION_COST
GROSS_MARGIN
PRODUCT_IMAGE
These impacts are listed below. These impacts may also propagate to other objects that indirectly use the above objects.
BMT-MD-0060 determinant "PRODUCT_NUMBER" will be deleted.