Skip To Content
Query Failed. Contact portal administrator. System.Exception: SELECT format(getdate(),'yyyy') as [Year], case when sch.TRM_CDE like '2%' and len(sch.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE <> 'OC' then 'Fall' when sch.TRM_CDE LIKE '2%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Fall 1' when sch.TRM_CDE LIKE '2%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Fall 2' when sch.TRM_CDE like '2%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE and sch.END_DTE = ytt.TRM_END_DTE then 'Fall' when sch.TRM_CDE like '2%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Fall 1' when sch.TRM_CDE like '2%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Fall 2' when sch.TRM_CDE like '3%' and len(sch.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE <> 'OC' then 'Spring' when sch.TRM_CDE LIKE '3%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Spring 1' when sch.TRM_CDE LIKE '3%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Spring 2' when sch.TRM_CDE like '3%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE and sch.END_DTE = ytt.TRM_END_DTE then 'Spring' when sch.TRM_CDE like '3%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Spring 1' when sch.TRM_CDE like '3%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Spring 2' when sch.TRM_CDE like '4%' and len(sch.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE <> 'OC' then 'Summer' when sch.TRM_CDE LIKE '4%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Summer 1' when sch.TRM_CDE LIKE '4%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Summer 2' when sch.TRM_CDE like '4%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE and sch.END_DTE = ytt.TRM_END_DTE then 'Summer' when sch.TRM_CDE like '4%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Summer 1' when sch.TRM_CDE like '4%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Summer 2' end as [Term], section_master.crs_cde as [Course Code], section_master.crs_title as [Course Title], case when section_master.LEAD_INSTRUCTR_ID = 1 then '' else nm.FIRST_NAME + ' ' + nm.LAST_NAME end as [Instructor], FORMAT(SECTION_MASTER.FIRST_BEGIN_DTE,'MM/dd/yyyy') as [Begin Date], FORMAT(SECTION_MASTER.LAST_END_DTE,'MM/dd/yyyy') as [End Date], case when section_master.division_cde = 'OC' then '' else ss.MONDAY_CDE + ss.WEDNESDAY_CDE + ss.FRIDAY_CDE + ss.TUESDAY_CDE + ss.THURSDAY_CDE + ' at ' +CONCAT(REPLACE(REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,ss.begin_tim,100),7)),7),'AM',' AM'),'PM',' PM'),' - ',REPLACE(REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,ss.end_tim,100),7)),7),'AM',' AM'),'PM',' PM')) end AS [Days/Time], case when student_master.CUR_STUD_DIV = 'SU' and section_master.division_cde <> 'OC' then concat(lm.LOC_DESC,' - ',bm.BUILDING_DESC,', Rm ',ss.ROOM_CDE) when student_master.CUR_STUD_DIV = 'SU' and section_master.division_cde = 'OC' then lm.LOC_DESC when student_master.CUR_STUD_DIV IN ('AG','AU') and section_master.division_cde = 'OC' then lm.LOC_DESC when student_master.CUR_STUD_DIV IN ('AG','AU') and section_master.division_cde <> 'OC' then rm.ROOM_DESC else concat(tl.trsitename,' - ',tl.trlocaddress,' - ',tc.City,', ',tc.trstate) end as [Location], case when tt.link_2 is not null then concat(tt.link_1,', ',tt.link_2) when tt.link_3 is not null then concat(tt.link_1,', ',tt.link_2,', ',tt.link_3) when tt.link_4 is not null then concat(tt.link_1,', ',tt.link_2,', ',tt.link_3,', ',tt.link_4) else tt.link_1 end as Textbook FROM wwu_ex.EX_Prod.dbo.STUDENT_CRS_HIST sch join EX_Prod.dbo.section_master on sch.YR_CDE = SECTION_MASTER.YR_CDE and sch.TRM_CDE = SECTION_MASTER.TRM_CDE and sch.CRS_CDE = SECTION_MASTER.CRS_CDE join EX_Prod.dbo.section_schedules ss on sch.YR_CDE = Ss.YR_CDE and sch.TRM_CDE = Ss.TRM_CDE and sch.CRS_CDE = Ss.CRS_CDE join EX_Prod.dbo.STUDENT_MASTER on sch.ID_NUM = student_master.ID_NUM join EX_Prod.dbo.NAME_MASTER nm on SECTION_MASTER.LEAD_INSTRUCTR_ID = nm.ID_NUM join EX_Prod.dbo.NAME_MASTER nm1 on sch.ID_NUM = nm1.ID_NUM join EX_Prod.dbo.ADDRESS_MASTER am on sch.ID_NUM = am.ID_NUM and am.ADDR_CDE = '*LHP' left outer join EX_Prod.dbo.DEGREE_HISTORY DH on sch.ID_NUM = DH.ID_NUM and DH.CUR_DEGREE = 'Y' left outer join EX_Prod.dbo.YEAR_TERM_TABLE ytt on sch.YR_CDE = ytt.YR_CDE and sch.TRM_CDE = ytt.TRM_CDE left outer join EX_Prod.dbo.LOCATION_MASTER lm on ss.LOC_CDE = lm.LOC_CDE left outer join EX_Prod.dbo.BUILDING_MASTER bm on ss.BLDG_CDE = bm.BLDG_CDE left outer join EX_Prod.dbo.ROOM_MASTER rm on ss.LOC_CDE = rm.LOC_CDE and ss.BLDG_CDE = rm.BLDG_CDE and ss.ROOM_CDE = rm.ROOM_CDE left outer join GASTracking.dbo.StartDateSheettable sds on student_master.LOC_CDE = sds.JbarLocCode left outer join GASTracking.dbo.trcohortlocationt tcl on sds.trcohortID = tcl.trcohortID left outer join GASTracking.dbo.trlocations tl on tcl.trlocid = tl.trlocid left outer join GASTracking.dbo.trcity tc on tl.trcityid = tc.trcityid left outer join (select YR_CDE, TRM_CDE, crs_cde, max(book1) as book_1, max(link1) as link_1, max(book2) as book_2, max(link2) as link_2, max(book3) as book_3, max(link3) as link_3, max(book4) as book_4, max(link4) as link_4 from (select 'book' + convert(varchar(5),ROW_NUMBER() over (partition by concat(tt.yr_cde,'-',tt.trm_cde,'-',tt.crs_cde) order by concat(tt.yr_cde,'-',tt.trm_cde,'-',tt.crs_cde))) as book, 'link' + convert(varchar(5),ROW_NUMBER() over (partition by concat(tt.yr_cde,'-',tt.trm_cde,'-',tt.crs_cde) order by concat(tt.yr_cde,'-',tt.trm_cde,'-',tt.crs_cde))) as link, concat(tt.yr_cde,'-',tt.trm_cde,'-',tt.crs_cde) as bk_key, tt.YR_CDE, tt.TRM_CDE, tt.CRS_CDE, td.book_desc from EX_Prod.dbo.TEXTBOOK_TABLE TT left outer join EX_Prod.dbo.TEXTBOOK_DEF td on tt.BOOK_SEQ_NUM = td.BOOK_SEQ_NUM ) bks pivot ( max(bk_key) for book in (book1, book2, book3, book4) ) as p1 pivot ( max(book_desc) for link in (link1, link2, link3, link4, link5, link6) ) as p2 group by yr_cde, trm_cde, crs_cde ) TT ON sch.YR_CDE = tt.YR_CDE and sch.TRM_CDE = tt.TRM_CDE and sch.CRS_CDE = tt.CRS_CDE WHERE sch.DROP_FLAG is null and sch.ID_NUM = 0 and TRANSACTION_STS = 'C' ORDER BY sch.yr_cde, case when sch.TRM_CDE like '2%' and len(sch.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE <> 'OC' then 'Fall' when sch.TRM_CDE LIKE '2%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Fall 1' when sch.TRM_CDE LIKE '2%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Fall 2' when sch.TRM_CDE like '2%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE and sch.END_DTE = ytt.TRM_END_DTE then 'Fall' when sch.TRM_CDE like '2%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Fall 1' when sch.TRM_CDE like '2%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Fall 2' when sch.TRM_CDE like '3%' and len(sch.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE <> 'OC' then 'Spring' when sch.TRM_CDE LIKE '3%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Spring 1' when sch.TRM_CDE LIKE '3%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Spring 2' when sch.TRM_CDE like '3%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE and sch.END_DTE = ytt.TRM_END_DTE then 'Spring' when sch.TRM_CDE like '3%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Spring 1' when sch.TRM_CDE like '3%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Spring 2' when sch.TRM_CDE like '4%' and len(sch.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE <> 'OC' then 'Summer' when sch.TRM_CDE LIKE '4%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Summer 1' when sch.TRM_CDE LIKE '4%' AND LEN(SCH.TRM_CDE) = 1 AND SECTION_MASTER.DIVISION_CDE = 'OC' and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Summer 2' when sch.TRM_CDE like '4%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE and sch.END_DTE = ytt.TRM_END_DTE then 'Summer' when sch.TRM_CDE like '4%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE = ytt.TRM_BEGIN_DTE then 'Summer 1' when sch.TRM_CDE like '4%' and len(sch.trm_cde) > 1 and sch.BEGIN_DTE <> ytt.TRM_BEGIN_DTE then 'Summer 2' end, section_master.crs_cde ---> System.Data.Odbc.OdbcException: ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Query timeout expired 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()
You are not authorized to use this portlet; It is only available to users in certain roles within the portal.