Hi All, I am facing a issue while running execute procedure smart ser

sunnya527

A Score Level 2

over 11 years ago

Hi All,

I am facing a issue while running execute procedure smart service. While I am trying to run the process I am getting the following error.

There is a problem with task “Execute Stored Procedure” in the process “TestStoredProcedure”. java.sql.SQLException: Invalid column type: 1111

The column name given are same as that in procedure. but still facing this issue. Please if anybody could provide the solution it will be of great help.Thanks in advance...

Discussion posts and replies are publicly visible

0 Gaurav Arora
Appian Employee
over 11 years ago

Sunny, this is likely because one of the values you are inserting is null. if you do not tell the jdbc type, it uses the default jdbc type which is
Types.UNKNOWN (1111). Please verify the data that you are trying to insert/update.
0 sunnya527
A Score Level 2
over 11 years ago

HI Gaurav, In the procedure I have 2 parameter 1st is IN parameter there I am passing a value. and 2nd parameter is OUT parameter there just I am mapping it to a cdt. so I am not able to understand which value is passed as null. I have provided the data source name and procedure name correctly
0 shwetap02
A Score Level 1
over 5 years ago in reply to sunnya527

hi i am facing same issue is your issue resolved ? and if so how ?
0 Vadivelan over 5 years ago in reply to shwetap02

Hi

Have you tried executing the Stored Procedure directly through db passing the same inputs which you are passing via execute stored procedure smart service?

Also make sure you passing the same column name in smart service. Please post a snapshot of your config from Appian and the SP inputs from Db if possible.

Thanks

Vadivelan