[Wactclc-alma] Report error - where would log be?

[Guidry, Wade]

Sally,

Is this an analytics error?

What you're looking at is a raw Oracle database error. There won't be any log accessible to you that you can look at.

This error is saying that there's a problem with the criteria, or maybe there is mutually exclusive criteria.

You'll sometimes see SQL errors, if an analysis doesn't have any results to return, but that error is pretty explicit about no results to return.

So, this error seems related to criteria in use.


Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org


From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Sally Sheedy
Sent: Monday, June 29, 2020 12:47 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Report error - where would log be?

We got an error with our Fines and Fees report, the text is below. Where would log be, and what would I do with it when I found it?

Has this occurred with anyone else? afaik nothing has changed that could account for this new behavior.

Thanks for any info.

-SAlly

Odbc driver returned an error (SQLExecDirectW). Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: Please have your System Administrator look at the log for more details on this error. (HY000) SQL Issued: SELECT 0 s_0, "Fines and Fees"."Fines and Fees Transactions"."Fine Fee Creation Date" s_1, "Fines and Fees"."Fines and Fees Transactions"."Fine Fee Type" s_2, "Fines and Fees"."Loan Details"."Author" s_3, "Fines and Fees"."Loan Details"."Barcode" s_4, "Fines and Fees"."Loan Details"."Due Date" s_5, "Fines and Fees"."Loan Details"."Loan Date" s_6, "Fines and Fees"."Loan Details"."Title" s_7, "Fines and Fees"."User Details"."First Name" s_8, "Fines and Fees"."User Details"."Last Name" s_9, "Fines and Fees"."User Details"."Primary Identifier" s_10, "Fines and Fees"."User Details"."User Group" s_11, "Fines and Fees"."Fines and Fees Transactions"."Original Amount" s_12 FROM "Fines and Fees" WHERE (("Fines and Fees Transactions"."Fine Fee Creation Date" BETWEEN TIMESTAMPADD(SQL_TSI_DAY, -1, CURRENT_DATE) AND CURRENT_DATE) AND ("Fines and Fees Transactions"."Remaining Amount" > 0)) FETCH FIRST 500001 ROWS ONLY


Sally Sheedy
Systems Librarian
Whatcom Community College Library
237 W. Kellogg Rd
Bellingham, WA  98226
360-383-3287 direct (Library 3300, College 3000)


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200629/1a52bf9b/attachment-0002.html>