1
Vote

Install failes with "Error loading files from temporary folder - see below." Error

description

Installing on DNN 8.0.3 with SQL Express 2014 I see this:
"SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Your SQL installation is non-standard using a Custom Object Qualifier. 2sic uses the standard Microsoft Entity Framework which doesn't work well with this feature - installation aborted. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) in D:\Users\bitzb\Documents\visual studio 2015\Projects\School Council\Dnn.Platform-8.0.3\DNN Platform\Library\Data\SqlDataProvider.cs:line 138 ClientConnectionId:1a660589-8806-4a21-819e-4ebc36fe1ea7 Error Number:50000,State:1,Class:16 -- Check for custom Object Qualifier - break installation if it's configured (2sxc does not support object qualifier)...."

comments

poolem wrote Sep 27, 2016 at 7:16 PM

Installing version 08.05.04 into Evoq Content 8.4.2 resulted in same error.

poolem wrote Sep 27, 2016 at 8:14 PM

Read a reference that elluded to the objectQualifier in the web.config but this was already set when we set up our DNN instance and based on this from DNN:
The objectQualifier is an optional parameter of the SqlDataProvider value.

The objectQualifier attribute is used to control the prefix applied to every object in the SQL Server database. By default this is set to an empty string “”, so for instance the “Portals” table is created as “Portals”. If, for example, the objectQualifier was set to “dnn_” then the “Portals” table would be created as “dnn_Portals” and stored procedures etc that referenced the Portals table wold reference it as dnn_Portals. Setting this value is recommended, as it allows DotNetNuke to exist within an environment where multiple applications might need to use the same database.

In the case of Upgrades it is important to confirm that this value is consistent with the existent installation ie. once DotNetNuke is installed the objectqualifier cannot be changed.

What do we do now?