Task LRs gives no results

Owen_Jackson_(afftc2admin_-_(deleted))

For some reason none of the LiveReports related to tasks is coming up with results. There are a number of tasks in various stages throughout the enterprise. The same result occurs regardless of account (even Admin). I can see no errors in any logging. I've run database verifications with no errors and everything seems to be working fine and all permissions seem to be in order.Has anyone ran across this before?(LL Ver 9.5.1 running on Win2K3 server with Oracle 10g backend)

Janusz_Frydecki

The fact is they changed the DB schema without really informing people and with no automatic modification to LiveReports. A new table has been added called assignees which replaces the assignedTo column of dtree.Take a look here for a list of modified queries:https://knowledge.opentext.com/knowledge/llisapi.dll/Application_Note_-_Updating_Live_Reports_following_a_Version_Upgrade_(download_attachment_zip_file).pdf?func=doc.fetch&amp;nodeId=6849440&amp;vernum=1This is a manual job so good luck ;)For more documentation, you could also search for:updating live reportson the KCHere is a sampled modified query:select DTree.*, KUAF.Name "kuafname" from DTree, KUAF, Assignees where (DTree.DateDue>%1) and (DTree.DateDue<%2) AND (Dtree.DataID = Assignees.DataID) and (KUAF.ID=Assignees.AssignedTo) and %3 order by DTree.DateDueLouis