Release v3.1.9

Summary Description Resolution
FOIA Ext – FOIA Exemption Report Needs to be fixed FOIA Ext – FOIA Exemption Report Needs to be fixed Fixed
FOIA Ext – Sending an email from the system has no title FOIA Ext – Sending an email from the system has no title.

The title should be ‘Request – <Case #>’

Fixed
Even though correspondence templates are enabled in Admin module, can’t be added 1: Login as admin user
2: Navigate to Admin/Correspondence Templates
3: Activate all templates
4: Login with supervisor user
5: Create new case/complaint
6: Click on documents sub link
7: Right click on root folder and select “New Correspondence”.
Expected result: “New correspondence” and sub menu for all active documents is displayed,
Actual result: “New correspondence” is missing as option for selection.
Fixed
When complaint is closed or status of case is changed, automatic generated task for approval is not created 1: Login as user that have permissions to complaints
2: Open some draft complaint
3: Click on “Close” button
4: Insert all required fields for closing complaint and submit
5: Navigate to tasks,
Expected result: Automatic generated task is created,
Actual result: Automatic generated task is not created
Fixed
LDAP SyncFails on Index out of Bounds When running an LDAP sync on JSAP SIPR Pre prod, the sync fails with an index out of bounds error. Presumably this is because of an edge case where the last fetch fills the page size but there are no entries to process. Fixed
Snowbound pages to communicate to ArkCase server, not directly with Snowbound server iframe can still be used if that makes the UI easier, but the iframe URL should be an ArkCase URL. ArkCase would use the httpd proxy module (acm-proxy-http) to forward the requests to Snowbound. Fixed
Security: Authentication ticket doesn’t actually expire after 30 minutes of not being used The authentication token cache is implemented with ehCache, and configured in the file ‘authenticationTokenCacheConfig.xml’ like so:

<cache name=”authentication_token_cache”
maxEntriesLocalHeap=”10000″
eternal=”false”
overflowToDisk=”true”
diskSpoolBufferSizeMB=”20″
timeToIdleSeconds=”3600″
timeToLiveSeconds=”0″
memoryStoreEvictionPolicy=”LFU”
transactionalMode=”off” />

The intention is for the ticket to expire after an hour of idle time (i.e., an hour of not being retrieved from the cache). This doesn’t seem to happen. Ian’s security team was able to use a ticket after a few days.

To test, just set the timeToIdleSeconds very low. After expiration time, if you ask for the same cache key again, it shouldn’t return any value. Let’s consider a max time to live too, of 10 hours or so, so somebody can’t grab a ticket and use it forever in some automated way.

Ideally the fix would involve only fixes to the ehcache configuration, versus writing some kind of custom ticket expiration job.

Fixed
Add Header to Audit Report ArkCase Audit Report… Add Header to Audit Report

ArkCase Audit Report
Date Range

Fixed
Add buttons on all new tasks for Concur/Non-concur Add buttons on all new tasks for Concur/Non-concur Fixed
AFDP-2915 Can’t Delete a Correspondence From a Complaint of Case now Can’t Delete a Correspondence From a Complaint of Case now

Steps:

1. Add a new Correspondence to a complaint or case
2. Now right click and delete it
3. It is removed, then refresh the document management tree
4. The Correspondence is still there

Fixed
AFDP-2915 Takes Way to long to upload a Correspondence on a Complaint and Case now Takes Way to long to upload a Correspondence on a Complaint and Case now and when it finally uploads and you get a confirmation message in the top left corner of the app, the document looks like it is still uploading. So you have to refresh the table. I shouldn’t have to do that. Fixed
AFDP-2915 Few more Small Changes on Admin page – New correspondences default to active
– Fix the modifier to be full name
– We need an Object Column
Fixed
AFDP-2915 Create functionality for supporting Correspondence Template versioning Create functionality for supporting Correspondence Template versioning Fixed
AFDP-2915 Change Generate Correspondence service Change generate correspondence service to map values by field name instead of index. Fixed
FOIA Ext – Queues Received Date is Wrong FOIA Ext – Queues Received Date is Wrong

– The date is one day behind when the request was actually received.

Fixed
Email is not sent with appropriate document attached, please check configuration 1: Login with user that have permissions to open cases/complaitns
2: Open some case/complaint
3: Click on Documents sub link
4: Double click on root folder
5: Right click on some document and click “Email”
6: Insert your email in Recipient field and click “Send Email”
Expected result: email is sent with attached doc,
Actual result: Email is not sent.
Fixed
When document is sent by email, there is not record in audit 1: Login as user that have permissions to open cases/complaints
2: Open some case/complaint
3: Click on “Documents” sublink
4: Double click on root folder
5: Right click on document and click “Email”
6: Insert Your email in “Recipient” and click “Send Email”
7: Open Audit
8: In report name select “Files” , select current dates and click “Generate Audit Report” button,
Expected result: In audit report there is record for email sent.
Actual result: In audit report there is no record for email sent.
Fixed
FOIA Ext – Add the date range at the top of the Exemption Report and Disposition Report FOIA Ext – Add the date range at the top of the Exemption Report and Disposition Report

1. Login to FOIA App
2. Got to Report module
3. Run the 3 reports, see that the FOIA

Fixed
FOIA Ext – Add the days in queue and Group column from Correspondence Management FOIA Ext – Add the days in queue and Group column from Correspondence Management
Need to also change the label from ‘Received’ to ‘Entered Queue’ and remove the time amount and just leave date.

1. Login to FOIA App
2. Got to queue module
3. See the columns in each queue. Need to add the days in queue column and the group column.

Fixed
Complaint/Case Modules – Claim/Unclaim Group assignments not working Complaint/Case Modules – Claim/Unclaim Group assignments not working

Steps:
1. Login into app with Ann
2. Create new Case and only assign a group(ACM_ADMINISTRATOR_DEV)/not an assignee
3. Case is created with group assignment and no assignee, which is correct
4. Click the claim button that is available to Ann – this seems to work
5. Now click the unclaim button – doesn’t always work

Fixed
FOIA Ext – MY TASKS Widget not populating MY TASKS Widget not populating any data on the FOIA Dashboard. Fixed
Add the Application User Picker to any user select in the application Add the Application User Picker to any user select dropdown in the application. Whenever someone clicks on a user dropdown, that should be changed to opening the user picker search. The person searching should only be able to search against the users that fall in the group listed. Fixed
Case file folder creation handler fails on nested folders in MySQL and SQL Server MySQL and SQL Server do not support deferred foreign keys; and our AcmFolder JPA entity only has a simple @Column mapping for the parentFolderId. This @Column mapping means the JPA system isn’t aware that folders have a recursive relationship to each other, so JPA inserts the folders in any old order; if it inserts a child folder before a parent, SQL Server and MySQL will throw an exception. (Oracle and PostgreSQL are OK since they verify the foreign keys only at commit time, versus on every statement).

The true fix is to setup a proper JPA mapping of the parent-folder-child-folder relationship, so JPA knows which folders are parents and which are children. Basically we add a “private AcmFolder parentFolder” field, with a proper JPA ManyToOne annotation; and a “private List<AcmFolder> children” field, with a proper OneToMany annotation; and change the client code to maintain these two new fields correctly.

Fixed
Reset Password Functionality Reset Password Functionality Fixed
Enhance Document Management Enhancement #1: Need to be able to select one/many documents or an entire folder of documents and right click and select ‘Declare’.
This would then declare all those document selected in Alfresco. We would need to show an icon on the document table to show it was declared. Also need to make sure that a declared document can’t be replaced/Delete.
Once a document is declared, it can’t be declared again, which means if a document is already declared on a close action, we will need to account for it.

Enhancement #2: Need to be able to select one/many documents or an entire folder of documents and click a ‘New Task’ button on the document table.
This would then open a normal task window with the document(s) attached to the task.

Fixed
Improving overall code quality Overall code quality has to be improved, using different approaches:

– deciding common code style, applying it to the existing code and enforcing developers to obey that style
– using helper tools, such as [FindBugs|http://findbugs.sourceforge.net/] and [CheckStyle|http://checkstyle.sourceforge.net/], which should be integrated into IDEs developers are using
– using [SonarQube|http://www.sonarqube.org/] as quality metrics center, and investigate the possibilities of integrating SonarQube reports with developer IDEs

Fixed
AFDP-766 Update SOLR transformers to include new fields Update SOLR transformers to include new fields

See attachment that has new fields highlight in blue.

Fixed