Arithmetic overflow in F_BUILD_REQU_METRICS_R
Defect Description
The Data Mart Data Collection build Build Facts could fail with an arithmetic overflow error.
Steps to reproduce:
Run the data collections (manually or scheduled). In cases where there is actual build metrics to collect from Rational Team Concert applications, the build could fail with an arithmetic overflow error thrown by the DBMS
Error Description/Symptom
03/07/2014 15:38:35,672 [dcc_etl_Fact_Build_RIDW_resource_3] ERROR Some issues occur when retrieving the resource 'F_BUILD_REQUI_METRICS_R'.
java.util.concurrent.ExecutionException: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.14.121
Resolution or workaround
To resolve this problem, you need to add a new fact_build.ttl file.
Steps to apply the fix:
- Shut down the application server (WebSphere Application Server or Tomcat) where the Data Collection Component war file is deployed.
- Go to the directory of /server/conf/dcc and back up the teamserver.properties file. Open the teamserver.properties file for editing and change the property from
com.ibm.rational.datacollection.initialized=true
to
com.ibm.rational.datacollection.initialized=false
Save and close the file
- Go to the directory of <Data Collection Component installation directory >/server/conf/dcc/mapping and back up the fact_build.ttl file (do not leave the .ttl extension in the backed up file, rename it to something like fact_build.bak.
- Download the updated fact_build.ttl file and save it into the directory of <Data Collection Component installation directory>/server/conf/dcc/mapping.
- Restart the application server where the Data Collection Component war file is deployed.
- Open the browser again and go to the DCC page, https://<server>:port/dcc/web, to the Data Collection Jobs tab.
- Run the Build Facts collection, the collection should complete without any arithmetic overflow errors