No LUA script found message after upgrade from 2020.3 to 2023.1

[john_watkins]

Our team upgraded from 2020.3 --> 2022.1 --> 2023.1.   At the time we upgraded all workflows were working fine local and from the gallery.   After the upgrade, we noticed that most of our In-DB connections get an error stating "No table chosen; Please select a Table from data source. "    These scripts will run on my machine local, but not from the gallery.   I have a co-worker who can't run locally or on the gallery.   We both upgraded to designer 2023.1 as well.

Inside of the workflows that error on his machine it give an error "Unable to load LUA file"    When we checked the LUA files from SnowFlake, we both have the same file loaded, and are on the same driver.   

This makes me feel like since the code runs just fine on my local machine , but not on a co-worker and not on the gallery that there must be some sort of configuration that is different.   My Designer has no issues loading the LUA and runs fine.   His and the server can not. 

I am confused to say the least and I have many jobs that will start failing come Monday.   Any help is greatly appreciated.

[eisenzjw]

Hi, did you get this resolved? We are currently dealing with the same thing

[john_watkins]

I ended up copying the function portion from one portion of the LUA files into this specific one and that seemed to make it work just fine.  This was copy/pasted into the snowflakedsii.lua below the portion that was there.

function getFieldInfo(odbcInfo)

odbcVal = odbcInfo["odbcType"]

alteryxType = ODBCToAlteryx[odbcVal]

scale = odbcInfo["scale"]

precision = odbcInfo["precision"]

if (odbcVal == common.ODBCTypes.SQL_DECIMAL) then

if (scale == 0) then

if (precision < 5) then

alteryxType = common.types.Int16

elseif (precision < 10) then

alteryxType = common.types.Int32

elseif (precision < 19) then

alteryxType = common.types.Int64

else

alteryxType = common.types.FixedDecimal

end

else

alteryxType = common.types.FixedDecimal

end

end

if (alteryxType == nil or alteryxType == '') then

alteryxType = common.types.V_String

end

return alteryxType

end

function getCType(altType) 

alteryxType = altType["altType"]

cType = AlteryxToC[alteryxType].c_type

return cType

end

function getLength(altType)

alteryxType = altType["altType"]

cLength = AlteryxToC[alteryxType].c_length

return cLength

end

function getCreateType(colInfo)

size = colInfo["size"]

alteryxType = colInfo["altType"]

if (alteryxType == common.types.FixedDecimal and size > 38) then

createType = "NUMBER(38,scale)"

else

createType = AlteryxToC[alteryxType].create_type

end

return createType

end