Unable to export KD documents with customized SREL attribute.

Products

• CA Service Desk Manager
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager - Mobile Application
• CA Service Desk Manager - Xtraction

Issue/Introduction

KD export fails when a custom SREL field is included in export fields list.

Environmental Details:
======================
USRD 17.3 RU1

Steps:
=====
1. In 17.3 RU1 machine added a column called z_group_owner under KD as SREL to grp table.

z_group_owner        SREL -> grp.id SERVICE_PROVIDER_ELIGIBLE

2. Updated Nx.env as below:

@NX_KEIT_AVAILABLE_FIELDS=TITLE,SUMMARY,PROBLEM,RESOLUTION,NOTES,USER_DEF_ID,STATUS_ID,PRIORITY_ID,OWNER_ID,AUTHOR_ID,SUBJECT_EXPERT_ID,ASSIGNEE_ID,START_DATE,EXPIRATION_DATE,REVIEW_DATE,SD_PRODUCT_ID,SD_ASSET_ID,SD_ROOTCAUSE_ID,SD_PRIORITY_ID,SD_SEVERITY_ID,SD_IMPACT_ID,SD_URGENCY_ID,DOC_TEMPLATE_ID,CUSTOM1,CUSTOM2,CUSTOM3,CUSTOM4,CUSTOM5,CUSTOM_NUM1,CUSTOM_NUM2,PUBLISHED_DATE,z_group_owner

@NX_KEIT_ADDL_FIELDS=z_group_owner.combo_name

3. Added in export fields as below:

4. Tried to export and got below error:

In logs noted below:
stdlog:
===== 

9/16 22:02:57.49 ibndev0044 keit_daemon             2444 ERROR        DomWrap.c              959 Failed to complete reply method: 'get_kd' ,BOP Name:'all-docs' in class:'Export_Main_Obj', Error:id, DOC_TYPE_ID, DOC_UUID, PRIMARY_INDEX.INDEX_PATH, TOP>test, CREATION_DATE, MODIFY_DATE, tenant.name, , TITLE, test, SUMMARY, test, PROBLEM, test, RESOLUTION, test, z_group_owner.sym, AHD03066:Unknown name: z_group_owner.sym
09/16 22:02:57.49 ibndev0044 keit_daemon             2444 ERROR        export.c               302 Export_Main_Obj::recvmsg() - Failed to export document -842150451
09/16 22:02:57.49 ibndev0044 keit_daemon             2444 SIGNIFICANT  export.c               313 Export_Main_Obj::recvmsg() -  Number of errors has reached threshold limit of 10%
09/16 22:02:57.49 ibndev0044 web:local               3136 ERROR        kt_admin.spl          1169 msg[0]=0; msg[1]='Number of errors have reached threshold limit of 1%.'; msg[2]='1'; msg[3]='1';-2
0
In keitinfo:

09/16 22:02:57.49 ibndev004144 keit_daemon             2444 ERROR        export.c               303 Export_Main_Obj::recvmsg() - Failed to export document -842150451

Environment

Release : 17.3

Component : SDM KNOWLEDGE MANAGEMENT

Resolution

Update value as below in Nx.env and recycle services:

@[email protected]

Now export is successful with custom field.