What to do when "Creation of the Data Warehouse failed" on a German MS SQL server 2008 ?
A failing STAR ETL job was found to be caused by an error message in /jts/setup when creating the data warehouse tables. The error message is:
CRRTC8030E Die Erstellung des Data Warehouse ist fehlgeschlagen.
com.ibm.team.repository.common.TeamRepositoryException: INSERT INTO RIDW.D_DATE (DATE_ID,PERIOD_START_DATE ,DAY_OF_WEEK,DAY_OF_MONTH,DAY_OF_YEAR,DAY_NAME,WEEK_OF_MONTH,WEEK_OF_YEAR,WEEK_NO,MONTH_OF_YEAR,MONTH_NAME,MONTH_NO,QUARTER_OF_YEAR,QUARTER_NO,YEAR_OF,DAY_OF_WEEK_ISO,WEEK_OF_MONTH_ISO,WEEK_OF_YEAR_ISO,WEEK_NO_ISO) VALUES (-1,'1899-12-31',-1,-1,-1,'No dayname',-1,-1,-1,-1,'No month',-1,-1,-1,-1,-1,-1,-1,-1)The error states that one can try again to create the tables and no more error is displayed.
But then all ETL jobs will be failing; most notably the STAR job.
Using the manual steps for DWH creation with repotools will give the same error message.
This works fine instead on an English MS SQL server, but fails on German MS SQL Server 2008 and Express Edition.
CLM application will work fine, but no historical data will be collected.
One answer
As a workaround you can change the default language of the SQL userid to English.
Remove the broken data ware House DB.
In SQL server Management Studio, right click on the user you had created earlier for the data ware house DB.
Click "Login Properties" and switch the "Default Language" to English.
Then run the JTS setup page again and create the data ware house tables successfully.
Remove the broken data ware House DB.
In SQL server Management Studio, right click on the user you had created earlier for the data ware house DB.
Click "Login Properties" and switch the "Default Language" to English.
Then run the JTS setup page again and create the data ware house tables successfully.