Forums

I am having the same problem. Added a new field to a table. Just viewing via Table Browser the new field shows 'Unretrieved'. I've tried adding several new field types, EDT, non-EDT, nothing helps. The field is not linked to any other tables.

This appears to be a new type of issue for 2012. Currently there is scant information on this via search engine.

I think this is an AOS caching problem as when I restarted the AOS, the "Unretrieved" didn't appear any more.  If I hit F5 to do a Refresh in the table browser the "Unretrieved" goes away as well.

Can you try this and see if it takes care of the issue for you?

I have the same problem. Refreshing with F5 works for me, but only until I open the table browser again.

Clearing the Cache through Tools -> Caches -> Refresh Data has no effect. Nor does running the data flush function server-side.

Looks like a bug to me!

Volker, the blog you reference only explains why it occurs in a form as a result of joins. This thread is discussing table viewing via the Table Browser after adding basic field datatypes (Int, Enum, etc), no joins.

Oh, you're right. I'm sorry.

Did you try to "Synchronize" the table after adding a new field?

I tried Synchronize when I first looked into this and it didn't help.

If you add this line to the end of the SysTableBrowser form's Run() method, you won't have to hit F5 whenever the form opens:

// refresh the form's data to avoid a problem with unretrieved field values

ds_ds.research();

Anybody have any updates on this?

Hitting F5 does refresh the field OK as a short-term fix, but entering data will result in a SQL error and the whole thing is flaky until the following day or whenever the "automagic fix" occurs.

I concur that this is a bug in Microsoft's ad hoc query logic.  The ad hoc query logic should only result in unretrieved columns where table inheritance is involved.  I am getting it where no inheritance exists and for all columns in the table.

I have been able to force data to be retrieved by adding a unique index to the table.

Very Best Regards,

Guy

Restore the form, come out from ax and relogin to ax, its comes up, All the best

Hi,

I have created new fields for my customisation on Inventsum table in Ax 2012, in table browser i can put data and do any kind of manipulations i need, but i have used them on a form but they are coming up as unretrieved,

I have tried everyother work around  as proposed in this forum like sync, aos restart , adding new fields in place of them etc.. but still the display on the form is coming as unretrieved.

any body please suggest what can I do to overcome the issue,

thanks in advance.

We actually don't get this issue any more, and I'm not sure why (we haven't really changed anything), but if all else fails you should see the fields the next day!

hi there, i have a simmilar issue, i have added 3 fields in PurchPurchaseOrderHeader, and they were working fine, than i added some more and they show a s non-retriveable, and the first 3 are ok...

i can add as many fields in temp tables, like salesInvoiceTmp, SalesConfirmHeaderTmp.... iwonder is it a sql or aos issue?

I'm having the same issue as well.  I've added a field to InventSum and populated the column with data.  The data shows up fine in the table browser.  I added the field to the InventOnHandItemListPage and the field only shows 'Unretrieved.'  As mentioned before it doesn't seem strictly related to joining tables.  All the tables and forms are synched and AOS has been restarted.  I guess I'm just supposed to cross my fingers and hope that the problem resolves itself over time.