Database Command | Supporting Tasks

Wed, 25 Nov 2015 16:01:15 GMT

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:

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)

###########

Re: Database Command | Supporting Tasks

santiago_respane — Thu, 26 Nov 2015 12:14:15 GMT

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,

Re: Database Command | Supporting Tasks

dvr_bhanu — Tue, 01 Dec 2015 22:16:28 GMT

Hi,

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

Regards,

Bhanu

topic Database Command | Supporting Tasks in QlikView

Database Command | Supporting Tasks

Re: Database Command | Supporting Tasks

Re: Database Command | Supporting Tasks