Query Failed. Contact portal administrator. System.Exception: select CSU_STUD_ABSENCE_BY_COURSE.CRS_CDE as Course,
Attendance_Status_Date = convert(char(10), dbo.csu_student_attendance.attendance_dte, 101),
case
when CSU_STUDENT_ATTENDANCE.ATTENDANCE_STS = 'A' then 'Absent'
when CSU_STUDENT_ATTENDANCE.ATTENDANCE_STS = 'L' then 'Late'
when CSU_STUDENT_ATTENDANCE.ATTENDANCE_STS = 'E' then 'Left Early'
end as Attendance_Status
from CSU_STUD_ABSENCE_BY_COURSE,
CSU_STUDENT_ATTENDANCE
where (CSU_STUD_ABSENCE_BY_COURSE.ID_NUM = CSU_STUDENT_ATTENDANCE.ID_NUM) and
(CSU_STUD_ABSENCE_BY_COURSE.YR_CDE = CSU_STUDENT_ATTENDANCE.YR_CDE) and
(CSU_STUD_ABSENCE_BY_COURSE.TRM_CDE = CSU_STUDENT_ATTENDANCE.TRM_CDE) and
(CSU_STUD_ABSENCE_BY_COURSE.STUD_SEQ_NUM = CSU_STUDENT_ATTENDANCE.STUD_SEQ_NUM) and
((CSU_STUD_ABSENCE_BY_COURSE.ID_NUM = 'guest') and
(CSU_STUD_ABSENCE_BY_COURSE.YR_CDE = '2024') and
(CSU_STUD_ABSENCE_BY_COURSE.TRM_CDE = '50') and
CSU_STUDENT_ATTENDANCE.ATTENDANCE_STS <> 'P') ---> System.Data.Odbc.OdbcException: ERROR [22018] [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value 'guest' to data type int.
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at CUS.OdbcConnectionClass3.OdbcConnectionClass3.OdbcConn(String sqlStatement, Exception& exReturn, Int32 timeout, List`1 parameters)
--- End of inner exception stack trace ---
at CUS.ICS.SimpleQuery.SimpleQueryExecution.GetData(Guid portletId)
at CUS.ICS.SimpleQuery.Default_View.RenderOutput()
This portlet is only available to users of certain roles logged into the system.