Basic Development Errors.

 Error 1: 

    Table does not contain a valid time state key. A unique index needs to be marked as a valid time state key D365Basics (USR)[Muthu_Extension]

C:\AOSService\PackagesLocalDirectory\KARYA_D365FO_Training\Muthu_Extension\AxTable\VAR_ChitMasterTable.xml 0


Solution :

    Whenever we set the 'Valid Time State Field Type' as Property for a table, needs to update following property.

    Table Property:
  • We need to map both 'Valid To' and 'Valid From' Columns in the Table Indexes. 
  • Set the Primary Index as 'VAR_ChitGUID_Idx'(Newly Created Index) Instead of "SurrogateKey"

                   

    Index Property: 

  • Set "Alternate Key ": "Yes" in the Index property level.
  • Set  "Valid Time State Key" : "Yes" in the Index Property.



Error 2: 

 
Warning BP Rule: [BPErrorTableFieldNotDefinedUsingType]:Path: [dynamics://Table/custTableStaging/TableFieldString/BusinessActivity]:BPErrorTableFieldNotDefinedUsingType: Field must be defined using a type. XXX (USR) [XXXExtension]

Fix: We need to set the "extended data type" for the table property column. 

Comments

Post a Comment

Popular posts from this blog

DMF (1073676279) - Issue Fix

 Problem Statement:      When  I tried to Import the data via DMF I got the following error message. <?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 -    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlPackageImport.AddDataFlowComponent(Package _Package)    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerImport.CreateAndExecutePackage()    at DMFExecutePackage.PackageCreator.processEntity()    at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-1073676279</ErrorCode><SubComponent>Microsoft.SqlServer.DTSPipelineWrap</SubComponent><Description>Exception from HRESULT: 0xC0010009 -    at Microsoft.SqlServer.Dts.Pipeline.Wra...
Read more

Read the JSON data via REST API (X++)

  Problem Statement:           Read the data from outside Application. Here I am fetch the JSON data from Shopify Integration and push it in to the D365FO System.   Development steps:       Step 1 : Create Runnable Class.      Step 2 : After create the Runnable class, use the following Library in your solution.                               using System.Net.HttpWebRequest;                               using System.Net.HttpWebResponse;                               using System.Text.Json;                               using System.Text.Json.Serialization;  ...
Read more

Activate Financial Dimension in Dynamics 365 FO. (On- Premises)

  If you want to activate the financial dimension in Dynamics 365 on on-premises, you need to do a following step. 1.      Open SQL and go to D365FO Database. 2.     Execute the following Query                   select * from SQLSYSTEMVARIABLES         update SQLSYSTEMVARIABLES SET VALUE = 1 WHERE PARM =                     'CONFIGURATIONMODE' 3.      Execute IIS Restart. 4.     Refresh the Page. 5.     After activating the financial dimension, you need to revert the option.              update SQLSYSTEMVARIABLES SET VALUE = 0 WHERE PARM                     =   'CONFIGURATIONMODE' 6.    Execute IIS Restart. 7.    Refresh the Page.
Read more