TR3313错误如何解决？transformer添加数据源无响应

xiaoerp

今天新装了个cognos8.4，安装配置一切顺利，我的环境windows7+cognos8.4+Oracle11g+iis7。
我的维表和事实表都放在了我新建的olap用户下，这个用户有自己的表空间tbs_olap，维表和事实表也同样建立在tbs_olap上;
我使用的登录名是olap。

问题：
当我创建transformer项目时，通过iqd文件添加数据源时，点完成，填写db用户名（olap）和密码以后，transformer就无响应了，等一会儿就弹出错误，内容为
(TR3313) An error occurred reading from the DA Server Pipe. No child processes.
使用8.3的时候就没有这个问题。

我的调查结果：
我在IBM官网上找了个这个错误，但是错误的发生条件都不是我的这种情况，网上大致查的有以下内容
1.Error when using MySQL Datasource in Transformer
http://www-01.ibm.com/support/docview.wss?uid=swg21438279&myns=swgimgmt&mynp=OCSS9RTN&mync=R

2.Unable to build a cube in Transformer due to the following error
http://www-01.ibm.com/support/docview.wss?uid=swg21338333

请大大们帮帮我吧！万分感谢！

-----------------------
附上我的iqd内容：
COGNOS QUERY
STRUCTURE,1,1
DATABASE,GAMEDWH
TITLE,[GAMEDWH]
BEGIN SQL
{
SELECT
      OLAP.D_GAMEWEEK.WEEK_NAME,
      OLAP.D_LOCATION.PROVINCE_ID,
      OLAP.D_LOCATION.PROVINCE_NAME,
      OLAP.D_LOCATION.CITY_ID,
      OLAP.D_LOCATION.CITY_NAME,
      OLAP.D_LOCATION.COUNTY_ID,
      OLAP.D_LOCATION.COUNTY_NAME,
      OLAP.D_PERSON.D_PERSON_ID,
      OLAP.D_PERSON.PERSON_NAME,
      OLAP.D_PERSON.PERSON_TYPE_ID,
      OLAP.D_PERSON.PERSON_TYPE_NAME,
      OLAP.D_PRODUCT.PRODUCT_CHINESE_NAME,
      OLAP.D_PRODUCT.PRODUCT_ENGLISH_NAME,
      OLAP.D_PRODUCT.PRIZE_ID,
      OLAP.D_PRODUCT.PRIZE_VALUE,
      OLAP.D_PRODUCT.THEME_ID,
      OLAP.D_PRODUCT.THEME_NAME,
      OLAP.D_VIP.VIP_NAME,
      OLAP.F_STATE.Shipped_Count,
      OLAP.F_STATE.Shipped_Amount,
      OLAP.F_STATE.Returned_Count,
      OLAP.F_STATE.Returned_Amount,
      OLAP.F_STATE.Destroyed_Count,
      OLAP.F_STATE.Destroyed_Amount,
      OLAP.F_STATE.Active_Count,
      OLAP.F_STATE.Active_Amount,
      OLAP.F_STATE.Promotion_Count,
      OLAP.F_STATE.Promotion_Amount,
      OLAP.F_STATE.Blocked_Count,
      OLAP.F_STATE.Blocked_Amount,
      OLAP.F_STATE.Defective_Count,
      OLAP.F_STATE.Defective_Amount,
      OLAP.F_STATE.Stolen_Count,
      OLAP.F_STATE.Stolen_Amount,
      OLAP.F_STATE.Trunk_Stock_Count,
      OLAP.F_STATE.Trunk_Stock_Amount,
      OLAP.F_STATE.Sold_Count,
      OLAP.F_STATE.Sold_Amount,
      OLAP.F_STATE.Validation_Count,
      OLAP.F_STATE.Validation_Amount,
      OLAP.F_STATE.SG_DATE,
      OLAP.F_STATE.D_GAMEWEEK_ID ,
      OLAP.F_STATE.D_LOCATION_ID ,
      OLAP.F_STATE.D_PRODUCT_ID,
      OLAP.F_STATE.D_VIP_ID ,
      OLAP.D_PRODUCT.sell_begin_date,
      OLAP.F_STATE.INVENTORY_COUNT,
      OLAP.F_STATE.INVENTORY_AMOUNT,
      OLAP.D_GAMEWEEK.WEEK_NO,
      OLAP.D_PRODUCT.GAME_NO,
      OLAP.F_STATE.INVENTORY_OUT_COUNT,
      OLAP.F_STATE.INVENTORY_OUT_AMOUNT,
      OLAP.F_STATE.INVENTORY_IN_COUNT,
      OLAP.F_STATE.INVENTORY_IN_AMOUNT
  FROM OLAP.F_STATE
  left JOIN OLAP.D_GAMEWEEK ON OLAP.F_STATE.D_GAMEWEEK_ID = OLAP.D_GAMEWEEK.D_GAMEWEEK_ID
  left JOIN OLAP.D_LOCATION ON OLAP.F_STATE.D_LOCATION_ID = OLAP.D_LOCATION.D_LOCATION_ID
  left JOIN OLAP.D_PERSON ON OLAP.F_STATE.D_PERSON_ID = OLAP.D_PERSON.D_PERSON_ID
  left JOIN OLAP.D_PRODUCT ON OLAP.F_STATE.D_PRODUCT_ID = OLAP.D_PRODUCT.D_PRODUCT_ID
  left JOIN OLAP.D_VIP ON OLAP.F_STATE.D_VIP_ID = OLAP.D_VIP.D_VIP_ID
  order by OLAP.F_STATE.SG_DATE
}
END SQL
COLUMN,0,GAME_WEEK
COLUMN,1,PROVINCE_ID
COLUMN,2,PROVINCE_NAME
COLUMN,3,CITY_ID
COLUMN,4,CITY_NAME
COLUMN,5,COUNTY_ID
COLUMN,6,COUNTY_NAME
COLUMN,7,D_PERSON_ID
COLUMN,8,PERSON_NAME
COLUMN,9,PERSON_TYPE_ID
COLUMN,10,PERSON_TYPE_NAME
COLUMN,11,PRODUCT_CHINESE_NAME
COLUMN,12,PRODUCT_ENGLISH_NAME
COLUMN,13,PRIZE_ID
COLUMN,14,PRIZE_VALUE
COLUMN,15,THEME_ID
COLUMN,16,THEME_NAME
COLUMN,17,VIP_NAME
COLUMN,18,Shipped_Count
COLUMN,19,Shipped_Amount
COLUMN,20,Returned_Count
COLUMN,21,Returned_Amount
COLUMN,22,Destroyed_Count
COLUMN,23,Destroyed_Amount
COLUMN,24,Active_Count
COLUMN,25,Active_Amount
COLUMN,26,Promotion_Count
COLUMN,27,Promotion_Amount
COLUMN,28,Blocked_Count
COLUMN,29,Blocked_Amount
COLUMN,30,Defective_Count
COLUMN,31,Defective_Amount
COLUMN,32,Stolen_Count
COLUMN,33,Stolen_Amount
COLUMN,34,Trunk_Stock_Count
COLUMN,35,Trunk_Stock_Amount
COLUMN,36,Sold_Count
COLUMN,37,Sold_Amount
COLUMN,38,Validation_Count
COLUMN,39,Validation_Amount
COLUMN,40,SG_DATE
COLUMN,41,D_GAMEWEEK_ID
COLUMN,42,D_LOCATION_ID
COLUMN,43,D_PRODUCT_ID
COLUMN,44,D_VIP_ID
COLUMN,45,sell_begin_date
COLUMN,46,INVENTORY_COUNT
COLUMN,47,INVENTORY_AMOUNT
COLUMN,48,WEEK_NO
COLUMN,49,GAME_NO
COLUMN,50,INVENTORY_OUT_COUNT
COLUMN,51,INVENTORY_OUT_AMOUNT
COLUMN,52,INVENTORY_IN_COUNT
COLUMN,54,INVENTORY_IN_AMOUNT

xiaoerp

找到原因了，是\c8\CS7Gateways\bin\cs7g.ini中的[Databases]数据库连接字符串写错了。。
GAMEDWH=^User ID:^?Password:;LOCAL;OR;Oracle@%s@GAMEDWH/%s@COLSEQ=
切记是红色粗体部分为Oracle数据库的sid