Blog

Category: Technology

Delete Personal View from Dynamics CRM 2011 Online

To me, it’s real easy to accidentally create a duplicate Personal View in Dynamics CRM 2011.  What’s not so easy is to figure out how to delete a Personal View.  Once you do it though, it’s very easy but not too intuitive the first time.

 

1. On your main ribbon, click the Advanced Find icon.  You may need to click on an entity to get it to display but selecting most entities in your left side menu will get it to appear (i.e. Dashboards, Leads, Accounts, etc.)

image

2.  In the Look for: drop down select the correct entity for your view.  If you clicked on Advanced Find from that entity, it’ll already be selected.  For my example, it’s Leads.

 

3. Click The Saved Views icon on that ribbon bar.  This is the part that’s easy to overlook and then once you see it, you’re like “Duh!”.  You need to have the Advanced Find tab selected and not File but that should be the case by default.

 

image

 

4.  Now you’ve got your list of Saved Views.  Just put a checkbox on the one you want to delete and click Delete Saved View.

image

 

So easy, I almost didn’t blog about it but since it eluded me I thought I’d go ahead and post any way.




Where’s my Lightswitch ServerGenerated folder in Visual Studio 11

If you’re looking for your /ServerGenerated folder, it’s not there in VS 11 like it is in VS 2010.  The Server and ServerGenerated projects have been combined into one Server project. 




Pass on Elastix for Asterisk Solution

If you’re looking for a commercially supported Asterisk solution, you may want to focus on companies other than Elastix…maybe TrixBox…or I think PBX in a Flash (one of my favorites) has support now.  I was looking for some Asterisk add-ons and found that Elastix had something that might work.  But down on the product info page it had three icons to download the user manuals (in English, French, and Spanish) but no where on the page was it clickable.  None of the words or the images were “hot” so I couldn’t download the guides.  I logged in as a registered user, but still no download.  On the bottom of the page it said to email Sales for more questions so I shot off an email to sales@palosanto.com to let them know about the link issue.  I quickly received an email delivery failure stating that my message was rejected by pbx.palosanto.com as that mailbox was unknown.  Being an IT guy, I’d hate to know my emails to sales@ weren’t working so I called 1-877-ELASTIX (number from the Contact Us page) and hit the option for Sales.  I told the woman “I sent an email to your sales@palosanto.com email address and it bounce back with a delivery failure and I thought you should know.”  Her response baffled me…she said “we’ve already received your incident and someone should be responding to you hopefully by the end of the day”.  I was sort of stunned and just said okay and hung up.  It sounded like a canned response “we’re working on it and get back to you soon”.

So I started typing up this blog to share my experience and just thought I’d have another go at it.  So I called Sales again and repeated it and asked her how she could have already received my issue.  She finally just said “I didn’t really know what you were talking about”.  I explained again and this time she said “oh…that might explain why I haven’t received any emails today.”  Smile 

So maybe it’s not a company issue…but it’s certainly a red flag.  I’m sure others love the product and the company but for me trying to check it out, things seem a little sketchy early.




Unable to load data - please check your network connection and try again

Do you have the Red X and the error "unable to load data" in certain parts of your LightSwitch application.  This problem has plagued lots of people as it's just about the worse, most generic error message.  The "Unable to load data" does nothing to point you in the right direction.  I followed Michael Washington's post and turned on tracing but that didn't give me any clues.  Finally in this post Sheel Shah with Microsoft suggested using Fiddler to see what errors might be coming back. (Notice that the fix to the original issue posted by Mr. Yossu was totally different then my issue though we both had that same generic unable to load data error). 

 Turns out Fiddler did reveal the following:

Error Code: 500 Internal Server Error. The request was rejected by the HTTP filter.

