Tracker log

An overview of recent activity in the tracker.

New issue »DB error for getClassByClassNumberLongDescrTopicCX« added by Maccabee Levine

Every call to getClassByClassNumberLongDescrTopicCX since yesterday ~2pm is failing with an HTTP 500 response caused by a DB error. Tested with multiple courses from this past term and the upcoming summer term.

From the HTML response:


<dd>DatabaseError</dd>
    
                <dt>
                Error Value
                </dt>
                    <dd>ORA-65535: Message 65535 not found; product=RDBMS; facility=ORA
</dd>
                <dt>
                Request made at
                </dt>
                <dd>2012/05/16 12:42:08.194 GMT-5</dd>
            </dl>

Added 10 day(s) ago.

New issue »document each web service« added by T. Kim Nguyen

on plonedev/it site probably or wherever the PeopleSoft docs end up

Added 164 day(s) ago.

New issue »create Oracle views and users specific to each web service« added by T. Kim Nguyen

instead of using a single login

Added 164 day(s) ago.

New issue »HTTP 204 for Elem Ed 317« added by Maccabee Levine

HTTP 204 response returned for a lookup for 60885/0650: ELEM ED 317 - Teaching Social Studies Pre K - 8. It looks like a perfectly normal class: assigned instructor who has been teaching for several years, assigned room & time, etc. The program assistant knows of nothing strange about the course in PS.

ELEM ED 317 - Teaching Social Studies Pre K - 8
003C-LEC(60885)
We 8:00AM - 11:20AM Nursing/Ed 202B Patricia Sowls 09/08/2010 - 12/17/2010

Added 619 day(s) ago.

New issue »HTTP 204 returned for cross-listed class« added by Maccabee Levine

A call to getClassByClassNumberLongDescrTopicCX for 63314 / 0650 returns response code 204 No Content. This usually happens when the course does not exist or when it does not have an assigned instructor. For this class, it exists and had an instructor assigned last Friday (9/3).

    WOM STDS 105 - Social Work Ethics in a Diverse Society
    001C-LEC(63314)
    
Days & Times Room Instructor Meeting Dates
TuTh 8:00AM - 9:30AM N. Halsey 266 Annette Lechnir 09/08/2010 - 12/17/2010

The only thing still unusual about the course is that it is a "combined section" with Social Work 105. That class (62483) also returns 204 No Content.

Added 625 day(s) ago.

New issue »No data being returned for any course« added by Maccabee Levine

No call to the web service has succeeded since 10:15am yesterday morning; every call returns an empty response. For example the following two course lookups have failed, all for courses that are valid and look normal in TitanWeb.

43087/0645
    JOURNAL 341 - Media and Society
    001C-LEC(43087)
    Session
    14W
TuTh 9:40AM - 11:10AM Clow Class 13 Timothy Gleason 02/01/2010 - 05/14/2010
    
    
42176/0645
BUSINESS 320 - Essentials of Law for Business
    002C-LEC(42176)
    Session
    14W
MoWe 1:50PM - 2:50PM Nursing/Ed 222 Willis Hagen 02/01/2010 - 05/14/2010

Added 779 day(s) ago.

New issue »Oracle reporting ORA-00257: archiver error.« added by Maccabee Levine

A new error appeared in response to web service calls yesterday, causing all three calls to fail between 10pm last night to 9am this morning, but seems to be ok again now. As usual, it was returned in the middle of a large block of HTML. I'm reporting it in case it's something that might happen again.


            <dl>
                <dt>
                Error Type
                </dt>
        
                <dd>DatabaseError</dd>
    
                
                <dt>
                Error Value
                </dt>
    
                <dd>ORA-00257: archiver error. Connect internal only,
until freed.
</dd>

Added 780 day(s) ago.

New issue »WS always fails with libclntsh.so.11.1 file error« added by Maccabee Levine

Every call to the https://ws.it.uwosh.edu/get[…]ClassNumberLongDescrTopicCX web service this morning fails with a new error. A full HTML page is returned, the key portion follows.


        <div>

            <h1>Site error</h1>

            <p>
            This site encountered an error trying to fulfill your request.
            The errors were:
            </p>

            <dl>
                <dt>
                Error Type
                </dt>

                <dd>ImportError</dd>




                <dt>
                Error Value
                </dt>

                <dd>libclntsh.so.11.1: cannot open shared object file: No such f
ile or directory</dd>


                <dt>
                Request made at
                </dt>

                <dd>2010/02/09 10:01:52.413 US/Central</dd>
            </dl>

        </div>
</div>

Added 837 day(s) ago.

New issue »All calls to new WS failing since early AM« added by Maccabee Levine

