Hi Experts,
I have reporting enabled, but getting the below response in the reporting status
Pending - waiting for job to be processed
can i have any suggestion to stop all the pending jobs so that I run a new report from a watcher
Regards
dilip
1 Like
Good news, this was recently added to the UI: https://github.com/elastic/kibana/pull/60077
In the meantime, you will have to resort to deleting the underlying documents. Unless you have modified xpack.reporting.index, this should follow the .reporting-* pattern.
You can see the uncompleted jobs with the following query. I would recommend using Dev Tools in Kibana for this:
GET /.reporting*/_search
{
"query": {
"bool": {
"must_not": {
"exists": {
"field": "completed_at"
}
}
}
}
}
If the results look correct there, you can then remove those by passing the same query to the _delete_by_query Elasticsearch API.
POST /.reporting*/_delete_by_query
{
"query": {
"bool": {
"must_not": {
"exists": {
"field": "completed_at"
}
}
}
}
}
1 Like
Thanks for your response , I am able to delete the pending reports, but still my new report is going into pending state.. instead of executing the report.
Am i missing something here, please advise
Regards
Dilip
What version are you running? Is there anything in the Kibana logs as to why the report isn't proceeding?
version of ELK is 6.7
The below are the logs as per the kibana
{"type":"log","@timestamp":"2020-05-20T11:21:38Z","tags":["debug","legacy-proxy"],"pid":3156,"message":"\"getConnections\" has been called."}
{"type":"log","@timestamp":"2020-05-20T11:21:38Z","tags":["debug","legacy-proxy"],"pid":3156,"message":"\"getConnections\" has been called."}
{"type":"log","@timestamp":"2020-05-20T11:21:38Z","tags":["debug","monitoring-ui","kibana-monitoring"],"pid":3156,"message":"Received Kibana Ops event data"}
{"type":"log","@timestamp":"2020-05-20T11:21:38Z","tags":["debug","legacy-proxy"],"pid":3156,"message":"\"getConnections\" has been called."}
{"type":"log","@timestamp":"2020-05-20T11:21:38Z","tags":["debug","monitoring-ui","kibana-monitoring"],"pid":3156,"message":"Received Kibana Ops event data"}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","legacy-proxy"],"pid":3156,"message":"Event is being forwarded: connection"}
{"type":"error","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","security","auth","session"],"pid":3156,"level":"error","error":{"message":"Unauthorized","name":"Error","stack":"Error: Unauthorized\n at validate (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi-auth-cookie\\lib\\index.js:153:49)\n at Object.authenticate (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi-auth-cookie\\lib\\index.js:226:26)\n at module.exports.internals.Manager.execute (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi\\lib\\toolkit.js:35:106)\n at module.exports.internals.Auth.test (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi\\lib\\auth.js:92:54)\n at Session.get (F:/ELKELK/kibana-6.7.0-windows-x86_64/kibana-6.7.0-windows-x86_64/node_modules/x-pack/plugins/security/server/lib/authentication/session.js:56:47)\n at Authenticator.authenticate (F:/ELKELK/kibana-6.7.0-windows-x86_64/kibana-6.7.0-windows-x86_64/node_modules/x-pack/plugins/security/server/lib/authentication/authenticator.js:142:49)\n at Object.server.expose.request [as authenticate] (F:/ELKELK/kibana-6.7.0-windows-x86_64/kibana-6.7.0-windows-x86_64/node_modules/x-pack/plugins/security/server/lib/authentication/authenticator.js:297:60)\n at Object.authenticate (F:/ELKELK/kibana-6.7.0-windows-x86_64/kibana-6.7.0-windows-x86_64/node_modules/x-pack/plugins/security/server/lib/auth_redirect.js:29:60)\n at module.exports.internals.Manager.execute (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi\\lib\\toolkit.js:35:106)\n at module.exports.internals.Auth._authenticate (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi\\lib\\auth.js:238:58)\n at authenticate (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi\\lib\\auth.js:214:21)\n at Request._lifecycle (F:\\ELKELK\\kibana-6.7.0-windows-x86_64\\kibana-6.7.0-windows-x86_64\\node_modules\\hapi\\lib\\request.js:263:62)\n at process._tickCallback (internal/process/next_tick.js:68:7)"},"message":"Unauthorized"}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","legacy-service"],"pid":3156,"message":"Request will be handled by proxy GET:/api/reporting/jobs/download/kaf90d1e02fo043c5d7cbsjz."}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","security","basic"],"pid":3156,"message":"Trying to authenticate user request to /api/reporting/jobs/download/kaf90d1e02fo043c5d7cbsjz."}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","security","basic"],"pid":3156,"message":"Trying to authenticate via login attempt."}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","security","basic"],"pid":3156,"message":"Username and password not found in payload."}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","security","basic"],"pid":3156,"message":"Trying to authenticate via header."}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","security","basic"],"pid":3156,"message":"Request has been authenticated via header."}
{"type":"log","@timestamp":"2020-05-20T11:21:39Z","tags":["debug","reporting","download"],"pid":3156,"message":"Report kaf90d1e02fo043c5d7cbsjz has non-OK status: [503] Reason: [\"pending\"]"}
{"type":"response","@timestamp":"2020-05-20T11:21:39Z","tags":["api"],"pid":3156,"method":"get","statusCode":503,"req":{"url":"/api/reporting/jobs/download/kaf90d1e02fo043c5d7cbsjz","method":"get","headers":{"user-agent":"Apache-HttpClient/4.5.2 (Java/1.8.0_191)","accept-charset":"UTF-8","host":"mydns:80","x-cluster-client-ip":"10.**.**.135","kbn-xsrf":"reporting","connection":"Keep-Alive","accept-encoding":"gzip,deflate","content-length":"0"},"remoteAddress":"10.**.**.132","userAgent":"10.**.**.132"},"res":{"statusCode":503,"responseTime":66,"contentLength":9},"message":"GET /api/reporting/jobs/download/kaf90d1e02fo043c5d7cbsjz 503 66ms - 9.0B"}
Regards
Dilip
1 Like
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.