Updating Jobstatus to A in Status Table

[PhilippZiemer]

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:

[Hakan_Ronningberg · Accepted solution]

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