After upgrading JTS and RTC to v6.0, why are all data collection jobs are failing?
After upgrading to v6.0, all the Data Collection Jobs are failing with
the following JDBC error:
the following JDBC error:
10/20/2015 19:48:52,075 [dcc_etl_Fact_File_RIDW] ERROR
com.ibm.rational.datacollection.etl.exception.ETLException: CRRCD4506E A JDBC connection could not be created for the database at jdbc:db2:.
at com.ibm.rational.datacollection.etl.jdbc.ConnectionPool.createConnection(ConnectionPool.java:175)
at com.ibm.rational.datacollection.etl.utils.ETLExecutionUtil.initializeRGParams(ETLExecutionUtil.java:993)
at com.ibm.rational.datacollection.etl.tasks.ETLBaseTask.initialize(ETLBaseTask.java:147)
at com.ibm.rational.datacollection.etl.tasks.ETLDBTask.call(ETLDBTask.java:60)
at com.ibm.rational.datacollection.etl.tasks.ETLDBTask.call(ETLDBTask.java:1)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:314)
at java.util.concurrent.FutureTask.run(FutureTask.java:149)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:767)
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10033][4.17.28] Invalid database URL syntax: jdbc:db2:. ERRORCODE=-4461, SQLSTATE=42815
at com.ibm.db2.jcc.am.fd.a(fd.java:747)
at com.ibm.db2.jcc.am.fd.a(fd.java:66)
at com.ibm.db2.jcc.am.fd.a(fd.java:93)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:145)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:115)
at java.sql.DriverManager.getConnection(DriverManager.java:419)
at java.sql.DriverManager.getConnection(DriverManager.java:467)
at com.ibm.rational.datacollection.etl.jdbc.ConnectionPool.createConnection(ConnectionPool.java:172)
... 9 more
Caused by: java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:188)
at java.util.StringTokenizer.nextToken(StringTokenizer.java:203)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:141)
... 13 more
All of my DCC jobs were running fine before the upgrade. How can I resolve this?
One answer
Check to see if the Resource Group for Data Warehouse is configured for Data Warehouse.
Navigate to the https://server:port/dcc/web page.
In the "Data Warehouse Connection" page, confirm the Data Warehouse is configured and Test Connection successful .
Now, in the Resource Group Configuration page, check the "Rational Reporting Data Warehouse Database" section.
If it is unconfigured, you can try hitting the "Discover" button to fill in the settings, but you may have to fill this out manually, depending on if you manually registered DCC to the JTS, or if you used jts/setup.