Suddenly, I had something to search on which led me to this post.  As soon as I read it, I knew that was my issue as we are being a TMG firewall.  To test, I accessed the deployed app by internal IP through a VPN and guess what?...No Red X's.  So, if you have deployed your LS app behind TMG (or ISA), here's what you need to do:

  1. Open TMG, click Firewall Policy
  2. Right-click on the rule you use to publish your Lightswitch app and select Configure HTTP.
  3. Uncheck Block high bit characters and Verify normalization.
  4. Click OK and then Apply the rule.

Based on the Stack Overflow post, I thought just unchecking Block High Bit Characters would work but it didn't.  Checking TMG logs I found that my actual error was "Blocked by the HTTP Security filter: URL normalization was not complete after one pass".   I should have known this as we've been bit by the "Verify Normalization" setting previously when deploying a Silverlight Web app.   After making  the changes to the HTTP Filter, it took a few minutes to take effect (probably because we have a TMG array) but in just a few minutes, everything was coming up Red X free.  I hope this help someone else.  It won't fix all the "Unable to Load Data" issues as there are a ton of other scenarios that will give you that error, but it will fix those with the error when TMG is the culprit.

Take care,

John




data loss might occur - SQL single user mode

I've been having challenges Publishing Lightswitch apps when selecting the option to "update an existing database".  For some reason, the Publish will at times run and run and never finish forcing me to kill Visual Studio.  I'm still working on the cause of that issue but when it does work, if you've deleted table rows in your LS app, you'll get an error when you try to Deploy on IIS that says:

Rows were detected. The schema update is terminating because data loss might occur.

Once you get this your database is now stuck in Single User Mode.  Here's the quick fix:

Open a query window in SQL Management Studio.

USE [master]

ALTER DATABASE [your locked DB] SET MULTI_USER WITH ROLLBACK IMMEDIATE

GO

 

 




Setting NTP Time on ProCurve 3500yl

This is probably true for most of the ProCurve line but since I've only performed this on a 3500yl and want make any statements other than "I assume it'll work on most ProCurve switches".   Here's the steps to set the switch to get it's time from an NTP server such as us.pool.ntp.org.

  • Telnet into your switch.
  • Type Menu <Enter>
  • System Information <Enter>
  • Edit <Enter>
  • Arrow down to Time Sync Method and hit <Space> until it's set to SNTP.
  • Arrow down one to SNTP Mode and hit <Space> until it's set to Unicast and hit <Enter>.
  • Arrow to Server Address and enter the address of your NTP server and hit <Enter> (Note: For me I use the ip for us.pool.ntp.org. Since the switch doesn't offer DNS settings, we put the IP and just hope it doesn't change...which it does from time to time. If we have a local NTP server, we use this IP)
  • Move to Save and hit <Enter>

If your switch has access to the NTP server, it updated the time immediately for me which you'll see in the top right of your Switch Configuration Menu.

While your here, you probably also want to set the timezone which is an offset in minutes from GMT.  For example, EST is -5 hours from GMT so you'd enter -300 and save.




The IP address is already assigned to another Microsoft Virtual Machine Bus Network Adapter

 

If you recreate a virtual machine and re-attach the original hard drive, you’ll sometimes get a new NIC created and the original NIC will be ‘hidden’.  There’s other scenarios but that’s the most common for me.  Then new 2nd nic will default to ‘Server Assigned IP’ and then if you try to give it the original IP (assuming you were using static IP’s), you’ll get the error below:

The IP address 10.40.1.3 you have entered for this network adapter is already assigned to another adapter 'Microsoft Virtual Machine Bus Network Adapter'. 'Microsoft Virtual Machine Bus Network Adapter' is hidden from the Network Connections folder because it is not physically in the computer. If the same address is assigned to both adapters and they both become active, only one of them will use this address.  This may result in incorrect system configuration.

