Workflow and ServiceDesk Community

Hello! 

Has anyone received this error when using a SQL Query component?  I even tried to use the Initialize data component to set the value to 0 and I still got the same error.  Does anyone know how to address this?  I bolded the error message that I'm getting in the debugger.  Hopefully someone can shed some light on this for me!

Tom

 

Component Link Executed

Exception Type : System.Exception

Message: (GetAltirisHD6ActiveWorkers GetAltirisHD6ActiveWorkers) - Format of the initialization string does not conform to specification starting at index 0.

Stack Trace

(inner exception)

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 System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)

at System.Data.SqlClient.SqlConnection..ctor(String connectionString)

at GetAltirisHD6ActiveWorkers.SqlQuery.GetAltirisHD6ActiveWorkers.GetConnection(IData data)

at GetAltirisHD6ActiveWorkers.SqlQuery.GetAltirisHD6ActiveWorkers.Run(IData data)

at LogicBase.Core.ExecutionEngine.SinglePathProcessComponentExecutionDelegate.Execute(IData data, IOrchestrationComponent comp, String& outputPath, IExecutionEngine engine, TLExecutionContext context)

at LogicBase.Core.ExecutionEngine.AbstractExecutionEngine.DoRunComp(IOrchestrationComponent comp, IData data, TLExecutionContext context)

I think it's having a problem with your SQL Connection String. Open up the Integration project that contains your SQL Query/Script generator, choose Adjust Definitions and double click the generator that pertains to the SQL Query component in your project. On the first part of the wizard, click the "Test Connection" button under the Connection String drop-down and make sure you are getting the "Connection Test Success" message. If not, you need to modify your connection string. If that's not it close your Workflow project, reset server extensions and then reopen your project and see if it still gives the error.

I rebooted the computer, restarted the services and checked the connection.  The SQL connection was working when I was creating the component.  I double checked it and it's still good.  I'm still getting the same error though. 

Here is the workflow.  It doesn't get past the component for GetAltirisHD6ActiveWorkers

 Will you paste the connection string for your "GetAltirisHD6ActiveWorkers" component?  It should read something like "Data Source=mySQLServerName;Initial Catalog=myDatabaseName;User ID=myUsername;Password=myPassword;"

Also, if you disable/remove the "GetAltirisHD6ActiveWorkers" component, does the "GetAltirisHD6Licenses" component throw the same ConnectionString error?

Wes

All the components throw the same error when I'm going through the debugger (such as if I remove one and substitute with another).  The connection string to the SQL Server works fine.

Here is the string...

Data Source=Altiris11;Initial Catalog=Altiris_11_incidents;User ID=SysPrep;Password=xxxxxx;

The part of the error that says "index 0" means that the beginning of the connection string does not contain valid input.  If you use a connection string like "0", "Data Source", or random text like "asldkfjaslkg", it will return an error with "index 0".

What did you mean when you said: "I even tried to use the Initialize data component to set the value to 0 and I still got the same error."?  If your connection string is set to "0", you will get that error for sure.

Is the connection string you pasted coming from the component in your workflow ("Edit Component" --> "Connection Configuration" tab --> "Connection String:") or from the integration project ("Integration Library"-->"Adjust Definitions"-->"Connection String")?  The connection string property of the component in your workflow is the one that will be used when the project is run.

Thanks freEner-g_Wes, I had to check the properties and make a quick edit!