Updating Jobstatus to A in Status Table

PhilippZiemer — Mon, 26 Jan 2026 21:26:37 GMT

To remove manual effort from the SAP extraktor interface for a customer I am trying to get the status from /QTQVC/STATUS and set it afterwards through the BAPI connector. This is how my query looks (without parametrization):

[/QTQVC/UPDATE_STATUS_E_JOBDATE]:

LOAD *;

SQL {

"function":"\/QTQVC\/UPDATE_STATUS",

"output":"E_JOBDATE",

"parameters":

[

{ "direction":"out", "length":8, "name":"E_JOBDATE", "optional":false, "type":"DATE", "value":"00000000" },

{ "direction":"out", "length":6, "name":"E_JOBTIME", "optional":false, "type":"TIME", "value":"000000" },

{ "direction":"in", "length":10, "name":"CONNECTOR", "optional":false, "type":"CHAR", "value":"QLIKVIEW" },

{ "direction":"in", "length":32, "name":"JOBNAME", "optional":true, "type":"CHAR", "value":"BIREQU_QLIKVIEW_20180613030008" },

{ "direction":"in", "length":1, "name":"JOBSTATUS", "optional":true, "type":"CHAR", "value":"A" },

{ "direction":"in", "length":1, "name":"MODE", "optional":false, "type":"CHAR", "value":"U" }

]

};

However this is the response:

2018-08-02 10:41:41 Error /QTQVC/UPDATE_STATUS failed after 00:00:00 Key = ERROR (ID:00 Type:E Number:001 Failed to find Status record)

2018-08-02 10:41:41 Error ID:00 Type:E Number:001 Failed to find Status record

The entry exists in the table:

Re: Updating Jobstatus to A in Status Table

Hakan_Ronningberg — Mon, 06 Aug 2018 12:32:28 GMT

Hi Philipp,

You need to give the input JOBDATE and JOBTIME parameters as they are part of the key to the status record. See this similar example:

[/QTQVC/UPDATE_STATUS_E_JOBDATE]:

LOAD *;

SQL {

"function":"\/QTQVC\/UPDATE_STATUS",

"output":"E_JOBDATE",

"parameters":

[

{ "direction":"out", "length":8, "name":"E_JOBDATE", "optional":false, "type":"DATE", "value":"00000000" },

{ "direction":"out", "length":6, "name":"E_JOBTIME", "optional":false, "type":"TIME", "value":"000000" },

{ "direction":"in", "length":10, "name":"CONNECTOR", "optional":false, "type":"CHAR", "value":"QTQVCEXTR1" },

{ "direction":"in", "length":8, "name":"JOBCOUNT", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":8, "name":"JOBDATE", "optional":true, "type":"DATE", "value":"20170627" },

{ "direction":"in", "length":32, "name":"JOBNAME", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":1, "name":"JOBSTATUS", "optional":true, "type":"CHAR", "value":"A" },

{ "direction":"in", "length":6, "name":"JOBTIME", "optional":true, "type":"TIME", "value":"143323" },

{ "direction":"in", "length":1, "name":"MODE", "optional":false, "type":"CHAR", "value":"U" },

{ "direction":"in", "length":40, "name":"OBJECT", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":255, "name":"STATUS_TEXT", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":1, "name":"TFMETHOD", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":2, "name":"UPDMODE", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":12, "name":"USERNAME", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":16, "name":"WINIPNR", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":50, "name":"WINUSER", "optional":true, "type":"CHAR", "value":"" }

]

};

Regards,

Hakan

topic Re: Updating Jobstatus to A in Status Table in QlikView

Updating Jobstatus to A in Status Table

Re: Updating Jobstatus to A in Status Table