Community forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline Mike.G  
#1 Posted : Monday, July 2, 2018 1:50:55 PM(UTC)
Mike.G

Rank: No customer

Joined: 7/2/2018(UTC)
Posts: 1
Sweden
Location: Stockholm

Running SQL-code works but running the SQL Agent job fails.

Log:
</ImpersonationResultClass>
2018-06-29 10:00:00 Debug Impersonation result 2: True, suppress flow: True, current user: PILEN\bexec
2018-06-29 10:00:00 Debug SQL Task->Run->Task: SQL, DataProvider: DirectMSSQL
2018-06-29 10:00:00 Debug RunMSSQLJob->Retrieving Job id
2018-06-29 10:00:00 Debug GetJobId->Query for Job 'VPS Failed Account Openings'
2018-06-29 10:00:00 Debug GetJobId->Found Id '120990d0-0153-4779-adc9-613196b61e21' for Job 'VPS Failed Account Openings'
2018-06-29 10:00:00 Debug RunMSSQLJob->Job id retrieved: 120990d0-0153-4779-adc9-613196b61e21
2018-06-29 10:00:00 Debug RunMSSQLJob->Retrieving max instance
2018-06-29 10:00:00 Debug GetMaxJobInstanceId->Query: SELECT MAX(instance_id) FROM [msdb].[dbo].[sysjobhistory] WHERE job_id = 120990d0-0153-4779-adc9-613196b61e21 AND step_name IN ('(Job outcome)',('(Job Outcome)','(Auftragsergebnis)','(Sortie du travail)')
2018-06-29 10:00:00 Err GetMaxJobInstance->Failed with error: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.NFMCAMDOGBCBCKKAEOJICMPGMOLBJPKAAHOI.IOMCEHALENFPHACPMPCMCFCJGCKDCHLNFFIH(SqlConnection , String , Int32 ) in C:\sourcefiles\code\VisualCronService\Jobs\TaskProcesses\Database\SQL\apiSQL.vb:line 857
ClientConnectionId:5a20204d-c7e2-4e2d-984b-10d52cbbd75a
Error Number:102,State:1,Class:15

Edited by moderator Tuesday, July 3, 2018 2:20:44 PM(UTC)  | Reason: Not specified

Offline Support  
#2 Posted : Tuesday, July 3, 2018 2:20:35 PM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,167

Thanks: 866 times
Was thanked: 443 time(s) in 421 post(s)
Thanks for the report. It has been fixed here: https://www.visualcron.c....aspx?g=posts&t=8018
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top