Dienstag, 27. Juli 2010

SQL Server 2008 datetime2 issue

If you got the following error in an INSERT statment from entity framework to MSSQL 2008: System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

Solution:
The problem occurrs when you use Entity Framework to INSERT a System.DateTime (a not initialized one like 0001-01-01 00:00:00.0000000) into the SQL2008 DB. Change the datatype in DB to datetime2 and everything will run smoothly.
Another solution is to initialize the datetime field with a value greater than 1/1/1753.

Montag, 26. Juli 2010

Data Source Conflict

If you are developing BCS solutions in Visual Studio, you might have experienced the following error when you attempt to create or update a new item in an external list:

DataFormWebPartException: Data Source Conflict: Your changes conflict with those made concurrently by another user. Refresh the form and submit your changes again.

Solution: In your Visual Studio 2010 BCS project, find the Create or Update method that's failing. Verify that each of the fields in your input type descriptor have the Creator property (for the Create method) or Updater property (for the Update method) set to True.
Note, this property should not be set to true for the identifier field if the LOB auto generates the value. You also need to delete and re-add the external list before the changes take effect. (Because the object definition of the external content type is saved in the existing list and does not change when you update the BCS model.)

Montag, 19. Juli 2010

There are no addresses available for this application

After creating a Business Data Connectivity Service Application in SharePoint 2010 I wasn’t able to access the service application with the BDC models, external systems and external content types.
I tried to deploy a Visual Studio Solution by hitting F5. The error message I received was: "Error occurred in deployment step 'Add Solution': There are no addresses available for this application.” Clicking the BCS under "Manage service applications" got the same error.
Solution:
Check that the service under "Manage services on server" is running. If the error occures despite the service is running, restart the IIS with "iisreset".

Debugging SharePoint Solutions

You are using Visual Studio 2010 on a SharePoint 2010 site and get an error when hitting F5 to begin debugging....
The debugger may fail to start and complain that the web.config could not be loaded with the error message: “Could not load the Web.config configuration file. Check the file for any malformed XML elements, and try again. The following error occurred: The given key was not present in the dictionary.”
Make sure the URL assigned to the Default zone for the Web Application’s Alternate Access Mappings matches the Site URL of the SharePoint project in Visual Studio. Using one of the other zones (like Intranet) for the URL will not work. The Default Zone and the project’s Site URL need to match.