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
BedrockMission!

Learn More

View all

Sign in to view all badges

Error while loading and updating profile data

Avatar

Avatar
Boost 1
Level 1
pp36849159
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
pp36849159
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
pp36849159
Level 1

19-10-2018

I have a new file of 50K profiles which needs to be imported in to ACS. I get an error trying to import these profiles due to gender code.

Gender Code on my file : 'F','M' etc.

Error received:

WKF-560065 the type of the 'GNDR_CD' expression (type: string) does not match the type of the '@gender' destination field (type: byte)

1) When I change the data type to Integer, the data does not get updated in profiles though the worflow runs without any errors. How do I resolve this?

2) The Birth_DT field also does not get mapped into the newly imported profiles. I have changed the format in the load file stage to date which matches the target dimension data type but still does not get imported. How do I import Birth Date?

Thank you!

Replies

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

30-10-2018

Hi Prabha,

As the error indicates: one is type:string and the @gender destination field is type:byte.

Can you change the destination field to match type:string?

The reason why changing to type:integer might work is because type:byte is in essence a number but it doesn't mean it's correct, as the gender values are strings ('F', 'M', 'Other').

Same thing for Date: Make sure content type matches the destination field.

I hope this helps!

Pablo