Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Getting error while exporting Entity

(0) ShareShare
ReportReport
Posted on by 100

Hi Experts,

I have imported bulk data in new Database.

I am exporting data from the Entity - EcoResProductAttributeValueV3Staging but after taking a long time it is showing error.

Error log - 
Cannot select a record in Product attribute values V3 (EcoResProductAttributeValueV3Entity).
A time-out occurred in the database while the query was executing.
Results. SELECT T1.PRODUCTNUMBER,T1.ATTRIBUTETYPENAME,T1.ATTRIBUTENAME,T1.CURRENCYCODE,T1.CURRENCYVALUE,T1.BOOLEANVALUE,T1.DATETIMEVALUE,T1.DECIMALVALUE,T1.INTEGERVALUE,T1.TEXTVALUE,T1.FLOATUNITOFMEASURE,T1.INTUNITOFMEASURE,T1.UNITOFMEASURE,T1.FLOATUNITOFMEASURESYMBOL,T1.INTUNITOFMEASURESYMBOL,T1.RECID#2,T1.RECVERSION#2,T1.RECID#3,T1.RECVERSION#3,T1.RECID#4,T1.RECVERSION#4,T1.RECID#5,T1.RECVERSION#5,T1.RECID#6,T1.RECVERSION#6,T1.RECID#7,T1.RECVERSION#7,T1.RECID#8,T1.RECVERSION#8,T1.RECID#9,T1.RECVERSION,T1.PARTITION,T1.RECID FROM ECORESPRODUCTATTRIBUTEVALUEV3ENTITY T1 WHERE (((((((((PARTITION=5637144576) AND (PARTITION#2=5637144576)) AND (PARTITION#3=5637144576)) AND (PARTITION#4=5637144576)) AND (PARTITION#5=5637144576)) AND ((PARTITION#6=5637144576) OR (PARTITION#6 IS NULL))) AND ((PARTITION#7=5637144576) OR (PARTITION#7 IS NULL))) AND ((PARTITION#8=5637144576) OR (PARTITION#8 IS NULL))) AND (PARTITION#9=5637144576)) ORDER BY T1.PRODUCTNUMBER,T1.ATTRIBUTETYPENAME,T1.ATTRIBUTENAME.

Can anyone suggest something

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Getting error while exporting Entity

    Check this thread for large volume of data export from data entities

    community.dynamics.com/.../890277

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Getting error while exporting Entity

    HI Harish,

    If there is a lot of records, best way will be adding filter to split the number of records to be exported.

    4666.Capture.PNG

    This filter is similar to the Advance filter and sort option on the forms.

    Refer to the below documentation for query syntax.

    https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options

    Thanks,

    Girish S.

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Getting error while exporting Entity

    If the records are in lakhs, then I would suggest you to add the filter and do the export in batch.

    For setting timeout, you can follow the same thing how we will do it for SSRS reports. But setting timeout with long times will actually affect the total system performance.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Getting error while exporting Entity

    I haven't changed timeout settings but you can try in Data import/export framework parameters

    check this article

    dynfotech.com/.../

  • HARISH MEHRA Profile Picture
    HARISH MEHRA 100 on at
    RE: Getting error while exporting Entity

    Hi Rampal/Preetham,

    The records are in lakhs.

    Preetham- How to increase the timeout time.?

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Getting error while exporting Entity

    How many records are there in underlying table in that legal entity and are you exporting for one or all legal entities 

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Getting error while exporting Entity

    So the issue is with data. It might have lot of data. You need to increase the timeout time or you need to give the filter and run in batch.

  • HARISH MEHRA Profile Picture
    HARISH MEHRA 100 on at
    RE: Getting error while exporting Entity

    Hi Rampal,

    Yes Facing issue when Exporting in Batch. If I export using Filter for some records. It is working fine.

  • HARISH MEHRA Profile Picture
    HARISH MEHRA 100 on at
    RE: Getting error while exporting Entity

    Hi Preetham,

    Yes I have checked and it is returning some data.

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Getting error while exporting Entity

    Are you facing this issue only in this data entity? Can you try export in Batch option from your data project.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans