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

[Thomas, Kirsti]

I usually see error messages like this when I've tried to use fields from 2 different Subject Areas in the report.

Was this a report you'd been using for a while that stopped working?

Following Wade's idea, try taking the criteria filters out and see if you still get the error message.

Kirsti


From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Sally Sheedy
Sent: Monday, June 29, 2020 12:47
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)


CAUTION: This email originated outside of the Seattle Colleges’ email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

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