D365FO - 10.0.24 VHD - Local VM setup Issues

 Microsoft recently released new VHD for D365 FO 10.0.24. Below are some links which explain full process and issues but some steps were not clear to me. 

Dynamics 365 Finance and Operation 10.0.24 vhd 已提供下载-ww12345678 的部落格 | AX Helper

How to configure 10.0.24 onebox VM on Local Laptop (alirazazaidi.com)

Set up the downloadable VHD for first use - Finance & Operations | Dynamics 365 | Microsoft Docs

So, I will explain only those steps which were not clear to me initially:

1) While registering app, I selected below option for "Supported Account Types"

• Accounts in any organizational directory (Any Azure AD directory - Multitenant) and personal Microsoft accounts (e.g. Skype, Xbox)
  

2) In Azure portal, create a new user. Enter user name and leave the domain name (striked out in blue below). 

Once created, open user details and copy the user name (content in red box below)

Use this user name in "Admin provisioning Tool" and you need to try few times before it succeeds (stop batch service before using admin provisioning tool to improve chances of success.

Note: We need LCS account which has D365FO authorization ONLY for downloading VHD files. After this, we don't need MS partner account or enterprise/corporate account for Azure portal . I used my outlook account to login to Azure portal. I got Azure portal by using the 12 month free trial. Use your credit credit for free offer, you wont be charged unless you manually opt.

Btw, I use dual booting to fully utilize 16 GB RAM on my box.

Dynamics 365 for operations - DB sync failed, table FinancialReports (deleting duplicate rows)

DB sync failed - table financialreports

DB sync failed due to error creating a unique index

CREATE UNIQUE INDEX I_4361FOLDERREPORTNAME ON DBO.FINANCIALREPORTS(PARTITION,DATAAREAID,FOLDER,REPORTNAME)

The duplicate key value is (5637144576, 0987, Default Report Definitions, 12 Month Rolling Single Column Income Statement - Default).

When applying application packages, DB sync failures typically occur during creation of unique index:

• New column (unique values) - if table has existing data, sync will try to create blank values in existing rows which will throw error

In my case, I got error in table finacialreports. However, data is correct. data is unique on columns "PARTITION,DATAAREAID,FOLDER,REPORTNAME, designID". But for some reason in our package, the clusteredindex doesn't have designname and hence, it is throwing errors for rows with different design name but same values for "PARTITION,DATAAREAID,FOLDER,REPORTNAME"

To resolve issue temporarily, I used below query to delete duplicate rows.

delete FROM financialreports

WHERE  recID NOT IN (SELECT MAX(recID) as recid

                  FROM   financialreports

                  GROUP  BY REPORTNAME,DATAAREAID,FOLDER,PARTITION

                  /*Even if ID is not null-able SQL Server treats MAX(ID) as potentially

                    nullable. Because of semantics of NOT IN (NULL) including the clause

                    below can simplify the plan*/

HAVING   COUNT(REPORTNAME) > 1

                 -- HAVING MAX(recID) IS NOT NULL

 ) 

Note: Before doing this, make sure you backup data for that table so that it can be used later.

Dynamics 365 for Operations: Use test VM for development VM

We have lot of environments in our project but due to some issues, we needed  to use one of our test VM for development purpose as it has the correct data.

We tried to export and import data to one of the dev boxes but the code base Test and DEV machine are different (which is another story). We were having lot of sync issues especially on views. In AX2012, we can just go and install VS tools. But in AX7, i dont know 

So, here is the approach we followed:

1. Installed VS2015 update 3. VS 2017 is not supported
2. Download binary update from LCS and extract it to a folder. In my case, I used update 4 from MS. In that folder, go to DevToolsService\Scripts, find Microsoft.Dynamics.Framework.Tools.Installer.vsix, double-click it to start the installation and walk through the installation wizard.
3. If you want to create projects, copy MSBuild target files (which are referenced by projects) to the the below location. You can do it using below Powershell script (run as admin and go to DevToolsService\Scripts to run below commands).
1. $dir = New-Item "C:\Program Files (x86)\MSBuild\Microsoft\Dynamics\AX" -Type Directory
2. cp *.targets $dir

After doing this, your VS will have correct settings w.r.t, AX7 database etc.

Now, you can connect to TFS and get latest code. You should also map your workspace properly and start using.

Note: If you want to browse thru the code of AX7 without having the full AX7 setup, please follow this wonderful link: https://community.dynamics.com/ax/b/goshoom/archive/2017/02/03/ax7-development-tools-without-vm

This post is based on the above URL. I thank Martin for his invaluable contribution to AX7 community

AX 2012 SysLookupMultiSelectCtrl issues

While working with SysLookupMultiSelectCtrl, we came across 3 issues:

Scenario: We had 3 controls in our form:

1. Dimension name - displays all financial dimensions (Existing and custom types)
2. Dimension Value - displays values of the dimension selected in the above control
3. ItemId - Multiselect lookup. Shows all released products having above dimension value

Issue 1: ItemId lookup is not opening for the first time. But When i try to open it again(2nd time), it shows data. This issue occurs only when opening for the first time

Resolution: Not sure how this works. But moving below code from ItemId.lookup() to DimensionValue.modified() resolved the issueItemIdCtrl   = SysLookupMultiSelectCtrl::constructWithQueryRun(element, msCtrlItemId, ItemIdQueryRun);

Issue 2: ItemIds are displayed in the multiselect control first time. But when we change the selection in either Dimension name OR value and open the ItemId lookup, data is not refreshed (in fact, lookup method is not firing)

Resolution: Declare ItemIdQueryRun as global variable instead of local variable. After Dimension value selection is changed, get query and querybuildsource from the queryRun and clear ranges from the query. Add ranges again and call refreshQueryRun()

Issue 3:After selecting multiple ItemIds, and then try to get selected products into a container using getSelectedFieldValues() - It returns truncated ItemIds (e.g. ItemId "00050000" is returned as "50000")

Resolution: This is an issue with the getSelectedFieldValues(). getSelectedFieldValues() calls str2con(). str2con() takes an optional parameter to specify whether to convert contents into Int64 or not. It's default value is true. For some reason, multiselectlookup is not passing this parameter to getSelectedFieldValues() and hence values are always converted to Int64 while populating container. We created a new method in SysLookupMultiSelectCtrl and called str2con() with false as last parameter and it worked fine.

References: https://community.dynamics.com/ax/f/33/t/178799

AX7 VM - 500 Error

Few days ago, I have installed AX7 on my local box and it was working fine.

However, when I opened it today, I got Error 500 while opening home page (https://usnconeboxax1aos.cloud.onebox.dynamics.com/en/).

Looks like it is an issue with the date/time. Here are the steps I followed:

1. In my windows 10, I have noted date, time and timezone
2. Restarted and logged into AX7 by selecting AX7 boot option
3. opened date/time settings
4. changed time zone option to match with my win10 OS settings
5. Next sync time with internet time (shown below)
6. screenshot -->
7. After successful sync, you can now login to AX7 successfully

My system setup: I have three OS options at the time of booting. 1) Windows 10 2) AX 2012 R3 VM 3) AX7 VM

