18.10.2022, 14:12 | #1 |
Участник
|
alirazazaidi: TempDB, SrsReportDataProviderPreProcessTempDB And long Running Report Dynamics 365 Finance and operations
Источник: https://www.tech.alirazazaidi.com/te...nd-operations/
============== Recently I got interesting issue. I developed the report based on RDP Class. I have to populate temp table. And based on this temp table I have to aggregate some calculation like sum, Average on Group by. But when I populate another table based on this aggregation. Report starts to go long awaiting state. I dont know the reason. Later I found that I did not give active connection to temp table variables. I added following line of code in reports and report processing reduce to less then 2 minutes this.takeOwnershipOfTempTable(_BEGroupWiseSalarySheetTmp); this.takeOwnershipOfTempTable(_BEBranchWiseSalarySheetTmp); Источник: https://www.tech.alirazazaidi.com/te...nd-operations/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|