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

Article Id: 32877

Status: Published

Updated On: 14-02-2018 08:21

Legacy Id: TEC1857735

Products:

SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , 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: