SQL query from the input data tool ({"Format of the initialization string does not )

[kashan]

I have work flow from the team member who moved out and I have to perform the task , he gave me workflow and when I open to get the query it gives . How can I retrieve the the query from the input tool?

Format of the initialization string does not conform to specification starting at index 0.

[CharlieS · Accepted solution]

Are you unable to view the query after that error message appears? You could always open the workflow in a text editor and find the query among the XML code.

[kashan]

Thanks alot yes I was able to find out .

[latimo1]

Using Dynamic Input Tool. I am getting the same error.  I get results from using the Refresh Button. I looked at the Alteryx file and here is the Node info:

<Node ToolID="19">
<GuiSettings Plugin="AlteryxBasePluginsGui.DynamicInput.DynamicInput">
<Position x="882" y="126" />
</GuiSettings>
<Properties>
<Configuration>
<InputConfiguration>
<Configuration>
<Passwords />
<CachedCosmeticName>Snowflake_Alteryx_RW</CachedCosmeticName>
<File RecordLimit="" FileFormat="23">aka:66c0a2346163da9309bfec1c|||select "ta_1"."DATA_SOURCE",
"ta_1"."SALES_DOC_NUM",
"ta_1"."BILL_DOC_NUM",
"ta_1"."DELIVERY_DOC_NUM"
from "METUS_PRD_DB"."DWH"."VW_BI_FACT_ORDERS_TO_INVOICE" "ta_1"
where "ta_1"."DELIVERY_DOC_NUM" in ('80779107','80779900','80787161','80791159','84890944')
and Lower("ta_1"."DATA_SOURCE") = 's4'</File>
<FormatSpecificOptions>
<PreSQLOnConfig>True</PreSQLOnConfig>
<NoProgress>False</NoProgress>
<SessionReadOnly>True</SessionReadOnly>
<ReadUncommitted>False</ReadUncommitted>
<TableStyle>Quoted</TableStyle>
<PreSQL />
<PostSQL />
</FormatSpecificOptions>
</Configuration>
</InputConfiguration>
<Mode>ModifySQL</Mode>
<Modifications>
<Modify Action="ReplaceStringEx" Annotation=" &quot;ta_1&quot;.&quot;DELIVERY_DOC_NUM&quot; in ('80779107','80779900','80787161','80791159','84890944')">
<ReplaceIn><![CDATA[ "ta_1"."DELIVERY_DOC_NUM" in ('80779107','80779900','80787161','80791159','84890944')]]></ReplaceIn>
<ReplaceValueType>String</ReplaceValueType>
<ReplaceText>'80779107','80779900','80787161','80791159','84890944'</ReplaceText>
<GroupForIn value="True" />
<GroupForIn_Limit value="5000" />
<Field>WhereClause</Field>
</Modify>
</Modifications>
<ErrorBehaviour>Error</ErrorBehaviour>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
<Dependencies>
<Implicit />
</Dependencies>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDynamicInput" />
</Node>

Here is the Input I Used for the Dynamic Input:

<Node ToolID="6">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="210" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<CachedCosmeticName>Snowflake_Alteryx_RW</CachedCosmeticName>
<File RecordLimit="" FileFormat="23">aka:66c0a2346163da9309bfec1c|||select "ta_1"."DATA_SOURCE",
"ta_1"."SALES_DOC_NUM",
"ta_1"."BILL_DOC_NUM"
from "METUS_PRD_DB"."DWH"."VW_BI_FACT_ORDERS_TO_INVOICE" "ta_1"
where Lower("ta_1"."DATA_SOURCE") = 's4'</File>

Any ideas? Thanks!  John!

[apathetichell]

@latimo1  So not really sure what you are doing or why you are posting to a 6 year old thread but:

from "METUS_PRD_DB"."DWH"."VW_BI_FACT_ORDERS_TO_INVOICE" "ta_1"

is wrong. snowflake has a 3 part object naming so DB.Schema.TABLE. You have "DB"."Schema""Table"

maybe open a new thread - start at the beginning/explain what you are trying to do and what troubleshooting steps you've taken?

[latimo1]

Why would the Refresh Button give results? The exact same query works in the Input Tool.

[apathetichell]

Honestly - i'd have to see the screenshots of the configuration - not just the xml. start a new thread. post screenshots of your query and your configuration. My hunch -> you have db/schema set up in one of your tools so it's ignoring that you're SQL is wrong. Without seeing everything - thats my best guess.

if this works in regular input - post the xml too?

[apathetichell]

correction -> seeing ta1 is the internal name -> try a new thread some screenshots of the your config and of the error messages.