Share
Report
590In 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!
All responses (
Answers (
