Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am trying to execute a SQL Command throw QMC -> Supporting Task .-> Database Command
In Connection String i am giving below mention value
"ODBC CONNECT TO <DATABASE NAME>(XUserId is <USERID>, XPassword is <PASSWORD>)"
in Database Command there is simple sql command, i am getting below mention error.
(2017-05-25 09:51:04) Information: Starting task 'Copy of TestDatabase'. Id:e385c08d-1432-48c0-9585-0cacf3929f56. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
(2017-05-25 09:51:04) Information: Entering Task Execution.
(2017-05-25 09:51:04) Information: ClusterID=1
(2017-05-25 09:51:04) Information: QDSID=a8c6155e-7112-ac3c-858d-7d7675394be0
(2017-05-25 09:51:04) Information: TaskID=e385c08d-1432-48c0-9585-0cacf3929f56
(2017-05-25 09:51:04) Information: MaxRunTime=1.00:00:00
(2017-05-25 09:51:04) Information: MachineName=*****************
(2017-05-25 09:51:04) Information: Max attempts:1
(2017-05-25 09:51:04) Information: Current Attempt=0
(2017-05-25 09:51:04) Information: Task Dependencies are OK
(2017-05-25 09:51:05) Error: The task "Copy of TestDatabase" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task failed ---> System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0. || at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue) || at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) || at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) || at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) || at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) || at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) || at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) || at QDSMain.SQLTask.ExecuteSqlClient(Int32 commandTimeout) || at QDSMain.SQLTask.ExecuteSqlThread(ILogBucket logBucket, TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.SQLTask.Execute(TaskResult taskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2017-05-25 09:51:05) Information: Task Execute Duration=00:00:01.0156315
(2017-05-25 09:51:05) Information: TaskResult.status=Finished
(2017-05-25 09:51:05) Information: Notifying all triggers of new state:FinishedWithErrors
(2017-05-25 09:51:05) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2017
Did anyone can help me ?