FastLoad Error when trying to import...

Database
Enthusiast

FastLoad Error when trying to import...

Hello Everyone,

I am runnning into the error -> Query Failed. Refer to result column in History for details. <- Here is the script that I am running. Any suggestions? ]

DROP TABLE DLAB_MARKETING.ProfileAttributes;

CREATE MULTISET TABLE DLAB_MARKETING.ProfileAttributes ,NO FALLBACK ,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

(

SubscriberKey VARCHAR(125) CHARACTER SET LATIN NOT CASESPECIFIC,

FullName VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

EmailAddress VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

FirstName VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

LastName VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

ZipCode INTEGER,

StoreNumber INTEGER,

StoreAddress VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

StoreCity VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

StoreState CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,

StoreZip INTEGER,

State VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

Source_ VARCHAR(75) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

PhoneNumber INTEGER,

Address1 VARCHAR(150) CHARACTER SET LATIN NOT CASESPECIFIC,

Address2 VARCHAR(150) CHARACTER SET LATIN NOT CASESPECIFIC,

City VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

Gender CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,

MobilePhone INTEGER,

CR2StoreIntersection INTEGER,

CR2StoreCity VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

Pet INTEGER,

ShoppingFrequency INTEGER,

AgeToddler INTEGER,

AgeChildren6to17 INTEGER,

Age25To34 INTEGER,

Age18To24 INTEGER,

Age35To44 INTEGER,

Age45To54 INTEGER,

AdultApparel INTEGER,

Age55To64 INTEGER,

Age65orGreater INTEGER,

Dog INTEGER,

Cat INTEGER,

Groceries INTEGER,

Snacks INTEGER,

Cleaning INTEGER,

Q4NoAnswer INTEGER,

AgeInfant INTEGER,

HBA INTEGER,

Baby INTEGER,

ChildrenClothing INTEGER,

Housewares INTEGER,

Party INTEGER,

Seasonal INTEGER,

Toys INTEGER,

SchoolSupplies INTEGER,

Cellular INTEGER,

General INTEGER,

Ad INTEGER,

Survey INTEGER,

Coupon INTEGER,

Contest INTEGER,

White INTEGER,

AA INTEGER,

AmericanIndian INTEGER,

Asian INTEGER,

Hawaiian INTEGER,

Hispanic INTEGER,

Other INTEGER,

Q6NoAnswer INTEGER,

CR2StoreNumber INTEGER,

HTMLEmails VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

EmailStatus VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)

PRIMARY INDEX ( EmailAddress );

DEFINE

SubscriberKey (VARCHAR(125)),

FullName (VARCHAR(50)),

EmailAddress (VARCHAR(100)),

FirstName (VARCHAR(100)),

LastName (VARCHAR(100)),

ZipCode (INTEGER),

StoreNumber (INTEGER),

StoreAddress (VARCHAR(100)),

StoreCity (VARCHAR(100)),

StoreState (CHAR(2)),

StoreZip (INTEGER),

State (VARCHAR(25)),

Source_ (VARCHAR(75)),

PhoneNumber (INTEGER),

Address1 (VARCHAR(150)),

Address2 (VARCHAR(150)),

City (VARCHAR(100)),

Gender (CHAR(1)),

MobilePhone (INTEGER),

CR2StoreIntersection (INTEGER),

CR2StoreCity (VARCHAR(100)),

Pet (INTEGER),

ShoppingFrequency (INTEGER),

AgeToddler (INTEGER),

AgeChildren6to17 (INTEGER),

Age25To34 (INTEGER),

Age18To24 (INTEGER),

Age35To44 (INTEGER),

Age45To54 (INTEGER),

AdultApparel (INTEGER),

Age55To64 (INTEGER),

Age65orGreater (INTEGER),

Dog (INTEGER),

Cat (INTEGER),

Groceries (INTEGER),

Snacks (INTEGER),

Cleaning (INTEGER),

Q4NoAnswer (INTEGER),

AgeInfant (INTEGER),

HBA (INTEGER),

Baby (INTEGER),

ChildrenClothing (INTEGER),

Housewares (INTEGER),

Party (INTEGER),

Seasonal (INTEGER),

Toys (INTEGER),

SchoolSupplies (INTEGER),

Cellular (INTEGER),

General (INTEGER),

Ad (INTEGER),

Survey (INTEGER),

Coupon (INTEGER),

Contest (INTEGER),

White (INTEGER),

AA (INTEGER),

AmericanIndian (INTEGER),

Asian (INTEGER),

Hawaiian (INTEGER),

Hispanic (INTEGER),

Other (INTEGER),

Q6NoAnswer (INTEGER),

CR2StoreNumber (INTEGER),

HTMLEmails (VARCHAR(100)),

EmailStatus (VARCHAR(50))

file = C:\Users\conndixo\Documents\Export_A.txt;

BEGIN LOADING DLAB_MARKETING.ProfileAttributes

ERRORFILES DLAB_MARKETING.ProAtt_Err1, DLAB_MARKETING.ProAtt_Err2

CHECKPOINT 300000;

INSERT INTO DLAB_MARKETING.ProfileAttributes VALUES

(

:SubscriberKey

,:FullName

,:EmailAddress

,:FirstName

,:LastName

,:ZipCode

,:StoreNumber

,:StoreAddress

,:StoreCity

,:StoreState

,:StoreZip

,:State

,:Source_

,:PhoneNumber

,:Address1

,:Address2

,:City

,:Gender

,:MobilePhone

,:CR2StoreIntersection

,:CR2StoreCity

,:Pet

,:ShoppingFrequency

,:AgeToddler

,:AgeChildren6to17

,:Age25To34

,:Age18To24

,:Age35To44

,:Age45To54

,:AdultApparel

,:Age55To64

,:Age65orGreater

,:Dog

,:Cat

,:Groceries

,:Snacks

,:Cleaning

,:Q4NoAnswer

,:AgeInfant

,:HBA

,:Baby

,:ChildrenClothing

,:Housewares

,:Party

,:Seasonal

,:Toys

,:SchoolSupplies

,:Cellular

,:General

,:Ad

,:Survey

,:Coupon

,:Contest

,:White

,:AA

,:AmericanIndian

,:Asian

,:Hawaiian

,:Hispanic

,:Other

,:Q6NoAnswer

,:CR2StoreNumber

,:HTMLEmails

,:EmailStatus

);

END LOADING;

Tags (1)
3 REPLIES
WAQ
Enthusiast

Re: FastLoad Error when trying to import...


Can you post the logs please?


Enthusiast

Re: FastLoad Error when trying to import...

Error fixed. Thanks guys

WAQ
Enthusiast

Re: FastLoad Error when trying to import...

Its always good to post the solution, so that it can be helpful for others as well.