It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,474
×6,037

question asked: Oct 30 '13, 12:14 p.m.
question was seen: 5,301 times
last updated: Oct 30 '13, 7:12 p.m.

Related questions

How can I determine if RRDI is installed already?

0
Ryan McBryde (59●1●12●33) | asked Oct 30 '13, 12:14 p.m.
JTS ver: 4.0.2

I have the CLM tools;  RRC, RQM.,and RTC installed on a Linux cloud, using SQL Server as the backend database. I did not install the tools myself but instead they were installed by another organization in our company.  I am responsible now for administering them and I am trying to get Reporting to work.  From what I can tell from the available literature, I am trying to use Rational Reporting for Development Intelligence (RRDI) but I can't tell whether it was installed or not, but I am suspecting that it wasn't.

I can see that I have a Data Warehouse that has been created and that the ETL jobs are there but only one of them seems to be running successfully, the STAR job.  All the others are failing and I am trying to debug why.

All the Quality Management jobs are failing; Work Items, Repository, Common, Quality Management as are the CCM jobs;  SCM, Build, etc.

Accepted answer

0
permanent link
Benjamin Silverman (4.1k●6●10) | answered Oct 30 '13, 2:15 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Strange errors...seems like the jobs are running but not getting the expected response back from the applications.  The build star job runs fine because all those builds are run within the context of the data warehouse database.  Since you did not set up the applications yourself, I would go back through and make sure the ETL is properly configured.  Make sure the user running the ETL is a valid user with the data collector license assigned.  This topic describes the process that should have been followed when the ETL was configured (step 9f), so if needed you can go through that again to validate the user defined is valid, and then go to jts/admin to make sure that user has the data collector license, and also make sure that is the same user defined for the ETL jobs when you go to jts/admin -> Reports.  Hope it helps,
Ryan McBryde selected this answer as the correct answer
Comments
Ryan McBryde commented Oct 30 '13, 3:54 p.m.

I looked under "Data Warehouse Collection Jobs" under Data Collection Jobs in jts/admin/Reports and there I see "etl_user" as the id for 4 jobs; Common, Repository, License, Requirements and all 5 jobs (including Star) are enabled and showing a state of Idle.  etl_user is the userid for a user named "Data Collection User" and has "CCM Data Collector", "QM Data Collector" and "RM Data Collector" licenses assigned to it. The "Data Collector" license is unassigned but I understood that with the advent or 4.0, that it was no longer used and that the product specific licenses were used instead.  Correct? I have tested the password for that user, etl_user, and was able to login to RTC with it.

Benjamin Silverman commented Oct 30 '13, 3:59 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Could it be an authentication problem?  Have you switched the server from FORM to BASIC authentication but the ETL user is still trying to authenticate using FORM authentication?  Otherwise you'll probably want to enable the ETL driver log found in the jts log4j.properties and see what is going on there.  At that point it may be practical to open a PMR with support.

Ryan McBryde commented Oct 30 '13, 5:05 p.m.

Thanks,
I have not knowingly switched the server authentication method and as far as I know the authentication method is still FORM.  I will see if I can enable the ETL driver log in log4j.properties and see what it produces.

1
Benjamin Silverman commented Oct 30 '13, 5:13 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

If that's the case you probably want to confirm one more thing before enabling the driver log...check in jts/admin -> Server -> Advanced Properties -> and check that "XDC Authentication Type" is set to either FORM and that the etl_user ID and password are entered properly a few properties above that under "Data Collection User or Consumer Key" and "Data Collection User Password or Consumer Secret".  It wouldn't hurt to re-enter them, save the changes and attempt to re-run the ETL to see if you get the same errors. 

Ryan McBryde commented Oct 30 '13, 5:21 p.m.

Aha!
The etl_user id is set and I can reset the password BUT when I look at the Authentication Type it is set to BASIC!

And the data collection jobs Enabled property is set to true.

It would appear that I should change that back to FORM, correct?

1
Benjamin Silverman commented Oct 30 '13, 5:28 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Yes, change it back to FORM and make sure the credentials are good then re-run the ETL.  You'll have to make the change for each app (ie - ccm/admin, qm/admin).  For RM and JTS ETL's it's done in jts/admin. 

1
Ryan McBryde commented Oct 30 '13, 7:06 p.m.

Benjamin,

Thank you! That appears to have done the trick.  Setting the Auth method back to Form and then manually re-setting the password for etl_user had resulted in all the jobs running!  Thanks again!

Benjamin Silverman commented Oct 30 '13, 7:12 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Glad to hear.  Now to just install RRDI so you can do something with all that data :)

showing 5 of 8 show 3 more comments

2 other answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Benjamin Silverman (4.1k●6●10) | answered Oct 30 '13, 1:23 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Ryan,

RRDI must be deployed to WebSphere, so if you have access to the server directly (or WAS admin console) you can check to see if the IBM Cognos application is deployed.  If RRDI was installed and configured, you might also see a connection defined to the report server under jts/admin -> Reports -> Custom Reports Connection -> Report Server URL.

