Created On:  



If you are using the Japanese version of SilkCentral Test Manager and go to the Reports section there is an issue with the default parameters of the trend reports. These reports are located under the Performance Trend Reports folder.

The default parameters work fine with the English and German versions of SilkCentral Test Manager. However if you are using the Japanese version you will get the following display when accessing the Data tab with the default parameters still set.

The English translation of this error is "Could not execute report query: Conversion failed when converting datetime from character string".

The following will also be found in your FrontendServer log file:

I;OV;2008-11-07;01:34:59;BCA;http-19120-3;Could not execute report query
E;OV;2008-11-07;01:34:59;BCA;http-19120-3;java.sql.SQLException: 文字列から datetime 型に変換中、変換に失敗しました

I have also attached the full trace from the FrontendServer.log file for your reference.


This issue is caused by the fact that default values in the Parameters tab are not valid date format for Japanese operating systems and databases.

The method to workaround this issue is as follows:

1. Open Parameters tab and click Edit Parameters button
2. Change to date values with correct format depending on your database configuration.

For example, instead of 01-JAN-2000 change to:

SQL Server: 2000-01-01
Oracle: 00-01-01