Reliance JIO Jiofi2 - Review

Today, I got a Jiofi with the help of my friend Uday. It is the new version of the device with OLED display.

My devices - Desktop, Windows 10 laptop, Meizu M2 Note, Samsung tab P3100

24-Sep-2016 update (Final):

• JIOFI speeds are pathetic even when it shows 4 bars in the JIOFI device
• Jio TV app very frequently fails to connect on my phone. Sometimes, I have to open app, connect to my JIOFI and then connect to my home wifi to see the channel. I guess JIOFI is not able to provide require bandwidth. But once connection is made, the app is not checking whether i am using JIO network or home wifi on a continuous basis.

I decided not to use it anymore, far from my initial thoughts of using it as my primary internet source. May be i will give it to one of my enthusiastic friends who wants to try the JIO experience.

19-Sep-2016: First impression:

• Device is sleek and good looking.
• Initially, speed on my phone is ~50 Kbps but improved after placing it another room
• Connection seems to be dropping but reconnecting quickly. Need to check while I am working on remote desktop as it will be easily confirmed if connection is erratic or not
• What caught my eye is "Designed in India" at the back. Usability could be better. To press POWER button to see the display is not convenient. Instead, the JIO logo could have been a capacitive button to light up the screen.
• I am getting 6 - 11 Mbps on my laptop and 2-3 Mbps on my phone (Tests done using speedtest.net, You have to note that the server used during testing was hosted by JIO. I am not sure whether it has any relevance to speedtest). Note: In my area (Aarambh township, Lingampally, Hyderabad, India - 500 019), network connectivity is very bad (I have Airtel which is very poor, despite reaching out to their open network initiative there is no response or action taken)
• http://www.speedtest.net/my-result/5644676280

Conclusion: 

• Low speeds on phone but decent on laptop. Will check phone settings and update later
• Not yet ready to replace my wired internet with this, need more testing

http://indianexpress.com --> Redirection to shopping sites - Irritating factor

http://indianexpress.com --> Redirection to shopping sites - Irritating factor

Few weeks for now, i have been observing that when I try to open a news article from news.google.com, I am redirected to shopping sites(www.flipkart.com) :( I am not sure if this is an issue with google news OR the website of the news item.

This usually happens with http://indianexpress.com and I guess that this could be intentional or un intentional on the website part (in this is case http://indianexpress.com). This is very irritating and i stopped visiting their news. I hope this is just an isolated experience.

Insurance policy - Safeguards

The Married Woman Property (MWP) Act can protect the life insurance death claim benefit from creditors and ensure that your wife and children are secured. Lack of awareness and loss of control prevents insured from going for this option. Find out how you can benefit from it

Source link 1: http://www.moneylife.in/article/use-the-married-woman-property-act-to-safeguard-your-life-insurance-policy/29728.html

Source Link 2: http://timesofindia.indiatimes.com/insure-your-health/Power-to-women-and-children-Life-Insurance-and-Married-Womens-Property-Act/starhealthshow/18166650.cms

[Updated] SlimBrowser - Slim and Fast

[Updated on 29-Jun-15]: This uses IE rendering engine and is sometimes fast and sometimes slow. Hence, i have uninstalled it. I have IE9 and hence this behaves like IE9 but not a consistent performer especially with script intensive sites like eCommerce e.g. shopclues.com, flipkart.com, paytm.com snapdeal.com, infibeam.com etc


I use my office laptop at home and my Organization doesn't allow us installing any browser other than IE. I am stuck in IE 9 which is pathetic on new age ecommerce sites.

So, I was looking for a small browser which can be installed and and unistalled easily. I came across SlimBrowser (v7) which is just 3+ mb in size. http://www.slimbrowser.net/en/
It got

• installed fast
• No bundled software
• browsing is blazing fast
• Automatically imported all my IE9 favorites into it
• Integration with Facebook - sharing status, current page and selected text,
• Reviews were also good
• Shrinking images during uploads etc (infact you have choice of multiple sizes)

It got good features like IE9 mode, download mgr, ad blocker, popup blocker, privacy, backup and restore etc. So far it looks good, lets see how it fares in the long term :)

Re-evaluate your insurance and improve returns in the process!

I am one of those millions who have taken ULIP Life insurance and other traditional life insurance policies. We are lured by the amount we receive at the maturity.

Rule: With times, we have to re-evaluate our options and choose wisely. I know you all are ready to ask me what has changed...Its the Govt with development as their core agenda. Next 10 years will be roller-coaster ride for all of us. Dont miss the fun (of course take enough precautions)

So, here it goes:

1. According to experts, term insurance is the best option. 
2. For health conscious people, add health insurance.
3. For people with returns in mind, spend the surplus in mutual funds (direct investment to save some more money)
4. For active investors, invest remaining amount in good stocks..
5. Investing in realty is a good option provided you can take enough care (especially open plots...)
6. If your assets (excluding your investments planned for future expenses) is more than your insurance needs, better not take any insurance. Instead invest that amount to increase your net worth.

Note: Review performance of your stocks/Mutual funds periodically to avoid losses (remember above rule)

I have already taken health insurance and in the process of taking term insurance. My wife wont allow me to surrender my LIC and Birla sunLife policies without taking term and health insurance policies :)

Update on 20-Jun-15: I took term insurance from Aegon Religaire and planning to increase the coverage by taking another policy from the same company OR thinking of MAXLIFE insurance. General suggestion is to NOT to take policies from multiple companies to avoid the hassle of running around multiple companies during claim processing.

Medicines at low cost @ Hyderabad

If you are a regular user of medicines and spending thousands every month, here is a way to cut your expenditure.

Today I got medicines at 50% less rate @ "NIMS medical Hall" next to NIMS hospital bus stop. Of course, not every medicine will be given 50% discount. Some medicines will be 20%, some will be 40%.

I got Espogen @ 900/-. In fact, Eripro is just 350/-, Eprox is just 750/-. I used to pay 1600/- for all these medicines at Yashoda hospital.

In fact, i heard that if you go to Koti (wholesale medical shops near Andhra bank), you will get much cheaper.

Here is another option (with free home delivery):

www.medstar.in/
http://www.sastasundar.com/

Quick review of some Indian Brokerage houses by my friend Uday...

https://www.facebook.com/udaykumar.koppanati/posts/873881305973203

We reap what we sow !

