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

sunnya527

A Score Level 2

over 10 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

Parents

0 Gaurav Arora
Appian Employee
over 10 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Gaurav Arora
Appian Employee
over 10 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data