Perry
going with the flow
Posts:50
 |
| 10-26-2010 09:17 PM |
|
Hello,
The DUD was installed and worked fine for a week, but it appeared the following error message after several changes made to DR and DL form. I am not sure whether there is anything to do with the changes to DR/DL, even DR failed to assign user role.
Error: User Directory is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'dbo.tempDUDPivot'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.tempDUDPivot'. at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectory.GenerateReport(String Status, String strNewRecordsPerPage) at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectory.GetData(String Status, String strNewPageSize) at DataSprings.DNN.Modules.DynamicUserDirectory.DynamicUserDirectory.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Thanks /Perry |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-27-2010 11:27 AM |
|
Hi Perry - Well, there is a process that runs (typically hourly) that regenerates a flat table of user data. This is executed under Host/Schedule. Its possible something caused that process to stop, time out, etc... Do you get this all of the time or just every once in a while?
-Chad
|
|
|
|
|
Chad Nash
Posts:5260
|
| 10-27-2010 11:28 AM |
|
Also - Is this in the new 3.0 or in the latest 4.0?
-Chad
|
|
|
|
|
Perry
going with the flow
Posts:50
|
| 10-27-2010 04:42 PM |
|
Hi Chad,
It seems that I got this all of the time when it occurred. It was in Version 3.0. I have Collection 4.0, but I cannot see any update link in Patch & Hotfix or Download area in Snowcovered.
Thanks/ Perry |
|
|
|
|
Perry
going with the flow
Posts:50
|
| 10-27-2010 04:59 PM |
|
Hi Chad,
Here is the error message from Scheduler History.
Start creation of tempDUDProfile and tempDUDPivot tables.
Failed.Exception:System.Data.SqlClient.SqlException: The column name "UserID" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument. The column 'UserID' was specified multiple times for 'p'. 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.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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.Modules.DynamicUserDirectory.Data.SqlDataProvider.DataSprings_RetrieveDNNUserProfileData(Int32 PortalID, String RoleFilter, String LimitResults, Int32 AuthOnly, String strUserFilter) at DataSprings.DNN.Modules.DynamicUserDirectory.Business.DynamicUserDirectoryController.DataSprings_RetrieveDNNUserProfileData(Int32 PortalID, String RoleFilter, String LimitResults, Int32 AuthOnly, String strUserFilter) at DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient.CreateTables() at DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient.DoWork()
Thanks/ Perry |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-28-2010 03:36 PM |
|
Perry - This sounds to me like maybe you created another actual DNN PRofile Field called UserID? If that is the case we might have to add some extra code and logic to account for that... IF you go to Admin, User Accounts, Manage Profile PRoperties, did you create an extra profile field there called "UserID"? I think that is really used (for our purposes at least) as a reserved word because DNN already uses and references a specific column already called UserID.
-Chad
|
|
|
|
|
Perry
going with the flow
Posts:50
|
| 10-29-2010 05:26 PM |
|
Hi Chad, Yes, that was the situation. The error was disappeared after the created UserID was deleted. Thank you so much.
Perry |
|
|
|
|