All Forums Database
Sram 21 posts Joined 03/16
05 Apr 2016
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'.

dnoeth 4628 posts Joined 11/04
05 Apr 2016

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

Dieter

Sram 21 posts Joined 03/16
05 Apr 2016

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 ?
 

dnoeth 4628 posts Joined 11/04
05 Apr 2016

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 '|'?

Dieter

anu.priya 1 post Joined 04/16
21 Apr 2016

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!

 

 

 
 

You must sign in to leave a comment.