Error on running procedure with input parameter in an XSJob

[shyam_uthaman]

Hi All,

I have a stored procedure and wish to run it with an XSjob.

The hdb procedure has 1 input parameter p_material of type nvarchar.

I get the error: Parameter mismatch. Abort.

What could be the issue here?

The XSjob runs fine when I remove parameters in the procedure and in the job file.

There's something silly in the code I wrote below and I can't seem to figure it out. Please help. Thanks!

The XS code I wrote is:

{

    "description": "Demo Procedure",

    "action": "<package_name>::sales_procedure",

    "schedules": [

       {

          "description": "Run every 10 seconds",

          "xscron": "* * * * * * 10",

          "parameter": {

              "p_material" : "Material1"

             }

       }

    ]

}

BR,

Shyam

[pfefferf · Accepted solution]

Hello Shyam,

please write the parameter name in the XSJOB file in upper case letters.

...

          "parameter": {

              "P_MATERIAL" : "Material1"

             }

...

Regards,

Florian

[shyam_uthaman · Accepted solution]

Thanks Florian. Can't believe I was breaking my head over this problem.

You save my brains once again.