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