CA SDM pdm_load 537  Invalid character encountered in input - error

Document created by TMACUL Champion on Nov 5, 2015
Version 1Show Document
  • View in full screen mode

pdm_load is a useful way to data load


The pdm_load command may not like some characters within input data files, such as a tilde or apostophe.

 

If you are getting error like above

 

11/05 12:47:31.44 server_hostname dbload              27820 FATAL        tokfile.c             537  Invalid character encountered in input

 

2 ways:

 

1. pdm_uconv

 

Examples:

  • From local charset to UTF-8
    pdm_uconv -t utf-8 inputfile.txt > outputfile.txt
  • From specific charset (iso-2022-jp) to UTF-8
    pdm_uconv -f iso-2022-jp -t utf-8 inputfile.txt > outputfile.txt
  • From UTF-8 to local charset
    pdm_uconv -f utf-8 inputfile.txt > outputfile.txt
  • From UTF-8 to specific charset
    pdm_uconv -f utf-8 -t iso-2022-jp inputfile.txt > outputfile.txt

 

2. Save file using a text tool

 

CASDM_20151105_utf8.jpg

 

pdm_uconv--Convert Local Charset to UTF-8 - CA Service Management - 14.1 - CA Technologies Documentation

pdm_uconv--Conversión de un conjunto de caracteres local a UTF-8 - CA Service Management - 14.1 - Spanish - Spain

pdm_uconv - 将本地字符集转换为 UTF-8 - CA Service Management - 14.1 - Chinese - China

pdm_uconv – Konvertiert den lokalen Zeichensatz in UTF-8 - CA Service Management - 14.1 - German - Germany

pdm_uconv - Conversione di set di caratteri in UTF-8 - CA Service Management - 14.1 - Italian - Italy

pdm_uconv : Conversion du jeu de caractères local à UTF-8 - CA Service Management - 14.1 - French - France

pdm_uconv--ローカルの文字セットから UTF-8 への変換 - CA Service Management - 14.1 - Japanese - Japan

 

DEREF - pdm_deref - Everthing do you need know

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg

CA SDM Loading contacts pdm_load

Administration Guide r12.6

1 person found this helpful

Attachments

    Outcomes