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
Release : 17.3
Component : SDM KNOWLEDGE MANAGEMENT
Update value as below in Nx.env and recycle services:
Now export is successful with custom field.