We have just started to use “Manage Software Distribution Packages”. When uploading files we get a warning “File uploads in progress”. That warning doesn’t go away. We have even tested with small files (less than 50KB) located on the BES server itself and using the local console to bypass potential FW-problems Still the upload doesn’t seem to finish. Version 8.1.617.0
I had this issue, but my problem was that the BES plugin service was not running as the Active Directory service account that had rights to the database. In our case, the DB server is a separate box, and we use NT auth on the service accounts. If you simply deploy the plugin service and install the upload service plugin via fixlets, it can only start them as local system. Change service login account, problem solved.
Environment:
I’ve new installation of IEM 9.1 - on the same server I’ve also SQL Express.
In IEM configuration TASKS and SWD Setup I’ve done:
BES server plugin service is installed - completed
SOAP Api for plugin - completed
REST Api for plugin - completed
TEM server download plugin - completed
TEM upload maintenance service - completed
ODBC DSN names shows good connection and no problems with “Test connectivity” - success
SQL Express has sa user configured and is owner of every single DB I have - password good.
File size does not make any difference. My file is 29mb
I’ve free space on my drive - no problems with that.
Problem:
Files hangs in stage of uploading…
Logs - Upload.log shows:
[Thu, 26 Feb 2015 19:58:50 +0200]Waiting 10
seconds to retry the Temp to Uploads queue due to SQL failure.
[Thu, 26 Feb 2015 19:58:51 +0200]Could not
connect to DSN: bes_bfenterprise using username: sa
[Thu, 26 Feb 2015 19:58:51 +0200]Cannot
execute query:select count(1) from dbo.dashboarddata where
name=‘SWD_Orphan_fe6808d5d11e94dc5581f33ed386ce552f0c84d6’ and IsDeleted=0 and
DashboardId=‘SoftwareDistribution.ojo’ to check if that deleted file has an
orphan.
[Thu, 26 Feb 2015 19:58:51 +0200]Waiting 10 seconds to
retry the Temp to Uploads queue due to SQL failure.
I’ve tried to execute these queries in MS SQL Studio - no problems.
MS SQL DB is setup for SQL and WindowsNT login - Mixed.
all services is running under Local system user - seems to be ok.
I don’t see uploadmanager service to be running under TaskManager / servcies (I’ve tried all previous steps for configuration but no success).
I’ve tried to run uploadmanager.exe independently - I got the same error.