Among the myriad of reasons why I like employing Scrum for software development, I think the main reason is the frameworks ability to remove what is often called Technical Debt (TD) or Design Debt. Ward Cunnigham was the one who coined the term and simply put, the concept is when improper code is created, the assumption is to make the code “complete” at later date (i.e. refactoring) however these changes are shelved and never truly completed. The finance analogy would be using your high…(read more)

In Part 1, we looked at a scenario using the Service Bus as a WCF relay endpoint that allowed clients on the web to communicate with a WCF service hosted on my local machine.  The workflow looks something like below, where a publically available endpoint (a simple ASP.NET application on Windows Azure) made calls to my service, self-hosted in a WPF application and running on my local machine, behind a firewall but attached to a relay endpoint in the Service Bus.

A Service Bus relay implementation is fairly straightforward, well for anyone that has done WCF programming, since the primary difference from the on-premises scenario is the use of a Service Bus namespace to host the endpoint and a set of relay bindings, most of which have analogs in the on-premises world (we used BasicHttpRelayBinding in the previous post).

All that works fine, but there is a significant drawback in the approach: both sides have to be “up” at the same time or the communication fails.  Sure that happens on-premises too, and you can build retry logic in, but wouldn’t it be easier if all that were just done for you? That’s where Service Bus queues come in. A queue provides a place for the messages to sit in case there are no clients available to process them, perhaps because the client is down or too busy. As an direct result of this ‘temporal decoupling,’ it’s possible now for senders and receivers to operate at different rates; furthermore, multiple consumers that work off the same queue can process messages at their independent own rates.  It’s the same type of “competing consumer” model as a queue in a bank where you’re waiting to be served by the next available teller.

As the focus of this post, I’ll take the existing sample I walked through in the previous blog post and modify it to work with Service Bus queues. As with that previous sample, you can download the full source code from GitHub, although you will need to modify the application settings (in App.config and web.config) to use the Service Bus identities and keys you set up for the previous sample.

Creating a Queue

The first step is to create a Service Bus queue.  You can do that programmatically or  via the Windows Azure Portal directly under the Service Bus namespace you created in part 1.  Here I’ve created a queue named thequeue and left all of the properties at their default settings:

• Default message time to live (TTL) indicates how long the message will sit on the queue before it is deleted.  That curious default number there is just over 29000 years, by the way! If you also check the Enable Dead Lettering on Message Expiration box, the message will be moved to a special dead letter queue with an endpoint in this case of sb://heyjim.servicebus.windows.net/thequeue/$DeadLetterQueue
• Queues also support duplicate message detection where a message’s uniqueness is defined by the MessageId property.  To detect duplicates, you’d check the Requires Duplicate Detection checkbox and set the time window during which you want duplicates to be detected (Duplicate Detection History Time Window).  The default is 10 minutes, which means that a second message with the same MessageId that arrives within 10 minutes of the first occurrence of that message will automatically be deleted.
• Lock Duration specifies the length of time (with a max of five minutes) that a message is hidden to other consumers when the queue is accessed in PeekLock mode (versus ReceiveAndDelete mode).
• The Maximum Queue Size can be specified in increments of 1GB up to a maximum of 5GB; each message can be up to 256KB in size.
• If Requires Session is checked, messages that must be processed together by the same consumer can be accommodated.  A session is defined at message creation time using the SessionId property.  Setting this property requires that clients use a SessionReceiver to consume messages from the queue.

All of these properties can be set when you programmatically create a queue as well (using the CreateQueue method via a Service Bus identity that has the Manage claim).  In fact there are two additional (QueueDescription) properties that don’t seem settable via the portal:

• EnableBatchedOperations indicates that Send and Complete requests to the queue can be batched (only when using  asynchronous methods of the .NET managed client), which can increase efficiency; by default batched operations are enabled.
• MaxDeliveryCount (default value: 10) indicates the maximum number of times a message can be read from the queue. This setting applies only when the MessageReceiver is in PeekLock mode, in which a message is locked for a period of time (LockDuration) during which it must be marked complete, or it will again be available for processing.  MaxDeliveryCount then figures into strategies for poison message processing, since a doomed message would never be marked complete and would otherwise reappear on the queue ad infinitum.

Coding the Consumer

