Changing Identifier in BCS Solution results in Deploying an External Content Type, Error:

After changing my my identifier in my BDC model from String to Guid, I tried to redeploy my solution from Visual Studio 2010.

Suddenly everything went wrong! I received all kinds of errors telling me that my BDC model was not compliant with the previous version… previous version? uhrm? was my previous version beeing cached???

this was not what I expected, because there was no BDC model stored in my BCS application and I've done multiple IISRESET commands…

But, I remembered that a SQL database was created when I created a new BCS service application. I opened this database and all the definitions from my previous BCS models (113 versions ) where in there…

This was the cache I've been looking for.

So there are 2 solutions to tackle this issue:

1) Delete the BCS service application from the central administration page and recreate it with a new SQL content database
2) Run the following script on your BCS database, in order to truncate all the data in there:

— disable all constraints
EXEC sp_msforeachtable “ALTER TABLE ? NOCHECK CONSTRAINT all”

— delete data in all tables
EXEC sp_MSForEachTable “DELETE FROM ?”

— enable all constraints
exec sp_msforeachtable “ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all”

I'm not sure if this is THE BEST SOLUTION and I wouldn't recommend it, but at this moment this was the only solution I could come up with …

If you have a better solution please let me know! Or reply here:
http://social.msdn.microsoft.com/Forums … c25e8d438d

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa

This morning I received an COM exception while opening my central administration page (Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa.)

Because it was a COM exception I started looking in my DCOMCNFG like when I received DCOM errors with MOSS 2007 (remember the IISWAMREG?).

Unfortunately this was not the winning path. It seemed like you need to change the application pool (SharePoint Central Administration v4) advanced settings and change the “Load User Profile” value to “True”. However this setting is not available in the advanced settings window for the central administration application pool.

The solution is to use the inetsrv\appcmd command with administrative rights. This command shows all settings of my application pool
%windir%\system32\inetsrv\appcmd list apppool “SharePoint Central Administration v4” /text:*
This resulted in this output


[processModel]
identityType:”SpecificUser”
userName:”DGMNTSAP\spfarm”
loadUserProfile:”false”


As you can see is the load user profile value False, where it should be True, in order to change this we can use this command

%windir%\system32\inetsrv\appcmd set apppool “SharePoint Central Administration v4” -processModel.loadUserProfile:true

After running this command the value of loadUserProfile has been changed to True and this error should never reoccur again.

VN:F [1.9.22_1171]
Rating: 8.0/10 (2 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Unable to find the default new form for list

While exploring the new Business Connectivity Services from SharePoint 2010, I created an external content type with only 2 methods specified (ReadList & ReadItem). As the only 2 methods available are Read methods, the external list only displays data from an external content source.

After I added a Create method and updated my wsp, I received this error: in my eventlog:Unable to find the default new form for list

The list was created by using the readonly contenttype and therefor the list did not have a NewForm associated. After deleting this list and recreating the External list with my cutom external contenttype, everything went as smooth as it should!

So next time you create a new Create or Update method on your external contenttype, don't forget to recreate the list in your sharepoint 2010 site.

Oh, you don't have to worry about any data loss 😉

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

The User Code Execution Request was refused because the User Code Execution Host Service was too busy to handle the request

While activating the sandbox solution from 21apps . It seems that several requirements are required for sandboxed solutions to work:

Only upload solutions with *.wsp extentions
When the solution hasn't a wsp extension but for example a zip extension, the activate button remains grayed out.

Always check if the User Code Service is running
Even if you are 100% certain it was activated yesterday or the day before 😉

The Sandbox service has been renamed in the RTM to Microsoft SharePoint Foundation Sandboxed Code Service !!!

Run powershell script when Domain Controller is installed on same server
I received an error (The User Code Execution Request was refused because the User Code Execution Host Service was too busy to handle the request). It seems that a powershell script is required in order to make this work.

$acl = Get-Acl HKLM:\System\CurrentControlSet\Control\ComputerName 
$person = [System.Security.Principal.NTAccount]"Users"
$access = [System.Security.AccessControl.RegistryRights]::FullControl
$inheritance = [System.Security.AccessControl.InheritanceFlags]"ContainerInherit, ObjectInherit"
$propagation = [System.Security.AccessControl.PropagationFlags]::None
$type = [System.Security.AccessControl.AccessControlType]::Allow
$rule = New-Object System.Security.AccessControl.RegistryAccessRule($person, $access, $inheritance, $propagation, $type)
$acl.AddAccessRule($rule)
Set-Acl HKLM:\System\CurrentControlSet\Control\ComputerName $acl

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Community Day 2010 : June 24th 2010 in Utopolis Mechelen.

Community Day is back with the Fourth Edition of this annual community event on Microsoft technologies!

Fourteen Microsoft User Groups combine their efforts to organize this unique networking and knowledge sharing
event. With so many new releases from Microsoft, the theme of Community Day 2010 is of course 2010: a new wave of products and technologies. This means that most sessions will be looking at Visual Studio 2010, Silverlight 4, Office 2010, SharePoint 2010, SQL Server 2008 R2, OCSR2…

Microsoft Community Day will take place on Thursday 24th June 2010 in Utopolis, Mechelen, where we will
bring together over 300 IT Pro

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)