Win32Exception (0x80004005): Access is denied pg_dump.exe


#1

Hello,

I have been using your PosgresQL backup tool for free for some time and it was working nice. Now I upgraded to your “SQLBackupand FTP” software, because I need to backup some MySQL databases too, but it does not work. MySQL backups works nice, but with PostgreSQL backup,i recieved error. Test connection to the DB server is OK, connection to the storage is OK, but the backup job fail with error " * ERROR: Job execution error: Access is denied Computer name: “my_server”".
I have enabled advanced log and it shows this:

“2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. ConnectionInfo: “SqlBak.Job.PostgreSql.Impl.PostgreSqlConnectionInfo”; FileName: “pg_dump.exe”
2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. PathToBinFolder: “”; FileName: “pg_dump.exe”
2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. Return: “C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql”
2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. Return: “C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql”
2019-01-12 00:27:50.1079|ERROR|43|Net.Pranas.SqlBak.Job.Business.Base.JobBase|Run|System.ComponentModel.Win32Exception (0x80004005): Access is denied
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo()
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo) 2019-01-12 00:27:50.1079|DEBUG|170|Pranas.Net.SqlBak.Service.SBF.DesktopAppService|LoadDeltaJobLogDetail. Return: "IsSuccess: True; Error: ""; Value: "SBF.Channel.Contract.DataContract.JobLogDetailDelta"" 2019-01-12 00:27:50.1079|DEBUG|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceAppError. LogSource: "Application"; Message: "Access is denied"; StackTrace: " at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo) at System.Diagnostics.Process.Start(ProcessStartInfo startInfo) at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo() at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo)”
2019-01-12 00:27:50.1079|DEBUG|148|Net.Pranas.SqlBak.Context.Context.Data.ProfileDatabaseHandler|LoadSendErrorReportEnabled
2019-01-12 00:27:50.1079|DEBUG|148|Net.Pranas.SqlBak.Context.Context.Data.ProfileDatabaseHandler|LoadSendErrorReportEnabled. Return: “True”
2019-01-12 00:27:50.1079|TRACE|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceError. IsSendErrorReportEnabled: “True”
2019-01-12 00:27:50.1079|TRACE|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceError. For this installation forbidden send log
2019-01-12 00:27:50.1079|DEBUG|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceAppError. Return
2019-01-12 00:27:50.1079|DEBUG|43|Net.Pranas.SqlBak.Log.Core.Logger|Serialize. Limit: “8192”|System.ComponentModel.Win32Exception (0x80004005): Access is denied
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo()
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo) 2019-01-12 00:27:50.1079|TRACE|43|Net.Pranas.SqlBak.Job.Business.Base.JobBase|Run. Trace event. JobId: "{LocalId:3; GlobalId:3}"; Severity: "Error"; ActionType: "SqlBak_JobError4". 2019-01-12 00:27:50.1269|DEBUG|170|Pranas.Net.SqlBak.Service.SBF.LocalNetPipeService.LocalJobTraceService|TraceBackupLog. LocalBackupId: "9"; Severity: "Error"; ActionType: "SqlBak_JobError4" 2019-01-12 00:27:50.1269|DEBUG|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. LocalBackupId: "9"; ActionType: "SqlBak_JobError4"; BackupLogKey: "594441095200c1ab119e518f18c91a16" 2019-01-12 00:27:50.1269|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting record into [BackupLog] table. LocalBackupId: "9" 2019-01-12 00:27:50.1849|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. A record of [BackupLog] table has successfully inserted. BackupLogId: "119" 2019-01-12 00:27:50.1849|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting "5" records into [BackupLogParam] table 2019-01-12 00:27:50.1849|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "Code"; ParamValue: "JOB-BAK:2001#1" 2019-01-12 00:27:50.2139|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "Error"; ParamValue: "Access is denied" 2019-01-12 00:27:50.2699|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "AgentId"; ParamValue: "0" 2019-01-12 00:27:50.3469|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "AgentName"; ParamValue: "ALPHACOOL" 2019-01-12 00:27:50.4389|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "_exception"; ParamValue: "System.ComponentModel.Win32Exception (0x80004005): Access is denied at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo) at System.Diagnostics.Process.Start(ProcessStartInfo startInfo) at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo() at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo)""

I have checked premissions on pg_dump and looks ok. I have checked premissions on the temp folder, and it looks OK. What am I doing wrong ? I just wanted to order standard licence for backing up everytning, but I dont know how to solve this.

Thank you.


#2

Hi Jan_Sustr,

We have checked your logs and added some changes to the alpha version. Could you please install the following release (https://sqlbackupandftp.com/download/alpha ) and test it. Please let us know if it works smoothly.

If you still have this issue please send us the advanced log. Please find more details on how to do it https://sqlbackupandftp.com/blog/how-to-send-log-to-developers

Please let us know if the log will be sent. Also please provide us with your Application ID to identify the log. You can find it by clicking “Help” > “About”.

Sorry for the inconvenience.


#3

I’m currently running 12.1.3 and am having the same problem. Postgres v11


#4

Hi Robert_Luke,

We have added some changes to SQLBackupAndFTP that should resolve the issue. Please download and install the following release https://sqlbackupandftp.com/download/alpha

Sorry for the inconvenience.


#5

That did indeed appear to work. Thank you.

Rob


#6

Thank you for the reply Robert_Luke

Good news! Please feel free to contact us on any issues or concerns.