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

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...

OriginalPostID-113349

OriginalPostID-113349

  Discussion posts and replies are publicly visible

  • 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.
  • 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
    A Score Level 1
    in reply to sunnya527

    hi i am facing same issue is your issue resolved ? and if so how ?

  • 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