web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Error Comes in Pull Jo...

Microsoft Dynamics AX (Archived)

Error Comes in Pull Job for some Custom Table in P job

(0) Share

Report

Report

Posted on by Community Member

In Retail P-JOB

Error when bulk inserting data. Target table: MFL_RETAILPURCHASERECEIPTLINEX

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.

at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)

--- End of inner exception stack trace ---

Any Idea How To find the Store Table sending some incompatible data from Store to HO.(P-jobs)

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 26

#2

#3

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans