DUD started to show this error:

Erro: não está disponível de momento.
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. 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 ---

The Schedule also returns the same error:

Dynamic User Directory

Start creation of tempDUDProfile and tempDUDPivot tables.

Failed.Exception:System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) 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, String strOrderBy) at DataSprings.DNN.Modules.DynamicUserDirectory.Business.DynamicUserDirectoryController.DataSprings_RetrieveDNNUserProfileData(Int32 PortalID, String RoleFilter, String LimitResults, Int32 AuthOnly, String strUserFilter, String strOrderBy) at DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient.CreateTables() at DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient.DoWork()

I can't view the profile list...

DNN version 5.6.3
DUD: 4.0.10

Hi Miguel,

Was this an upgraded version or a fresh installation? Sounds like we need to have a stored procedure updated on your installation. Please open a support ticket and I can get you the update.

Thanks,

Chad

Neither...

It was working and one day it just stopped working...

I'll open the support resquest

Now I get another error:

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 ---