BPC Import Won't Complete

I find there are a couple reasons for an import into BPC to not complete, getting stuck on the the DumpLoad task:

1. The first reason it stops at the DumpLoad task is there is alot of data and it just takes that long. You can always Abort the import and try importing a smaller set of data.
   
2. The OutlookSoft SendGovernor Service is not started. This is usually the result of a server reboot. To check this out:
   1. Start > Run
   2. Type services.msc and press Enter
   3. Scroll down to the OutlookSoft SendGovernor Service
   4. Start the service if it is not running
3. The other reason has to do with the dbo.lck[Application Name] table. So if the application name is Finance, then there are rows left in the dbo.lckFinance table. This can happen if an import errors out. To solve this:
   1. Verify no imports are occurring
   2. Check if there are any rows in the table: SELECT * from dbo.lckFinance
   3. If there are, remove them: DELETE dbo.lckFinance
      

That should solve a hung import.