Error connecting to Redshift

[sersal10]

Hi all,

I suddenly recieved this message: ERROR [22P02] [Qlik][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 22P02] ERROR: invalid input syntax for integer: ""

I select the schema I want to load, and this appears. It worked before. What have may changed? Any suggestion. Very lost here.

Many thanks,

Sergio.

[sersal10]

Could it be a bug? It has been like that over a week now.

Many thanks

[Anil_Babu_Samineni]

Looks like there is data type changed in the target machine? the column data type for BLOB on source was set to jsonb on the target?

Or, is this something not working since beginning and worked at least once?

[sersal10]

Hi Anil, Thanks for replying.

It had been working fine for months until one point during the last 2 weeks.

About the data types we use Redshift and they are views and tables with strings, numbers and dates.

[Anil_Babu_Samineni]

@sersal10 In general all the schema will change in two way.

1) Could be If anything config done at Redshift.

2) If any Qlik side connector changed or due to hotfixes.

Not sure, which one is blocking.