Cannot get Trial Installed and Working
Last Post 01-24-2012 07:12 AM by Chad Nash. 10 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
Trevor DanielUser is Offline
Posts:15
Avatar

--
01-24-2012 03:30 AM

    Hi,

    Please can someone help me get the trial of Dynamic Directory installed and working on my DNN 4.9.4 installtion please?

    I downloaded and installed the package and received errors. I then found the troubleshoot shooting page and worked through the suggestions...

    But I am still getting the following errors:

    Error: Dynamic User Directory is currently unavailable.
    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 ---v

    I have followed every help article on this site to try and fix this but to no avail...

    I have confirmed my database Compatibility Level SQL Server 2005(90)

    I am at a complete loss as what is wrong and how to fix this.

    Please help.

    Trevor DanielUser is Offline
    Posts:15
    Avatar

    --
    01-24-2012 03:40 AM
    Extra Information:

    The script that I found to create the schedule ran with errors so i created the schedule manually but it is throwing the following error in the schedule history:


    DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory

    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()
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    01-24-2012 03:42 AM
    Hello Trevor,

    If you go to Host->SQL and run the following statement do you get an error or is records returned?

    Select * from TempDUDPivot

    If you receive an error stating that this object doesn't exist in your data base then this is the reason that Dynamic User Directory isn't working. If this table "TempDUDPivot" and "TempDUDProfile" doesn't exist then Dynamic User Directory won't work correctly if at all.

    You can also go to Host Scheduler and see the History of the DUD Scheduler Client and see if the creation of these tables just isn't happening.

    Let me know your findings.

    Thanks,

    Ryan
    Trevor DanielUser is Offline
    Posts:15
    Avatar

    --
    01-24-2012 03:46 AM
    Hi Ryan,

    Just ran that statement and as you suspected the table does not exist...

    Looking in SQL Enterprise also confirms this...

    I do however have the tempDUDProfile table...

    What shall I try next?

    Would you like host access to have a look?

    Trev
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    01-24-2012 03:56 AM
    Ok so that was the problem. Well the script that was built that you run under Host -> SQL is for versions DNN 5 or above I believe.

    When you add the schedule manually you're still unable to get the scheduler to work?

    You will need to take a look at the stored procedure "AddSchedule". Go to Host -> SQL and execute the following SQL:

    sp_helptext "AddSchedule"

    You'll be able to see how many parameters this stored procedure is looking for.

    Then compare these parameters to the SP call in our blog post:

    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0, 'Dynamic User Directory'

    In the SP call above there are 13 parameters being passed. Make sure the AddSchedule procedure accepts 13 parameters. I can almost guarantee it doesn't matchup to 13 parameters. It probably only accepts 12 parameters.

    So please compare these two and see what doesn't need to be passed in to AddSchedule via the SP call.

    Let me know if you have any questions.

    Thanks,

    Ryan
    Trevor DanielUser is Offline
    Posts:15
    Avatar

    --
    01-24-2012 04:17 AM
    Hi Ryan,

    Thanks for the help.

    I found the script that I think you are talking about and tried running it but as you said it failed.

    So, I then looked at the parameters in the sql command and manually created a schedule... Adding the schedule worked with no problems.

    But, when I look into the schedule history it is giving the following error...


    DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory

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

    So, the schedule is there, albeit created manually, but is having problems....

    Can you see what might be going wrong above please?

    Thanks

    Trev
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    01-24-2012 04:26 AM
    Yes Trevor,

    Please look at the section of the error "Parameter Count does not match Parameter Value". This goes back to my solution above from my last post.

    Here's whats happening.

    You're calling a stored procedure that expects 12 values to be passed to it anytime it is called.

    So please use the logic I used above to resolve your issue.

    The logic in a summarized for is. Use the SQL I provided to look at your DNN stored procedure "AddSchedule" and compare the expected Parameters to the stored procedure call:

    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0, 'Dynamic User Directory'

    The AddSchedule parameter will be specified with an @.

    Please let me know if this makes sense.

    Thanks,

    Ryan


    Well you tried to call this stored procedure and you passed 13 variables.

    The stored procedure doesn't know what to do so since it is confused it just throws an error.


    Trevor DanielUser is Offline
    Posts:15
    Avatar

    --
    01-24-2012 05:12 AM
    Hi Ryan,

    Apologies, I thought i had curcumvented the above by creating the schedule manually..

    Anyway, from what I can see my AddSchedule only accepts 11 vaiables, not 12 or 13

    Here is the output from HOST > SQL

    ALTER PROCEDURE [dbo].[AddSchedule]
    @TypeFullName varchar(200)
    ,@TimeLapse int
    ,@TimeLapseMeasurement varchar(2)
    ,@RetryTimeLapse int
    ,@RetryTimeLapseMeasurement varchar(2)
    ,@RetainHistoryNum int
    ,@AttachToEvent varchar(50)
    ,@CatchUpEnabled bit
    ,@Enabled bit
    ,@ObjectDependencies varchar(300)
    ,@Servers varchar(150)
    AS
    INSERT INTO Schedule
    (TypeFullName
    ,TimeLapse
    ,TimeLapseMeasurement
    ,RetryTimeLapse
    ,RetryTimeLapseMeasurement
    ,RetainHistoryNum
    ,AttachToEvent
    ,CatchUpEnabled
    ,Enabled
    ,ObjectDependencies
    ,Servers
    )
    VALUES
    (@TypeFullName
    ,@TimeLapse
    ,@TimeLapseMeasurement
    ,@RetryTimeLapse
    ,@RetryTimeLapseMeasurement
    ,@RetainHistoryNum
    ,@AttachToEvent
    ,@CatchUpEnabled
    ,@Enabled
    ,@ObjectDependencies
    ,@Servers
    )


    select SCOPE_IDENTITY()
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    01-24-2012 05:20 AM
    Exactly, the fix from our blog to manually create a scheduled task is for DNN versions 5 +. You stated that you're running on DNN 4.9.x. So this stored procedure AddSchedule is different in DNN 4 compared to DNN 5 versions.

    So now that you know that this procedure accepts only 11 parameters then you can compare the script to this and see which parameters you're passing in that doesn't belong.

    The Script:

    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0, 'Dynamic User Directory'

    For instance the last parameter being passed "Dynamic User Directory" doesn't look like it would be passed in so now the updated script would be:

    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory',60,'m',30,'m',25,'',1,1,'', NULL,0

    However there's one more parameter that doesn't belong.

    Please let me know if you have any questions.

    Thanks,

    Ryan


    Trevor DanielUser is Offline
    Posts:15
    Avatar

    --
    01-24-2012 06:30 AM
    Hi Ryan,

    Sorry but I am still confused.....

    At the moment you are asking me to fix the sp that creates a schedule...?

    But, as mentioned, I do already have a task as I added it manually using the "add item to schedule" button within DNN....

    But when the schedule runs with the error:


    DataSprings.DNN.Modules.DynamicUserDirectory.DUDSchedulerClient, DataSprings.DNN.Modules.DynamicUserDirectory

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

    Am i missing something? Why am i trying to fix the create schedule script when I already have a scheduled item?

    Sorry if I am getting confused...

    Trev


    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    01-24-2012 07:12 AM
    Hi guys...

    I think the issue here is related to the items you ran within the troubleshooting method. I believe you probably have the schedule setup properly and running... but the problem now is that its running an older stored procedure (the procedure rom the blog post is probably old and you probably need to update the stored procedure that the scheduler runs).

    I would:
    1. Uninstall the module
    2. Install the module again
    3. This type - ONly execute the item related to the schedule, or add the schedule manually.


    This should take care of you, I know that there are two stored procedures to run within the scheduler and what is happening is its attempting to run them but they are old (which is why you get the parameter count problem and the scheduler never gets created). We probably need to upgrade that blog post with this info!


    Thanks,


    Chad


    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi