pixelPete
skipping stones Posts:9
|
10-27-2009 08:21 PM |
|
Hi,
Just installed the Interactive import module and went through the setup steps. Configured my first import job: steps 1-5 all seem ok.
The import preview displayed the correct records but the Scheduler has not received the job. There is no trace of it in the history or in the currently scheduled tasks.
Any suggestions on where to look for the solution?
Peter |
|
|
|
|
pixelPete
skipping stones Posts:9
|
10-28-2009 04:17 AM |
|
UPDATE
- Have tried re-installing - no effect.
- Have tried your www.betasprings.com beta site - file uploads fine and records are created correctly (according to the emailed report)
- Have tried to limit the import to just 4 fields with five records on my server - still fails to start the scheduler . . .
- Is there something I have to do to get the scheduler notification working i.e. is there something I have not installed?
|
|
|
|
|
David To
river guide Posts:2719
|
10-28-2009 07:05 AM |
|
HI, what version of DNN and IUI are you running? Did you enable logging in your import step? Also, go to Host / Schedule, find the UserImport scheduler, click on "History" and see what is in the log. Any errors or messages? You might need to kick-start the scheduler by editing it and just changing the time and it will kick in right away. -- David |
|
|
|
|
pixelPete
skipping stones Posts:9
|
10-28-2009 11:19 AM |
|
Hi David,
I am using DNN 5.1.4 and your latest install (I just bought the 30 modules) so it is DataSprings_InteractiveUserImport_PA 02.00.10.
The thing is that there is no InteractiveImport task in the DNN Scheduler - that is the problem. The tasks that are running are:
DotNetNuke.Entities.Users.PurgeUsersOnline, DOTNETNUKE
DotNetNuke.Services.Log.SiteLog.PurgeSiteLog, DOTNETNUKE
DotNetNuke.Services.Scheduling.PurgeScheduleHistory, DOTNETNUKE
DotNetNuke.Services.Log.EventLog.PurgeLogBuffer, DOTNETNUKE
DotNetNuke.Services.Log.EventLog.SendLogNotifications, DOTNETNUKE
DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
DotNetNuke.Services.Cache.PurgeCache, DOTNETNUKE
DotNetNuke.Modules.Forum.StartEmailQueuedTasks, DotNetNuke.Modules.Forum
DotNetNuke.Modules.Forum.CleanupEmailQueuedTasks, DotNetNuke.Modules.Forum
Hyper.Modules.EventsCalendar.SendReminder, EventsCalendar
DotNetNuke.Modules.Events.EventNotification, DotNetNuke.Modules.Events
OnyakTech.Axon.ProcessSMTPJobs,OnyakTech.Axon
OnyakTech.Axon.ProcessPOPJobs,OnyakTech.Axon
OnyakTech.Axon.ProcessThreads,OnyakTech.Axon
DataSprings.Modules.RecentPages.RecentPagesPurge,DataSprings.Modules.RecentPages
DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient,DataSprings.DNN.RoleReminder
I also installed a number of your other modules and two of them started scheduler tasks but not Interactive Import.
Yes I did enable logging.
Peter |
|
|
|
|
pixelPete
skipping stones Posts:9
|
10-28-2009 09:21 PM |
|
Hi David,
I've worked around the issue. It is an installation fault.
- I did a bulk install of your modules by FTPing them to the Install/Module folder and then using the Install Available Modules option. As you know, error reporting using this methodology is pretty poor in DNN.
- In an effort to get things working, I deinstalled the InteractiveImport and used the Install Extension Wizard which then helpfully reported the following two errors:
- Info Start Sql execution: 01.00.00.SqlDataProvider file
Warning
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@CreatedByUserID', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) . . . . and;
- Info Start Sql execution: 02.00.00.SqlDataProvider file
Warning
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@CreatedByUserID', which was not supplied. . .
- Knowing the "ADD SCHEDULER" routine had failed, I then created a new Interactive User Import process manually in Host/Schedule by nominating the Full Class Name and Assembly as "DataSprings.DNN.Modules.UserImport.UserImportProcess,DataSprings.DNN.Modules.UserImport"
with an object dependency of "DataSprings_UserImport " (as described elsewhere in these forums http://www.datasprings.com/Products...fault.aspx )
All seems to be fine now, I have my users in and that was the primary object.
FINAL QUESTION
Is there something wrong with your installation procedure that caused the errors noted in 2 above or is there something fundamentally wrong with my installation? Please let me know as I am now moving on to other DataSprings modules and I'd rather avoid the hassles I've just been through!
Cheers,
Peter
|
|
|
|
|
David To
river guide Posts:2719
|
10-29-2009 07:24 AM |
|
HI, problem is that DNN 5.0 and higher added a new column called "CreatedbyUserID" and cannot accept null values. We didn't realize this under after the release of IUI. So you can edit the last sqldataprovider file and add the following code at the end to error trap for this: -- ADD DNN SCHEDULER ITEM if not exists (select TypeFullName from {objectQualifier}schedule where TypeFullName = 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport') if exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = '{objectQualifier}Schedule' and COLUMN_NAME = 'CreatedByUserID') execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',60,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL,1 else execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',60,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL GO -- David |
|
|
|
|
Tareq Mahmud
wading in the water Posts:20
|
11-29-2009 03:57 AM |
|
I am having the same problem. Instead of telling us what to change can you please put up a new build. I did add the script as you mentioned it still does not work. I am using DNN 5.1.4 |
|
|
|
|
David To
river guide Posts:2719
|
12-10-2009 07:04 AM |
|
HI Tareq, sorry for the late response but can you email us using the "Contact Us" and reference this forum and I'll send you the install with the modified sqldataprovider that will check for DNN 5.1 and higher, etc. Thanks. -- David |
|
|
|
|
Oliver Crow
skipping stones Posts:5
|
03-31-2010 02:39 PM |
|
I had this problem installing Interactive User Import v2.00.10 on DNN 5.2.3.
Just for reference, here are the install error messages that I got trying to install Interactive User Import v2.00.10 on DNN 5.2.3 without this fix:
Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'dnn_AddSchedule' expects parameter '@CreatedByUserID', which was not supplied.
... at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ADD DNN SCHEDULER ITEM execute dnn_AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',45,'m',60,'m',250,'',0,1,'DataSprings_UserImport', NULL
Info Start Sql execution: 02.00.00.SqlDataProvider file
Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'dnn_AddSchedule' expects parameter '@CreatedByUserID', which was not supplied.
... at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ADD DNN SCHEDULER ITEM execute dnn_AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',1,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL
Info End Sql execution: 02.00.00.SqlDataProvider file
For the solution to this problem see also this post:
http://www.datasprings.com/Products...fault.aspx
|
|
|
|
|
David To
river guide Posts:2719
|
04-01-2010 07:28 AM |
|
HI, all our modules work fine with the latest versions of DNN. The problem is only when a module requires the service of the Scheduler. We always use the "AddSchedule" stored procedure which is a DNN stored procedure. However, by the time we release our product (let's say IUI 2.0) and DNN was still in version 5.0, then the "AddSchedule" will work fine because DNN 5.0 didn't have the extra column @CreateByUserID. So anyone using older versions of DNN, the install will add the scheduler but if they upgrade their DNN and install, it will error out. By the time we fix the install to support DNN 5.1 for example, DNN 5.2 may come out and they add another column called @FriendlyName and the install will error out for this version. For the moment, we are chasing our tails trying to keep up with all the versions of DNN out there and even in our test environment, we may not have the latest DNN version and not be aware of certain changes. But this only effects the "AddSchedule" routine since we are using their stored procedure. But the module itself still works for higher DNN versions onward. This usually only effects modules that uses a scheduler routine and is using the DNN stored procedure which they sometimes change going forward. But when a customer encounters this, we do help out and post on the forum how to add the schedule manually or run the SQL "AddSchedule" routine with the updated column item. Going forward, we are considering using code within the VB.NET itself as opposed to using the DNN "AddSchedule" routine to prevent this trouble from happening. But this only started happening in DNN 5.0 and higher when they started adding new column fields. -- David |
|
|
|
|