Question Status

Unanswered
Prabath Ranasinghe asked a question on 18 Feb 2014 11:25 PM

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

Reply
Palle Agermark responded on 19 Feb 2014 12:17 AM

Hi Prabath,

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

Palle Agermark | AX Developer | www.agermark.com | @PalleAgermark

Reply
Prabath Ranasinghe responded on 19 Feb 2014 12:34 AM

AX 2009 R2 RU7

Reply
Denis Macchinetti responded on 19 Feb 2014 1:40 AM

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

Reply
Prabath Ranasinghe responded on 19 Feb 2014 2:22 AM

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

Reply
Denis Macchinetti responded on 19 Feb 2014 2:27 AM

Hi

You have tried to restart the AOS ?

Regards

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply
Prabath Ranasinghe responded on 19 Feb 2014 2:49 AM

yes. But the result was same.

Reply
Denis Macchinetti responded on 19 Feb 2014 2:58 AM

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

Reply
Prabath Ranasinghe responded on 19 Feb 2014 3:02 AM

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

Reply
Prabath Ranasinghe responded on 19 Feb 2014 8:14 PM

Hi,

We have deleted all index files ( *.??I) . Still the issue is there.

Reply
Martin Dráb responded on 19 Feb 2014 10:22 PM

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

Reply
Prabath Ranasinghe responded on 20 Feb 2014 12:57 AM

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

Reply
Martin Dráb responded on 20 Feb 2014 1:49 AM

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

Reply