Field "fieldname" in Table "tablename" has not been explicitly selected in AX 2012

Hi all,
I've a Dynamics AX 2012 installation in my enviroment. When I open several forms (like Target Entities in Data Import Export Framework, or CustTrans, or VendTrans) I receive this error: Field "fieldname" in Table "tablename"  has not been explicitly selected in AX 2012.
Can you tell me what can be the cause of this error?
#EXPLICITLYSELECTED
  • Petr Janík
    POSTED BY 
    ON 11 MAY 2013 12:31 PM
    Hi Guiseppe,
    I have seen this error a few times. It can be caused by an illegal data in a table , e.g. it contains NULL value, which is not allowed in AX (except table inheritance). Sometimes it helps me to restart a client or AOS. Of course I assumed that you did full compile without errors and synchronized the database.
  • Giuseppe Caradonna
    POSTED BY 
    ON 13 MAY 2013 2:14 AM
    Hi Petr,
    Unfortunately I have already compiled and synchronized the application without errors and restarted the AOS...Any other ideas?
  • Martin Dráb
    POSTED BY 
    ON 13 MAY 2013 2:31 AM
    It means that the field was read but its value wasn't retrieved from database. See Tutorial: AX 2012 - Invalid field access or Accessing unretrieved fields for more detailed explanation.
    Martin "Goshoom" Dráb | Freelancer | Goshoom.NET Dev Blog
    Troubleshooter 5 Problem Solver 5 Troubleshooter 4 Problem Solver 4 Level 4 Level 3 Microsoft Dynamics AX Community Contributor Microsoft Dynamics AX MVP Community Moderator for Microsoft Dynamics AX
  • Petr Janík
    POSTED BY 
    ON 13 MAY 2013 3:05 AM
    You are right Martin, but this is true if you select existing record from a table. In this case is evident that the user open the form DMFEntity for the first time. So, the table DMFEntity is empty and the init method of the DMFEntity form wants to populate this table with default mapping and calls the validateWrite method before insert.
  • Giuseppe Caradonna
    POSTED BY 
    ON 14 MAY 2013 3:11 AM
    Petr, is it a bug?
  • J. Pospisil
    POSTED BY 
    ON 16 MAY 2013 10:02 AM
    Hi,
    I have the some problem with AX 2012R2:
    This is the error msg when I run Sales Tax Report:
    Stack trace: Field 'VATNum' in table 'CompanyInfo' has not been explicitly selected.
    Stack trace
    (S)\Classes\TaxReportingDP\insertTaxReportingTmp - line 82
    (S)\Classes\TaxReportingDP\processReport - line 101
    (S)\Classes\SrsReportProviderQueryBuilder\initialize - line 57
    (S)\Jobs\
    Stack trace error appears also - for example - when I export data from the database.
    Can somebody help me, please?
    thx!
    AX2012 UNRETRIEVED
  • Gustavo Bagno
    POSTED BY 
    ON 16 MAY 2013 10:10 AM
    I believe the original "select" is using a Field List, and the field DMFEntity is probably not in the field list, or for some other reason (aggregate functions maybe) the field may be not retrieved.
    There is no problem on calling validateWrite before Insert. It's actually a good practive, but if the validateWrite is overridden in the Form Datasource, then there might be a need for a technical intervention.
    Check that.
  • Giuseppe Caradonna
    POSTED BY 
    ON 16 MAY 2013 10:48 AM
    I get the same error in other places...CustTrans table --> postLoad() method, VendTrans table --> postLoad() method...What can I do to fix it?
  • Giuseppe Caradonna
    POSTED BY 
    ON 22 MAY 2013 3:38 AM
    SUGGESTED ANSWER
    Hi all,
    I'm receiving this error in some other methods in AX. I am solving by changing the select statements adding the required field.
  • Kim Lee
    POSTED BY 
    ON 4 JUL 2013 12:14 AM
    What do you mean by "changing the select statements adding the required field"?
  • Bella N
    POSTED BY 
    ON 11 JUL 2013 5:15 AM
    Hi Giuseppe,
    I encountered the same error also "Field 'isConsolidation' in "CompanyInfo' has not been explicitly selected".
    How do you resolve the issue? Where do you do the select statement?
    Thank you.
  • pvanstipelen
    POSTED BY 
    ON 30 JUL 2013 3:50 AM
    I added a blog post about this matter. I hope this helps!
    Always check the datasource/select statement for the error
    Kind regards,
    Philippe
  • ____-__-__
    POSTED BY 
    ON 2 AUG 2013 2:18 AM
    System administration - setup - system - server configuration
    tab: performance optimization
    "Error on invalid field access" => set to "no"
  • Oleg Abapolov
    POSTED BY 
    ON 20 NOV 2013 4:28 AM
    SUGGESTED ANSWER
    Hi,
    For new fields in CompanyInfo the solution was to "compile forward" from DirPartyTable.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)