JustCode and the new SQL Server Data Tools

12 posts, 0 answers
  1. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 18 Mar 2012 Link to this post

    Hi,

    I've upgraded to SQL Server 2012 and am making use of their replacement for Business Intelligence Development Studio (BIDS) called SQL Server Data Tools.  It's basically the same but uses the VS2010 shell rather than the VS2008 shell.

    I suspect there could be a compatibility problem between JustCode and the SQL Server Reporting Services report writing tool (not the separate "report builder v3.0").  Specifically, if I go to edit an expression, I get the usual popup window where I can write something like

    =IIF( Fields!FieldA.Value, "It was true", "It was false")
    .  However upon the first display of that window I also get an error message about an add-in (it doesn't say exactly which one).  I can tell VS not to bother me with the error again, but the editor itself doesn't function very well afterwards.  Keyboarding around the text doesn't work properly - almost as though my keyboard focus is being moved to an invisible window.

    I'm not trying to be lazy - I can uninstall JustCode and give things a try - but for some (potentially unrelated) reason just loading my project takes many minutes (the first few of which have just passed) and I need to knock out a couple of changes to a report.  I figured I had time to log in to Telerik forums, search for this issue, and then, after not finding anyone with similar circumstances, write this entire post...  It's that slow :)

    The reason why I've written about JustCode first over other add-ins is that I can see the expression window displaying what I think are some of the Telerik line markers down the right-hand margin of the text edit window.  I never noticed that sort of behaviour in the old VS2008-based Business Intelligence Development Studio.

    So, I guess my questions are
    a) Could this strange expression editor behaviour be JustCode related?  (I'll assume this is a "yes")
    b) Is there special handling in JustCode to avoid interfering with reporting services work in Visual Studio 2008?  If so, is there similar code in JustCode to handle Visual Studio 2010/
    c) Any other ideas?

    I'm running the latest internal release of JustCode.  I also have OpenAccess ORM installed along with the rest of the Telerik components.

    Later today I'll try to open my project on another machine that doesn't have any Telerik components installed.
  2. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 19 Mar 2012 Link to this post

    Hi,

    I've had to restart visual studio so I took the chance to start it with the /Log parameter to both catch the error message with logging information and also to see why loading a data project takes soooooo long.  That was about 10 minutes ago...  (still waiting for it to finish preparing my solution)

    I've been refreshing the Internet Explorer window that is displaying the activitylog.xml file generated by Visual Studio.  The past few minutes have been visual studio saying things like
    Attempting to add Toolbox item Telerik.Windows.Controls.Data.PropertyGrid.PropertyGridIndentCell
    (substitute every Telerik.* toolbox item) and taking maybe 700ms before spitting out the next line.

    I don't have any other toolbox items than the Telerik controls so they may not be to blame at all - or they could be...
    For example, the built-in Microsoft components also attempt to get loaded, such as
    Attempting to add Toolbox item System.Windows.Controls.Expander

    However this takes only 8ms before moving on to the next line rather than the 700-1000ms taken by each of the Telerik control lines.

    So, is this a known issue?  Was it a problem with BIDS in 2008 that you had to code around?

    I know my way around SQL Server and C# but am not much of an expert with IDE customisation.  Is there a way I can start Visual Studio with some sort of personality where a lot of controls (eg Telerik and other 3rd party ones I may acquire down the line) are simply not present?

    I'll catch the bug report for the expression editor in a moment and add more to this post then.

    Thanks for reading!

  3. DevCraft banner
  4. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 19 Mar 2012 Link to this post

    Further information

    On a server with just SQL Server 2012 Data Tools installed the reporting solution loads VERY quickly - maybe 10 seconds at most.
    No crashes either.

    I've now gone through all of the various extensions that were installed in my instance of Visual Studio and have disabled all of the "productivity enhancement" ones - including those from Microsoft.  The only one not disabled was JustCode since the Disable button is greyed out (which is fair enough).

    Restarting visual studio I'm again watching the log.  The toolbox items are still loading as slowly as they previously did - I didn't expect that to change.

    ...
    It's now loaded.  I can bring up the expression editor and no longer get a crash.  Cursoring around the text of the expression, particularly using the right-arrow key, causes it to switch keyboard focus to seemingly nowhere.  I can use the left-arrow key to move back through the text and occasionally the "end" key works.   All of this is fine on the machine without JustCode (or other extensions).

    I'll remove JustCode and see how it goes soon.  Any feedback you could offer, on either the toolbox load time or on what might be causing the expression editor to misbehave, would be most appreciated.
  5. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 19 Mar 2012 Link to this post

    I have uninstalled JustCode.
     
    It still takes a long time to load the solution.
     
    The good news is that I can now edit reporting services expressions - right & left arrow keys, etc. JustCode wasn't responsible for the crash in the first presentation of the expression editor but it did cause the keyboard behaviour to go awry.
     
    So it does seem that JustCode does have a negative effect on SQL Server 2012 Data Tools (reporting expressions) and the Telerik RAD controls negatively affect the loading time of the solution - although for all I know other 3rd party control libraries could be equally as bad. 


    VIsual Studio 2008 on this same machine, even with Telerik controls and Justcode loaded, doesn't behave this way though.
     
    I'm happy to take logs, etc. I did take some activity logs of the the original crash message and have some activity logs of Visual Studio loading the solution. I tried to zip & rename them as *.png to attach to an earlier post - your message board is too smart and, quite rightly, rejected the attachments :)
     
    I'll be doing some C# development in a day or two and will need to flick between reporting services and C#. If there's some way I can fix this by then, even if it involves have 2 separate shortcuts for Visual Studio, I'll be really happy :)
  6. Ivo Bratoev
    Admin
    Ivo Bratoev avatar
    107 posts

    Posted 23 Mar 2012 Link to this post

    Hi,
     
     I will look into the keyboard navigation while editing reporting services expression.
     I have seen similar problems with slow solution loading due to the Visual Studio toolbox. To verify if this is the same case can you check the Visual Studio status bar while the solution is loading? Do you see something like: "Loading toolbox content from package 'Microsoft.VisualStudio.IDE.ToolboxControlsInstaller,ToolboxInstallerPackage'{2C298B35-07DA-45F1-96A3-BE55D91C8D7A} "?
     This is a Visual Studio related issue and there is a already logged connect bug for it: http://connect.microsoft.com/VisualStudio/feedback/details/551183/loading-toolbox-content-from-package-takes-55-seconds-or-more . My advise is to vote for it there. There is a workaround posted in the bug report but I do not advise to use it as it will break your toolbox completely.

    All the best,
    Ivo Bratoev
    the Telerik team
    Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
  7. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 23 Mar 2012 Link to this post

    Hi Ivo,

    Yes it does say something like that.  I'll read through the connect item.

    Thanks for looking in to the expression editor keyboard handling - it was driving me nuts :)

    I've reinstalled JustCode because the past couple of days have been all C# - SQL reports is early next week again.  If the behaviour is somehow different I'll let you know.

    Thanks!
  8. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 28 Mar 2012 Link to this post

    Any news on this front?  Have you been able to test JustCode in the SQL Server Data Tools Report Builder Expression Editor (big breath!!)
  9. Ivo Bratoev
    Admin
    Ivo Bratoev avatar
    107 posts

    Posted 28 Mar 2012 Link to this post

    Hi,

     I will need some more time to reproduce the issue. I have some issues setting up a test machine with SQL 2012. I will let you know when I have more info.

    Kind regards,
    Ivo Bratoev
    the Telerik team
    Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
  10. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 29 Mar 2012 Link to this post

    Thanks Ivo - look forward to hearing from you about it.
    Cheers,
    Ian
  11. Ivo Bratoev
    Admin
    Ivo Bratoev avatar
    107 posts

    Posted 09 Apr 2012 Link to this post

    Hi,

     I was finally able to setup a test environment and for now I am unable to reproduce the issue you described. Can you make a screen cast reproducing the issue or describe it in more details?
    If an extension crashed there must be some info in the Visual Studio log. Can you start Visual Studio with logging enabled (http://msdn.microsoft.com/en-us/library/ms241272(v=vs.100).aspx) and send me the resulting log (it should at %APPDATA%\Microsoft\VisualStudio\10.0\ActivityLog.xml by default)?

    Kind regards,
    Ivo Bratoev
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  12. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 16 Apr 2012 Link to this post

    Hi Ivo,

    My apologies for the late reply.

    I've reinstalled JustCode - loving it by the way for my C# work :)

    I'll be doing some reporting services work again in the next day or so - if it's better, or still failing, I'll write back here and give more information (activity log, JustCode log, etc).
    Thanks,
    Ian
  13. Ian
    Ian avatar
    26 posts
    Member since:
    Jun 2012

    Posted 22 May 2012 Link to this post

    Hi,

    I've done some binary search -style enabling & disabling of the visual studio 2010 extensions that I had installed.  I started with JustCode, but unlike last time, the problem persisted even after JustCode was completely uninstalled.

    After much fiddling it seems that Microsoft's own VIsual Studio Productivity Power Tools extension causes the issue...  http://visualstudiogallery.msdn.microsoft.com/d0d33361-18e2-46c0-8ff2-4adea1e34fef

    I can only assume that when I last tried removing JustCode I must have also disabled a couple of other extensions and forgot to re-enable them when I was trying to isolate the root cause.

    I have just reinstalled JustCode and all is well :)

    Sorry for reporting what now seems to be a false positive!

Back to Top
DevCraft banner