David,
Rob Coutts has an excellent document on upgradingto 9.7.x that discusses both Audit migration and the import of the new LiveReports. It can be found at the Champion Toolkit:
https://knowledge.opentext.com/knowledge/llisapi.dll/open/6970472
The way I usually handle it is to create afolder on the Enterprise Work Space called Old LiveReports. I then go tothe LiveReports Volume from the Admin pages and Move all existing LiveReportsto the Old LiveReports folder I just created. I do all of this whilelogged on as the Admin user. Finally I do an Import LiveReports. Thenew LiveReports are found under the following directory:
Drive:\<Opentext_Home>\module\report_2_2_0\html\
For Oracle, the import file is named OracleExport.txt – for MSSQL it is MssqlExport.txt – the reports shouldimport very quickly.
The reason I move the old reports isbecause clients often have custom reports they have created and then storedunder the LiveReports Volume. Moving them to a known location allows themto test them and then move them back if they still work (or after they havebeen edited to work with the new schema).
To get complete Audit reports, you willhave to run the Audit Migration. This is also done via the Admin pages. Otherwise your old (pre-9.5) audit records will reside in the dAudit table andyour new ones will reside in the dAuditNew and dAuditMore tables. Gettingall the data becomes that much harder. The Audit Migration moves the oldinto the new but does not purge the old so once the migration is complete, youmay want to purge the old audit records to save on DB space.
--
Greg Kellogg
(361) 815-8950
From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, January 16, 20096:31 AMTo: eLink RecipientSubject: RE Recently vieweddocuments
RE Recently viewed documents
Posted by ldavies (Davies, Lindsay) on 2009/01/16 07:30
In reply to: Recently viewed documents
Posted by openunivuser2 (Turpie, David) on 2009/01/16 06:56
Message from Lindsay Davies <ldavies@opentext.com> via eLink
When you upgraded, (actually to 9.5 or above from a pre 9.5 version) the DAudit table is replaced by the DAauditNew table.
There would be a manual step in the documentation to tell you how to move DAudit records to DAuditNew.
But in your case another step will be to load up the new Livereports. I cannot recall how this is recommended in the upgrade documentation, but the release notes state "LiveReports are not automatically updated when the Livelink database is upgraded."
It goes on to say...
With the addition of a number of new database tables and similar depreciation of other tables when upgrading from a pre-9.5 database, some existing LiveReports may cease to function or alternatively return incorrect results. Any pre-9.5 LiveReports that referenced the DAUDIT table will need to be updated to reference DAUDITNEW and perhaps the DAUDITMORE table. In some cases, where table VIEWS were previously established for the DAUDIT table, new views will need to be created. For more information, see "Application Note - Updating Live Reports following a Version Upgrade" on the Open Text Knowledge Center: https://knowledge.opentext.com/knowledge/llisapi.dll/properties/6849440 (LPAD-14769)
However, this is the SQL from a clean 971 install...
select %4, DAuditNew.*, DVersData.MimeType from DTree, DAuditNew, DVersData where (DTree.DataID=DAuditNew.DataID) and (DTree.DataID = DVersData.DocID ) and (DAuditNew.PerformerID=%1) and (DAuditNew.AuditDate>%2) and ( (DAuditNew.AuditStr='Fetch') OR (DAuditNew.AuditStr='View') ) and %3 and %5 order by DAuditNew.AuditDate desc
The parameters the same.
Regards
Lindsay
Open Text UK
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 16 January 2009 12:00To: eLink RecipientSubject: Recently viewed documents
Recently viewed documents
We have recently upgrade to Livleink 9.7.1 and one of my users has relised that on of the standard reports "recently viewed documents" is reporting nothing except they know they have viewed docucments recently in the past week and days. We are running SQL Below is the report as it is in livelink and I just wondered if anyone else had come across this and had a fix? select %4, DAudit.*, DVersData.MimeType from DTree, DAudit, DVersData where (DTree.DataID=DAudit.DataID) and (DTree.DataID = DVersData.DocID ) and (DAudit.UserID=%1) and (DAudit.AuditDate>%2) and ( (DAudit.Event='FETCH') OR (DAudit.Event='VIEW') ) and %3 and %5 order by DAudit.AuditDate desc Parameters are also being set Param %1 - UserID Param %2 - This Week-Start Param %3 - Filter permissions Param %4 - Report fields Param %5 - Filter Document Display columns are Field - AuditDate; Column Title - Audit Date FIeld - Event; Column Title - Event Thanks David
