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

[Sally Sheedy]

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/ac204ee9/attachment.html>