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

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.

Workflow

Input

Accepted answers

CharlieS

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.

All comments

CharlieS

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=" "ta_1"."DELIVERY_DOC_NUM" 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.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335