In good measure, here at IntellPartners we eat our own dog food. As of January 1, 2014 we completed our internal rollout of Microsoft Dynamics GP 2013 and web client on Windows Azure for our US headquarters and our UK, and Ireland subsidiaries. Needless to say, we are pretty excited about the prospects of accessing our data from just about anywhere in the world, at any point in time, and without barriers. Also loving the ability to use Business Analyzer as our reporting delivery method.
All was going well until a few days aback I began receiving a Silverlight exception, each time I attempted to access the Sales option on the Navigation Bar:
As a result, I fired up the Web Management Console and activated the traces for the session to determine what the issue could be. The traces showed nothing specific. After exhausting all options, I contacted my good friend Jason Lech, Escalation Engineer over at Microsoft who indicated seeing this issue once. Jason had me verify the content of the Navigation Pane Options window, looking for duplicate entries.
Unfortunately, this visual inspection yielded no results. Nonetheless, Jason had indicated to remove any duplicate entries from the SY07140 table if I happened to find spot any duplicate entries in the Navigation Pane Options window. I then proceeded to fire up SQL Server Management Studio to search for duplicates in the SY07140 by writing a simple query which yielded no results.
Since I had nothing to lose at this point, I truncated the table:
TRUNCATE TABLE SY07140;
Once this query was executed, I launched the web client once more and follow the standard credential validation procedures. Once I logged back into Microsoft Dynamics GP, it recreated all area page entries in the SY07140 as expected. I clicked on the Sales navigation bar and all was good once again.
In retrospect, the only thing I did prior to getting the Silverlight exception was to add a few sales series windows to my Quick Links entries, but can't be sure this caused the problem. Also to note, the Microsoft Dynamics GP 2013 desktop client running on the session host machine did not show any errors clicking on the Sales navigation bar.
I will try to re-add the same entries back to Quick Links to attempt to reproduce the issue. Keep an eye out for the follow up article.
Until next post!
Mariano Gomez, MVP