AHD04405 internal error is received during login whilst the following ERROR is written in the stdlog: SQL Parse error: parse error, expecting "(" at READ_PGROUP

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:

A work-around for avoiding the login problem is suggested in the Solution section.

Solution:

The symptoms are known to occur in some cases in which the value for the IN clause of the SKELETONS and O_INDEXES constraints for the Employee data partition is null.

The problem can be avoided by adding an extra set of parenthesis around "@root.role" in the following constraints:

SKELETONS View (READ_PGROUP in @root.pgroups OR READ_PGROUP.[pgroup]contained_roles.role IN @root.role) and ACTIVE_STATE = 0
O_INDEXES View READ_PGROUP in @root.pgroups OR READ_PGROUP.[pgroup]contained_roles.role IN @root.role

So, the constraints would then be:

SKELETONS View (READ_PGROUP in @root.pgroups OR READ_PGROUP.[pgroup]contained_roles.role IN (@root.role)) and ACTIVE_STATE = 0
O_INDEXES View READ_PGROUP in @root.pgroups OR READ_PGROUP.[pgroup]contained_roles.role IN (@root.role)

To modify the constraints, when logged in to Service Desk Manager and running under the Administrator role, open Security and Role Management, and within that click on Data Partitions and then Data Partition Constraints; in the Filter, enter Employee in the field named Data Partition, select View in Constraint Type field and then enter, in turn, SKELETONS and O_INDEXES in the Table Name field, and then click on Search. Modify the constraint by right-clicking on View in the row presented and then select Edit. Make the changes and then Save them.

Warning! The solution suggested above is a temporary solution in the case that Employee contacts cannot log in to Service Desk Manager. If you are hitting this situation and require a permanent code fix, please open an issue with CA Support.

Environment

Release:
Component: ARGIS