Assessment Manager: Error in exported questionnaire xml files due to regional settings

Products

• Control Compliance Suite Assessment Manager

Issue/Introduction

If CCS Assessment Manager is installed on systems with locale settings such as German where a ‘,’ is used as a ‘Decimal Symbol’ instead of ‘.’, exported questionnaires cannot be reimported.  Another issue unrelated to locale settings causing imports of questionnaires to fail was reported.  If by chance the ‘Notice’ property of a questionnaire is updated and saved before the ‘Description’ property, the values are exported in a transposed manner that cannot be reimported. 

Resolution

Now, CCS Assessment Manager exports all questionnaires using the ‘.’ as the decimal symbol regardless of locale settings.  Also, the ‘Notice’ and ‘Description’ properties are exported in the correct order regardless of which was updated first.

1. Extract the contents of the CCSAM_v11.1_10003_3798633_QF.zip file at a known location.
2. Open a connection to the CCS AM 11.1 RAM_DB database using Microsoft SQL Management Studio
3. Execute the SQL script included in the QF package to update the ‘[RAM].[GetDocumentDetailsList]’ stored procedure in RAM_DB.
4. Backup and replace the following file, with the binary that is provided with the QF, at the mentioned locations:

File Name	Path
Symantec.AM.Business.dll	<CCS AM server install directory>\CCS Assessment Manager Server\webclient\bin <CCS AM server install directory>\CCS Assessment Manager Server\Application Server <CCS AM Windows client install directory>\CCS Assessment Manager Client

5. Start the IIS.
6. Start the CCS Assessment Manager Application service.