Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

[Data Import failure] Data Loading File Activity error

manovinayaka757
Level 4
Level 4

Hi All,

Environment:

Adobe Campaign V6.1

Build Number: 8861

DB: MSSQL Server

I was working on this exercise:

Implementing a Data Feed: Uploading a File in Adobe Campaign v6 |

Enriching Data in Adobe Campaign v6 |

But I am unable to load the data.

Data file data with 1 record:

First Name,Last Name,Email,Account#

Stanely,jobs,stanep@gmail.com,1234

Data Loading file activity loads data from file user_accounts.csv with the sample template file people.csv.

While Loading data the following error happens and enrichment activity is not executed.

Please share your knowledge on the SQL Error that is hapenning.

wf_0.JPG

wf_1.JPG

wf_2.JPG

Detail of Errors during data loading:

----------------------------------------

ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'wkf104351_1'. SQLState: S0002

ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. SQLState: 37000

WDB-200001 SQL statement 'SELECT  top 200 W0.sFirst_Name, W0.sLast_Name, W0.sEmail, W0.sAccount_ FROM wkf104351_1 W0' could not be executed.

BAS-010003 Unable to complete operation in current status.

Server Logs:

--------------------------------------------------------------------------------------------------

15:05:59 >>> ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'wkf104351

_1'. SQLState: S0002 (iRc=-2006)

15:05:59 >>> ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prep

ared. SQLState: 37000 (iRc=-2006)

15:05:59 >>> WDB-200001 SQL statement 'SELECT  top 200 W0.sFirst_Name, W0.sLast_Name, W0.sEmail, W0.sAccount_ FROM wkf10

4351_1 W0' could not be executed. (iRc=-2006)

1 Accepted Solution
manovinayaka757
Correct answer by
Level 4
Level 4

Hi Vipul,

Thanks for taking time to analyse my problem.

I got the answer from neolane support yesterday.

As "enrichment" activity can only be used for updating a record which is already present in the "Recipient" table, the data that I was importing does not exists in the "Recipient" table. So I should be using "Update data" activity.

Hope my understanding is correct on this.

Regards,

Mano

View solution in original post

4 Replies
Vapsy
Employee
Employee

Can you please click on the "​Edit additional data​" link inside your Enrichment and show to us the setting there?

manovinayaka757
Level 4
Level 4

Hi Vipul,

Thanks for replying!!

Below is the snapshot

The properties, Reconcilation & deduplication and simple join tabs are empty.

wf_4.JPG

Vapsy
Employee
Employee

Please enable the option "Keep all additional data from the main set. It should work

manovinayaka757
Correct answer by
Level 4
Level 4

Hi Vipul,

Thanks for taking time to analyse my problem.

I got the answer from neolane support yesterday.

As "enrichment" activity can only be used for updating a record which is already present in the "Recipient" table, the data that I was importing does not exists in the "Recipient" table. So I should be using "Update data" activity.

Hope my understanding is correct on this.

Regards,

Mano

View solution in original post