I noticed that my NIC was now listed as “Microsoft Virtual Machine Bus Network Adapter #2”.  But how do I remove the original phanthom network adatper.  In Device Manager, if I clicked View and Show Hidden Devices, it wasn’t there.  Finally I found this post by Shankaran with the missing piece. Here’s the steps.

  1. Open a elevated command prompt (run as administrator)
  2. Enter set devmgr_show_nonpresent_devices=1
  3. Enter start devmgmt.msc (Note: Do this from the same command window where you entered the previous command.  This is an important concept that I missed)
  4. In Device Manager, click View and Show Hidden Devices.
  5. Open Network Adapters, and right-click on the hidden NIC most likely named ‘Microsoft Virtual Machine Buss Network Adapter’ and select Uninstall.

Now you can give the IP to your NIC without any conflict.




Updating Hyper-V Guest Time

 

Based on this post, I tried disabling Time Synchronization in VMM but though it seemed to save it never did.

For us, hyper-v servers were part of a domain so the guest AD server was setting the time for the hyper-v hosts and they were setting it for all the guests. So we were in a bit of a loop.  More research led me to Ben Armstrong’s post and his answer to Question #6 got me going.

On the primary Active Directory server (If it’s a hyper-v Guest) add this registry setting

  • reg add HKLM\SYSTEM\CurrentControlSet\Services\W32Time\TimeProviders\VMICTimeProvider /v Enabled /t reg_dword /d 0
  • When prompted to “overwrite”, type Y and hit <enter>

Now you just set the NTP server as normal on that AD server and now it’ll stick.

  • win32tm /config /update /manualpeerlist:us.pool.ntp.org /synchfromflags:MANUAL
  • w32tm /resync

Then to send to each server if you don’t want to wait.

  • w32tm /resync /computer:<computerName> /rediscover

That should do it.




SBS 2008 Shutdown/Restart Scripts

Doing a shutdown or restart on SBS 2008 can be a slow process (and even slower when users are waiting on the server to come back up!).  Stopping the exchange services is a big part of the slowness.  Below are a couple of bat file I use that helps a good bit.  There’s no difference between the two other than whether it’s a shutdown or a restart of the server.

 

ServerShutdown.bat

net stop msexchangeadtopology /y
net stop msftesql-exchange /y
net stop msexchangeis /y
net stop msexchangesa /y
net stop iisadmin /y
shutdown /s /t 00

 

ServerRestart.bat

net stop msexchangeadtopology /y
net stop msftesql-exchange /y
net stop msexchangeis /y
net stop msexchangesa /y
net stop iisadmin /y
shutdown /r /t 00




Filtering “Assigned To” field in TFS 2010

When you select the Assigned To drop down in a TFS work item, you’ll often see a lot of system accounts that you don’t want.  Nikos’ post on TFS 2008 still works for TFS 2010 with the Power Tools.  Previously, I was exporting the XML, editing it, and then re-imported based on Edward Smit’s post and several other forums but once I found Nikos’ post I’ve started just updating it direct with the Power Tools.  I wanted to filter by the Project Administrators and Contributors groups.

I also wanted the ability to “unassign” a task after it had been assigned to a user.   If there’s an easy way to set a work item back “nothing” for the assigned user after it’s been assigned, I don’t know it.  But this is an easy work around.  Create a user called Unassigned and then we just set it to that when we want to let them team know it’s currently unassigned. Here’s the steps…

  1. In VS 2010, click Tools, Process Editor, Work Item Types, and Open WIT from Server. (assumes you’ve install TFS Power Tool)
  2. Select the Work Item Type you want to edit for your Team Project.
  3. Double click the row for Assigned To.
  4. Click the Rules tab.
  5. Select VALIDUSER and click Delete (if you don’t do this you want see users that aren’t valid like our Unassigned user)
  6. Click New and select ALLOWEDVALUES and click OK
  7. On ALLOWEDVALUES, leave For and Not blank.  Click New and enter each of these:
    • [Project]\Contributors
    • [Project]\Project Administrators
    • Unassigned

image

  1. Click OK

image

  1. Click OK again.

That should do it.  Refresh you Team Project and now open the work item of the type you edited and the Assigned To should be filtered now and should include the option to set it Unassigned.