Finance | Project Operations, Human Resources, ...

DIXF Error during directory based imports

(0) Share

Report

Posted on by BrandonSA

1,673

Hi everyone

I get this error when I try to import FTIs via DIXF

"Error occurred while doing bulk copy from temp table to entity table-The given value of type String from the data source cannot be converted to type nvarchar of the specified target column."

What does this mean? I've looked up other people who've had the same problem, but none of the other articles help.

A little about the error:

- Ax 2012 R2

- Full compile and Full CIL done

- The import works correctly if run manually - from source to staging and then staging to target

- The file is validated correctly and can be shown in preview

- The file is even imported correctly to staging via batch

- This import does NOT work if imported as a directory based batch process

- The error log says: "The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.", but how do I know what the guilty column is. They all look fine.

Any ideas?

Thanks

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Fangyuan Hou on at

Like (0)

Report
Copy link

Link copied!

Hi Brandon,

Are you using the standard entity or the customized entity?

If you are using standard entity, please submit a support ticket to our support team with the file you want to import, we can have a further debug and investigation on this.

If you are using customized entity, please have a check the on Classes\DMFxxxxEntityClass\insertUpdate. To see which field could cause the error.

Was this reply helpful? Yes No
BrandonSA 1,673 on at

Like (0)

Report
Copy link

Link copied!

Hi Fang

Thanks for the reply. I forgot to mention that it fails even at the staging part... the data doesn't even get into the staging table if using directories. Checking the insertUpdate method is for staging to target transfers. This happens during the copy to staging.

Thanks

Was this reply helpful? Yes No
Fangyuan Hou on at

Like (0)

Report
Copy link

Link copied!

Hi Brandon,

please submit a support ticket to our support team with the file you want to import, we can have a further debug and investigation on this.

Was this reply helpful? Yes No