After running a Re-deploy in Jasper Integration page in OneClick, the LDAP users are no longer able to login on JasperReports.
Users are getting sync from Spectrum after re-deploy even though LDAP is configured in Jasper server.
Spectrum 10.2.1 and JasperReports 6.3
Spectrum 10.2.3 and JasperReports 6.3
This issue has been addressed in the following patches: Spectrum_10.02.01.PTF_10.2.158, and Spectrum_10.02.03.PTF_10.2.324
Please contact CA Spectrum Support for a copy of the required patch.Note:
To get around this anomaly:
On then OneClick SRM server's $SPECROOT/mysql/data/reporting database.
Check the 'devicemodule' table to see if it contains the 'physical_index' column.
If the 'physical_index column is not found, we need to update the schema by running the following query: Delete from schemaversion where name = 2011;
Restarting tomcat after the change is made, will cause the schema version will be updated, and SRM will run.
For further questions or concerns, please contact CA Spectrum Support.