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

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
• CA Service Desk Manager
• 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: