UTY4014 Access module error '39' received during 'pmSetSchema' operation: 'Invalid UTF8 character

Tools
Fan

UTY4014 Access module error '39' received during 'pmSetSchema' operation: 'Invalid UTF8 character

Hello.


Im currently trying to migrate a multiload script import from a server to another. The datasets to import are the same and so are the scripts. The only difference is the client Teradata which is 14 in one server and 15 on the other. On the 14 client version server the dataset is imported with success.

 

On the 15 version server I get the following error:

 

UTY4014 Access module error '39' received during 'pmSetSchema'
operation: 'Invalid UTF8 character encountered !ERROR! Specified
'Delimiter' character is not a valid UTF8 character'

 

Where can I see what is the character that has any issues?

Also were the any changes between 14 and 15 client version in regards to parsing of utf8 character?

 

Database is in version 15.

 

This is a sample of the dataset:

HEADER201706261572
N9145143 705691016052252495 A1930-05-14MN150167482 Luis Leao Av dom Afonso Henriques 799 2esq Guimaraes 4810-431 Braga PTNao@tem.pt 12017-06-25PT A966678559
N9144927 705691016051599482 A1954-02-08FN166427209 Maria Glória Santos Rua Carolina Michaelis Nº327 1ºcasa2 Águas Santas 4425-040 Porto PTdianapatricia_mo@hotmail.com 12017-06-25PT A912649757
N9107396 705691016051501728 A1992-06-24MN246884878 Jpereira46 João Pereira 1 Rua da Corga n°4 lajinhas Branca 3850-576 Aveiro PTJoaopereira11c8@gmail.com 12017-06-26PT A912323877

 

Thanks for the help.

 

  • UTF8
2 REPLIES
Teradata Employee

Re: UTY4014 Access module error '39' received during 'pmSetSchema' operation: 'Invalid UTF8 characte

Hello ricvie,

 

What is the delimiter character used?

The issue is with the delimiter character specified in the script.

There will be a command like the following in your script.

 

.IMPORT INFILE TEDA1001 format vartext  '|'
               LAYOUT LAY1001
               APPLY LABEL1001A;

 

In this command '|' is the delimiter character.

There were no changes between 14 and 15 client version in regards to parsing of utf8 character?

Please use od -x 'multiload script name' and check if the hex value of delimiter charater is same in both the scripts.

 

Fan

Re: UTY4014 Access module error '39' received during 'pmSetSchema' operation: 'Invalid UTF8 characte

Hi. Thanks for the reply.

It seems to be the delimiter yes.

I was using the command mload -c UTF8.


Now I am using mload -c UTF8  -i UTF8 and it is working fine.

Weird it was working before in another server.

 

Thanks for the help.