Posted on 2008-11-19 17:12
沙漠中的魚 閱讀(1755)
評論(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.