In our example, the message queue consumer is the WPF client application. In the on-premises scenario covered by my previous post, the WPF application self-hosted a WCF service endpoint through the Service Bus using BasicHttpRelayBinding. With queues you can also use WCF semantics via a new binding, NetMessagingBinding, and Tom Hollander covers this approach in his blog. Alternatively, you can use the REST API from any HTTP client, or as I’ll cover here the .NET API.

The code for processing the messages is launched on a separate thread from the simple UI of the WPF window. The complete code appears below, with the more salient portions highlighted and explained below.

   1:  internal void ProcessMessages()

   2:  {

   3:      try

   4:      {

   5:          MessagingFactory factory = MessagingFactory.Create(             

   6:              ServiceBusEnvironment.CreateServiceUri("sb",                

   7:                  Properties.Settings.Default.SBNamespace,                

   8:                  String.Empty),                                          

   9:              TokenProvider.CreateSharedSecretTokenProvider("wpfsample",  

  10:                      Properties.Settings.Default.SBListenerCredentials));

  11:          MessageReceiver theQueue = factory.CreateMessageReceiver("thequeue");

  12:   

  13:          while (isProcessing)

  14:          {

  15:              BrokeredMessage message = theQueue.Receive(new TimeSpan(0, 0, 0, 5));

  16:              if (message != null)

  17:              {

  18:                  Dispatcher.Invoke((System.Action)(()

  19:                      =>

  20:   

  21:                  {

  22:                      NotificationWindow w;

  23:                      try

  24:                      {

  25:                          w = new NotificationWindow(                 

  26:                              message.Properties["Sender"].ToString(),

  27:                              message.GetBody<String>(),              

  28:                              message.Properties["Color"].ToString());

  29:                      }

  30:                      catch (KeyNotFoundException)

  31:                      {

  32:                          w = new NotificationWindow(

  33:                              "system",

  34:                              String.Format("Invalid message:\n{0}",                                                      message.GetBody<String>()),

  35:                              "Red"

  36:                          );

  37:                      }

  38:                      WindowRegistry.Add(w);

  39:                      w.Show();

  40:                      message.Complete();

  41:                  }));

  42:              }

  43:          }

  44:      }

  45:   

  46:      catch (Exception ex)

  47:      {

  48:          Dispatcher.Invoke((System.Action)(()

  49:              =>

  50:              {

  51:                  btnServiceControl.Content = "Start Responding";

  52:                  this.Background = new SolidColorBrush(Colors.Orange);

  53:                  this.isProcessing = false;

  54:              }));

  55:          MessageBox.Show(ex.Message, "Processing halted",                                  MessageBoxButton.OK, MessageBoxImage.Stop);

  56:      }

  57:  }

Lines 5-10 set up the MessagingFactory which establishes the Service Bus endpoint and the credentials for access (the wpfsample user is assumed to present the Send claim as set up in my prior blog post).  In Line 11, a MessageReceiver is instantiated pointing to the queue that we explicitly created earlier via the Windows Azure portal.

The call to Receive in Line 15 yields the next message on the queue or times out after five seconds. If no message appears on the queue within that time period, the resulting message in Line 16 is null. The enclosing while loop will then iterate and continue to await the next message.  (The isProcessing flag is a class level variable that enables the WPF application user to stop and start listening on the queue; it’s set via the command button on the user interface).

The message returned is of type BrokeredServiceMessage, through which you can access header information in a Properties bag and obtain the message payload itself via the GetBody method (Lines 25-28).  If the message doesn’t contain the expected content, for instance the headers aren’t set, some action needs to be taken. Here the remediation (Lines 30ff) is to simply display a error message via the same method as for a legitimate notification, but we could have taken another approach and moved it to the dead letter queue, via the aptly named DeadLetter method, where some other process could inspect and forward messages for human intervention or diagnosis.

With the message processed, the last step is to mark it complete (Line 40). That should be a cue that I’m using the (default) PeekLock semantics on the queue. If I’d set theQueue.Mode = ReceiveMode.ReceiveAndDelete; the message would automatically be deleted; however, I would have run the risk of losing that message had there been a service outage or error between retrieving the message and completing the processing of the message.

Other possibilities for handling the message include:

abandoning it, in which case the peek lock on the message is immediately released and the message become visible again for another consumer,

moving it to the dead letter queue as mentioned earlier, or

deferring the message and moving on to the next one in the queue. Here you must retain the SequenceNumber and call the overloaded Receive method passing that number at the point when you do wish to process the message.

Coding the Producer

The message producer in this case is the ASP.NET web application. It could be hosted anywhere, like say Windows Azure, but if you’re just testing it out, you can run it from the Azure emulator on your local machine or even just via the development web server (Cassini) from within Visual Studio.  The code follows:

   1:  protected void btnSend_Click(object sender, EventArgs e)

   2:  {

   3:      if (txtMessage.Text.Trim().Length == 0) return;

   4:      String userName = (txtUser.Text.Trim().Length == 0) ? "guest" : txtUser.Text;

   5:   

   6:      // create and format the message

   7:      BrokeredMessage message = new BrokeredMessage(txtMessage.Text);

   8:      message.Properties["Sender"] = txtUser.Text;

   9:      message.Properties["Color"] = ddlColors.SelectedItem.Text;

  10:   

  11:      // send the message

  12:      MessagingFactory factory = MessagingFactory.Create(

  13:          ServiceBusEnvironment.CreateServiceUri("sb",

  14:          ConfigurationManager.AppSettings["SBNamespace"],

  15:          String.Empty),

  16:          TokenProvider.CreateSharedSecretTokenProvider(

  17:              userName,

  18:              ConfigurationManager.AppSettings["SBGuestCredentials"]));

  19:      factory.CreateMessageSender("thequeue").Send(message);

  20:  }

In Lines 7-9, a new message is created from the text provided in the Web form, and two properties set, one corresponding to the name of the sender and the other corresponding to the selected color. 

Then in Lines 12-18, a MessagingFactory is likewise instantiated; however, here the Service Bus identity (guest, by default) needs the Send versus the Listen claim.

In Line 19, the message is sent via a MessageSender instance.  It’s done synchronously here, but asynchronous versions of Send and other operations on the complementary MessageReceiver class are also available (and preferred in most cases for scalability and user experience reasons).

Grab the Code!

I’ve added the code for the brokered messaging sample to the relay sample code already on GitHub (MS-LPL license) so you can experiment on your own. Next time we’ll look at a more advanced publication/subscription scenario leveraging Service Bus topics and subscriptions.

Du missar väl inteTechEd Europe 2012 i Amsterdam den 26-29 juni.
Med 400 sessioner fördelade på 12 tracks finns det något för alla.

[??????]  LightSwitch Community & Content Rollup–April 2012

[??????]  2012-05-01 7:11 AM

???????????????Visual Studio LightSwitch??????????????????? ??? ????????????????????????????? LightSwitch ??&????

?2 ? 29 ???Visual Studio 11 beta ??? 4 ?????????Beta????????????????????? Visual Studio 11 Beta?????????? LightSwitch Beta ?????????

????????LightSwitch UserVoice ?
???? ??bug ??? LightSwitch Connect??
???????? LightSwitch beta ???
?????????? LightSwitch ??????

Visual Studio Beta? LightSwitch???

LightSwitch ???????????Visual Studio 11 ????LightSwitch????????????????????LightSwitch ???????????????????????????????????????????

• ?? Visual Studio 11 Beta?? LightSwitch
• Contoso ??-LightSwitch ???? ?Visual Studio 11 Beta?
• LightSwitch ????? OData
• LightSwitch Beta
• LightSwitch Cosmopolitan Shell???
• ?? Visual Studio 11 Beta ?LightSwitch ???????

??????

?Visual Studio 11 ??LightSwitch???????????????OData? ??????????LightSwitch??? OData ???????????????? OData ?????????????????????4 ?????????????LightSwitch ????????????????????????Michael Washington, ???????www.LightSwitchHelpWebsite.com????????????????

MSDN ????? ??? LightSwitch

? 3 ??????LightSwitch ??????????? MSDN ?????????? LightSwitch ????4??Jan van der Haegen?????????????LightSwitch????

??? LightSwitch? LightSwitch MVVM ??

???????? LightSwitch ????Jan ??? MV3?????LightSwitch?????MVVM ?????????????????????????????

???Visual Studio LightSwitch??

Paul Ferrill??????????????????? LightSwitch??SharePoint ?????????????LightSwitch ?????? SharePoint ???????

??Tim Leung?Yann Duran??????? Visual Studio LightSwitch 2011 ??????????????LightSwitch ?????????????????????

????LightSwitch ????

• ?? Microsoft Visual Studio LightSwitch? ??
• ?? Visual Studio LightSwitch ????? (?????)
• ?LightSwitch ???????????
• Microsoft Visual Studio LightSwitch ?????????
• ??? Microsoft Visual Studio LightSwitch

