Generate source mapping error

(0) Share

Report

Posted on by Community Member

Hi,

whenever I try to generate source mapping (Data import export framework-> Common-> Processing group) I get this non-informative Mapping errors: Vendor$.

2045.Untitled.png

Any help would be appreciated, thanks.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

Hi,

As the error is not informative I feel due to some reason, DIXF is unable to access the worksheet from the excel sheet. To confirm the issue, please change the sourcedataformat to some other one(might be PIPE) and check the mapping. I feel it would be better to generate source file again(for excel) and provide the mapping.

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (1)

Report

Hi Dsatkus,

How does your source file look like? Does it have a sheet called 'Vendor$'? What exact steps did you do?

Was this reply helpful? Yes No
Suggested answer

Chris R Tilley 339 on at

Like (0)

Report

Hello,

I resolved this by installing the Access Database engine redistributable on the server which hosted the DIXF service, which in my case was a Shared SQL server.

https://www.microsoft.com/en-us/download/details.aspx?id=54920

We found that CSV worked, but Excel didn't which made me think drivers. The issue was it is a 3 tier, with RDS > AOS > SQL/DIXF so wasn't entirely sure at which point the access was happening

Hope that helps your issue

Chris

Was this reply helpful? Yes No