UTA - Office of Finance and Administration
Staff Directory Page Faculty Staff Students Visitors Departments Staff Directory Staff Directory Page
UTA Home Office of Finance and Administration

By Department
Complete list of Forms sorted by department
ERROR: invalid entry in resource_item for HEADING and RESOURCE_NAME... RESOURCE_ID=
Document No. [8/27/2009]

DEBUG: DB Query failed in... = Resource_Navigation::links()
$newSqlString: select distinct RESOURCE_ID, resource_resource_map.id_resource_2, resource_resource_map.display_priority as sortPriority, resource_item.heading as sortName from resource_resource_map inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id where resource_resource_map.id_resource_1 in () and resource_resource_map.id_role = 2 and resource_item.id_visibility=10 and resource_item.id_resource_type= 13 and (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_resource_map.DATE_END_EFFECTIVE is null)) and (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_item.DATE_END_EFFECTIVE is null)) order by sortPriority desc, sortName
ORA-00936: missing expression
select distinct RESOURCE_ID,  resource_resource_map.id_resource_2,  resource_resource_map.display_priority as sortPriority,  resource_item.heading as sortName  from resource_resource_map  inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id  where resource_resource_map.id_resource_1 in ()  and resource_resource_map.id_role = 2 and resource_item.id_visibility=10 and resource_item.id_resource_type= 13 and  (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_resource_map.DATE_END_EFFECTIVE is null))  and  (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_item.DATE_END_EFFECTIVE is null))  order by sortPriority desc, sortName
                                                                                                                                                                                                                                                                                                                                       ^