The DMF error "The column name 'RECVERSION' is specified more than once in the SET clause or column list of an INSERT."

(0) Share

Report

Posted on by RongYan

214

Hi,

I'm using set-based DMF to import the data into D365FO.

It works before, but now the below error happened:

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The column name 'RECVERSION' is specified
more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than
one value in the same clause. Modify the clause to make sure that a column is updated only once. If
this statement updates or inserts columns into a view, column aliasing can conceal the duplication
in your code.

Could you give some advices to resolve the problem?

Best Regards.

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

RongYan 214 on at

Like (0)

Report

RE: The DMF error "The column name 'RECVERSION' is specified more than once in the SET clause or column list of an INSERT."

It's the coding miss.

We add the custom code "insert xxx select staging_xxx", but we included the system field RecVersion.

Was this reply helpful? Yes No
Verified answer

RongYan 214 on at

Like (0)

Report

RE: The DMF error "The column name 'RECVERSION' is specified more than once in the SET clause or column list of an INSERT."

Hi Bhattacharyya & Nayak

thanks for your confirmation.

I found the reason: it's the coding miss.

We add the custom code "insert xxx select staging_xxx", but we included the system field RecVersion.

Best Regards.

Was this reply helpful? Yes No
Harshal Nayak on at

Like (0)

Report

RE: The DMF error "The column name 'RECVERSION' is specified more than once in the SET clause or column list of an INSERT."

Hello Rong,

Can you give is us more understanding about the steps that you performed and are getting the error.

Regards,

Harshal

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: The DMF error "The column name 'RECVERSION' is specified more than once in the SET clause or column list of an INSERT."

Hi RongYan,

Did you make any changes to the data entity? Is this a custom data entity or an OOB one?

Was this reply helpful? Yes No