If properly configured, the ETL's will run fine with or without RRDI installed.  RRDI just gives you an interface to create custom reports against the data that gets loaded in to the warehouse.  If you want to provide the ETL log here I can have a look at why they might be failing, or you can create a PMR by contacting support if you require immediate assistance. 

Hope it helps,
Comments
Ryan McBryde commented Oct 30 '13, 3:13 p.m.

Benjamin,
I looked under Applications in the WAS Admin console and didn't see anything that looked like IBM Cognos.  Is that the right place to look?  I also check under jts/admin->Reports->Custom Reports Connection->Report Server URL and the value is None.  That would appear to indicate that RRDI is not installed.  I guess what I am most concerned with now is to see why the ETL jobs are failing.  Did the log I sent shed any light on this?
Ryan

Benjamin Silverman commented Oct 30 '13, 3:20 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Yes, it would seem like RRDI is not installed if you're looking at the installed WAS applications from the WAS admin console.  See my response below regarding the ETL log you posted.

0
permanent link
Ryan McBryde (59●1●12●33) | answered Oct 30 '13, 1:52 p.m.
Hi Benjamin,

Thanks very much for the response.  I can login to the WAS admin console and will check as you said.  I have copied the contents of the jts-etl.log here.  Do you want to see the contents of the qm and ccm logs as well.

###
2013-10-30 00:00:00,081 [ jts: AsynchronousTaskRunner-0]  INFO ervice.internal.common.CommonRemoteSnapshotService  - ETL: *****Started Job Common at 10/30/13 12:00 AM*****
2013-10-30 00:00:00,116 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: ***Started Build Contributor at 10/30/13 12:00 AM***
2013-10-30 00:00:02,825 [ jts: AsynchronousTaskRunner-0] ERROR ervice.internal.common.CommonRemoteSnapshotService  - com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
        at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2101)
        at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next(BaseRDSResultSet.java:1472)
        at com.ibm.team.datawarehouse.service.XdcResultSet.next(XdcResultSet.java:176)
        at com.ibm.team.datawarehouse.service.internal.common.etlbuild.Contributor.execute(Contributor.java:94)
        at com.ibm.team.datawarehouse.service.internal.common.CommonRemoteSnapshotService.updateSnapshot(CommonRemoteSnapshotService.java:132)
        at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:200)
        at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$5.run(RemoteDatabaseService.java:254)
        at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:381)
        at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:244)
        at sun.reflect.GeneratedMethodAccessor983.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy288.write(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)
        at sun.reflect.GeneratedMethodAccessor982.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy1989.write(Unknown Source)
        at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService.updateData(AbstractRemoteSnapshotService.java:195)
        at sun.reflect.GeneratedMethodAccessor1743.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy549.updateData(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateAllRemoteSnapshotDataFromTask(InternalDataWarehouseService.java:913)
        at sun.reflect.GeneratedMethodAccessor2256.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy547.updateAllRemoteSnapshotDataFromTask(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.SnapshotRunnerTask.transactionSucceeded(SnapshotRunnerTask.java:53)
        at sun.reflect.GeneratedMethodAccessor1830.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy554.transactionSucceeded(Unknown Source)
        at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.transactionSucceeded(AsynchronousTaskSchedulerService.java:972)
        at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.executeTask(AsynchronousTaskSchedulerService.java:981)
        at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:153)
        at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:116)
        at java.lang.Thread.run(Thread.java:773)
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Records Selected: 0
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Records Inserted: 0
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Records Updated: 0
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Inserting: 0ms
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Updating: 0ms
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Looking Up: 0ms
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Running: 2 seconds
2013-10-30 00:00:02,836 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: ***Finished Build Contributor at 10/30/13 12:00 AM. The build was unsuccessful***
2013-10-30 00:00:02,903 [ jts: AsynchronousTaskRunner-0]  INFO ervice.internal.common.CommonRemoteSnapshotService  - ETL: *****Finished Job Common at 10/30/13 12:00 AM. The job was unsuccessful.*****
2013-10-30 00:00:03,031 [ jts: AsynchronousTaskRunner-0]  INFO epository.internal.RepositoryRemoteSnapshotService  - ETL: *****Started Job Repository at 10/30/13 12:00 AM*****
2013-10-30 00:00:05,117 [ jts: AsynchronousTaskRunner-0] ERROR epository.internal.RepositoryRemoteSnapshotService  - com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
        at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2101)
        at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next(BaseRDSResultSet.java:1472)
        at com.ibm.team.datawarehouse.service.XdcResultSet.next(XdcResultSet.java:176)
        at com.ibm.team.datawarehouse.service.repository.internal.etlbuild.IntegralRangeCounter.execute(IntegralRangeCounter.java:75)
        at com.ibm.team.datawarehouse.service.repository.internal.RepositoryRemoteSnapshotService.updateSnapshot(RepositoryRemoteSnapshotService.java:107)
        at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:200)
        at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$5.run(RemoteDatabaseService.java:254)
        at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:381)
        at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:244)
        at sun.reflect.GeneratedMethodAccessor983.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy288.write(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)
        at sun.reflect.GeneratedMethodAccessor982.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy1989.write(Unknown Source)
        at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService.updateData(AbstractRemoteSnapshotService.java:195)
        at sun.reflect.GeneratedMethodAccessor794.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy677.updateData(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateAllRemoteSnapshotDataFromTask(InternalDataWarehouseService.java:913)
        at sun.reflect.GeneratedMethodAccessor2256.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy547.updateAllRemoteSnapshotDataFromTask(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.SnapshotRunnerTask.transactionSucceeded(SnapshotRunnerTask.java:53)
        at sun.reflect.GeneratedMethodAccessor1830.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy554.transactionSucceeded(Unknown Source)
        at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.transactionSucceeded(AsynchronousTaskSchedulerService.java:972)
        at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.executeTask(AsynchronousTaskSchedulerService.java:981)
        at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:153)
        at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:116)
        at java.lang.Thread.run(Thread.java:773)
2013-10-30 00:00:05,123 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Records Selected: 0
2013-10-30 00:00:05,123 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Records Inserted: 0
2013-10-30 00:00:05,123 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Records Updated: 0
2013-10-30 00:00:05,123 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Time Inserting: 0ms
2013-10-30 00:00:05,124 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Time Updating: 0ms
2013-10-30 00:00:05,124 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Time Looking Up: 0ms
2013-10-30 00:00:05,124 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2013-10-30 00:00:05,124 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: Time Running: 2 seconds
2013-10-30 00:00:05,124 [ jts: AsynchronousTaskRunner-0] DEBUG epository.internal.RepositoryRemoteSnapshotService  - ETL: ***Finished Build IntegralRangeCounter at 10/30/13 12:00 AM. The build was unsuccessful***
2013-10-30 00:00:05,204 [ jts: AsynchronousTaskRunner-0]  INFO epository.internal.RepositoryRemoteSnapshotService  - ETL: *****Finished Job Repository at 10/30/13 12:00 AM. The job was unsuccessful.*****
2013-10-30 00:01:08,634 [ jts: AsynchronousTaskRunner-0]  INFO e.repository.internal.LicenseRemoteSnapshotService  - ETL: *****Started Job License at 10/30/13 12:01 AM*****
2013-10-30 00:01:08,642 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: ***Started Build IntegralRangeCounter at 10/30/13 12:01 AM***
2013-10-30 00:01:10,916 [ jts: AsynchronousTaskRunner-0] ERROR e.repository.internal.LicenseRemoteSnapshotService  - com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
        at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData(BaseRDSResultSet.java:2101)
        at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next(BaseRDSResultSet.java:1472)
        at com.ibm.team.datawarehouse.service.XdcResultSet.next(XdcResultSet.java:176)
        at com.ibm.team.datawarehouse.service.repository.internal.etlbuild.IntegralRangeCounter.execute(IntegralRangeCounter.java:75)
        at com.ibm.team.datawarehouse.service.repository.internal.LicenseRemoteSnapshotService.updateSnapshot(LicenseRemoteSnapshotService.java:67)
        at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:200)
        at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$5.run(RemoteDatabaseService.java:254)
        at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:381)
        at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:244)
        at sun.reflect.GeneratedMethodAccessor983.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy288.write(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)
        at sun.reflect.GeneratedMethodAccessor982.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy1989.write(Unknown Source)
        at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService.updateData(AbstractRemoteSnapshotService.java:195)
        at sun.reflect.GeneratedMethodAccessor794.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy555.updateData(Unknown Source)
        at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateAllRemoteSnapshotDataFromTask(InternalDataWarehouseService.java:913)
        at sun.reflect.GeneratedMethodAccessor2256.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at com.sun.proxy.$Proxy554.transactionSucceeded(Unknown Source)
        at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.transactionSucceeded(AsynchronousTaskSchedulerService.java:972)
        at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.executeTask(AsynchronousTaskSchedulerService.java:981)
        at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:153)
        at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:116)
        at java.lang.Thread.run(Thread.java:773)
