fcorti/alfresco-audit-analysis-reporting — pull request #2 by hutingung (2014-12-09 07:48:30+00:00)
Title: Fix View Table vw_cmis_documents_and_folders_path

-Fix Select Query Statement
VIEW Table vw_cmis_documents_and_folders_path select statement throw error
in mysql.
Error only appear with certain type of data in the view table.
scripts to simulate in simulate_vw_cmis_documents_folders_path

Error in aaar.log

2014/10/09 21:02:21 - Update node references - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : An error occurred executing this job entry :
2014/10/09 21:02:21 - Update node references - Couldn't execute SQL: update ope_audits
set
cmis_objectid = (select cmis_objectid from vw_cmis_documents_and_folders_path where cmis_path = path),
cmis_objecttypeid = (select cmis_objecttypeid from vw_cmis_documents_and_folders_path where cmis_path = path)
2014/10/09 21:02:21 - Update node references -
2014/10/09 21:02:21 - Update node references - Data truncation: Truncated incorrect DOUBLE value: '/'