| Author |
Messages |
|
Sumner MacDonald
Posts: 3
 |
| 31 May 2011 9:33 PM |
|
Recently tried to install 2.5.8 on DNN 5.6.2 and got the errors below. Any ideas on what went wrong and what to check? Thanks in advance for your advice.
Package Installed Successfully
The package installed successfully - see below
Error loading files from temporary folder - see below
StartJob
Starting Installation
Info
Starting Installation - Interzoic.AccordLMS.Manager
Info
Starting Installation - Module
Then a little further down
Info
Executing 02.04.02.SqlDataProvider
Info
Start SQL execution: 02.04.02.SqlDataProvider file
Failure
SQL execution resulted in following exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'Results'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE FUNCTION dbo.Interzoic_LMS_RptCategoryLEsNotViewed ( @PortalId INT, @ModuleId INT, @PermissionProfileId INT, @Assigned INT, @Criteria INT, @LEIdList NVARCHAR(MAX), @FolderIdList NVARCHAR(MAX), @RoleIdList NVARCHAR(MAX), @RoleStatus NVARCHAR(100) ) /* @RoleStatus is a comma seprated string with values Pending = 0 Active = 1 Expired = 2 For example, a value of "0,1,2" means to consider all roles. The normal value is "1" that means only active roles */ RETURNS TABLE AS RETURN ( SELECT DISTINCT Results.LOId, Results.UserId FROM ( SELECT E.LOId, E.UserId FROM dbo.Interzoic_LMS_Enrollment E WHERE E.PortalId = @PortalId AND E.ModuleId = @ModuleId AND E.LOId NOT IN (SELECT A.LOId FROM dbo.Interzoic_LMS_Attempt A WHERE E.UserId = A.UserId AND E.FolderGuid = A.FolderGuid AND E.PortalId = @PortalId AND E.ModuleId = @ModuleId) UNION SELECT RE.LOId, UR.UserId FROM dbo.Interzoic_LMS_RoleEnrollment RE INNER JOIN dbo.vw_UserRoles UR ON RE.RoleId = UR.RoleId WHERE RE.PortalId = @PortalId AND RE.ModuleId = @ModuleId AND RE.LOId NOT IN (SELECT A.LOId FROM dbo.Interzoic_LMS_Attempt A WHERE UR.UserId = A.UserId AND RE.FolderGuid = A.FolderGuid AND RE.PortalId = @PortalId AND RE.ModuleId = @ModuleId) AND (CHARINDEX ( '0' , @RoleStatus) > 0 OR UR.EffectiveDate <= GETDATE() OR UR.EffectiveDate IS NULL) AND (CHARINDEX ( '1' , @RoleStatus) > 0 OR UR.ExpiryDate < GETDATE() OR UR.EffectiveDate > GETDATE()) AND (CHARINDEX ( '2' , @RoleStatus) > 0 OR UR.ExpiryDate >= GETDATE() OR UR.ExpiryDate IS NULL) UNION SELECT CLE.LOId, CE.UserId FROM dbo.Interzoic_LMS_CategoryEnrollment CE INNER JOIN dbo.Interzoic_LMS_Category_LO CLE ON CE.FolderGuid = CLE.FolderGuid WHERE CE.PortalId = @PortalId AND CE.ModuleId = @ModuleId AND CLE.LOId NOT IN (SELECT A.LOId FROM dbo.Interzoic_LMS_Attempt A WHERE CE.UserId = A.UserId AND CE.FolderGuid = A.FolderGuid AND CE.PortalId = @PortalId AND CE.ModuleId = @ModuleId) UNION SELECT CLE.LOId, UR.UserId FROM dbo.Interzoic_LMS_CategoryRoleEnrollment AS CRE INNER JOIN dbo.Interzoic_LMS_Category_LO CLE ON CRE.FolderGuid = CLE.FolderGuid INNER JOIN dbo.vw_UserRoles UR ON CRE.RoleId = UR.RoleId WHERE CRE.PortalId = @PortalId AND CRE.ModuleId = @ModuleId AND CLE.LOId NOT IN (SELECT A.LOId FROM dbo.Interzoic_LMS_Attempt A WHERE UR.UserId = A.UserId AND CRE.FolderGuid = A.FolderGuid AND CRE.PortalId = @PortalId AND CRE.ModuleId = @ModuleId) AND (CHARINDEX ( '0' , @RoleStatus) > 0 OR UR.EffectiveDate <= GETDATE() OR UR.EffectiveDate IS NULL) AND (CHARINDEX ( '1' , @RoleStatus) > 0 OR UR.ExpiryDate < GETDATE() OR UR.EffectiveDate > GETDATE()) AND (CHARINDEX ( '2' , @RoleStatus) > 0 OR UR.ExpiryDate >= GETDATE() OR UR.ExpiryDate IS NULL) ) AS Results INNER JOIN dbo.vw_UserRoles UserRoles ON Results.UserId = UserRoles.UserId WHERE (@Assigned IS NULL OR Results.LOId IN (SELECT LOId FROM dbo.[Interzoic_LMS_RptLEsByEnrollment](@PortalId,@ModuleId,Results.UserId,Results.LOID,@Assigned,@RoleStatus))) AND (@RoleIdList = '' OR (@Criteria = 0 AND NOT EXISTS (SELECT ObjectId FROM dbo.[Interzoic_LMS_SplitCommaSeparatedParam](@RoleIdList) EXCEPT SELECT UR.RoleId FROM dbo.vw_UserRoles UR WHERE UR.UserId = Results.UserId)) OR (@Criteria <> 0 AND UserRoles.RoleId IN (SELECT ObjectId FROM dbo.[Interzoic_LMS_SplitCommaSeparatedParam](@RoleIdList)))) AND (@LEIdList = '' OR Results.LOID IN (SELECT ObjectId FROM dbo.[Interzoic_LMS_SplitCommaSeparatedGuids](@LEIdList))) AND (@FolderIdList = '' OR Results.LOId IN (SELECT LOId FROM dbo.Interzoic_LMS_Category_LO CLO INNER JOIN dbo.[Interzoic_LMS_SplitCommaSeparatedGuids](@FolderIdList) C ON CLO.FolderGuid = C.ObjectId)) GROUP BY Results.LOId, Results.UserId ); System.Data.SqlClient.SqlException: Incorrect syntax near 'A'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near the keyword 'ORDER'. Incorrect syntax near the keyword 'ORDER'. Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE FUNCTION dbo.[Interzoic_LMS_RptFilteredAttemptsForReports] ( @PortalId INT, @ModuleId INT, @PermissionProfileId INT, @Assigned INT, @StartDate DATETIME, @EndDate DATETIME, @Criteria INT, @LEIdList NVARCHAR(MAX), @FolderIdList NVARCHAR(MAX), @RoleIdList NVARCHAR(MAX), @CompletionStatus NVARCHAR(100), @SuccessStatus NVARCHAR(100), @Attempts NVARCHAR(100), @RoleStatus NVARCHAR(100) ) /* @ModuleId - Manager module ModuleId @Assigned - null means Enrolled and Not Enrolled, -1 means All Enrollments, 0 means Learner Enrollments, 1 means Manager Enrollments @Criteria - 0 uses AND else uses OR @LEIdList - list of LEs IDs (LOID) separated by , @FolderIdList - list of folder IDs (FolderGuid) separated by , @RoleIdList - list of roles Ids (RoleId) separated by , @CompletionStatus - '' means All, 'completed', 'incomplete' @SuccessStatus - '' means All, 'failed', 'passed' @Attempts - '' means All, 'BestAttempt' returns the best attempt, 'LastAttempt' returns the last attempt, 'LastCompleted' returns the last completed, 'UserBestAttempt' returns the best attempt for each user, 'UserLastAttempt' returns the last attempt for each user, , 'UserLastCompleted' returns the last completed for each user @RoleStatus - is a comma seprated string with values Pending = 0 Active = 1 Expired = 2 for example, a value of "0,1,2" means to consider all roles. The normal value is "1" that means only active roles */ RETURNS @Results TABLE ( AttemptId INT, LOId UNIQUEIDENTIFIER, Title NVARCHAR(200), FolderGuid UNIQUEIDENTIFIER, CompletionStatus NVARCHAR(20), SuccessStatus NVARCHAR(20), ScoreScaled DECIMAL(5, 2), ScoreRaw DECIMAL(10, 7), ScoreMax DECIMAL(5, 2), UserId INT, UserName NVARCHAR(100), FirstName NVARCHAR(50), LastName NVARCHAR(50), Email NVARCHAR(256), ScaledPassingScore DECIMAL(5, 2), SessionTime REAL, Created DATETIME, DBTotalTime REAL, PassingScore DECIMAL(5, 2), PRIMARY KEY ( AttemptId ) ) AS BEGIN INSERT INTO @Results SELECT DISTINCT A.AttemptId, A.LOId, LE.Title, A.FolderGuid, A.CompletionStatus, A.SuccessStatus, A.ScoreScaled, A.ScoreRaw, A.ScoreMax, A.UserId, Users.Username, Users.FirstName, Users.LastName, Users.Email, A.ScaledPassingScore, A.SessionTime, A.Created, A.DBTotalTime, LE.PassingScore FROM dbo.[Interzoic_LMS_FilteredAttempts](@PermissionProfileId, @PortalId, @ModuleId) AS A INNER JOIN dbo.Interzoic_LMS_LO LE ON A.LOID = LE.LOID INNER JOIN dbo.vw_Users Users ON A.UserId = Users.UserId INNER JOIN dbo.vw_UserRoles UserRoles ON A.UserId = UserRoles.UserId WHERE LE.PortalID = @PortalId AND Users.PortalId = @PortalId AND Users.IsSuperUser = 0 AND LE.ModuleId = @ModuleId AND ( A.Created >= @StartDate OR @StartDate IS NULL ) AND ( A.Created <= @EndDate OR @EndDate IS NULL ) AND Users.IsDeleted = 0 AND ( @Assigned IS NULL OR A.LOId IN ( SELECT LOId FROM dbo.[Interzoic_LMS_RptLEsByEnrollment](@PortalId, @ModuleId, A.UserId, A.LOID, @Assigned, @RoleStatus) ) ) AND ( @LEIdList = '' OR A.LOID IN ( SELECT ObjectId FROM dbo.[Interzoic_LMS_SplitCommaSeparatedGuids](@LEIdList) ) ) AND ( @FolderIdList = '' OR A.LOId IN ( SELECT LOId FROM dbo.Interzoic_LMS_Category_LO CLO INNER JOIN dbo.[Interzoic_LMS_SplitCommaSeparatedGuids](@FolderIdList) C ON CLO.FolderGuid = C.ObjectId ) ) AND ( @RoleIdList = '' OR ( @Criteria = 0 AND NOT EXISTS ( SELECT ObjectId FROM dbo.[Interzoic_LMS_SplitCommaSeparatedParam](@RoleIdList) EXCEPT SELECT UR.RoleId FROM dbo.vw_UserRoles UR WHERE UR.UserId = A.UserId ) ) OR ( @Criteria <> 0 AND UserRoles.RoleId IN ( SELECT ObjectId FROM dbo.[Interzoic_LMS_SplitCommaSeparatedParam](@RoleIdList) ) ) ) AND ( @CompletionStatus = '' OR CHARINDEX(A.CompletionStatus, @CompletionStatus) > 0 ) AND A.CompletionStatus != 'unknown' AND ( @SuccessStatus = '' OR A.SuccessStatus = @SuccessStatus ) AND ( @Attempts = '' OR ( @Attempts LIKE '%BestAttempt' AND A.AttemptId IN ( SELECT TOP 1 BestAttempt.AttemptId FROM dbo.[Interzoic_LMS_FilteredAttempts](@PermissionProfileId, @PortalId, @ModuleId) AS BestAttempt WHERE BestAttempt.LOId = A.LOId AND ( @Attempts <> 'UserBestAttempt' OR BestAttempt.UserId = A.UserId ) GROUP BY BestAttempt.AttemptID, BestAttempt.ScoreScaled, BestAttempt.ScoreRaw ORDER BY BestAttempt.ScoreScaled DESC, BestAttempt.ScoreRaw DESC, BestAttempt.AttemptID DESC ) ) OR ( @Attempts LIKE '%LastAttempt' AND A.AttemptId IN ( SELECT TOP 1 LastAttemp.AttemptId FROM dbo.[Interzoic_LMS_FilteredAttempts](@PermissionProfileId, @PortalId, @ModuleId) AS LastAttemp WHERE LastAttemp.LOId = A.LOId AND ( @Attempts <> 'UserLastAttempt' OR LastAttemp.UserId = A.UserId ) GROUP BY LastAttemp.AttemptID, LastAttemp.Created ORDER BY LastAttemp.Created DESC, LastAttemp.AttemptID DESC ) ) OR ( @Attempts LIKE '%LastCompleted' AND A.AttemptId IN ( (SELECT TOP 1 AttemptId FROM (SELECT TOP 1 LastCompleted.AttemptId, case when LastCompleted.CompletionStatus = 'completed' then 1 else 0 end as 'CompletionOrder' FROM dbo.[Interzoic_LMS_FilteredAttempts](@PermissionProfileId, @PortalId, @ModuleId) as LastCompleted WHERE LastCompleted.LOId = A.LOId AND ( @Attempts <> 'UserLastCompleted' OR LastCompleted.UserId = A.UserId ) GROUP BY LastCompleted.AttemptID, LastCompleted.Created, LastCompleted.CompletionStatus ORDER BY 'CompletionOrder' desc, LastCompleted.Created desc, LastCompleted.AttemptID desc) tmpLastComleted) ) ) ) RETURN END
Info
End SQL execution: 02.04.02.SqlDataProvider file
Info
Finished SQL execution
Failure
Installation Failed - Script
Info
Rolling back component install - Module
Info
Module un-registered successfully - Interzoic.AccordLMS.Manager
Info
Component rolled back successfully - Module
Info
Rolling back component install - ResourceFile
Failure
ExceptionSystem.IO.FileNotFoundException: Could not find file 'C:\Inetpub\HarpethDNN\Install\Temp\a0h1xcvbResources.zip'. File name: 'C:\Inetpub\HarpethDNN\Install\Temp\a0h1xcvbResources.zip' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode) at DotNetNuke.Services.Installer.Installers.ResourceFileInstaller.RollbackFile(InstallFile insFile) at DotNetNuke.Services.Installer.Installers.FileInstaller.Rollback()
Info
Component rolled back successfully - ResourceFile
Info
Rolling back component install - Config
Info
Config file changes rolled back - web.config
Info
Component rolled back successfully - Config
Info
Rolling back component install - Assembly
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Restored backup of previous version
Info
Component rolled back successfully - Assembly
Info
Installation Failed - Interzoic.AccordLMS.Manager
Info
Starting Installation - Interzoic.AccordLMS.Learner
Info
Starting Installation - Module
Info
Module registered successfully - Interzoic.AccordLMS.Learner
Info
Component installed successfully - Module
Failure
Install aborted - new version older than installed version
Info
Installation Failed - Interzoic.AccordLMS.Learner
Info
Starting Installation - Interzoic.AccordLMS.Reports
Info
Starting Installation - Module
Info
Module registered successfully - Interzoic.AccordLMS.Reports
Info
Component installed successfully - Module
Failure
Install aborted - new version older than installed version
Info
Installation Failed - Interzoic.AccordLMS.Reports
Info
Deleted temporary install folder
EndJob
Installation Failed
|
|
|
|
|
Horacio
Interzoic Staff
Posts: 52
|
| 01 Jun 2011 8:09 AM |
|
Hi,
Assuming your sql sever database is 2005/2008+, what happens it that its 'compatibility level' should be set as sql server 2000 (because, most likely, it is an upgraded database).
If you update its compatibility level to the proper value for your current database version, the install will go fine.
From a SQL Query window (e.g. from the 'sql server management studio'), run this query:
-- NOTE: replace my-database-name with the proper database name
EXEC sp_dbcmptlevel 'my-database-name'
It will return (I guess): "The current compatibility level is 80."
Which means the database is set at SQL 2000 compatibility level.
Then execute this:
-- NOTE: replace my-database-name with the proper database name
EXEC sp_dbcmptlevel 'my-database-name', 100
and finally:
-- NOTE: replace my-database-name with the proper database name
EXEC sp_dbcmptlevel 'my-database-name'
It now should say "The current compatibility level is 100."
Which means the database is now set at SQL 2008 compatibility level.
NOTE: '100' would be for a sql server 2008 database
If your sql server is 2005, then use '90' instead of '100'
Before reinstalling the module, uninstall it (from Host > Module Definitions) and also uninstall the database objectes that were created running (from Host > SQL) the uninstal.sqldataprovider file included in the module's zip installer.
Thanks,
Horacio.- |
|
Interzoic Media
Accord LMS – Affordable, Flexible, Scalable - The Right Choice |
|
|
Sumner MacDonald
Posts: 3
|
| 01 Jun 2011 10:10 AM |
|
Horacio,
Thank you for the quick response. I went through the process you outlined and updated the compatibility level from 80 to 90 (this is a SQL Server 2005 install). Uninstalled the module, ran the uninstall data provider, double checked the SQL server and all object were removed...
...but re-installing generates the exact same errors. What else can I try? |
|
|
|
|
Horacio
Interzoic Staff
Posts: 52
|
| 01 Jun 2011 1:25 PM |
|
That's weird. Thee users had in the past the same problem, and it was solved updating the database's compatibility level to the right value.
Please verify the database was change to '90' (SQL Server 2005) compatibility level.
SQL Server 2005 info page: http://msdn.microsoft.com/en-us/library/ms178653%28v=SQL.90%29.aspx
Thanks |
|
Interzoic Media
Accord LMS – Affordable, Flexible, Scalable - The Right Choice |
|
|
Sumner MacDonald
Posts: 3
|
| 01 Jun 2011 1:58 PM |
|
Just double checked...this is returned by SQL Server for that database name:
The current compatibility level is 90.
|
|
|
|
|
Horacio
Interzoic Staff
Posts: 52
|
| 01 Jun 2011 2:22 PM |
|
Please send an email to support@interzoic.com, referencing this forum thread and including: the site's URL, a DNN host user and password.
We'll review the installation and see what we could find.
Thanks |
|
Interzoic Media
Accord LMS – Affordable, Flexible, Scalable - The Right Choice |
|
|
|