Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
Any help? Clóvis Garcia Marcondes escreveu: > I enabled the Audit but something seems to be going wrong at the end of > the audit trigger. I´d checked at the database and the initial data is > been recorded but ner the end soemthing goes wrong and the asociation > between CommitLog table and SessionLog table is not set (SessionId in > CommitLog remais with 0(zero)). Check the trace below, where the error > is happening: > > 09:21:20: S -> Call pre-loaded 'audit.dll' > 09:21:20: S -> postcommand_proc() > 09:21:20: S -> Update CVSNT_SessionLog set EndTime='2008-11-13 > 12:21:20', FinalReturnCode=0 where Id=0 > 09:21:20: S -> Update CVSNT_SessionLog set EndTime=N'2008-11-13 > 12:21:20', FinalReturnCode=0 where Id=0 > 09:21:20: S -> MSSQL Execute Done > audit_trigger error (session end): > > > I thing the WHERE clause is wrong, because it seems to be trying to > update the Session Id 0 (zero) and it doesn´t exist. Is there something > I missed? > > Clóvis