Xpert 360 ?Dynamics CRM Online Adapter LightSwitch ?????

? 4 ???Xpert 360???????? LightSwitch ??????????Dynamics CRM????????????????Salesforce???????????

• ?????Microsoft Dynamics CRM ?Lightning Adapter
• ?????? Visual Studio LightSwitch???? Microsoft Dynamics CRM Online Adapter
• ?? ???LightSwitch Help Website?? Xpert 360 ?Dynamics CRM Online Adapter LightSwitch ??

?????????????? LightSwitch ??

?????? LightSwitch ???Visual Studio??????? #LightSwitch twitter feed?????????????????????????

• ComponentOne LightSwitch ??— — FlexGrid?OLAP?Scheduler
• ?? LightSwitch?DevExpress XtraReports — — ?????????
• ?? LightSwitch ????????— — ???????
• ??LightSwitch? Infragistics NetAdvantage ??— —????? ???? ??? ????? ??? ?
• ?? LightSwitch ?RSSBus??????— — 14 ???????????????

MSDN Webcast? Visual Studio 11? LightSwitch ????

?5 ? 11 ?????? 1:00????????????? Visual Studio 11 ?LightSwitch?????.

Microsoft Visual Studio LightSwitch ?????????????????????????????? Visual Studio 11??LightSwitch ???????????????????????????????????????????????? OData ??? ?????????????????????????

??????

?????????

?? ????????? 85?!):

???????????????????????

• Elyl ???
• MicroApplications LightSwitch ????
• DELORDSON ?Shell

?? (???????? 80?):

• ? LightSwitch ??????????
• ? Visual Studio LightSwitch??????????????
• ????????? LightSwitch ????

?????

???? Visual Studio 11 ?LightSwitch??????????????

• Active Directory Group ??
• ??Commuter OData ?????? LightSwitch ?????? 2 ??
• ??Entity Set Filter????
• ??? LightSwitch ???????
• ?????? LightSwitch ???
• ? Visual Studio 11 LightSwitch??????????????????
• ???Attached Database Data Sources??????
• ?Visual Studio 11 LightSwitch ????? SQL Server LocalDB

???????????“??”?????????????LightSwitch?

• ? LightSwitch ??????????
• ????????? LightSwitch ????

??????

• ?????.Html ?????? CRUD DataJs ? KnockoutJs LightSwitch ??
• ??? CRUD LightSwitch JQuery ??????
• ????????????? — — ???
• LightSwitch Netflix OData ??
• ?? Android App Inventor?LightSwitch ??
• DELORDSON ??? 6 ???????Shell
• ????????????????????????…
• LightSwitch ? OData? ??????
• SD ??? ?LightSwitch ???
• ?? WCF RIA??????? LightSwitch OData
• ?? Visual Studio LightSwitch ???Unity 3D ??
• ?? LightSwitch OData??OData Explorer

LightSwitch ??????

??Visual Studio LightSwitch ? Facebook ???????????????????????????????????????????? LightSwitch ????????
LightSwitch MSDN ??
LightSwitch ??????
LightSwitch ????
? Twitter ?? LightSwitch?@ VSLightSwitch?#VisualStudio #LightSwitch?

?????? ?

if you are seeing error 80072ee7 when trying to sing into Messenger it could be because that you are not connected to the Internet.

Here are 4 things you can check…

1. Make Sure you PC is connect to the Internet
2. refresh your IP Configuration
3. Check your DNS cache
4. Check to see if Messenger is allowed through your firewall

read how to do all these things at Messenger sign-in error 80072ee7

Get more help for Messenger

Rob

Das Content Delivery Network (CDN) ist ein Verbund von Windows Azure Rechenzentren, die weltweit verteilt sind. Im CDN können Inhalte aus Windows Azure Blob Storage für einen bestimmten Zeitraum gecached werden und somit eine effiziente Auslieferung von Inhalten des Blob Storage sicherstellen: Ein Anwender erhält beim Zugriff Blob Storage Inhalte aus dem für ihn nächstgelegenen Rechenzentrum ausgeliefert. Ich gebe in dem Video einen Überblick über das CDN, Hinweise darauf, worauf bei dessen Nutzung geachtet werden muss und zeige Aktivierung und Deaktivierung des CDN am Beispiel.

Hier das Video: Was ist das Windows Azure Content Delivery Network? [10:20]

Weitere Informationen

• Video: Was ist das Windows Azure Content Delivery Network?
• Video: Was ist Windows Azure Blob Storage?
• Video-Playlist zu Windows Azure auf YouTube

(???? ??2012? 4??? ?? ?? ??? ?? ?? ??????. ??? ???? ???? ??(http://www.embeddedworld.co.kr/) ? ????. ?? ?? : http://www.embeddedworld.co.kr/atl/view.asp?a_id=5538)

???
????
????
???
??
?? – 2) ???, ?, ??
??
???
???
???
??
??

: ???, ??
??
???
???????
??
???
????
????
???
??
????
????
????
????
???
?
???
?
??
??
???
??
??.

????

??
???? ??? ??? ????? ???
????? ??
?
??
????
???
????
??
???
??
???
??
???
???. ??
???
???
??????
????
????
???
???
????????
???? ???? ???, ??? ???? ? ??? ?? ?? ?? ?????.

???
????
????
????
???

?? ??? ???? ?????
????
?
????
???
???
??. ?
????
???
??? ?? ?? ??? ??? ? ? ??. ???
???
????
????
?????? ???? ??? ??
???
???
????
??
????
??
? ?? ?? ???
????
????.
??
????
????
??
???
???
???
??
?? ??? ?? ? ??. ??
??
?????
????
?????
???
???
????
????
???
?
??? ??? ?? ???? ???? ??, ????? ???? ???? ?? ???? ?? ????.

?
????
??
???
???
????
???
???
??
??
????
????
???
??
?
??. ???
??
????
????, ? ??? ????
???
???
??
??
????
???? ?? ??? ???
???
??, ??? ????? ? ??
???
??
?
??. ??
??
????
??? ??? ?? ???????
??
???, ? ??????? ?? ??
???
?
??
????
????
??. N ??? ????? ????? ????? ???? ?? ??? ??? ??? ??.

?
????
???
????
???
??
????
???
?
?
??. ??
????
????
??
???????
??
????
????
?????
??
??
??
??
????. ???
?
??
????
????
??? ??? ?? ? ??, ??
??
??
??
??
???
???
????
??
??
???
??
?
??. ??
????
???
?
?
???
???
???? ??
????
????
???
??
??.

???
???
???
?
???, ?????? ?? ? ??? ????? ???? ??? ???? ??? ??? ???? ????? ???? ???? ??? ??? ?? ???, ??? ?? ???? ???? ?? ??? ???? ?? ??? ???
????.

????
????
??
?
???

???
????? ???? ???? ?????? ??? ?? ?????
??
????
?????????
????
?????
???
??
???
???
????
??
???
???
????.

???
?????
??
?
??
???
????
????. ??
?
????
???
??
?
???
????
?????
???
?
??
???(Table) ????
??.
???(entity)?
????
????, ???
????
????(property)?
???? ????. ??? ???? ???
????
??
??
???
????
????
???
???
?
??. ??? ??? ????? ???? ??? ?? ?? ??? ?? ?? NoSQL ???? ???.

???
???
??

?
????
????
???
??
?????
????
???
??
????
??
???
?
??
????
???
?????
??
??(BLOB: Binary Large Object) ?????
????
????
???
?
??
???
??
??. ?? ???
????(Container) ?? ??? ??, ?????
??
???
??
??? ??(Block) ????
???
???
??
??? ??? ???(Page) ???? ??? ??
????. ??? ??? ??? URL? ??, ???? ??? ????? ??? ????? ? ? ??.

??
???
??

?
????
????
???
??
????
????
?????
?????(on-premise)??
??
??
??
?
??
?(Queue) ???? ??. ??
???
????
?? ??
?? ??
??? ?? ??? ?
?? ??? ??? ???
??? ?? ? ?
??.

?
???
??

????
???
???
????
????
??
???
? SQL ??? ??. ???
???
???
????
????
??
????
???
?
???, ??????
??
???
??
??
??
????
????
???
???, ??? ???? ????
???
???
?
??. ??? SQL ??? ???? ??
?? SQL ????
?????
????
????
????
????
??.

SQL ??
??

???
??
??
???
??

????
????
???
???
??
??
???
????
????, ??
??
??
???
???
???
????. ???
???
???
???
???
?? SQL ???
??
???????
????
??
?????
???
???
???
?????
????
?? ????.

???
??, ???, ??
????
??? ???
????
???
???
??
??
????
?
??
????
???
??
??, ??
???
???
?
?
??
??. ??
????
?????
?
??
???
???
???
???
??
?????
??
?
???
??
???
????
???
??.

?????
???
????
??

???
??
??
??
????
????
??
???
???
?
???
???
??
????
??
???
???
????? Public??
????
??
????
???, ?
???
??
??
??
??(Share Access Signature ) ???
????, ??
??
??
??? ??? ?? ?? ??
????
???
?
???
? ? ??. ?? ?? ??? ????? ???? Ad-hoc ??? ??? ???? ??? ?? Policy based ??? ??.

??
??
???
???
???
??
???
??

?
???
?
????
???
??
??
??
?????
????
??
???
?????
??
?
????
???
?
??. ???
????
?
????
??
??
???
??, ?????
??
?????
?
????
??(Polling)??
??? ?? ??? ?? ???
????
??
????
????.

?
????
???
??
??

??????
????
???
??
??

???
??
???
???
?????
????
???
????
???
?
???, ???
???
????
???
???
????
??(Windows Azure Toolkit for Windows Phone)?
?? ????? ???
???
?????. (?? ??? ??
??
?
??
???
?? 1? ???
??)

???
??????
??
???
????, ????
?? table list ?????
??
??? ????
????
??
???
???
???
?
??. UI?
??
???
???
????
?????
???
?
??. ??, sample data ?????? Sample Data ????
???
?(Row)?
???
?
??.

???
????
???
??, ?
??
?
??
??

??
??
????
????
??
????
??? list blobs ????
???
??. ????
???
??
???
??
???
?????
??
????
????
??
???
??
????
???
?? ???? ???. ??
????
??? pictures ??????
????
???
???
?
??.

??
????
???
????
 

??
?
????
????
????
???
????
??
?????. ??
??
??
????, ??
?? queue ??? ?
????
?? dequeue ?
????
??
????
??
???. ?????? ???? ???
???
????, ?? ???? ???
????? ???? ???? ??? ? ??? ?????
??
?? ?? ?
?
??.

?
????
?
??
?
???
???

???
?
???
??
??

??
????
??
???
??????? ???? ???? ???? ?? ??????? ???? ????
????
? ????????
????
??. ?
?????
????
????
??
???? ????????
?
??
??? ??? ????
?
?
??, ???
????
?????
??
???
???
?
??. User ???
??
???
??
??????
??
??
???
??
??
?
?
??.

???
?
???
??
??
??(?) ?
??
????
??
??
??(?)

????
???
????
????? ???? ????
??? ???? ???? ???? ?? ?? ??? ?????. ??????
????
???
??
???
????, ??
????
???? ??? ???? ???? ???? ? ? ???? ??. ?? ??? ???
????
????
???
???
???
???
????
???
????
???.

Are you experiencing the following combination of errors from event logs and ULS los? I found it occur most often after SharePoint migration from 2007 to 2010. However the same issue can also be reproduced in SP2010 using the out-of-box survey list and a minor change via the standard user interface.

Summary

To save you time, the problem is caused by the first question in the Survey list has a RowOrdinal number other than 0. In another word, the first question in a survey list must have RowOrdinal number equals to 0.

First, let’s look at the errors.

Application Event ID 5586:

Unknown SQL Exception 515 occurred. Additional error information from SQL Server is included below.

Cannot insert the value NULL into column ‘tp_DocId’, table ‘SP2010_Content_10030.dbo.AllUserData’; column does not allow nulls. INSERT fails.

The statement has been terminated.

SharePoint ULS Log:

MetadataNavigationContext Page_InitComplete: No XsltListViewWebPart was found on this page[/Team/Lists/Survey/NewForm.aspx?IsDlg=1].  Hiding key filters and downgrading tree functionality to legacy ListViewWebPart(v3) level for this list.

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column ‘tp_DocId’, table ‘SP2010_Content_10030.dbo.AllUserData’; column does not allow nulls. INSERT fails.  The statement has been terminated.   

SqlError: ‘Cannot insert the value NULL into column ‘tp_DocId’, table ‘SP2010_Content_10030.dbo.AllUserData’; column does not allow nulls. INSERT fails.’    Source: ‘.Net SqlClient Data Provider’ Number: 515 State: 2 Class: 16 Procedure: ‘proc_AddListItem’ LineNumber: 475 Server: ‘Win2k8-SQL-01′

SqlError: ‘The statement has been terminated.’    Source: ‘.Net SqlClient Data Provider’ Number: 3621 State: 0 Class: 0 Procedure: ‘proc_AddListItem’ LineNumber: 475 Server: ‘Win2k8-SQL-01′

Unknown SQL Exception 515 occurred. Additional error information from SQL Server is included below.  Cannot insert the value NULL into column ‘tp_DocId’, table ‘SP2010_Content_10030.dbo.AllUserData’; column does not allow nulls. INSERT fails.  The statement has been terminated.

ConnectionString: ‘Data Source=Win2k8-SQL-01;Initial Catalog=SP2010_Content_10030;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15′    ConnectionState: Closed ConnectionTimeout: 15

To keep this post readable, I’ve omitted the ULS log entry showing the complete SQL query that was executed and failed. You can follow the repro-steps to get the exact SQL query from your environment.

The problem here is because SharePoint utilizes SQL server row wrapping to allow a maximum number of columns in a SharePoint list where SharePoint Server will create several rows in the database when data will not fit on a single row. It then uses a property called RowOrdinal to identify in which row a certain field should be stored. When RowOrdinal = 0, the field is stored in the first row of the row set for that list item and when RowOrdinal = 1, the field is stored in the second row of the row set for that list item, and vice versa.

The number of fields/columns allowed in one single row is based on the type of the fields/columns. SharePoint Server 2010 Software Boundaries and Limits – Column Limits states the following;

Note: visit the link for a complete list of column types.

Take Number type for example, row wrapping occurs after each 12 columns in a SharePoint list as stated above. This means the 13^th Number typed column you created, would have a RowOrdinal = 1 (25^th Number typed column would then have RowOrdinal = 2).

Repro Steps

With the above information, we can reproduce the problem as below

1. Create a survey list.
2. Create 13 questions all based on Number type.
3. Answer the survey by responding all 13 questions. This should complete without any error.
4. Go to the list settings, change the order of 13^th question to 1. (so it becomes the first question of the survey list)
5. Try answering the survey again by responding all 13 questions.
   Bam! The SharePoint dialog error hits you in the face!

In case you still don’t know what’s going on. This is because the 13^th question has RowOrdinal equals to 1 which is not allowed by SharePoint.

Remediation for Existing Survey List

For existing survey lists, the idea is to figure out which questions have RowOrdinal = 0 and then make the one that has RowOrdinal = 0 to be the first question in the survey list.

To find out RowOrdinal number assigned to each of the columns/fields, save the list as a template, eg. Survey.stp. Change the file name to survey.cab, then extract the manifest.xml file in it.

Open manifest.xml and look under ListTemplate > UserLists >List > Metadata > Fields

My Thought on This….

In my opinion, I think it’s more of a bad design issue rather than a bug. I can’t be bothered going into details to capture and analyse SQL Profiler trace, but I did create a custom list and check the list template’s manifest.xml file. With normal a list or library, the first field within <Fields> tag is actually content type ID with RowOrdinal equals to 0. Users cannot change the order of fields within <Fields> tag through SharePoint user interface hence eliminating the possibility of such problem. SharePoint PG certainly needs to review survey list design and come up with a better solution.

Sample Download: http://code.msdn.microsoft.com/ASPNETComboBoxSysApplicatio-4c7381d2

Today’s code sample illustrates the use of Sys.Application.add_load to add an handler to Sys.Application.load event.  And the handler, usually scripted by users, can successfully access DOMs generated by AJAX control toolkit. Otherwise, by simply placing a <script> tag in the page, it may not find the DOMs and their attributes as expected.
 
This sample comes up because when some of the users use client side methods, such as  getElementById() and getElementsByTagName() to access DOMs generated by AJAX control toolkit, they fail to get the attribute(s) of some specific DOMs. So, they can’t script to add features at client side to meet their personal needs or project’s requirement by ASP.net technology.

For detailed introduction of the sample, please read the documentation at http://code.msdn.microsoft.com/ASPNETComboBoxSysApplicatio-4c7381d2.

You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, manage the downloaded samples in a centralized place, and automatically be notified about sample updates. If it is the first time that you hear about Microsoft All-In-One Code Framework, please watch the introduction video on Microsoft Showcase, or read the introduction on our homepage http://1code.codeplex.com/.

#wp7jp #is12T

Windows Phone ?????????????????????

????????????????????

????????????????????????