search cancel

Load DWH error: DWH TZ - Can not convert value [1,0] to number! For input string: "1,0"

book

Article ID: 229689

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Since we upgraded to Clarity 16.0.0 out Load DWH job is failing with the following error:

DWH TZ - Can not convert value [1,0] to number! For input string: "1,0"

The bg-dwh.log file shows the following errors:

ERROR 2021-11-23 20:30:02,498 [Thread-308] dwh.event DWH TZ - Can not convert value [1,0] to number! For input string: "1,0"

ERROR 2021-11-23 20:30:02,501 [Thread-308] dwh.event DWH Time Abort - The Data Warehouse Date is Different than the Transactional Database Date.

 

 

Resolution

Go to the CSA > Server Properties > Application

Under the Application Instance: nsa section > 'Java VM Parameters' add the following parameter: -Duser.country=US -Duser.language=en

Go to the CSA > Server Properties > Background > > 'Java VM Parameters' 

Add the following parameter: -Duser.country=US -Duser.language=en

 

 

 

Additional Information

The bg-system.log file shows the following errors:

2021/12/02 02:00:31.820 | java.text.ParseException: Unparseable date: "01/Dec/2021:22:51:11 +0100"
2021/12/02 02:00:31.820 |      at java.base/java.text.DateFormat.parse(DateFormat.java:395)
2021/12/02 02:00:31.820 |      at com.niku.content.loganalysis.LogDiscovery.processLogIntoDatabase(LogDiscovery.java:258)
2021/12/02 02:00:31.820 |      at com.niku.content.loganalysis.job.LogDiscoveryJob.autoDiscoverLogs(LogDiscoveryJob.java:280)
2021/12/02 02:00:31.820 |      at com.niku.content.loganalysis.job.LogDiscoveryJob.execute(LogDiscoveryJob.java:145)
2021/12/02 02:00:31.820 |      at com.niku.content.loganalysis.job.LogDiscoveryJob.scheduledEventFired(LogDiscoveryJob.java:96)
2021/12/02 02:00:31.820 |      at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:746)
2021/12/02 02:00:31.820 |      at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2021/12/02 02:00:31.820 |      at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2021/12/02 02:00:31.820 |      at java.base/java.lang.Thread.run(Thread.java:829)