Incorrect syntax near the keyword 'ON' error for custom attribute in list_nr.htmpl

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

When a developer customizes the object adding two attributes

zattr1       SREL -> nr.id
zattr2       SREL -> zattr1.id

and modify the list_nr.htmpl file to include the custom attribute

<PDM_MACRO name=lsCol hdr="zattr2" attr=zattr1.zattr2 startrow="no">

the configuration items don't display in list_nr.htmpl, and stdlog has error messages

07/15 15:32:44.44 <server-name> sqlagt:select21         9932 ERROR        sqlclass.c            1016 SQL Execute  failed: [Microsoft SQL Server Native Client 11.0] [ SQL Code=102 SQL State=42000] Incorrect syntax near 'ca_owned_resource'.; [Microsoft SQL Server Native Client 11.0] [ SQL Code=156 SQL State=42000] Incorrect syntax near the keyword 'ON'.
07/15 15:32:44.44 <server-name> sqlagt:select21         9932 ERROR        sqlclass.c            1017 Clause (SELECT ca_owned_resource.own_resource_uuid, ca_owned_resource.resource_name, ca_resource_family.table_extension_name, ca_resource_class.name, ca_resource_family.name, ca_owned_resource.serial_number, ca_owned_resource.product_version, zattr1.Name, bool_tab.sym, cn02_Boolean_Table.sym, ca_company.company_name, ca_resource_family.table_extension_name, ca_resource_class.name, ca_resource_family.name, ca_owned_resource.serial_number, ca_owned_resource.product_version, bool_tab.sym, cn02_Boolean_Table.sym, zattr1.Name FROM (ca_owned_resource LEFT JOIN ca_resource_family ON ca_owned_resource.resource_family = ca_resource_family.id LEFT JOIN ca_model_def ON ca_owned_resource.model_uuid = ca_model_def.model_uuid LEFT JOIN ca_company ON ca_model_def.manufacturer_uuid = ca_company.company_uuid) LEFT JOIN ON ca_owned_resource.own_resource_uuid = cn01_usp_owned_resource.owned_resource_uuid, (usp_owned_resource LEFT JOIN usp_owned_resource cn01_usp_owned_resource ON usp_owned_resource.zattr1 = cn01_usp_owned_resource.owned_resource_uuid LEFT JOIN zattr1 ON cn01_usp_owned_resource.zattr2 = zattr1.id), bool_tab cn02_Boolean_Table, bool_tab, ca_resource_class WHERE ( ( ( ( ca_owned_resource.own_resource_uuid IN (?,?,?) ) ) AND ca_owned_resource.resource_class = ca_resource_class.id ) AND ca_owned_resource.is_asset = bool_tab.enum ) AND ca_owned_resource.is_ci = cn02_Boolean_Table.enum) Input (<uuid><uuid-1>|<uuid><uuid-2>|<uuid><uuid-3>)

Environment

• CA Service Desk Manager all versions

Cause

There is a product defect causing this issue.

Resolution

This is a known issue and the fix will be included in the next product fix patch. For more info, open a Broadcom Support case with product Support team.