Answered by:
Error After upgrading to CRM 2011

Question
-
Hi
I backed up CRM 4.0 database and installed CRM 2011 on SQL 2008 with SBS 2011 however after restoring the data CRM does not work and i am getting the following error in Event viewer when accessing CRM:
Error:17145
Source: MSCRMAsyncService
Host LEO: error while processing organization e2f0841e-2c61-46a9-87fc-2d49fe93826e.
Exception: System.Data.SqlClient.SqlException (0x80131904):
Invalid column name 'OwningExtensionId'.
Invalid column name 'OwningExtensionIdName'.
Invalid column name 'OwningExtensionTypeCode'.
Invalid column name 'OwnerId'.
Invalid column name 'ExecutionTimeSpan'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)
Do you have any Suggestions Thanks Mahesh
Saturday, July 30, 2011 10:14 AM
Answers
-
I just looked through the implementation guide and it appears that only Windows Server 2008 64-bit is supported for CRM 2011.
http://technet.microsoft.com/en-us/library/gg554667.aspx
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Monday, August 1, 2011 4:47 PM
- Marked as answer by Donna EdwardsMVP Wednesday, August 3, 2011 4:03 PM
Monday, August 1, 2011 4:47 PMModerator -
Just because something appears to work doesn't mean it is "supported". You can do almost anything in CRM by modifying the aspx pages directly or by modifying the database but when you call Microsoft for support you might be surprised to find that their resolution to your problem is to reinstall the server and use web services to migrate your data to a brand new org.
Another not so dramatic example would be IE9 not being supported with CRM 2011 yet. People use, actually I use it. But I have seen reports on here where it doesn't work properly for some people or that it causes problems if you are using CRM with the Outlook client.
I provided a link to the implementation guide which is the official word from Microsoft on the topic.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Marked as answer by Donna EdwardsMVP Wednesday, August 3, 2011 4:03 PM
Tuesday, August 2, 2011 11:05 AMModerator -
I am just telling you that you might not have this problem if you use the supported OS which is the 64 bit Windows Server 2008 family. The setup you have suggested either hasn't been adequately tested by Microsoft or else there are known issues.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Marked as answer by Donna EdwardsMVP Wednesday, August 3, 2011 4:03 PM
Tuesday, August 2, 2011 2:37 PMModerator
All replies
-
Have you made any manual customizations in the past to the organization DB?
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!Sunday, July 31, 2011 4:34 PMModerator -
Hi
I added a few tabs and fields to 'cases' so I could enter extra details.
Mahesh
Monday, August 1, 2011 6:55 AM -
But nothing at the database level? For instance, no one went into SQL Management Studio and made changes to the database that way or by any other database level editor?
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!Monday, August 1, 2011 1:25 PMModerator -
Hi Jamie
No no-one edited the database using the SQL managment studio.
Mahesh
Monday, August 1, 2011 1:45 PM -
I just looked through the implementation guide and it appears that only Windows Server 2008 64-bit is supported for CRM 2011.
http://technet.microsoft.com/en-us/library/gg554667.aspx
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Monday, August 1, 2011 4:47 PM
- Marked as answer by Donna EdwardsMVP Wednesday, August 3, 2011 4:03 PM
Monday, August 1, 2011 4:47 PMModerator -
Hi Jaime
It seems to be supported because if i do a fresh install the CRM works perfect and i can browse straight after instlalling it.
Mahesh
Tuesday, August 2, 2011 10:01 AM -
Hi Mahesh,
Did you encounter any warnings or errors during the import process??, i would suggest you to go through this article which fairly discusses the process.
Thanks
Cheers, Francis Edwin
Follow me on: https://twitter.com/astutecrm
My Blog: http://astutecrm.wordpress.com/
Tuesday, August 2, 2011 10:30 AM -
Just because something appears to work doesn't mean it is "supported". You can do almost anything in CRM by modifying the aspx pages directly or by modifying the database but when you call Microsoft for support you might be surprised to find that their resolution to your problem is to reinstall the server and use web services to migrate your data to a brand new org.
Another not so dramatic example would be IE9 not being supported with CRM 2011 yet. People use, actually I use it. But I have seen reports on here where it doesn't work properly for some people or that it causes problems if you are using CRM with the Outlook client.
I provided a link to the implementation guide which is the official word from Microsoft on the topic.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Marked as answer by Donna EdwardsMVP Wednesday, August 3, 2011 4:03 PM
Tuesday, August 2, 2011 11:05 AMModerator -
Hi Jamie
Thanks for that information and I understand how IE9 is causing problems. I installed CRM 4.0 onto sbs 2008 and restored my database and it seems to work with all the data there so i will try install CRM 2011 on top of that and see if it allows the database to be upgraded.
Thanks
Mahesh
Tuesday, August 2, 2011 12:35 PM -
I am just telling you that you might not have this problem if you use the supported OS which is the 64 bit Windows Server 2008 family. The setup you have suggested either hasn't been adequately tested by Microsoft or else there are known issues.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Marked as answer by Donna EdwardsMVP Wednesday, August 3, 2011 4:03 PM
Tuesday, August 2, 2011 2:37 PMModerator