If you have more (of anything), there is nothing wrong in enjoying it. But if you gain enjoyment ONLY by flaunting it, beware of the fact that you are seeding corruption in the minds of have-nots, which will hit you back in ways you can't even imagine.

By all means, enjoy what you have modestly! By displaying what you have, you are actually highlighting what others don't have and seeding jealousy in their minds.

This is the root cause of all evils we are now witnessing in our society...

Think for yourself how better the world would have been if we didn't allow obscenity in our movies, everyday life!

What can you do?

Follow this simple rule  --> Respect and value every woman you come across in your life!!!

Another common folly:
Just because you couldn't OR your parents didn't allow you to wear modern (revealing) dresses, don't encourage your next generation to do it in the name of freedom.

May GOD bless India!

Online Telugu weekly

http://www.gotelugu.com/index.php

Women in our Lives!

It takes a CEO of Pepsi Co. to say this and not be blamed!

Click this link to know more --> Women can't have it all says Indra Nooyi !

Be a Transformer

Thanks Uday for taking me to Transformers movie today which reminded me of the current situation!

For first time investors, I think this is the best time to start investing in India, in their future. For naysayers, I am not asking to believe in Modi, I am asking to believe in India and to believe in our collective capability.

As highlighted in many articles on the web, India will be the Youngest nation in world by 2020. Coupled with highly skilled people, able leadership and the opportunities after a lengthy global recession, India is roaring to conquer the world.

Capitalize on the wave by taking proper guidance and TRANSFORM yourself into a MILLIONAIRE OR BILLIONAIRE after few years...

For existing investors, evangelize investing principles to benefit yourself as it improves trading volumes and overall market dynamics :) :)

Cheers,
Jag

Review: Little Italy – Jubilee Hills, Hyderabad

My Rating : (3 out of 5)

After coming from Chennai, we wanted to visit a good Italian restaurant in Hyd. We missed La Focaccia Restaurant. It’s a small restaurant with some nice dishes. Friends suggested a few good ones and finally I took some time to visit the most suggested one “Little Italy” in Jubilee Hills.

We visited on 11-Nov-2012. We tried starters-spl crostini, pasta, crocchette, Mexican rice, mock tail-chiller.

Pasta is heavenly and I would pay even more for the quality. crostini is okay. Veggies served for crocchette is good but not sufficient. Mexican rice is okay. I didn't like Chiller at all but my wife found it to be just okay.

Second course has an exorbitant price tag esp. given the servings and okay taste.

I saw a wise group come and eat Pasta and a cold drink and leave.

Ambience is not good and seating is not at all comfortable for a long evening.

I don't know how many people care about this but i want to mention it here. Its about the awareness rather than cribbing. Service tax should be calculated only on service charges and should not include other amounts. But unfortunately, most restaurants in the city charge way more and Little Italy is no exception. I request them to charge correct amount. In my case, service charge is Rs:79/- approx. and service tax is Rs: 78/- approx..

Technorati Tags: Food

Duplicate messages received by BizTalk

I recently witnessed an issue with AIF in Dynamics AX 2009. The system uses BizTalk adapter to send messages to a subsystem. It was working fine till recently. All of a sudden, we found that BizTalk is receiving multiple messages for each message sent out of AIF.

Here are the symptoms:

• Send messages out of AX using AIF
• Message is successfully sent out and can be seen in document history
• After that, message stays in AIF Queue manager for 10-15 minutes
• In these 10-15 minutes, BizTalk receives the same message multiple times(5-12 times)

What we tried:

• Running AIF receive/send related 4 classes using a job
• Tweaking AIF global settings (disable caching etc)
• Restart AOSes (its a clustered environment)
• shut down one AOS and one BizTalk instance
• No luck after all the above

Here is the solution proposed by MS support:

• Create a new configuration and restart AOS and BizTalk
• Duplicate issue is resolved
• We reverted to the original configuration but Duplicate issue didn't arise

I suspect some where sessions/previous Business connection session information is stuck and the new configuration cleared it up.

Dynamics AX 2009 BizTalk Adapter issue

When ever we change AIF configuration in DAX 2009, we refresh services and sometimes restart AOS to refresh business connector sessions.

However, recently we found that we need to restart BizTalk host instances as well. We never had this issue before. It looks like this is an adhoc issue.

New guest in my balcony...

Now a days, Sparrows are a rare sight. A few days back, we spotted a cute female sparrow in our balcony. It is playing with the mirror. Is it admiring its own beauty or wondering about the other sparrow in the mirror mimicing his acts? See for yourself...