Hi,I'm working on EP AX2012 with the table migrated from AX 4.0.I've created a dataset from two tables(one of them is tmp table).When adding the dataset to a axGridView, I'm getting the error above.These two tables has been migrated from AX 4.0.I checked the join, relations of individual tables. All looks fine.
I'm guessing it could be something to do with AX2012 table properties.
Any ideas to find issue step by step.
One thing you can look for is the DataKeyName property you have for the AxGrid in the web control (in VS, if you open up the web control page definition (.ascx)). You should have fields that form the unique key from both tables.
Another thing is the PK on the temp table, it has to be set to RecId and you need to use it in the DataKeyName.
Forgot to ask, the tables in the dataset are inner joined, right?
The join is active.
This is fine now.
Can you describe here what exactly you did in order to solve your issue? It might help others in the future.
I removed one of the a table from the Datasource.
And I noticed that the table with array field was the issue.
I need to add the table again. But having issue with that.
So, the solution wasn't the very complete one.