Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] understanding diagnostic servlet output for loader jobs

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] understanding diagnostic servlet output for loader jobs

Chronological Thread 
  • From: Scott Koranda <>
  • To: "Hyzer, Chris" <>
  • Cc: grouper-users <>
  • Subject: Re: [grouper-users] understanding diagnostic servlet output for loader jobs
  • Date: Mon, 7 Nov 2016 08:07:11 -0600
  • Ironport-phdr: 9a23:adxXNB1qq3LshCXcsmDT+DRfVm0co7zxezQtwd8ZsegTKvad9pjvdHbS+e9qxAeQG96KsbQV16GN6ejJYi8p2d65qncMcZhBBVcuqP49uEgeOvODElDxN/XwbiY3T4xoXV5h+GynYwAOQJ6tL2PbrnD61zMOABK3bVMzfbWvXN+OxJ/tn8mJuLTrKz1SgzS8Zb4gZD6Xli728vcsvI15N6wqwQHIqHYbM85fxGdvOE7B102kvpT4r9Zf9HEam+Mz+tQEGY76ZaUjB/QMCT8mInI4/uXqrhKFUBOC4H1aX2kLxElmGQ/AuSrxWYvt+gj9rON71CDSadb1Sqo9Xzirx6huQR7sziwAMmhqoynslsVsgfcD81qarBtlztuMbQ==

> Give me a full screen copy of the status servlet, and look in logs and get
> full error message there. Sometimes it fails on a job but its really
> another job (but threaded so it say both, if you know what I mean). IF
> that doesn't help find the problem job...
> Maybe run this in the database: (is it oracle? If not you need to change
> the SYSDATEs to whatever else for your DB...
> SELECT DISTINCT 'loaderRunOneJob("' || job_name || '");' AS script
> FROM grouper_loader_log gll
> WHERE started_time > SYSDATE - 1
> AND status != 'SUCCESS'
> AND gll.job_name NOT LIKE 'subjobFor%'
> FROM grouper_loader_log gll2
> WHERE gll2.started_time > SYSDATE - 1
> AND gll2.status = 'SUCCESS'
> AND gll2.job_name = gll.job_name);

For the archives:

The issue was that the copy of in
the WS and UI deployment directories was out of sync with the
one in the "API" deployment directory (the one from which the
loader process actually runs).

So although there was no issue with the loader, the diagnostic servlet
was not working from a "proper" configuration.

After synchronizing that file across the API, UI, and WS and
restarting Tomcat the diagnostic servlet is reporting 200 OK,
the expected value based on the state of the loader jobs.


Scott K

Archive powered by MHonArc 2.6.19.

Top of Page