All calls to the new web service are failing. The last success was at 2010-02-08 01:10:02. Now all calls encounter a 500 error; in 'steps to reproduce' is the output of that last success from 1:10am. The web service returns a full HTML page, 10kb of data. The key excerpt:


            <p>
            This site encountered an error trying to fulfill your request.
            The errors were:
            </p>

            <dl>
                <dt>
                Error Type
                </dt>

                <dd>DatabaseError</dd>




                <dt>
                Error Value
                </dt>

                <dd>ORA-65535: Message 65535 not found; product=RDBMS; facility
=ORA

</dd>


                <dt>
                Request made at
                </dt>

                <dd>2010/02/08 08:44:17.625 US/Central</dd>
            </dl>

Added 838 day(s) ago.

New issue »Every call failing with "Error Value: connection_string" (getClassByClassNumber)« added by Maccabee Levine

Since around 4pm on Saturday (9/12), all 26 calls to getClassByClassNumber have failed. This is causing every course page creation to fail. The calls return a full HTML page response (similar to bugs #2 and #5). The key portion of the HTML is below. From the command line (wget), I get an Error 500.

This happens for every class_num I try, real (34654/0640) or fake (12345/0640).


      <div>

          <h1>Site error</h1>

          <p>
          This site encountered an error trying to fulfill your request.
          The errors were:
          </p>

          <dl>
              <dt>
              Error Type
              </dt>

              <dd>AttributeError</dd>




              <dt>
              Error Value
              </dt>

              <dd>connection_string</dd>


              <dt>
              Request made at
              </dt>

              <dd>2009/09/13 08:36:40.231 GMT-5</dd>
          </dl>

      </div>

Added 985 day(s) ago.

New issue »Data repeated for multi-session class« added by Maccabee Levine

MPA 711 Politics, Policy, and Public Administration (30400/0640) appears from TitanWeb to meet on 5 days, spread out over the fall term. The return data from the getClassByClassNumber web service returns a long response, repeating the relevant data block 5 times. The Course Pages app handles this ok but it is definitely unexpected. Return value below.

-bash-3.2$ wget --no-check-certificate "https://ws.it.uwosh.edu/getClassByClass
Number?class_nbr=30400&strm=0640"

Added 1025 day(s) ago.

New issue »getCurrentSemesterUgradEndDate causes exception« added by scorcm43

It seems to be working through the web. When I go to http://ws.it.uwosh.edu:8080/[…]/getCurrentSemesterUgradEndDate it works fine.

But calling it in python using xmlrpclib is throwing an exception.

Added 1075 day(s) ago.

New issue »getCurrentSemester and getCurrentSemesterUgradEndDate return error string« added by scorcm43

When the current date is in between semesters (so there is no current semester) calling either of those two methods returns a string like:
"error: no semester code found matching today's date"

They should probably return an empty string. Or at least some kind of documented error without a single-quote in it.

Added 1080 day(s) ago.

New issue »New Oracle errors: Invalid connection string, Oracle not available, ...« added by Maccabee Levine

A call to https://ws.it.uwosh.edu/get[…]ass_nbr=11970&strm=0635 at 2009-05-21 02:46:32 returned a Plone error page with some new (to me) oracle errors. Key section follows (I removed some whitespace); if you want I'll post the full thing. I've also snipped the connection string because I think it includes a password. The same call succeeded just now.



                <dt> Error Type </dt>
                <dd>BadRequest</dd>
                <dt> Error Message </dt>
                <dd>&lt;strong&gt;Invalid connection string: &lt;/strong&gt;&lt;
...snip...
&lt;!--
cx_Oracle.DatabaseError
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
--&gt;
</dd>
                <dt>
                Request made at
                </dt>
                <dd>2009/05/21 02:46:32.808 GMT-5</dd>
            </dl>
        </div>
</div>

Added 1101 day(s) ago.

New issue »getClassByClassNumber returns no data for Soc Work course« added by Maccabee Levine

The getClassByClassNumber web service returns no course data for valid input, 13182/0635, which is a section of SOC WORK 734 - Field Research Consultation. I can find the course in TitanWeb without a problem. By 'no course data' I mean that it returns the exact same response XML as for a non-existent class, i.e. 12345/0635. The result is consistent for this input. Other valid input (i.e. 12569/0635) still returns correct course data.

Added 1102 day(s) ago.

New issue »Products.ZXOracleDA.db: ValueError: incomplete format« added by Maccabee Levine

This morning, 2009-05-08 04:40:58, the web service for library course pages returned a new error, for input

https://ws.it.uwosh.edu/get[…]ass_nbr=30912&strm=0640

The same call succeeded when I tried it a few minutes ago. Because of the inconsistent nature this is probably related to your work on bug #2 but you can make that judgment. I notice that it's a Fall '09 (0640) course, but the web service has worked on those in the past.


<h2>Site Error</h2>
  <p>An error was encountered while publishing this resource.
  </p>
  <p><strong>exceptions.ValueError</strong></p>

  Sorry, a site error occurred.<p><p>Traceback (innermost last):
<ul>

<li> Module ZPublisher.Publish, line 196, in publish_module_standard</li>

<li> Module Products.PlacelessTranslationService.PatchStringIO, line 34, in new
_publish</li>

<li> Module ZPublisher.Publish, line 157, in publish</li>

<li> Module Zope2.App.startup, line 243, in abort</li>

<li> Module transaction._manager, line 107, in abort</li>

<li> Module transaction._transaction, line 507, in abort</li>

<li> Module transaction._transaction, line 580, in abort</li>

<li> Module Shared.DC.ZRDB.TM, line 64, in abort</li>

<li> Module Products.ZXOracleDA.db, line 67, in _abort</li>

</ul>ValueError: incomplete format
</p></p>
  <hr noshade="noshade"/>

  <p>Troubleshooting Suggestions</p>

  <ul>
  <li>The URL may be incorrect.</li>
  <li>The parameters passed to this resource may be incorrect.</li>
  <li>A resource that this resource relies on may be
      encountering an error.</li>
  </ul>

  <p>For more detailed information about the error, please
  refer to the error log.
  </p>

  <p>If the error persists please contact the site maintainer.
  Thank you for your patience.
  </p>

Added 1114 day(s) ago.

New issue »ORA-03114: not connected to ORACLE« added by Maccabee Levine

The web service used by Library Course Pages to map "class id + term" => catalog information occasionally returns the following error message instead of an XML data stream. It is not triggered by any particular input data; for example the error occurred at 2009-04-06 09:10:37 for inputs 10849/0635, right now that query succeeds. The queries cover courses from many departments and have nothing apparent in common. All but one or two are classes from this term (0635).

Below the error message I've included the timestamps of the 31 times this error was recorded in our log files. Over that same time period, the query succeeded the other ~190 times it was called. Note that twice (the errors on 4/3 and 4/8) the query would have failed anyway because my input was badly formed, but the error response was the same so it didn't get that far.

<h2>Site Error</h2>
  <p>An error was encountered while publishing this resource.
  </p>
  <p><strong>cx_Oracle.DatabaseError</strong></p>

  Sorry, a site error occurred.<p><p>Traceback (innermost last):
<ul>

<li> Module ZPublisher.Publish, line 196, in publish_module_standard</li>

<li> Module Products.PlacelessTranslationService.PatchStringIO, line 34, in new
_publish</li>

<li> Module ZPublisher.Publish, line 157, in publish</li>

<li> Module Zope2.App.startup, line 243, in abort</li>

<li> Module transaction._manager, line 107, in abort</li>

<li> Module transaction._transaction, line 507, in abort</li>

<li> Module transaction._transaction, line 580, in abort</li>

<li> Module Shared.DC.ZRDB.TM, line 64, in abort</li>

<li> Module Products.ZXOracleDA.db, line 61, in _abort</li>

</ul>DatabaseError: ORA-03114: not connected to ORACLE

</p></p>
  <hr noshade="noshade"/>

  <p>Troubleshooting Suggestions</p>

  <ul>
  <li>The URL may be incorrect.</li>
  <li>The parameters passed to this resource may be incorrect.</li>
  <li>A resource that this resource relies on may be
      encountering an error.</li>
  </ul>

  <p>For more detailed information about the error, please
  refer to the error log.
  </p>

  <p>If the error persists please contact the site maintainer.
  Thank you for your patience.
  </p>


2009-03-02 09:50:07
2009-03-03 10:51:33
2009-03-05 07:18:11
2009-03-06 05:18:27
2009-03-09 06:34:40
2009-03-10 10:32:07
2009-03-11 09:27:17
2009-03-12 07:59:00
2009-03-13 08:12:58
2009-03-16 09:40:15
2009-03-17 13:15:00
2009-03-18 08:06:21
2009-03-19 11:24:21
2009-03-19 15:53:56
2009-03-20 08:55:21
2009-03-23 07:47:36
2009-03-23 10:10:29
2009-03-24 12:28:54
2009-03-24 16:04:27
2009-03-25 13:54:11
2009-03-25 19:49:15
2009-03-26 13:21:20
2009-03-27 06:46:03
2009-03-30 09:46:23
2009-03-31 14:40:41
2009-04-01 08:22:56
2009-04-02 09:30:40
2009-04-03 14:53:33
2009-04-06 09:10:38
2009-04-07 09:24:33
2009-04-08 10:43:50

Added 1144 day(s) ago.

New issue »Add 'long' course description and 'topic' fields to result« added by Maccabee Levine

Please add two result fields to the PeopleSoft course catalog data web service:
- "long" course description, i.e. you give me 'Bible & Cur Ev' vs. TitanWeb shows 'The Bible and Current Events' for Jodi's Religious Studies 106 (#11602) this term
- "topic" for Special Topics classes, i.e. all of the WBIS 188 sections.

Added 1201 day(s) ago.