Dynamics Community Forum Thread Details

In Cloud Migration Management there is an action "Manage Custom Tables".

I created an extension and inside it a table that matches the definition of GP table GL00100.

table 50140 "GL00100"

{

DataClassification = SystemMetadata;

fields

{

field(1; "[ACTINDX]"; Integer) { DataClassification = SystemMetadata; }

field(2; "[ACTNUMBR_1]"; Text[50]) { DataClassification = SystemMetadata; }

field(3; "[ACTNUMBR_2]"; Text[50]) { DataClassification = SystemMetadata; }

field(4; "[ACTNUMBR_3]"; Text[50]) { DataClassification = SystemMetadata; }

field(5; "[ACTNUMBR_4]"; Text[50]) { DataClassification = SystemMetadata; }

field(6; "[ACTNUMBR_5]"; Text[50]) { DataClassification = SystemMetadata; }

field(7; "[ACTALIAS]"; Text[50]) { DataClassification = SystemMetadata; }

field(8; "[MNACSGMT]"; Text[100]) { DataClassification = SystemMetadata; }

field(9; "[ACCTTYPE]"; Integer) { DataClassification = SystemMetadata; }

field(10; "[ACTDESCR]"; Code[100]) { DataClassification = SystemMetadata; }

field(11; "[PSTNGTYP]"; Integer) { DataClassification = SystemMetadata; }

field(12; "[ACCATNUM]"; Integer) { DataClassification = SystemMetadata; }

field(13; "[ACTIVE]"; Integer) { DataClassification = SystemMetadata; }

field(14; "[TPCLBLNC]"; Integer) { DataClassification = SystemMetadata; }

field(15; "[DECPLACS]"; Integer) { DataClassification = SystemMetadata; }

field(16; "[FXDORVAR]"; Integer) { DataClassification = SystemMetadata; }

field(17; "[BALFRCLC]"; Integer) { DataClassification = SystemMetadata; }

field(18; "[DSPLKUPS]"; Decimal) { DataClassification = SystemMetadata; }

field(19; "[CNVRMTHD]"; Integer) { DataClassification = SystemMetadata; }

field(20; "[HSTRCLRT]"; Decimal) { DataClassification = SystemMetadata; }

field(21; "[NOTEINDX]"; Decimal) { DataClassification = SystemMetadata; }

field(22; "[CREATDDT]"; DateTime) { DataClassification = SystemMetadata; }

field(23; "[USERDEF1]"; Text[100]) { DataClassification = SystemMetadata; }

field(24; "[USERDEF2]"; Text[100]) { DataClassification = SystemMetadata; }

field(25; "[PostSlsIn]"; Integer) { DataClassification = SystemMetadata; }

field(26; "[PostIvIn]"; Integer) { DataClassification = SystemMetadata; }

field(27; "[PostPurchIn]"; Integer) { DataClassification = SystemMetadata; }

field(28; "[ADJINFL]"; Integer) { DataClassification = SystemMetadata; }

field(29; "[INFLAREV]"; Integer) { DataClassification = SystemMetadata; }

field(30; "[INFLAEQU]"; Integer) { DataClassification = SystemMetadata; }

field(31; "[ACCTENTR]"; Integer) { DataClassification = SystemMetadata; }

field(32; "[USRDEFS1]"; Integer) { DataClassification = SystemMetadata; }

field(33; "[USRDEFS2]"; Integer) { DataClassification = SystemMetadata; }

field(34; "[Clear_Balance]"; Integer) { DataClassification = SystemMetadata; }

field(35; "[Workflow_Status]"; Integer) { DataClassification = SystemMetadata; }

field(36; "[DEX_ROW_TS]"; DateTime) { DataClassification = SystemMetadata; }

field(37; "[DEX_ROW_ID]"; DateTime) { DataClassification = SystemMetadata; }

}

keys

{

key(Key1; "[ACTINDX]") { Clustered = true; }

}

The action "Manage Custom Tables" opens up Migration Table Mapping page.

I started the migration but the migration for this table failed:

When I click on Tables Failed cue I see this error:

Violation of PRIMARY KEY constraint 'TWO$GL00100$514b1439-9541-4c23-bcae-c24cd2db2231$Key1'. Cannot insert duplicate key in object 'dbo.TWO$GL00100$514b1439-9541-4c23-bcae-c24cd2db2231'. The duplicate key value is (0).

Am I missing any other steps in order to bring this GP table in?

Thank you!

Community site session details

Bring GL00100 table in BC from GP

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates