error in dbcollector.log : Column 'ASSIGNED_USER_UUID' not found in SHR_4930_EVENTEXT

hello,

 

i found this error in default installation:

 

ERROR, com.hp.bto.bsmr.collection.collector.db.DataProcessor.dumpJoinData , [ ABCBatchID:147806, ABCStreamID:PMDB_Platform@platform_poller_db_data_process, ABCStepID:Process_DB_Data, ABCProcessID:147807 ] Error occurred while processing extracted data with query select
SHR_4930_EVENTEXT.ID,
SHR_4930_EVENTEXT.TITLE,
SHR_4930_EVENTEXT.DESCRIPTION,
SHR_4930_EVENTEXT.SOLUTION,
SHR_4930_EVENTEXT.CIRES_STATUS,
SHR_4930_EVENTEXT.NODEHINTS_HINT,
SHR_4930_EVENTEXT.RELATED_CI_HINT,
SHR_4930_EVENTEXT.OM_SERVICE_ID,
SHR_4930_EVENTEXT.SOURCECIHINTS_HINT,
SHR_4930_EVENTEXT.UA_CALL,
SHR_4930_EVENTEXT.AA_CALL,
SHR_4930_EVENTEXT.EVENT_KEY,
SHR_4930_EVENTEXT.CLOSE_KEY_PATTERN,
SHR_4930_EVENTEXT.ORIGINAL_DATA,
SHR_4930_EVENTEXT.OBJECT,
(CASE WHEN SHR_4930_EVENTEXT.CIREF_ID = 'NotFound' or SHR_4930_EVENTEXT.CIREF_ID is null Then 'CI_Unknown' Else SHR_4930_EVENTEXT.CIREF_ID END) as CIREF_ID,
(CASE WHEN SHR_4930_USERS.user_name = 'NotFound' or SHR_4930_USERS.user_name is null Then 'User_Unknown' Else SHR_4930_USERS.user_name END) as user_name,
(CASE WHEN SHR_4930_GROUPS.group_name = 'NotFound' or SHR_4930_GROUPS.group_name is null Then 'GroupName_Unknown' Else SHR_4930_GROUPS.group_name END) as group_name
FROM SHR_4930_EVENTEXT, SHR_4930_USERS, SHR_4930_GROUPS
WHERE SHR_4930_EVENTEXT.ASSIGNED_USER_UUID *= SHR_4930_USERS.USER_ID
AND SHR_4930_EVENTEXT.ASSIGNED_GROUP_UUID *= SHR_4930_GROUPS.GROUP_ID. Cause : SQL Anywhere Error -143: Column 'ASSIGNED_USER_UUID' not found

 

 

any idea how to fix it ?

 

thx,

R

Parents Reply Children