search cancel

OPENQUERY string length limitation causes processing steps to fail

book

Article ID: 202514

calendar_today

Updated On:

Products

Information Centric Analytics Data Loss Prevention Core Package

Issue/Introduction

The RiskFabric Processing job fails on the step Calculate Risk Scores with an error similar to the following:

Error Msg: The character string that starts with 'SELECT NON EMPTY{[Measures].[DIM Incident Count]}ON 0,NON EMPTY {[User].[User ID].CHILDREN}ON 1FROM(SELECT({[DIM Incident Individ' is too long. Maximum length is 8000.

Processing jobs may also fail while processing event scenarios with an error similar to the following:

Error Msg: Exit processing of ScenarioID = 50001 The character string that starts with 'SELECT ... FROM(SELEC' is too long. Maximum length is 8000.

Environment

Release : 6.5.3, 6.5.4

Component : Risk Vectors, Event Scenarios, Entity Collections

Cause

Event Scenario and Risk Vector processing use an OPENQUERY function to retrieve data from the RiskFabric Analysis Services database (ASDB). The OPENQUERY function has a hardcoded string length limitation of 8 KB (8,000 characters).

Resolution

Information Centric Analytics (ICA) has been updated in 6.5.4 MP1 (6.5.4.0100) to circumvent the OPENQUERY string length limitation.

Additional Information

Microsoft OPENQUERY Transact-SQL reference document:

https://docs.microsoft.com/en-us/sql/t-sql/functions/openquery-transact-sql