Skip to Content
0
Jun 30, 2020 at 11:35 AM

HANA XS Job fails - parameter at position 1 is not of type that can be processed xsjob

221 Views Last edit Jun 30, 2020 at 11:41 AM 3 rev

Hi,

I have checked lot of blog before posting this , but i am not able to find actual root cause mentioned in this blog, how to find this input parameter is set or not which is mentioned in the blog

https://answers.sap.com/questions/348087/sql-error-when-executing-through-xsjob.html

I have a below XS Job code which calls a XS JS function. When i run the XS JS file ARCHVAUDLOG.xsjs direclty passing the input iv_old_days and iv_until_time in browser it is running successfully.

But when i schedule it in XS JOB Dashboard it fails with error "Execution of script /hm/zca/ARCHIVE_AUDIT_LOG_XS/ARCHVAUDLOG.xsjs failed with error(s): Error: $hdb.Connection.executeProcedure: Parameter at position 1 is not of type that can be processed( line 5 position in /hm/zca/ARCHIVE_AUD_LOG_XS/ARCHIVE_AUDLOG_LIB.xsjslib"

XSJS Job file:

Below is my XSJS file ARCHVAUDLOG.xsjs

And below is my xsjslib file ARCHIVE_AUDLOG_LIB.xsjslibbelow is the job log, and i checked the marked line 5 below there seems to be no problem in mapping the input

XS Job failure:

Please help in resolving the issue.

Thanks,

Attachments

xcjf8.png (67.9 kB)
eeiwe.png (78.3 kB)
xttve.png (38.1 kB)
n3h5y.png (123.5 kB)