onbuyuka
commented
5 months ago Works fine on my end:
Generated file:
table 50101 "CDS msdyn_FunctionalLocation"
{
ExternalName = 'msdyn_functionallocation';
TableType = CDS;
Description = '';
fields
{
field(1; msdyn_FunctionalLocationId; GUID)
{
ExternalName = 'msdyn_functionallocationid';
ExternalType = 'Uniqueidentifier';
ExternalAccess = Insert;
Description = 'Unique identifier for entity instances';
Caption = 'Functional Location';
}
field(2; CreatedOn; Datetime)
{
ExternalName = 'createdon';
ExternalType = 'DateTime';
ExternalAccess = Read;
Description = 'Date and time when the record was created.';
Caption = 'Created On';
}
field(4; ModifiedOn; Datetime)
{
ExternalName = 'modifiedon';
ExternalType = 'DateTime';
ExternalAccess = Read;
Description = 'Date and time when the record was modified.';
Caption = 'Modified On';
}
field(25; statecode; Option)
{
ExternalName = 'statecode';
ExternalType = 'State';
ExternalAccess = Modify;
Description = 'Status of the Functional Location';
Caption = 'Status';
InitValue = " ";
OptionMembers = " ", Active, Inactive;
OptionOrdinalValues = -1, 0, 1;
}
field(27; statuscode; Option)
{
ExternalName = 'statuscode';
ExternalType = 'Status';
Description = 'Reason for the status of the Functional Location';
Caption = 'Status Reason';
InitValue = " ";
OptionMembers = " ", Active, Inactive;
OptionOrdinalValues = -1, 1, 2;
}
field(29; VersionNumber; BigInteger)
{
ExternalName = 'versionnumber';
ExternalType = 'BigInt';
ExternalAccess = Read;
Description = 'Version Number';
Caption = 'Version Number';
}
field(30; ImportSequenceNumber; Integer)
{
ExternalName = 'importsequencenumber';
ExternalType = 'Integer';
ExternalAccess = Insert;
Description = 'Sequence number of the import that created this record.';
Caption = 'Import Sequence Number';
}
field(31; OverriddenCreatedOn; Date)
{
ExternalName = 'overriddencreatedon';
ExternalType = 'DateTime';
ExternalAccess = Insert;
Description = 'Date and time that the record was migrated.';
Caption = 'Record Created On';
}
field(32; TimeZoneRuleVersionNumber; Integer)
{
ExternalName = 'timezoneruleversionnumber';
ExternalType = 'Integer';
Description = 'For internal use only.';
Caption = 'Time Zone Rule Version Number';
}
field(33; UTCConversionTimeZoneCode; Integer)
{
ExternalName = 'utcconversiontimezonecode';
ExternalType = 'Integer';
Description = 'Time zone code that was in use when the record was created.';
Caption = 'UTC Conversion Time Zone Code';
}
field(34; msdyn_Name; Text[60])
{
ExternalName = 'msdyn_name';
ExternalType = 'String';
Description = 'Required name field';
Caption = 'Name';
}
field(35; msdyn_ParentFunctionalLocation; GUID)
{
ExternalName = 'msdyn_parentfunctionallocation';
ExternalType = 'Lookup';
Description = '';
Caption = 'Parent Functional Location';
TableRelation = "CDS msdyn_FunctionalLocation".msdyn_FunctionalLocationId;
}
field(36; msdyn_Sequence; Integer)
{
ExternalName = 'msdyn_sequence';
ExternalType = 'Integer';
Description = 'Relative order of functional location entity node in hierarchy control';
Caption = 'Sequence';
}
field(38; msdyn_CostCenter; Text[100])
{
ExternalName = 'msdyn_costcenter';
ExternalType = 'String';
Description = '';
Caption = 'Cost Center';
}
field(39; msdyn_EmailAddress; Text[100])
{
ExternalName = 'msdyn_emailaddress';
ExternalType = 'String';
Description = '';
Caption = 'Email Address';
}
field(40; msdyn_LocationOpenDate; Date)
{
ExternalName = 'msdyn_locationopendate';
ExternalType = 'DateTime';
Description = '';
Caption = 'Location Open Date';
}
field(42; msdyn_PrimaryTimeZone; Integer)
{
ExternalName = 'msdyn_primarytimezone';
ExternalType = 'Integer';
Description = '';
Caption = 'Primary Time Zone';
}
field(43; msdyn_ShortName; Text[100])
{
ExternalName = 'msdyn_shortname';
ExternalType = 'String';
Description = '';
Caption = 'Short Name';
}
field(45; msdyn_Address1; Text[250])
{
ExternalName = 'msdyn_address1';
ExternalType = 'String';
Description = '';
Caption = 'Street 1';
}
field(46; msdyn_Address2; Text[250])
{
ExternalName = 'msdyn_address2';
ExternalType = 'String';
Description = 'Street 2';
Caption = 'Street 2';
}
field(47; msdyn_Address3; Text[250])
{
ExternalName = 'msdyn_address3';
ExternalType = 'String';
Description = 'Street 3';
Caption = 'Street 3';
}
field(48; msdyn_AddressName; Text[250])
{
ExternalName = 'msdyn_addressname';
ExternalType = 'String';
Description = 'Address Name';
Caption = 'Address Name';
}
field(49; msdyn_City; Text[80])
{
ExternalName = 'msdyn_city';
ExternalType = 'String';
Description = 'City';
Caption = 'City';
}
field(50; msdyn_Country; Text[80])
{
ExternalName = 'msdyn_country';
ExternalType = 'String';
Description = 'Country/Region';
Caption = 'Country/Region';
}
field(51; msdyn_Latitude; Decimal)
{
ExternalName = 'msdyn_latitude';
ExternalType = 'Double';
Description = 'Latitude';
Caption = 'Latitude';
}
field(52; msdyn_Longitude; Decimal)
{
ExternalName = 'msdyn_longitude';
ExternalType = 'Double';
Description = 'Longitude';
Caption = 'Longitude';
}
field(53; msdyn_PostalCode; Text[20])
{
ExternalName = 'msdyn_postalcode';
ExternalType = 'String';
Description = 'Postal Code';
Caption = 'Postal Code';
}
field(54; msdyn_StateOrProvince; Text[50])
{
ExternalName = 'msdyn_stateorprovince';
ExternalType = 'String';
Description = 'State Or Province';
Caption = 'State Or Province';
}
}
keys
{
key(PK; msdyn_FunctionalLocationId)
{
Clustered = true;
}
key(Name; msdyn_Name)
{
}
}
fieldgroups
{
fieldgroup(DropDown; msdyn_Name)
{
}
}
}From the stack trace, it looks like error comes from a Picklist type field. I have only two Picklist fields on my standard Field Service solution:
field(25; statecode; Option)
{
ExternalName = 'statecode';
ExternalType = 'State';
ExternalAccess = Modify;
Description = 'Status of the Functional Location';
Caption = 'Status';
InitValue = " ";
OptionMembers = " ", Active, Inactive;
OptionOrdinalValues = -1, 0, 1;
}
field(27; statuscode; Option)
{
ExternalName = 'statuscode';
ExternalType = 'Status';
Description = 'Reason for the status of the Functional Location';
Caption = 'Status Reason';
InitValue = " ";
OptionMembers = " ", Active, Inactive;
OptionOrdinalValues = -1, 1, 2;
}Do you have more? Or are these ones customized? Is this the only entity you are seeing this error? Keep in my mind you can always create proxy tables manually, you can take the one created above and add more fields if needed.
Shathika94
BazookaMusic
1. Describe the bug I'm trying to sychronize dataverse with Business Central onprem and I have synced User, Account, Business Unit, Work Order Substatus tables from dataverse to Business central using AL Table Proxy Generator which is available with the AL Language extension. However msdynfunctionallocation table is not syncing and giving an error as System.NullReferenceException: Object reference not set to an instance of an object._
Below are the queries that I used to perform the syncing. .\altpgen -project:"C:\Users\abc1\Documents\AL*" -packagecachepath:"C:\Users\abc1\Documents\AL*.alpackages" -serviceuri:"[https://***.crm3.dynamics.com/"](https://*.crm3.dynamics.com/%22) -entities:msdyn_functionallocation -tabletype:CDS**
below is the complete error message I'm receiving.
How to resolve this?
PS C:\Users\adnm1.vscode\extensions\ms-dynamics-smb.al-12.5.914975\bin> .\altpgen -project:"C:\Users\abc1\Documents\AL*" -packagecachepath:"C:\Users\abc1\Documents\AL*.alpackages" -serviceuri:"https://***.crm3.dynamics.com/" -entities:msdyn_functionallocation -tabletype:CDS Microsoft (R) AL Table Proxy Generator version 12.5.13.63033 Copyright (C) Microsoft Corporation. All rights reserved
Authenticating Dataverse using ServiceUri=https://***.crm3.dynamics.com/ Authenticated. Retrieving entity metadata. System.NullReferenceException: Object reference not set to an instance of an object. at System.Collections.Immutable.ImmutableArray`1.get_Length() at Microsoft.Dynamics.Nav.TableProxyGenerator.BuilderBase.CalcDataType(XrmEntityAttribute attr) in D:\a_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\BuilderBase.cs:line 456 at Microsoft.Dynamics.Nav.TableProxyGenerator.BuilderBase.AddNormalField(XrmEntityAttribute attr) in D:\a_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\BuilderBase.cs:line 84 at Microsoft.Dynamics.Nav.TableProxyGenerator.BuilderBase.BuildFields() in D:\a_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\BuilderBase.cs:line 56 at Microsoft.Dynamics.Nav.TableProxyGenerator.BuildContext.BuildFields() in D:\a_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\BuildContext.cs:line 140 at Microsoft.Dynamics.Nav.TableProxyGenerator.TableProxyGeneratorTool.RunCore(CompilerTextWriter consoleOutput, ErrorLogger errorLogger, CancellationToken cancellationToken) in D:\a_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\TableProxyGeneratorTool.cs:line 62 at Microsoft.Dynamics.Nav.CodeAnalysis.CompilationDependentTool.Run(CompilerTextWriter consoleOutput, ErrorLogger errorLogger, CancellationToken cancellationToken) in D:\a_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\CompilationDependentTool.cs:line 125 at Microsoft.Dynamics.Nav.CodeAnalysis.CompilationDependentTool.Run(CompilerTextWriter consoleOutput, CancellationToken cancellationToken) in D:\a_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\CompilationDependentTool.cs:line 77 at Microsoft.Dynamics.Nav.TableProxyGenerator.TableProxyGeneratorCommandLineTool.Run(String clientDirectory, String baseDirectory, String[] args) in D:\a_work\1\s\source\Prod\altpgen\TableProxyGeneratorCommandLineTool.cs:line 29