When attempting to process the DLP cubes the dimension Network Incident - Protocol throws an error preventing processing from completing successfully.
Error: OLE DB error: OLE DB or ODBC error: Invalid length parameter passed to the RIGHT function.; 42000. Errors in the OLAP storage engine: An error occurred while the 'Network Incident - Protocol' attribute of 'DLP Network Incident Protocol' dimension from the 'ITAnalytics' database was being processed.
The SQL view that is used to pull the 'Network Incident - Protocol' dimension was designed to expect that all protocal names pulled from the DLP database would contain either a colon ':' or a period '.'. If a protocol name doesn't contain one of these characters an error is generated.
This will be addressed in a future release.
For those experiencing the issue now they can use the following information to update the view vITAnalytics_DLP_ProtocolDim
CASE WHEN CHARINDEX('.', PROTOCOLNAME) > 0 THEN
right(PROTOCOLNAME,charindex('.',reverse(PROTOCOLNAME))-1)
ELSE right(PROTOCOLNAME,charindex(':',reverse(PROTOCOLNAME))-1)
8. Replace this portion of code with
CASE WHEN CHARINDEX('.', PROTOCOLNAME) > 0 THEN
right(PROTOCOLNAME,charindex('.',reverse(PROTOCOLNAME))-1)
WHEN CHARINDEX(':', PROTOCOLNAME) > 0 THEN
right(PROTOCOLNAME,charindex(':',reverse(PROTOCOLNAME))-1)
ELSE PROTOCOLNAME
9. Execute the query to update the view.