Question Status

Verified
ARPIT CHAVHAN asked a question on 22 Mar 2013 3:20 AM

Dear All,

My EP site was workingfine but suddenly I have encountered with the error "data or calculated fields with type 'record' are not supported" on some of the forms on the EP site. This error is not only coming on the EP site but also while import/export via Excel Addins.

Please help me out if any one knows to resolve this issue.

Thanks & Regards.

Reply
Verified Answer
ARPIT CHAVHAN responded on 25 Mar 2013 11:35 PM

Dear All,

I was getting an error as "Data or calculated fields of type 'Record' is not supported" while starting the EP site also when doing excel import via excel addins.

This type of error comes when you return a record of a table,as in display type on some table.

In my case it was HCMWorker which was a standard table and we had written a display method which was returning record of HcmEmploymentDetail table which does not supported by AX during run time.

display HcmEmploymentDetail retHcmEmploymentDetail()

{

   ;

            return HcmEmploymentDetail::findByEmployment(HcmEmployment::findWithWorker(this.recId).RecId);

}

the above query is not supported by AX during run time.

What I found out that, if you want to return any record of a table it should be static method as in.....

public static HcmEmploymentDetail retHcmEmploymentDetail(HcmWorkerRecId      _recId)

{

   ;

   return HcmEmploymentDetail::findByEmployment(HcmEmployment::findWithWorker(_recId).RecId);

}

Reply
Suggested Answer
Brandon Ahmad responded on 24 Mar 2013 6:38 PM

Arpit, are you able to produce this error on the sample Dynamics AX 2012r2 sample image Enterprise Portal.. If so, I'd love to to know so I can try to debug it.  

But if not, here is what you need to do in order to solve it:  

This is a case for WinDbg.  When you really need to debug what is happening on Dynamics AX, nothing (that is free) is more effective.  It's what Microsoft uses for their support team to do the heavy duty debugging.  Thankfully,

their support team made a blog post showing how to use this feature for Dynamics AX.  

blogs.msdn.com/.../setting-up-windbg-and-using-symbols.aspx

Can you post the dump file and the symbols from this?  

I'd do it myself but I'm not on your installation.  However,the tutorial is very straight foward and written well by Microsoft support.  That will tell us the cause of this.  

Independent, Freelance Consultant and Dynamics Development Instructor

http://www.instructorbrandon.com

http://www.youtube.com/user/BrandonAhmad

Reply
ARPIT CHAVHAN responded on 22 Mar 2013 9:03 PM

Any one with anything...?????

Reply
Sameer Gurav responded on 22 Mar 2013 9:16 PM

Any Update Arpit ?? We also facing the same Issue

Reply
ARPIT CHAVHAN responded on 23 Mar 2013 3:18 AM

So wat is d solution for this.....I am struggling wid same for last 5 days...Pls help Us i.e Me n Arpit !!

Reply
Suggested Answer
Brandon Ahmad responded on 24 Mar 2013 6:38 PM

Arpit, are you able to produce this error on the sample Dynamics AX 2012r2 sample image Enterprise Portal.. If so, I'd love to to know so I can try to debug it.  

But if not, here is what you need to do in order to solve it:  

This is a case for WinDbg.  When you really need to debug what is happening on Dynamics AX, nothing (that is free) is more effective.  It's what Microsoft uses for their support team to do the heavy duty debugging.  Thankfully,

their support team made a blog post showing how to use this feature for Dynamics AX.  

blogs.msdn.com/.../setting-up-windbg-and-using-symbols.aspx

Can you post the dump file and the symbols from this?  

I'd do it myself but I'm not on your installation.  However,the tutorial is very straight foward and written well by Microsoft support.  That will tell us the cause of this.  

Independent, Freelance Consultant and Dynamics Development Instructor

http://www.instructorbrandon.com

http://www.youtube.com/user/BrandonAhmad

Reply
Verified Answer
ARPIT CHAVHAN responded on 25 Mar 2013 11:35 PM

Dear All,

I was getting an error as "Data or calculated fields of type 'Record' is not supported" while starting the EP site also when doing excel import via excel addins.

This type of error comes when you return a record of a table,as in display type on some table.

In my case it was HCMWorker which was a standard table and we had written a display method which was returning record of HcmEmploymentDetail table which does not supported by AX during run time.

display HcmEmploymentDetail retHcmEmploymentDetail()

{

   ;

            return HcmEmploymentDetail::findByEmployment(HcmEmployment::findWithWorker(this.recId).RecId);

}

the above query is not supported by AX during run time.

What I found out that, if you want to return any record of a table it should be static method as in.....

public static HcmEmploymentDetail retHcmEmploymentDetail(HcmWorkerRecId      _recId)

{

   ;

   return HcmEmploymentDetail::findByEmployment(HcmEmployment::findWithWorker(_recId).RecId);

}

Reply
Prabakaran responded on 24 Mar 2014 5:47 AM

Make sure the table and all related tables does not have any display method returning a record.

Reply