Delete Sys layer fields in VendPurchOrderJour table

This question is not answered

Hi All,

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?

Thanks.

Prabath

All Replies
  • Hi Prabath,

    Could please let us know what version of AX you are using?

    Palle Agermark | AX Developer | www.agermark.com

  • AX 2009 R2 RU7

  • Hi Prabath

    Let me understand better.

    The field is missing from both AOT and Database or only from Database ?

    Regards

    Thanks & Regards

    Denis Macchinetti

    Senior Technical Architect

  • In AX side it shows as 'UNKNOWN'. In SQL side can't find those fields

  • Hi

    You have tried to restart the AOS ?

    Regards

    Thanks & Regards

    Denis Macchinetti

    Senior Technical Architect

  • yes. But the result was same.

  • Hi

    As per my understanding,  you have AX 2009.

    So :

    - Stop AOS

    - Delete the file AXAPD.AOI on Application folder

    - Start the AOS

    Regards

    Thanks & Regards

    Denis Macchinetti

    Senior Technical Architect

  • Hi Denis,

    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.

    Thanks

    prabath

  • Hi,

    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.)

    Martin "Goshoom" Dráb | Freelancer | Goshoom.NET Dev Blog

  • 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?

    Martin "Goshoom" Dráb | Freelancer | Goshoom.NET Dev Blog