Finance | Project Operations, Human Resources, ...

ODBC driver 17 for SQL in UAT environment

(0) Share

Report

Posted on by ..

1,965

Hi,I

I'm getting this error in UAT environment. How can I solve it?

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column
'DATAAREAID', table 'db_d365.dbo.Table1';
column does not allow nulls. INSERT fails.

I have the same question (0)

All responses (20)

Answers (0)

Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

At what point are you getting this error ?

Was there an upgrade recently?

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Komi,

I have a table that wasn't shared between all legal entities. And I made it shared and released to UAT.

This table had already records Inside but it doesn't have a unique index.

So this happens when calling custom code now as it inserts to this table

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

Alright, so you need to make sure your update the DATAAREAID on that table with your custom code.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Komi,

But the table is shared now..there is no dataAreaId.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

Is this table a standard table or a custom table ?

When you open the table browser, can you see DATAAREAID field ?

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Custom table and no I don't see the dataAreaId field

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Any idea?

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

I suggest you give more details about the table in question.

Share the table properties,

Share a screenshot of the table browser as well.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Komi,

Save data per company = No

One index with allow duplicate =true

I can assure you that the dataAreaId field doesn't appear in table browser

Also currently the table now contains only one record..as I ran a batch that deletes all records except for the last one. But when I tried again then I'm still getting the same error

I don't have access now to the environment..if there are other properties that you would like to know their values then please let me know

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

Now, let's take it back to the development environment. Are you having same issue in there ?

I suggest you debug and see what your code is actually doing.

Was this reply helpful? Yes No

Join the conversation

Community site session details

ODBC driver 17 for SQL in UAT environment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

ODBC driver 17 for SQL in UAT environment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates