Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qvwme_huthfa
Contributor
Contributor

QlikView Extractor Connector 5.8 IR - How to automatically delete rows with status S from SAP-Table /QTQVC/STATUS


Hello guys,

at the Moment I am facing a Problem on a customer site. They are using QlikView SAP Extractor connector 5.8 IR (Update 7/4/13).

There are a lot of Tasks which gather the relevant DataSources from SAP-System. Some of them are  for some reasons not returning, so that the customer Needs MANUALLY to delete the respecting rows Status S via Transaction /QTQVC/DELETE with the timestamp. This is a huge and effort not acceptable in production Environment. Unless These rows are not deleted, a new extraction can't be started

Idea is to write a script which, deletes hanging Job-rows from /QTQVC/STATUS .

--> A direct Access to /QTQVC/STATUS via DELETE or similiar seems not to be possible.

--> My idea is to use BAPI Connector or similiar to achieve the deletion.

Question:

-> Is there a better way to do this?

--> How to generally automatically delete rows from /QTQVC/STATUS

Any answers and snipplets are appreciated.

Best regards,

Fabian

0 Replies