Answered by:
Importing CRM 4.0 Organisation into CRM 2011 fails. File Group "Primary" full.

Question
-
Hi there
I am trying to import a CRM 4.0 Organisation into a freshly installed CRM 2011 Server. The old system is Server 2003 / SQL 2005 / CRM 4.0 and the new one Server 2008 R2 /SQL 2008 R2 SP1 / CRM 2011 Rollup 6. (on a Hyper-V Cluster: The virtual machine has 2 CPUs, 16GB fixed size RAM and 40GB HD)
I imported a SQL Backup File into a new DB on the new Server and started the import. After about half way thru it comes up with some memory issue. See log file below.
Any ideas?
Cheers
Uwe
--- End of inner exception stack trace ---
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
16:16:12| Error| Ausnahmefehler beim Importieren der Organisation (Name=trinovisCRM, Id=7b0d9826-9806-4f0e-923f-8e609152dd0c):
Microsoft.Crm.CrmException: Fehler beim Upgraden der Organisation mit der ID "7b0d9826-9806-4f0e-923f-8e609152dd0c". Ausnahme:
System.Exception: Fehler bei der Aktion Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Speicherplatz für das 'dbo.ActivityMimeAttachment_{6340de00-f1f4-4dc1-9aab-a202e8566390}'-Objekt in der TrinovisCRM-Datenbank konnte nicht belegt werden, da die Dateigruppe 'PRIMARY' voll ist. Speicherplatz kann durch Löschen nicht benötigter Dateien, Löschen von Objekten in der Dateigruppe, Hinzufügen von Dateien zur Dateigruppe oder Festlegen der automatischen Vergrößerung für vorhandene Dateien in der Dateigruppe gewonnen werden.
Die Anweisung wurde beendet.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.DataUpgrade.AttachmentUpgradeDriver.ProcessSqlCommand(String sqlStatement)
at Microsoft.Crm.DataUpgrade.AttachmentUpgradeDriver.HandleAttachmentUpgradeAfterPass1()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.Crm.Setup.Database.DllMethodAction.Execute()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---
at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo) ---> System.Exception: Fehler bei der Aktion Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Speicherplatz für das 'dbo.ActivityMimeAttachment_{6340de00-f1f4-4dc1-9aab-a202e8566390}'-Objekt in der TrinovisCRM-Datenbank konnte nicht belegt werden, da die Dateigruppe 'PRIMARY' voll ist. Speicherplatz kann durch Löschen nicht benötigter Dateien, Löschen von Objekten in der Dateigruppe, Hinzufügen von Dateien zur Dateigruppe oder Festlegen der automatischen Vergrößerung für vorhandene Dateien in der Dateigruppe gewonnen werden.
Die Anweisung wurde beendet.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.DataUpgrade.AttachmentUpgradeDriver.ProcessSqlCommand(String sqlStatement)
at Microsoft.Crm.DataUpgrade.AttachmentUpgradeDriver.HandleAttachmentUpgradeAfterPass1()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.Crm.Setup.Database.DllMethodAction.Execute()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---
at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
--- End of inner exception stack trace ---
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Execute(Object obj)Thursday, May 24, 2012 2:27 PM
Answers
-
please ignore it for now... Harddrive is full ;-(
I had no idea that importing a 3,5GB DB would cause such thing.
I'll restore the last checkpoint and give it another try after resizing the disk.
Sorry
Uwe
- Marked as answer by DavidJennawayMVP, Moderator Thursday, August 2, 2012 12:44 PM
Thursday, May 24, 2012 2:47 PM
All replies
-
please ignore it for now... Harddrive is full ;-(
I had no idea that importing a 3,5GB DB would cause such thing.
I'll restore the last checkpoint and give it another try after resizing the disk.
Sorry
Uwe
- Marked as answer by DavidJennawayMVP, Moderator Thursday, August 2, 2012 12:44 PM
Thursday, May 24, 2012 2:47 PM -
Hi Uwe,
Glad to see that you were able to figure this one out.
As you can see, you had insufficient disk space to perform the upgrade.
Here's the recommendation from Microsoft as per the Implementation Guide:
Important
We recommend that for each organization that you upgrade, the volume have free space that is at least three times the size of the organization database file and four times the size of the log file. Therefore, if a single organization database and log file are located on the same volume and are one gigabyte in total, you should have at least seven gigabytes of available disk space before you perform the upgrade. - Page 29 of Installation Guide
I hope this will help you complete your next upgrades.
Maxime
- Proposed as answer by MaximeFortier Wednesday, May 30, 2012 12:24 PM
- Edited by MaximeFortier Wednesday, May 30, 2012 12:25 PM
Wednesday, May 30, 2012 12:24 PM -
Hi Maxime
it wasn't just the importing job, it was also the page file (I upgrade from 4GB to 16 GB RAM) and the installation of various updates that filled up the hard drive.
Finally it completed successfully! Thanks
Uwe
Wednesday, May 30, 2012 2:24 PM -
Alright! Glad to see it worked out fine!
Max
- Edited by MaximeFortier Tuesday, July 31, 2012 7:34 PM
Tuesday, July 31, 2012 7:19 PM