Last week we found some sys layer fields were missing in VendpurchOrderJour table. We have access only for cus, var layers. Anyone can explain a reason for this.
We can guarantee no one has done it from x++ also. Is this is a problem of db sync? If so, how can we identified those problems before it fired?
Could please let us know what version of AX you are using?
AX 2009 R2 RU7
Let me understand better.
The field is missing from both AOT and Database or only from Database ?
In AX side it shows as 'UNKNOWN'. In SQL side can't find those fields
You have tried to restart the AOS ?
yes. But the result was same.
As per my understanding, you have AX 2009.
- Stop AOS
- Delete the file AXAPD.AOI on Application folder
- Start the AOS
Thanks for your advise. I'll try it and let you know the result
And can you explain any reason or any bad practice for these kind of issues happen . So we can stop future failures.
We have deleted all index files ( *.??I) . Still the issue is there.
Where do you see the fields as UKNOWN? I don't believe it's in the table in AOT. It's rather a form, a query or something else what refers to non-existing fields.
Can you give us an example of a field that you expect to be in SYS layer? Can you confirm your version of AX once more? (AX 2009 R2 doesn't exist.)
Sorry.. Its AX 2009 SP1
For the first time there was no field shown in the AX Table
After restore, sync it shows as 'UNKNOWN', in the Table itself.
Fields, PURCHID, PURCHORDERDATE, ORDERACCOUNT...
So you see a long list of fields with name "UNKNOWN", correct? What do you see in the Properties window? Have you already rebuilt axapd.aoi? Is the table customized in a higher layer?