Error label ID: - Excel export in DMF

Finance and Operations/AX
,
1

I Have added a new datasource to CustomersV3 data entity and Added the fields from this datasource to entity and staging. When I am trying to export the Customers V3 entity using Excel format I facing the error Error Label ID:

image
image1696Ă—703 71.1 KB

image
image1744Ă—786 67.3 KB

There are multiple fields I am using from this newly added datasource. For some of the fields I am not facing this problem. When I add the remaining fields this error is showing up in the export. When I use other formats the export is working fine without any error. I have performed full build and full DB Sync, but it is not resolving the problem.

When I debugged the issue I have found out that this is failing in the following class
DMFGenerateSSISPackage - class - generateFileDataV2 - method - 1524 line.

1 Like
2

In this case a record in DMFStagingErrorCode table for the error code in given in the catch block of generateFileDataV2Inner method of DMFGenerateSSISPackage class does not exist.

In getDescription method of DMFGenerateSSISPackage class the error code is translated into a label by searching it in the DMFStagingErrorCode table.

In case no record has not been found you get the error “error labelid:”.
In my case it was DMF2009, that means “Export to Excel does not support more than 255 columns.”.

The DMFStagingErrorCode table is only populated once.
To update this table you need the following runnable class.

/// <summary>
/// Runnable class to update DMF staging error codes
/// </summary>
public final class UpdateDMFStagingErrorCodes
{
    /// <summary>
    /// Class entry point. The system will call this method when a designated menu 
    /// is selected or when execution starts and this class is set as the startup class.
    /// </summary>
    /// <param name = "_args">The specified arguments.</param>
    public static void main(Args _args)
    {
        ttsbegin;
        DMFStagingErrorCode errorCode;        
        delete_from errorCode;

        DMFDataPopulation::createStagingErrorCodes();
        ttscommit;
    }
}

You can also have a look into DMFErrorCode.xml that you can find in the resources. This is the basis to populate DMFStagingErrorCode table.

1 Like