You’re offline. This is a read only version of the page.
Hi,
I am using AX 7 to create some entities. The entity starts at InventTable and goes to EcoResProduct. That complies and Syncs just fine.
When I add an inner join to the EcoResProductTranslations I get the error below when I try to sync the DB.
Error Database execution failed: Column 'INSERTED.DATAAREAID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. 0
Then several SQL statements that created triggers but are not using the INSERTED.DATAAREAID reference. I have seen that SQL error plenty of times in my life and know what it means but don't know what I am doing to cause it.
I am joining on InventTable.Product = EcoResProductTranslations.Product. The entity key is ItemID so I thought that the multiple rows per item might be a problem therefore I added a range to only return en-us. But that did not work.
When I remove the EcoResProductTranslations data source everything complies fine again, so know the issue is with this Join.
Any help would be appreciated.
Thanks in Advance
*This post is locked for comments
I have the same question (0)
I managed to figure this out. For the instance above I recreated the Entity and it worked. After a few month it reared it head again on another Entity. Turns out at the Entity level there is a parameter called "Primary Company Context" and it was set to DataAreaId. I made it blank and it worked. Because I as joining to tables that don't have a dataareaid this was a problem.
You can read more about it here: ax.help.dynamics.com/.../
Share
Report
All responses (
Answers (
4
