When using the Analyst Queue capability of CA Service Desk Manager (CA SDM) Mobile Enabler 2.0, the following errors may be received: Error:100 or Alert:100

Document ID : KB000019489
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When using the Analyst Queue capability of CA SDM Mobile Enabler 2.0, the following errors may be received: Error:100 or Alert:100. The error seems to be the same whether you try the capability from a real mobile device or a browser like Google Chrome.

Solution:

If a user is trying to access the CA SDM Mobile Enabler 2.0's Analyst Queue interface, an Error:100 or Alert:100 message would be displayed if the user's role in CA SDM contains Scoreboard Queries with underlying Stored Queries that are not supported.

A list of such queries is documented in the CA SDM Mobile Enabler Release Notes. Currently we do not support scoreboard queries in which the where clause contains the following pattern:

  • Queries consisting any TIME bound constants like TODO_TODAY, TODAY, NEXT_WEEK. For example, the 'Issues To Do' query has the following where clause:
    assignee = @cnt.id AND active = 1 AND call_back_flag = 1 AND call_back_date < EndAtTime(\'TODO_TODAY\')
  • Queries consisting Square brackets [ ], like [group], [contact]. For example, the 'My Group Requests' query has the following where clause:
    (group.[group]group_list.member IN (@cnt.id)) AND active = 1
  • Queries consisting of dotted notation, that is '.'. For example, the 'Change Orders - All Resolved Conflicts' query has the following syntax:
    conflicts.conflict.is_resolved=1 AND conflicts.conflict.delete_flag=0

There is no known solution for this issue at the moment.

File Attachments:
TEC601583.zip