Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Can't go to table definition and given error

Posted on by 2,988

Errorcod2.pngErrorinCode.jpgErrorinCode1.jpg

Hi Experts,

I want to add some fields in cust aging DP class(Standard Report), if i am trying to insert it giving an error(even i made fields in temp table already) as shown in the image. The second thing is if I tried to go to the definition of this temp report it behaves like a map giving an error please check.

Best Regards,

Shabir Ahmad

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Can't go to table definition and given error

    Hi Sergei Minozhenko,

    First thanks for your suggestion that worked, one point is there why temp table behave like MAP if I want to go to its definition it doesn't work check-in the image in the post.

    Best Regards,

    Shabir Ahmad

  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,083 on at
    RE: Can't go to table definition and given error

    Hi Shabir,

    The number of fields in insert_recordset section should be the same as in select section

    You have the same case as below: field3 is missing from select section. You need to review all fields in insert_recordset * select statement and find what field is missing in select.

    insert_recordset myTable 
    (
        field1,
        field2,
        field3)
    )
    select
        field1,
        field2
        // field3 is missing
    from myTable1

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Can't go to table definition and given error

    Errorcod3.png

    Hi Sergei Minozhenko,

    I added fields in tmp table before then i came here to add these fields.

    Best Regards,

    Shabir

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,083 on at
    RE: Can't go to table definition and given error

    Hi Shabir,

    The error in infolog shows that you added a field to insert_recordset section (SortOrder?), but have not added the source field in select section.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans