请教用jdbc连数据源能不能刷CUBE
我是linux系统，sqlserver 数据库，因为没有免费的odbc驱动，所以用jdbc,但是刷CUBE时报如下错误:transformer中可以data source viewer查看到数据
04 12月 2014 17时23分07秒 2 000000DB QE-DEF-0285 The logon failed.
四 04 12月 2014 17时23分07秒 2 000000DB QE-DEF-0325 The logon failed for the following reason:
四 04 12月 2014 17时23分07秒 2 000000DB RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
四 04 12月 2014 17时23分07秒 2 000000DB dim_120
四 04 12月 2014 17时23分07秒 2 000000DB
四 04 12月 2014 17时23分07秒 2 000000DB UDA-SQL-0031 Unable to access the "dim_120" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
四 04 12月 2014 17时23分07秒 2 000000DB UDA-SQL-0107 A general exception has occurred during the operation "attach".
四 04 12月 2014 17时23分07秒 2 000000DB [unixODBC][Easysoft][SQL Server Driver][SQL Server]General error: General error: Failed to initialise licensing - All valid licenses for this product have expired, return code 9
四 04 12月 2014 17时23分07秒 4 000000DB End processing 0 records from data source '购买渠道'.
四 04 12月 2014 17时23分07秒 4 000000DB Timing, READ DATA SOURCE,00:00:02
四 04 12月 2014 17时23分08秒 4 000000DB End cube update.
四 04 12月 2014 17时23分08秒 4 000000DB Timing, TOTAL TIME (CREATE CUBE),00:00:03
四 04 12月 2014 17时23分08秒 2 000000DB (TR3703) The user ID or password is either missing or invalid. Please re-enter the credentials. [->OK]
四 04 12月 2014 17时23分08秒 3 000000DB Closing model file /home/oracle/c10tran/temp/ppd02486.qyj
04 12月 2014 17时23分07秒 2 000000DB QE-DEF-0285 The logon failed.
四 04 12月 2014 17时23分07秒 2 000000DB QE-DEF-0325 The logon failed for the following reason:
四 04 12月 2014 17时23分07秒 2 000000DB RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
四 04 12月 2014 17时23分07秒 2 000000DB dim_120
四 04 12月 2014 17时23分07秒 2 000000DB
四 04 12月 2014 17时23分07秒 2 000000DB UDA-SQL-0031 Unable to access the "dim_120" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
四 04 12月 2014 17时23分07秒 2 000000DB UDA-SQL-0107 A general exception has occurred during the operation "attach".
四 04 12月 2014 17时23分07秒 2 000000DB [unixODBC][Easysoft][SQL Server Driver][SQL Server]General error: General error: Failed to initialise licensing - All valid licenses for this product have expired, return code 9
四 04 12月 2014 17时23分07秒 4 000000DB End processing 0 records from data source '购买渠道'.
四 04 12月 2014 17时23分07秒 4 000000DB Timing, READ DATA SOURCE,00:00:02
四 04 12月 2014 17时23分08秒 4 000000DB End cube update.
四 04 12月 2014 17时23分08秒 4 000000DB Timing, TOTAL TIME (CREATE CUBE),00:00:03
四 04 12月 2014 17时23分08秒 2 000000DB (TR3703) The user ID or password is either missing or invalid. Please re-enter the credentials. [->OK]
四 04 12月 2014 17时23分08秒 3 000000DB Closing model file /home/oracle/c10tran/temp/ppd02486.qyj
6同行回答
回复 sealink 在linux下可以通过odbc连接到sqlserver 测试也通过,就是刷cube不行，可能JDBC是刷不 ...aqiang_007 发表于 2014-12-9 18:13
我觉得还是环境哪里没配置好，呵呵。确认没这么用过SQL SERVER...浏览1394
use DQM package which supports JDBC driver access to SQLServer from Linux:
http://www.ibm.com/developerwork ... ecific/page529.html
Take a look at the following link to see if it work for you:
http://www-01.ibm.com/support/kn ... _how_crn_works.html收起
http://www.ibm.com/developerwork ... ecific/page529.html
Take a look at the following link to see if it work for you:
http://www-01.ibm.com/support/kn ... _how_crn_works.html收起
浏览1391
浏览1333
浏览1392