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

book

Article ID: 19489

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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.

Environment

Release: SWAMFC059000-12.7-Software Asset Manager-Flow Control
Component:

Attachments

1558534849838TEC601583.zip get_app