Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Invent Batch New Colum...

Invent Batch New Column Create throws error

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

there is a problem when i create a new in invent batch table it complies and gives no error while as i synchronize it with database it shows error as Cannot execute a data defination language command () ALTER TABLE INVENTBatch nvarchar(100) not null. Neither it let me drop the column. gives same error as Cannot execute a data defination language command () while synchronization. Please tell what could be the problem.

*This post is locked for comments

All responses (5)

Answers (0)

Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

can you mark the thread as answered then? tnx
Community Member Microsoft Employee on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

Thanks
Suggested answer

Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

That's the statement it was trying to execute. the error is one message above it.

But I can see you are trying to use a name for the column "DESC". That's a reserved SQL keyword, and thus cannot be a name of a column in a table.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

I am share error info
Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: Invent Batch New Column Create throws error

Can you paste a screenshot or the entire text of the error message?