MLOAD - UTY4014 Access module error '43' received during 'set position' operation

Tools & Utilities
Teradata Employee

MLOAD - UTY4014 Access module error '43' received during 'set position' operation

Hello,

The script is working fine until i have receive this error.

**** 12:01:11 UTY0817 MultiLoad submitting the following request:

     BEGIN TRANSACTION;

**** 12:01:11 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 0;

**** 12:01:11 UTY0817 MultiLoad submitting the following request:

     CHECKPOINT LOADING INTERVAL 0;

**** 12:01:12 UTY4014 Access module error '43' received during 'set position'

     operation: 'Restart data signature does not match'

**** 12:01:12 UTY1821 Aquisition Phase statistics

     Elapsed time:  00:00:01

     CPU time:      0 Seconds

     MB/sec:        0

     MB/cpusec:     N/A

MLOAD is being call in a script.  This is a simple MLOAD job.  This has been tested on a different server, using the same permissions and details without any error at all.

This error occurs in the MultiLoad Acquisition Stage.  I would appreciate any kind of help or push in the right path.

Thank you.

3 REPLIES
Teradata Employee

Re: MLOAD - UTY4014 Access module error '43' received during 'set position' operation

ALWAYS include the version of MultiLoad you are running and the platform.

A 'set position' message generally implies the job is trying to recover from a restart.

Is this a brand new job?

If so, then it is possible that the restart log table from a previous job still exists (or this MultiLoad script has an incorrect name for the .LOGTABLE table name).

Perhaps more output from the MultiLoad job would provide some clues as to whether MultiLoad thinks the job is a restart or not.

-- SteveF
Teradata Employee

Re: MLOAD - UTY4014 Access module error '43' received during 'set position' operation

Hi Steve,

We have a script that generates the MLOAD script and every run, the script is generated from scratch based on parameters.

OS Linux

**** 12:01:05 UTY8400 Teradata Database Release: 14.00.07.16

**** 12:01:05 UTY8400 Teradata Database Version: 14.00.07.15

**** 12:01:05 UTY8400 Default character set: ASCII                         

**** 12:01:05 UTY8400 Current RDBMS has interval support

**** 12:01:05 UTY8400 Current RDBMS has UDT support

**** 12:01:05 UTY8400 Current RDBMS has Large Decimal support

**** 12:01:05 UTY8400 Current RDBMS has TASM support

**** 12:01:05 UTY8400 Maximum supported buffer size: 1M

**** 12:01:05 UTY8400 Data Encryption supported by RDBMS server

**** 12:01:06 UTY6211 A successful connect was made to the RDBMS.

**** 12:01:06 UTY6210 Logtable 'TEST_DWH_LOG.ML_CuenBEPS_1' indicates that a

     restart is in progress.

Thank you.

Regards,

Ty

Teradata Employee

Re: MLOAD - UTY4014 Access module error '43' received during 'set position' operation

Notice this line:

**** 12:01:06 UTY6210 Logtable 'TEST_DWH_LOG.ML_CuenBEPS_1' indicates that a

     restart is in progress.

So, you may think they are all new inidividual jobs, but in fact one or more of them think they are a restart of some previously run job.

And since your data does not match the last checkpoint, you will get that error.

Make sure the generated script has a unique restart log table. You do not want multiple MultiLoad jobs sharing the same one.

It will lead to problems.

-- SteveF