Access module error '61' in mload insert

Database
Enthusiast

Access module error '61' in mload insert

Hi Team,

iam inserting data into table using txt file through mload.iam geeting below error.please help me out.

**** 16:21:03 UTY4014 Access module error '61' received during 'pmReadDDparse'

     operation: 'Warning, too few columns !ERROR! Delimited Data Parsing error:

     Too few columns in row 1'

**** 16:21:03 UTY1803 Import processing statistics

     .                                       IMPORT  1     Total thus far

     .                                       =========     ==============

     Candidate records considered:........           0.......           0

     Apply conditions satisfied:..........           0.......           0

     Candidate records not applied:.......           0.......           0

     Candidate records rejected:..........           0.......           0

**** 16:21:03 UTY1821 Aquisition Phase statistics

     Elapsed time:  00:00:02

     CPU time:      0 Seconds

     MB/sec:        0

     MB/cpusec:     N/A

     ========================================================================

     =                                                                      =

     =          Logoff/Disconnect                                           =

     =                                                                      =

     ========================================================================

**** 16:21:04 UTY6215 The restart log table was not dropped by this task.

**** 16:21:04 UTY6212 A successful disconnect was made from the RDBMS.

**** 16:21:04 UTY2410 Total processor time used = '1.71 Seconds'

     .       Start : 16:20:57 - TUE APR 05, 2016

     .       End   : 16:21:04 - TUE APR 05, 2016

     .       Highest return code encountered = '12'.

5 REPLIES
Junior Contributor

Re: Access module error '61' in mload insert

The layout definition doesn't match you input file. Did you specify the correct delimiter?

Enthusiast

Re: Access module error '61' in mload insert

Hi Dieter,

yeah, my file has duplicate records.

i have file as below 

042|1450000|40.0|1488000

042|1450000|40.0|1488000

042|1450000|40.0|1488000

042|1450000|40.0|1488000

042|1450000|40.0|1488000

042|1450000|40.0|1488000

042|1450000|40.0|1488000

042|1450000|40.0|1488000

042|1438|40.0|144000

042|1438|40.0|144000

042|1438|40.0|144000

042|1438|40.0|144000

042|1438|40.0|144000

042|1438|40.0|144000

042|1438|40.0|144000

042|1438|40.0|144000

042|1438|40.0|144000

042|1444003200000|40.0

042|1446595200000|40.0

i want to load data into table. iwant duplicate record in my table. while iam doing through mload iam not able load.

iam using multiset table.pFB structure.

CREATE MULTISET TABLE tablename ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      col1 VARCHAR(100) CHARACTER SET LATIN CASESPECIFIC,

      col2 VARCHAR(100) CHARACTER SET LATIN CASESPECIFIC,

      col3 VARCHAR(100) CHARACTER SET LATIN CASESPECIFIC,

      col4 VARCHAR(100) CHARACTER SET LATIN CASESPECIFIC)

PRIMARY INDEX ( col1 );

is there any way to load data ?

Junior Contributor

Re: Access module error '61' in mload insert

Of course you can load duplicate rows using MLoad, but your script stopped at the first record.

What's your .IMPORT, does it include FORMAT VARTEXT '|'?

Re: Access module error '61' in mload insert

Hi ,

I'm also facing the same error when i tried to Mload a Tab delimited file.

My file has contents like this.

-1 -1 AEDW DEFAULT -1 AEDW DEFAULT -1 AEDW DEFAULT -1 AEDW DEFAULT -1 AEDW DEFAULT NoProd No Product Unknown Product NoProd No Product Unknown Product   NoProd No Product Unknown Product   NoProd No Product Unknown Product   NoProd No Product Unknown Product   NoProd No Product Unknown Product   NoProd No Product Unknown Product

Please help me out

Thanks!

 

Visitor

Re: Access module error '61' in mload insert

Hi,

I am facing a very similar issue like @Sram and @anu_priya. I have a tab delimited import file that has every row blank for the first column and it has values with certain blanks for other columns. With some research, I concluded that it is something to do with the first column being duplicate or blank since it is between the start of line and a delimiter and not between two delimiters. I have checked my script and am using the correct format as a similar script with a different file ran successfully. Can anyone help me out please. It is kind of an urgent issue to be addressed.
Tags (3)