Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

alirazazaidi

TempDB, SrsReportDataProviderPreProcessTempDB And long Running Report Dynamics 365 Finance and operations

by

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);

intvNo Interval method is obselete

by

Code suddenly breaks. When I debug I found intvNo method which used to calculate days interval between two dates is not working.

intvNo(empLeave1.EndDate,periodStartDate,IntvScale::Day);

I have replace it with following way.

date2Num(periodEndDate) -date2Num(periodStartDate);

Changing direction of this blog

by

Time changes. Thoughts changes. I am not technical much now. New things are less as technical side. I am facing more challenges in closing things to clients. UAT Sessions and Probably Conference room pilot sessions. Some times I have to fix issue and there is a lot of debugging. Now I am not doing code and development. I have to debug and fix the issues. Other side, I have to discuss with clients, what is possible and what is not possible and how much time require to develop certain feature. Some times I have to develop some process to finalize certain feature.

Now I am facing a lot of notes taking, because I started to forget, what I did two or three days ago. So I am start learning and implementation of Getting thing done, Second brain and Check list Manifesto. And possible something in between.

Now I am more interested in project management, trainings and hand over sessions.

But being a software developer, I am more interest, how it do instead what it do.

Any how if we did not change, we are under the change. So I am thinking to shift this blog to highly technical blog to simple musing revolving around software development. Management issues. Client handling tips.

How to configure 10.0.24 onebox VM on Local Laptop

by

Most of the time, I usually run Dynamics 365 Finance and Operations vm on my personal Laptop for R&D purposes.

But after downloading latest 10.0.24 vm from LCS. I am unable to run , admin User Provisioning tool. I got following error.

The value’s length for key ‘password’ exceeds it’s limit of ‘128’.

Later on LinkedIn Microsoft Employee Volker Deuss shared a link which helps me resolve this issue. Here are my notes.

Now Microsoft requires you to create one web application register in Azure portal.

And before your provide your user as provision as admin, you have to perform one more step.

Generate Self-Signed Certificates and here we use this application id. It configure some certificates.

And interestingly your own azure portal without tenant is not work. You have to create web application. in your tenant azure subscription. It will not work like my personal email. even I purchase azure subscription on my personal Id alirazazaidi@live.com And web application register there is not work.

So here are some steps to create register application in following steps.

open your azure subscription. and type in search box on top register app

Click on new registration.

Enter the name

Enter local Dynamics url. We used this link inside the Vm.

Also select web in first drop down. Here we need to create a web

Enter name and in

add one more redirect.

Click on Redirect URIs and add one more.

Save it a

Now copy the application id created and go to Dynamics vm

and now go to Dynamics VM. and right click on Generate Self Signed Certificates.

Next step Press N. and let it process , it will restart the services, Batch job. When this job is completed. You can register same domain id as admin Provision

And my id is become successful admin

And successful, run Ax 10.0.24 on my local laptop.