When extracting/importing MDB tables using pdm_extract/pdm_load utilities, getting "ERROR: Invalid row termination, expected }"

Products

• 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

Problem:

When importing some MDB tables (i.e. Notify_Msg_Tpl table) from CA Service Desk Manager (CA SDM) r12.5 to r14.1 using pdm_extract/pdm_load utilities, getting message "ERROR: Invalid row termination, expected }"

Cause:

The data contained within the MDB table(s) that are being imported contains the '{' and '}' characters.

For example: 

TABLE Notify_Msg_Tpl
notify_flag notify_level notify_msg_body notify_msg_body_html notify_msg_title obj_type
{"1000", "ntfm:1000", "0", "Dummy text", "1", "2", "Number @{change_id.chg_ref_num} , ........}

Workaround:

Edit using a Text editor (i.e. Notepad), modify the input file created by the PDM_EXTRACT utility and change

'{'  characters by \\0173

and

'}' characters by \\0175

Additional Information:

Similar error may also happen for a possible issue, which is already addressed.  Refer to the below link for additional information:

https://support.ca.com/irj/portal/kbproblem?docid=609915&productcd=USRD&problemnbr=2867#properties

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: