Attachments after server migration

[LauriC]

We successfully migrated our CRM 4 database from a SBS 2003 Server to a
dedicated member server. However we recently discovered that we are unable
to open any attachments or create new ones. They appear in the Notes
sections of the Accounts, etc... and in the Document section of the Sales
Literature but attempting to open one gives the error: Unexpected Error - an
error has occurred from a Sales Literature document or Access Denied:
invalid operation from a Note on an Account. These same errors occur when
attempting to save an attachmetn as a Document or a Note. Any information
you can provide on this subject would be greatly appreciated. Thank you.

[Patrick]

This message in it self does not contain any useful information to track down
the actual problem. The windows eventlog (application) should contain a more
detailed error message.
--
Patrick Verbeeten (MCPD)
CRM/.NET Consultant

Tools for CRM Developers and Administrators
http://www.patrickverbeeten.com/Tools.aspx

Post by LauriC
We successfully migrated our CRM 4 database from a SBS 2003 Server to a
dedicated member server. However we recently discovered that we are unable
to open any attachments or create new ones. They appear in the Notes
sections of the Accounts, etc... and in the Document section of the Sales
Literature but attempting to open one gives the error: Unexpected Error - an
invalid operation from a Note on an Account. These same errors occur when
attempting to save an attachmetn as a Document or a Note. Any information
you can provide on this subject would be greatly appreciated. Thank you.

[Dave Stelzer]

I am receiving the same error. Here is the detailed Event Log:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 8/11/2010 8:23:15 AM
Event time (UTC): 8/11/2010 1:23:15 PM
Event ID: f3cb2be79f1f4af3aaf35638be292db9
Event sequence: 542
Event occurrence: 2
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/2/ROOT-1-129259724052949016
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: SPECTROLITE

Process information:
Process ID: 3844
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: CrmException
Exception message: Column 'BlockedAttachmentsForDownload' does not exist on Table 'Deployment'

Request information:
Request URL: http://spectrolite:5555/NicoletNationalBank/activities/attachment/edit.aspx?id={B9BFA650-8F90-DD11-B319-000D56BB502A}&_CreateFromType=4202&_CreateFromId=2bE74973B0-C623-419D-8029-621F45AE81F02d
Request path: /NicoletNationalBank/activities/attachment/edit.aspx
User host address: 192.168.21.23
User: NNB\mkirt
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 3
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.Crm.ServerLocatorService.HasOnlyCachedColumns(Table table, String[] columns)
at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
at Microsoft.Crm.ServerLocatorService.GetDeploymentSetting(String settingName)
at Microsoft.Crm.LocatorService.GetDeploymentSetting(String settingName)
at Microsoft.Crm.Application.Utility.Util.IsBlockedAttachment(String fileName)
at Microsoft.Crm.Web.Activities.ActivityAttachment.ConfigureForm()
at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:


Thanks.

Post by LauriC
We successfully migrated our CRM 4 database from a SBS 2003 Server to a
dedicated member server. However we recently discovered that we are unable
to open any attachments or create new ones. They appear in the Notes
sections of the Accounts, etc... and in the Document section of the Sales
Literature but attempting to open one gives the error: Unexpected Error - an
invalid operation from a Note on an Account. These same errors occur when
attempting to save an attachmetn as a Document or a Note. Any information
you can provide on this subject would be greatly appreciated. Thank you.

Post by Patrick
This message in it self does not contain any useful information to track down
the actual problem. The windows eventlog (application) should contain a more
detailed error message.
--
Patrick Verbeeten (MCPD)
CRM/.NET Consultant
Tools for CRM Developers and Administrators
http://www.patrickverbeeten.com/Tools.aspx
Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET Providerless Custom Forms Authentication, Roles and Profile with MongoDb
http://www.eggheadcafe.com/tutorials/aspnet/27f836b7-2c9e-4942-9712-1c7b901cadcc/aspnet-providerless-custom-forms-authentication-roles-and-profile-with-mongodb.aspx

[bayareacrm]

- may want throttle the servernames, lan account info when posting... just a
suggestion :)

I think it's an update rollup issue.

What update rollup are you on? Wouldn't be 6 would it? In the following
articles they recommend a re-install of ur 7, but I've seen a re-install of
ur 6 if you're on it fixes it too.

This one may be more helpful to you:
http://www.go4answers.com/Example/rollup-problems-67470.aspx?utm_source=twitterfeed&utm_medium=twitter

...but look at this one too!
http://blogs.msdn.com/b/emeadcrmsupport/archive/2010/02/05/after-applying-crm-4-0-rollup-7-or-rollup-8-on-the-sever-you-might-no-longer-be-able-to-attach-files-to-a-note.aspx

Michael Mayo
CRM2011Online.com
Please do click on "This was helpful" if you indeed found it helpful!

Post by Dave Stelzer
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 8/11/2010 8:23:15 AM
Event time (UTC): 8/11/2010 1:23:15 PM
Event ID: f3cb2be79f1f4af3aaf35638be292db9
Event sequence: 542
Event occurrence: 2
Event detail code: 0
Application domain: /LM/W3SVC/2/ROOT-1-129259724052949016
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: SPECTROLITE
Process ID: 3844
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception type: CrmException
Exception message: Column 'BlockedAttachmentsForDownload' does not exist on Table 'Deployment'
Request URL: http://spectrolite:5555/NicoletNationalBank/activities/attachment/edit.aspx?id={B9BFA650-8F90-DD11-B319-000D56BB502A}&_CreateFromType=4202&_CreateFromId=2bE74973B0-C623-419D-8029-621F45AE81F02d
Request path: /NicoletNationalBank/activities/attachment/edit.aspx
User host address: 192.168.21.23
User: NNB\mkirt
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread ID: 3
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.Crm.ServerLocatorService.HasOnlyCachedColumns(Table table, String[] columns)
at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
at Microsoft.Crm.ServerLocatorService.GetDeploymentSetting(String settingName)
at Microsoft.Crm.LocatorService.GetDeploymentSetting(String settingName)
at Microsoft.Crm.Application.Utility.Util.IsBlockedAttachment(String fileName)
at Microsoft.Crm.Web.Activities.ActivityAttachment.ConfigureForm()
at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Thanks.

Post by LauriC
We successfully migrated our CRM 4 database from a SBS 2003 Server to a
dedicated member server. However we recently discovered that we are unable
to open any attachments or create new ones. They appear in the Notes
sections of the Accounts, etc... and in the Document section of the Sales
Literature but attempting to open one gives the error: Unexpected Error - an
invalid operation from a Note on an Account. These same errors occur when
attempting to save an attachmetn as a Document or a Note. Any information
you can provide on this subject would be greatly appreciated. Thank you.

Post by Patrick
This message in it self does not contain any useful information to track down
the actual problem. The windows eventlog (application) should contain a more
detailed error message.
--
Patrick Verbeeten (MCPD)
CRM/.NET Consultant
Tools for CRM Developers and Administrators
http://www.patrickverbeeten.com/Tools.aspx
Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET Providerless Custom Forms Authentication, Roles and Profile with MongoDb
http://www.eggheadcafe.com/tutorials/aspnet/27f836b7-2c9e-4942-9712-1c7b901cadcc/aspnet-providerless-custom-forms-authentication-roles-and-profile-with-mongodb.aspx

.