ERROR TO EXECUTE JOB LOAD DATA WAREHOUSE 16.1.1

[Wilson Cardenas]

Hello, 


I actually install ca clarity 16.1.1, the health check is ok, but when i try execute the job load datawarehouse i return the next error:

Update Config Settings - An error occurred executing this job entry : 
Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS
SET    LANGUAGE_CODE_KEY = 1,
       LANGUAGE_CODE = 'en',
	   CURRENCY_PRECISION = 0,0,
	   WEEK_START_DAY = 1,

Basicly is for CURRENCY_PRECISION = 0,0, is not possible that. 

How i can update the script because i excecute manually this update and i delete the ,0 and the result was succesfully.

Attachment(s)

bg-dwh.log   116 KB 1 version

[Nika Hadzhikidi]

Wilson, looks like it's passing the currency precision wrongly as it should be a whole number. I got the Support case and looking into this for you

------------------------------
Nika Hadzhikidi
Sr Principal Support Engineer
Broadcom
------------------------------