Database Command | Supporting Tasks

[#1]

I am trying to check a database flag for "N" once this process completes successfully then trigger another task..no matter how i set it up it fails. am i doing correct? any help is greatly appreciated.

Attached a snapshot of the configuration:

Here is the log file

#########

11/25/2015 10:39:55 AM               Error      The task "Testing for Status Flag" failed. Exception:

1. QDSMain.Exceptions.TaskFailedException: Task failed ---> System.ArgumentException: Format of the initialization string does not conform to specification starting at index 108.

   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.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)

   at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)

   at System.Data.OleDb.OleDbConnection.ConnectionString_Set(DbConnectionPoolKey key)

   at QDSMain.SQLTask.ExecuteOleDb(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)

###########

[santiago_respane]

Hi Venkat,

i think this could be a connection string issue or permissions issue also.

You should verify:

• there is no single quote or wrong chacarter in the connection string
• if connection string is well formed for your source database
  • This is a good place to start Oracle connection strings - ConnectionStrings.com
• check if the user you are using has correct permissions
• check if its necessary to add database name in your query (select * from database.table)

Let me know if this helps.

Kindest regards,

[dvr_bhanu]

Hi,

I am also getting the same error. It would be great if someone can help on this.

Regards,

Bhanu