2013-10-30 00:01:10,919 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Records Selected: 0
2013-10-30 00:01:10,919 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Records Inserted: 0
2013-10-30 00:01:10,919 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Records Updated: 0
2013-10-30 00:01:10,919 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Inserting: 0ms
2013-10-30 00:01:10,920 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Updating: 0ms
2013-10-30 00:01:10,920 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Looking Up: 0ms
2013-10-30 00:01:10,920 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2013-10-30 00:01:10,920 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Running: 2 seconds
2013-10-30 00:01:10,920 [ jts: AsynchronousTaskRunner-0] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: ***Finished Build IntegralRangeCounter at 10/30/13 12:01 AM. The build was unsuccessful***
2013-10-30 00:01:10,950 [ jts: AsynchronousTaskRunner-0]  INFO e.repository.internal.LicenseRemoteSnapshotService  - ETL: *****Finished Job License at 10/30/13 12:01 AM. The job was unsuccessful.*****
2013-10-30 00:09:43,049 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Requirements Composer ETL jobs
2013-10-30 00:09:43,049 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - -=START=-
2013-10-30 00:09:43,049 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will collect metrics: true
2013-10-30 00:09:43,049 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Using threshold value 20
2013-10-30 00:09:43,049 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will filter incomplete rows: true
2013-10-30 00:09:43,050 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Will generate names if empty: false
2013-10-30 00:09:43,050 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Processing resource group _V3N-gs0vEeKl0fvb071gGQRRC
2013-10-30 00:09:43,068 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - -=LINKS=-
2013-10-30 00:09:43,068 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - Load all RRC link types
2013-10-30 00:09:46,725 [ jts: AsynchronousTaskRunner-0]  INFO house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - ***********Start to execute the Java ETL of com.ibm.team.datawarehouse.service.rrc.internal.etlbuild.RRCLinkTypeETL********************
2013-10-30 00:09:46,750 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,750 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type precondition  for
2013-10-30 00:09:46,752 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,752 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type References Term
2013-10-30 00:09:46,754 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,754 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Validated By
2013-10-30 00:09:46,756 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,756 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type main
2013-10-30 00:09:46,758 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,758 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Child Of
2013-10-30 00:09:46,760 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,760 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Synonym
2013-10-30 00:09:46,762 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,762 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type analysis for
2013-10-30 00:09:46,763 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,763 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Extracted
2013-10-30 00:09:46,764 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,764 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type part of
2013-10-30 00:09:46,766 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,766 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Derives
2013-10-30 00:09:46,767 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,767 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type stakeholder
2013-10-30 00:09:46,768 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,768 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Link To
2013-10-30 00:09:46,771 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,771 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Embeds
2013-10-30 00:09:46,772 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,772 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type References
2013-10-30 00:09:46,773 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,773 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Elaborated By
2013-10-30 00:09:46,774 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,774 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Tracked By
2013-10-30 00:09:46,775 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,775 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Affected By
2013-10-30 00:09:46,776 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,776 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type user
2013-10-30 00:09:46,777 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,777 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type source of impact distribution
2013-10-30 00:09:46,779 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,779 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type specification for
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - No project found for id d866475b2700e19876e24f7d4efe20d8
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Could not transform link type Specified By
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - Failure threshold 20 exceeded
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0] ERROR house.service.rrc.internal.etlbuild.RRCLinkTypeETL  - java.sql.SQLException
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Transforming [row]' from 'RRCLinkTypeETL::execute(?,...)'
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: Name:impact distribution @@ UUID:16069385fdf8899affdcb856ee192875 @@ URL:https://tools.apsp.accenture.com/rm/types/_MFW28O8dEeKblZjh5QCHIA @@ ProjectUUID:d866475b2700e19876e24f7d4efe20d8 @@ SubjToObj:source of impact distribution @@ ObjToSubj:impacts @@ Type:
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'CALL' from 'RRCLinkTypeETL::transformRecord(?, record)'
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: name=Specified By; UUID=2db13bd5cd3a88b7b06fde2117f2f4aa; datasrcId=_V3N-gs0vEeKl0fvb071gGQRRC; extKey2=_Dx4k4O8dEeKblZjh5QCHIA; subjToObj=Specified By; objToSubj=Specifies; projectUUID=d866475b2700e19876e24f7d4efe20d8; URL=https://tools.apsp.accenture.com/rm/types/_Dx4k4O8dEeKblZjh5QCHIA; lookupPrjId=-1; lookupLnkTypeId=-1
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Extracting external key 2 [row]' from 'RRCLinkTypeETL::execute(?,...)'
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: Name:specification @@ UUID:697f6273b56c84a3710105480fc23a1d @@ URL:https://tools.apsp.accenture.com/rm/types/_L71uke8dEeKblZjh5QCHIA @@ ProjectUUID:d866475b2700e19876e24f7d4efe20d8 @@ SubjToObj:specification for @@ ObjToSubj:specification @@ Type:
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Processing [row]' from 'RRCLinkTypeETL::execute(?,...)'
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: Name:specification @@ UUID:697f6273b56c84a3710105480fc23a1d @@ URL:https://tools.apsp.accenture.com/rm/types/_L71uke8dEeKblZjh5QCHIA @@ ProjectUUID:d866475b2700e19876e24f7d4efe20d8 @@ SubjToObj:specification for @@ ObjToSubj:specification @@ Type:
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Transforming [row]' from 'RRCLinkTypeETL::execute(?,...)'
2013-10-30 00:09:46,780 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: Name:specification @@ UUID:697f6273b56c84a3710105480fc23a1d @@ URL:https://tools.apsp.accenture.com/rm/types/_L71uke8dEeKblZjh5QCHIA @@ ProjectUUID:d866475b2700e19876e24f7d4efe20d8 @@ SubjToObj:specification for @@ ObjToSubj:specification @@ Type:
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'CALL' from 'RRCLinkTypeETL::transformRecord(?, record)'
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: name=Specified By; UUID=2db13bd5cd3a88b7b06fde2117f2f4aa; datasrcId=_V3N-gs0vEeKl0fvb071gGQRRC; extKey2=_Dx4k4O8dEeKblZjh5QCHIA; subjToObj=Specified By; objToSubj=Specifies; projectUUID=d866475b2700e19876e24f7d4efe20d8; URL=https://tools.apsp.accenture.com/rm/types/_Dx4k4O8dEeKblZjh5QCHIA; lookupPrjId=-1; lookupLnkTypeId=-1
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Extracting external key 2 [row]' from 'RRCLinkTypeETL::execute(?,...)'
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: Name:Specified By @@ UUID:2db13bd5cd3a88b7b06fde2117f2f4aa @@ URL:https://tools.apsp.accenture.com/rm/types/_Dx4k4O8dEeKblZjh5QCHIA @@ ProjectUUID:d866475b2700e19876e24f7d4efe20d8 @@ SubjToObj:Specified By @@ ObjToSubj:Specifies @@ Type:
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Processing [row]' from 'RRCLinkTypeETL::execute(?,...)'
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: Name:Specified By @@ UUID:2db13bd5cd3a88b7b06fde2117f2f4aa @@ URL:https://tools.apsp.accenture.com/rm/types/_Dx4k4O8dEeKblZjh5QCHIA @@ ProjectUUID:d866475b2700e19876e24f7d4efe20d8 @@ SubjToObj:Specified By @@ ObjToSubj:Specifies @@ Type:
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Preceding event: 'Transforming [row]' from 'RRCLinkTypeETL::execute(?,...)'
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: Name:Specified By @@ UUID:2db13bd5cd3a88b7b06fde2117f2f4aa @@ URL:https://tools.apsp.accenture.com/rm/types/_Dx4k4O8dEeKblZjh5QCHIA @@ ProjectUUID:d866475b2700e19876e24f7d4efe20d8 @@ SubjToObj:Specified By @@ ObjToSubj:Specifies @@ Type:
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  - Suspect event: 'CALL' from 'RRCLinkTypeETL::transformRecord(?, record)'
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer  -    Event subject: name=Specified By; UUID=2db13bd5cd3a88b7b06fde2117f2f4aa; datasrcId=_V3N-gs0vEeKl0fvb071gGQRRC; extKey2=_Dx4k4O8dEeKblZjh5QCHIA; subjToObj=Specified By; objToSubj=Specifies; projectUUID=d866475b2700e19876e24f7d4efe20d8; URL=https://tools.apsp.accenture.com/rm/types/_Dx4k4O8dEeKblZjh5QCHIA; lookupPrjId=-1; lookupLnkTypeId=-1
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  WARN ouse.service.rrc.internal.RemoteRRCSnapshotService  - com.ibm.team.datawarehouse.service.rrc.internal.etlbuild.RRCLinkTypeETL failed to complete
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0] ERROR ouse.service.rrc.internal.RemoteRRCSnapshotService  - !!!com.ibm.team.datawarehouse.service.rrc.internal.RemoteRRCSnapshotService has failed. Aborting all the jobs !!!
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - -=REQUIREMENTS=-
2013-10-30 00:09:46,781 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - End of loading requirements
2013-10-30 00:09:46,802 [ jts: AsynchronousTaskRunner-0]  INFO ouse.service.rrc.internal.RemoteRRCSnapshotService  - -=END=-
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  - -= RRC ETL Metrics =-
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  - Duration values are represented in seconds. The suboperations are indented according to their level.
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  - 'Requirements Composer ETL jobs'           Runs: 1 Total (s): 3.75
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -    'Load all RRC link types'               Runs: 1 Total (s): 3.71
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -            'Get page - RRC link types'             Runs: 1 Total (s): 3.66
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -            'Load page - RRC link types'            Runs: 1 Total (s): 0.06
2013-10-30 00:09:46,803 [ jts: AsynchronousTaskRunner-0]  INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics  -
2013-10-30 00:10:47,456 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Started executing Fact build (com.ibm.team.datawarehouse.service.starjobs.internal.StarRemoteSnapshotService)
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - successfully completed clean up with date id
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.cleanupfacts.CleanupFactsSQL********************
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Fact Tables Deleted = 93
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Batch update count = 93
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Fact Tables Deleted with the where clause of date id= 46
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Batch update count = 46
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:47,818 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Cleanup Fact tables passed, continue executing fact jobs
2013-10-30 00:10:48,069 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestClassificationDimension" passed
2013-10-30 00:10:48,070 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProgramDimension=>SELECT DISTINCT PROGRAM_ID, NAME, ISSOFTDELETED FROM RIODS.PROGRAM WHERE PROGRAM_ID>-1"
2013-10-30 00:10:48,073 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProgramDimension********************
2013-10-30 00:10:48,073 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 0
2013-10-30 00:10:48,073 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:48,073 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 0
2013-10-30 00:10:48,073 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:48,073 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProgramDimension" passed
2013-10-30 00:10:48,073 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProgramProjectDimension=>SELECT PJ.PROGRAM_ID AS PROGRAM_ID, PJ.PROJECT_ID, PJ.NAME, PC.NAME AS TYPE_NAME, PJ.ISSOFTDELETED FROM RIODS.PROJECT PJ JOIN RIODS.PROJECT_CLASSIFICATION PC ON PC.PROJECT_CLASS_ID=PJ.PROJECT_CLASS_ID WHERE PJ.PROJECT_ID>-1"
2013-10-30 00:10:48,183 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProgramProjectDimension********************
2013-10-30 00:10:48,183 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 4
2013-10-30 00:10:48,183 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:48,183 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 4
2013-10-30 00:10:48,183 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:48,186 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProgramProjectDimension" passed
2013-10-30 00:10:48,186 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProductDimension=>SELECT PRODUCT_ID, NAME, ISSOFTDELETED FROM RIODS.PRODUCT"
2013-10-30 00:10:48,210 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProductDimension********************
2013-10-30 00:10:48,210 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:48,210 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:48,210 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:48,210 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:48,212 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ProductDimension" passed
2013-10-30 00:10:48,213 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ReleaseDimension=>SELECT RELEASE_ID, NAME, ISSOFTDELETED FROM RIODS.RELEASE"
2013-10-30 00:10:48,250 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ReleaseDimension********************
2013-10-30 00:10:48,250 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:48,250 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:48,250 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:48,250 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:48,256 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ReleaseDimension" passed
2013-10-30 00:10:48,361 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestDimension********************
2013-10-30 00:10:48,361 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 7
2013-10-30 00:10:48,361 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:48,361 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 7
2013-10-30 00:10:48,361 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:48,364 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestDimension" passed
2013-10-30 00:10:48,364 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestStatusDimension=>SELECT REQUEST_STATUS_ID, NAME, ISSOFTDELETED FROM RIODS.REQUEST_STATUS"
2013-10-30 00:10:48,430 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestStatusDimension********************
2013-10-30 00:10:48,430 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 7
2013-10-30 00:10:48,430 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:48,430 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 7
2013-10-30 00:10:48,430 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:48,433 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestStatusDimension" passed
2013-10-30 00:10:48,578 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestSeverityDimension********************
2013-10-30 00:10:48,578 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 13
2013-10-30 00:10:48,578 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:48,578 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 13
2013-10-30 00:10:48,578 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:48,581 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestSeverityDimension" passed
2013-10-30 00:10:48,582 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestTypeDimension=>SELECT REQUEST_TYPE_ID, NAME, ISSOFTDELETED FROM RIODS.REQUEST_TYPE"
2013-10-30 00:10:49,738 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestTypeDimension********************
2013-10-30 00:10:49,739 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 31
2013-10-30 00:10:49,739 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:49,739 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 31
2013-10-30 00:10:49,739 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:49,741 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestTypeDimension" passed
2013-10-30 00:10:49,822 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TeamDimension" passed
2013-10-30 00:10:50,020 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestCategoryDimension********************
2013-10-30 00:10:50,020 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 4
2013-10-30 00:10:50,020 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:50,020 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 4
2013-10-30 00:10:50,020 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:50,022 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestCategoryDimension" passed
2013-10-30 00:10:50,023 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestPriorityDimension=>SELECT REQUEST_PRIORITY_ID, NAME, ISSOFTDELETED FROM RIODS.REQUEST_PRIORITY"
2013-10-30 00:10:50,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestPriorityDimension********************
2013-10-30 00:10:50,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 9
2013-10-30 00:10:50,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:50,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 9
2013-10-30 00:10:50,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:50,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestPriorityDimension" passed
2013-10-30 00:10:50,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL : Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestStateDimension=>SELECT REQUEST_STATE_ID, NAME FROM RIODS.REQUEST_STATE"
2013-10-30 00:10:55,114 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestStateDimension********************
2013-10-30 00:10:55,114 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 179
2013-10-30 00:10:55,114 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,114 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 179
2013-10-30 00:10:55,114 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,117 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequestStateDimension" passed
2013-10-30 00:10:55,117 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: ***Started Build BuildDimension at 10/30/13 12:10 AM***
2013-10-30 00:10:55,117 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildDimension"
2013-10-30 00:10:55,117 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - SELECT BUILD_ID,NAME,BUILD_TYPE,ISSOFTDELETED FROM RIODS.BUILD
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildDimension********************
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Records Selected: 0
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Records Inserted: 0
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Records Updated: 0
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Inserting: 0ms
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Updating: Less than 1ms
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Looking Up: Less than 1ms
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Running: Less than 1ms
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: ***Finished Build BuildDimension at 10/30/13 12:10 AM. The build was successful***
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildDimension" passed
2013-10-30 00:10:55,140 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildClassificationDimension"
2013-10-30 00:10:55,304 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildClassificationDimension********************
2013-10-30 00:10:55,304 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 5
2013-10-30 00:10:55,304 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,304 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 5
2013-10-30 00:10:55,304 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,304 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildClassificationDimension" passed
2013-10-30 00:10:55,304 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildTypeDimension"
2013-10-30 00:10:55,307 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - SELECT     DISTINCT BUILD_TYPE FROM RIODS.BUILD   WHERE BUILD_TYPE is not null
2013-10-30 00:10:55,311 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildTypeDimension********************
2013-10-30 00:10:55,312 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 0
2013-10-30 00:10:55,312 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,312 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 0
2013-10-30 00:10:55,312 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,312 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.BuildTypeDimension" passed
2013-10-30 00:10:55,312 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionResultClassficationDimension=>SELECT EXECRES_CLASS_ID, NAME FROM RIODS.EXECRESULT_CLASSIFICATION"
2013-10-30 00:10:55,362 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionResultClassficationDimension********************
2013-10-30 00:10:55,362 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 4
2013-10-30 00:10:55,362 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,362 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 4
2013-10-30 00:10:55,363 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,363 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionResultClassficationDimension" passed
2013-10-30 00:10:55,363 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: ***Started Build ExecutionResultDimension at 10/30/13 12:10 AM***
2013-10-30 00:10:55,364 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionResultDimension=>SELECT E.EXECUTION_RESULT_ID, E.NAME, EC.NAME AS TYPE_NAME, ISSOFTDELETED FROM RIODS.EXECUTION_RESULT E JOIN RIODS.EXECRESULT_CLASSIFICATION EC ON EC.EXECRES_CLASS_ID=E.EXECRES_CLASS_ID"
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionResultDimension********************
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Records Selected: 0
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Records Inserted: 0
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Records Updated: 0
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Inserting: 0ms
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Updating: Less than 1ms
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Looking Up: Less than 1ms
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: Time Running: Less than 1ms
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0] DEBUG ervice.starjobs.internal.StarRemoteSnapshotService  - ETL: ***Finished Build ExecutionResultDimension at 10/30/13 12:10 AM. The build was successful***
2013-10-30 00:10:55,377 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionResultDimension" passed
2013-10-30 00:10:55,379 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionWorkItemDimension=>SELECT EW.EXECWORKITEM_ID, EW.NAME, EC.NAME AS TYPE_NAME, ISSOFTDELETED FROM RIODS.EXECUTION_WORKITEM EW JOIN RIODS.EXECWORKITEM_CLASSIFICATION EC ON EW.EXECWORKIT_CLASS_ID=EC.EXECWORKIT_CLASS_ID"
2013-10-30 00:10:55,391 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionWorkItemDimension********************
2013-10-30 00:10:55,391 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:55,391 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,391 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:55,391 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,391 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionWorkItemDimension" passed
2013-10-30 00:10:55,394 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionWorkItemClassificationDimension=>SELECT EXECWORKIT_CLASS_ID, NAME FROM RIODS.EXECWORKITEM_CLASSIFICATION"
2013-10-30 00:10:55,418 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionWorkItemClassificationDimension********************
2013-10-30 00:10:55,418 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 4
2013-10-30 00:10:55,418 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,418 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 4
2013-10-30 00:10:55,418 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,418 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ExecutionWorkItemClassificationDimension" passed
2013-10-30 00:10:55,418 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.IterationDimension=>SELECT ITERATION_ID, NAME, ISSOFTDELETED FROM RIODS.ITERATION"
2013-10-30 00:10:55,486 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.IterationDimension********************
2013-10-30 00:10:55,486 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 5
2013-10-30 00:10:55,486 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,486 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 5
2013-10-30 00:10:55,486 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,486 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.IterationDimension" passed
2013-10-30 00:10:55,487 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobDimension=>SELECT JOB_ID, NAME, ISSOFTDELETED FROM RIODS.JOB "
2013-10-30 00:10:55,506 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobDimension********************
2013-10-30 00:10:55,506 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:55,506 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,506 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:55,506 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,506 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobDimension" passed
2013-10-30 00:10:55,508 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobResultStateDimension=>SELECT DISTINCT UPPER(STATE) AS STATE FROM RIODS.JOB_RESULT WHERE STATE IS NOT NULL  AND LEN(STATE) >0 "
2013-10-30 00:10:55,510 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobResultStateDimension********************
2013-10-30 00:10:55,510 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 0
2013-10-30 00:10:55,511 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,511 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 0
2013-10-30 00:10:55,511 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobResultStateDimension" passed
2013-10-30 00:10:55,511 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobResultVerdictDimension=>SELECT DISTINCT UPPER(VERDICT) AS VERDICT FROM RIODS.JOB_RESULT WHERE VERDICT IS NOT NULL "
2013-10-30 00:10:55,514 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobResultVerdictDimension********************
2013-10-30 00:10:55,514 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 0
2013-10-30 00:10:55,514 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,514 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 0
2013-10-30 00:10:55,514 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,514 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.JobResultVerdictDimension" passed
2013-10-30 00:10:55,516 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.LabResourceDimension=>SELECT LAB_RESOURCE_ID, NAME, ISSOFTDELETED FROM RIODS .LAB_RESOURCE"
2013-10-30 00:10:55,531 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.LabResourceDimension********************
2013-10-30 00:10:55,531 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:55,531 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,531 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:55,531 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,531 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.LabResourceDimension" passed
2013-10-30 00:10:55,531 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementDimension=>SELECT REQUIREMENT_ID, NAME, REQUIREMENT_TYPE, ISSOFTDELETED FROM RIODS.REQUIREMENT "
2013-10-30 00:10:55,655 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementDimension********************
2013-10-30 00:10:55,655 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 3
2013-10-30 00:10:55,655 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:55,655 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 3
2013-10-30 00:10:55,656 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:55,656 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementDimension" passed
2013-10-30 00:10:55,658 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementClassificationDimension=>SELECT REQUIREMENT_CLASS_ID, NAME FROM RIODS.REQUIREMENT_CLASSIFICATION"
2013-10-30 00:10:56,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementClassificationDimension********************
2013-10-30 00:10:56,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 26
2013-10-30 00:10:56,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 26
2013-10-30 00:10:56,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:56,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementClassificationDimension" passed
2013-10-30 00:10:56,445 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - SELECT DISTINCT UPPER(PRIORITY) AS PRIORITY FROM RIODS.REQUIREMENT where PRIORITY is not null
2013-10-30 00:10:56,447 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementPriorityDimension=>SELECT DISTINCT UPPER(PRIORITY) AS PRIORITY FROM RIODS.REQUIREMENT where PRIORITY is not null "
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementPriorityDimension********************
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 0
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records ignored  = 0
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 0
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementPriorityDimension" passed
2013-10-30 00:10:56,449 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - SELECT DISTINCT UPPER(REQUIREMENT_STATE) AS REQUIREMENT_STATE FROM RIODS.REQUIREMENT where REQUIREMENT_STATE is not null
2013-10-30 00:10:56,450 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementStateDimension=>SELECT DISTINCT UPPER(REQUIREMENT_STATE) AS REQUIREMENT_STATE FROM RIODS.REQUIREMENT where REQUIREMENT_STATE is not null "
2013-10-30 00:10:56,453 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementStateDimension********************
2013-10-30 00:10:56,453 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 0
2013-10-30 00:10:56,453 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,453 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records ignored  = 0
2013-10-30 00:10:56,453 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 0
2013-10-30 00:10:56,453 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:56,453 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementStateDimension" passed
2013-10-30 00:10:56,457 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementStatusDimension=>SELECT DISTINCT UPPER(STATUS) AS STATUS FROM RIODS.REQUIREMENT where STATUS is not null "
2013-10-30 00:10:56,461 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementStatusDimension********************
2013-10-30 00:10:56,461 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 0
2013-10-30 00:10:56,461 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,461 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records ignored  = 0
2013-10-30 00:10:56,461 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 0
2013-10-30 00:10:56,461 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:56,461 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.RequirementStatusDimension" passed
2013-10-30 00:10:56,464 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ResourceGroupDimension=>SELECT RESOURCE_GROUP_ID, NAME, ISSOFTDELETED FROM RIODS .RESOURCE_GROUP "
2013-10-30 00:10:56,495 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ResourceGroupDimension********************
2013-10-30 00:10:56,495 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:56,495 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,495 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:56,495 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:56,495 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.ResourceGroupDimension" passed
2013-10-30 00:10:56,497 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseDimension=>SELECT T.TESTCASE_ID,T.NAME,TC.NAME AS TYPE_NAME, T.ISSOFTDELETED FROM RIODS.TESTCASE T JOIN RIODS.TESTCASE_CLASSIFICATION TC ON T.TESTCASE_CLASS_ID=TC.TESTCASE_CLASS_ID "
2013-10-30 00:10:56,497 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseDimension=>SELECT T.TESTCASE_ID,T.NAME,TC.NAME AS TYPE_NAME, T.ISSOFTDELETED FROM RIODS.TESTCASE T JOIN RIODS.TESTCASE_CLASSIFICATION TC ON T.TESTCASE_CLASS_ID=TC.TESTCASE_CLASS_ID "
2013-10-30 00:10:56,539 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseDimension********************
2013-10-30 00:10:56,539 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:56,539 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,539 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:56,539 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:56,539 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseDimension" passed
2013-10-30 00:10:56,542 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseClassificationDimension=>SELECT TESTCASE_CLASS_ID, NAME FROM RIODS.TESTCASE_CLASSIFICATION"
2013-10-30 00:10:56,680 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseClassificationDimension********************
2013-10-30 00:10:56,680 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 4
2013-10-30 00:10:56,681 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,681 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 4
2013-10-30 00:10:56,681 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************
2013-10-30 00:10:56,681 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (STAR): Dimension build "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseClassificationDimension" passed
2013-10-30 00:10:56,682 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Java ETL (ODS): Started executing query: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseStateDimension=>SELECT TESTCASE_STATE_ID, NAME, TEST_STATUS_ID, ISSOFTDELETED FROM RIODS.TESTCASE_STATE "
2013-10-30 00:10:56,687 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - ***********com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TestCaseStateDimension********************
2013-10-30 00:10:56,687 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Selected = 1
2013-10-30 00:10:56,688 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Inserted into DataWarehouse = 0
2013-10-30 00:10:56,688 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records ignored  = 0
2013-10-30 00:10:56,688 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - Total Records Updated into DataWarehouse = 1
2013-10-30 00:10:56,688 [ jts: AsynchronousTaskRunner-0]  INFO ervice.starjobs.internal.StarRemoteSnapshotService  - *************************************************************

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.