web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SRSReportDataProviderT...
Finance | Project Operations, Human Resources, ...
Suggested Answer

SRSReportDataProviderTMPDB method 'linkPhysicalTableInstance() issue !

(0) ShareShare
ReportReport
Posted on by vinilkumar 318

Hi Team,

It's an reporting issue, As per RDP Based Resport, currently we are using the table type as Inmemory.

But, currently we are facing the performance issue on this report I.e while opening the rerport some times got a performance issue meand not opended and throwing an exception.

So, I have to decide for Debug. As per report debuggin only on 'DPProcess/DPprocessTmpDB' classes and I extended the 'DPProcessTmpDB' instead of DPbase class because TmpDB type can accept here.

As per the flow, I have changed the table type -> TmpDB In table property.

my concern is coding means we have to write the method 'linkPhysicalTableInstance()'.

pastedimage1610713491325v2.png

Please see the above one, they were using SETTmp() Mthod. This will store into the client/server.  for debugging  where to call this method 'linkPhysicalTableInstance() ?

pastedimage1610713572419v3.png

pastedimage1610713699525v4.png

pastedimage1610713745707v5.png

pastedimage1610713833452v6.png

Note: my concern is, get resolved the issue to change the TMPDB.

For debugging we must call this method 'linkPhysicalTableInstance(), pleaese help me on this.

Thanks,

Vinay.

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    Hi vinilkumar,

    How did you determine that the type of the temp table is the cause for your performance issue? I recommend you to first make sure that you understand the cause of the issue, before starting to refactor things that are possibly not relevant at all.

    What exception did you get when running the report?

    Here's my suggestion: put back your original code, but comment out the line that inserts to temp table. Now the report is obviously empty, but you can see whether it still takes a long time to load. If it still takes a long time to load, then the temp table type has nothing to do with your issue.

    Most likely the performance issue is caused by the code that you use to populate the temp table (fetching a lot of data from many places, possibly with inefficient code).

  • vinilkumar Profile Picture
    vinilkumar 318 on at

    Thanks for your reply, we are running the report 7 -8 times + per time.

    Each time data storing into the in-memory (basically using for less amount of data) into the client/server means will be stuck there. This will be the cause so, we want to change as Tempdb ( will be storing into the db means handling large volume of data).

    Regarding the performance issues, generally we will use the 'dppreprocesstmpdb' class for this I want to change to tempdb.

    I hope you knows right diff between in-memory and tempdb.

    Thanks,

    Vinay.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    Hi,

    if you want to change the table type to TempDB, you could check almost any standard report in the system that is using a temp table, and see how they are handled in the report class.

    For example BankAccountStatementTmp.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans