search

minhtu307 / alfresco-business-reporting

Automatically exported from code.google.com/p/alfresco-business-reporting
0 stars 0 forks source link

Unknown column 'reportingloginaudit.reportinglogin_login_error_user' in 'field list' #14

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Hi,

'Execute reporting' failed if none of your users fail to login.

Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
'reportingloginaudit.reportinglogin_login_error_user' in 'field list'

After failing to login and re-execute 'Fill Reporting Database', reports are 
correctly generated.

Regards.

Original issue reported on code.google.com by Bertrand...@gmail.com on 16 Apr 2013 at 10:41

Attachments:

GoogleCodeExporter commented 8 years ago 
Hi Bertrand,

That is correect and documented: "Remind, login-related reports will fail if 
there is no login audit trail available yet!" 
(https://code.google.com/p/alfresco-business-reporting/wiki/Home#Next_steps)

That is related to how the tool works. It doesn't know up front your auditing 
applications, nor the fields it can expect. I can guess every auditing app has 
a notion of logins and failed logins and pre-define these fields in each 
auditing-related table in the reportingdatabase. But I think that is false 
pollution of the system...

If you feel differently... Reopen the ticket and let e know!

Original comment by tjarda.p...@incentro.com on 16 Apr 2013 at 2:01