Fixed defects in Unica Campaign and Optimize 12.0

The following defects were fixed in Unica Campaign 12.0.

Issue key Summary
HMA-275481

Flowchart failed to run when when a "=" character is contained within the name of a flowchart.

HMA-302471 Customers were unable to use the "size" and "modified" sort tabs in the mail list process box when pasting any template. Once the tabs are clicked, the arrows on the tabs remain grayed out and are unable to sort
HMA-277141

If SSL was enabled post installation, then campaign web services URL was not accessible.

HMA-294598 In Optimize, incorrect column name appears on UI with Google Chrome for Optimize session > Score matrix
HMA-302416 Segment List UI distorted on accessing Displayed Segments >> Search Tab >> Tree View.
HMA-286185 Security Vulnerability: Sensitive information like username was exposed in the URL.
HMA-302476 Folders were arranged in the descending order by default under campaign-> campaigns folder .
HMA-302405 After changing the value of "progressFetchDelay" under Affinium|Campaign|partitions|partition1|Optimize|sessionRunMonitor from default value of 250 ms to a value like 2500 ms, incorrect run status of Optimize session was observed.
HMA-285636 A flat file with blank records in it did not throw error for an Extract process box.
HMA-293723 Users were not allowed to create offers when Campaign web app is installed separately than Campaign listener component.
HMA-291171 Load balance was unequal in spite of equal LoadBalanceWeight set for each listener nodes in a listener clustered environment.
HMA-290905 When fields were mapped to a mapped table in Snapshot process box, not all fields were displaying in the Snapshot process box.
HMA-284088 Additional double quotes around user variables that have space(s) in between the string caused triggers to not parse the string correctly.
HMA-292995 After upgrading to version 11.1, when System Database was SQL server, UBX data was not inserted into UA_EMAIL* tables.
HMA-283430 Optimize session failed in actual, but Platform scheduler showed run state as "successful".
APAR PO07157, DEF 266689 A linked campaign in Plan allowed the unsupported characters Backslash (\) and double quotes (") in its name.
APAR PO07143, DEF 266014 The Campaign permissions did not work as per design for flowchart objects when the permission is state is 'Not Granted'.
HMA-302421 BM Campaign extract process did not write to DB2 database when flowchart was configured with two extract processes and the second extract process contained a derived field that uses French accented characters in the name of the derived field.
HMA-289540 Segments displayed in a confusing manner if same segment was used in multiple flowcharts.
HMA-267944 Redundant queries displayed on opening the flowchart.
HMA-288804 unica_acsvr ghost process ran uselessly.
HMA-244840 When Campaign ran a query of "INSERT INTO... SELECT FROM ..." and joined base table, temporary table and extract table, the 'SuffixOnInsertSQL' value was inserted twice which was breaking the query and generating an error.
HMA-304483 Unable to edit 'Over the time period' column of FEC rule
HMA-280262 Session file size was increasing while saving the flowchart.
HMA-284692 While creating campaign, giving dates greater than 2020 in effective/ expiration date, resulted in bad date.
HMA-293646 The check box 'Do not run subsequent processes for empty cells' apeared as unchecked on reopening of page, even when user had checked the box and saved it.
HMA-185759 For nested Segment processes that used a de-normalized table, the condition whichis used for "Use Query Scope from Input Cell" is not applied for processing records in subsequent process boxes.
HMA-303657 Under a specific scenario, segment crashed when running.
HMA-293082 Multi-threaded UBX download ETL consuming system resources.
HMA-288413 Disable medium strength SSL ciphers supported by Contact Optimization
HMA-288562 Medium strength ciphers/protocols for Unica Campaign and Optimize Listener were disabled.
HMA-286064 Events were not getting downloaded and showed error

"org.hibernate.MappingException: org.hibernate.dialect.

Oracle9iDialect did not support identity key generation" in UBX log.

HMA-302744 Duplicate Interact segments displayed in the segment listing page
HMA-282906 Files created by Campaign (for example; Temp file or snap shot output file) were created in the root group instead of the user group that was specified in an alternate login.
HMA-162581 An error occurred when users tried to read the log files on GUI on a Clustered Campaign env, from the Settings > Camapign Settings > View System Log option
HMA-298393 While scheduling a flowchart with Platform scheduler if the data source credentials were supplied at scheduler page (in case ASMSaveDBAuthentication was set to FALSE for this data source) then the flowchart failed with error.

CODE 11522: Invalid database connection (user was not logged in to DB)

HMA-302463 GDPR : Incorrect Delete table UA_EmailOptOut in script for v10.1.0.3
HMA-302454 The delete, used against the UA_TREATMENT, was not correct when there was more than 1 audience .
HMA-302351 GDPR: Incorrect script in case of composite audience - Integrity constraint violated
HMA-292390 SQL on connect caused failure on Oracle 12.x.
HMA-302871 Crashed with 10404 error, when importing flowchart template with ICGF in French locale
HMA-285576 When user gave "\" in the subject line for Email process, Email Process Box run failed.
HMA-302499 Optimize functionality broke - POST OPT EXTRACT is picking whole list.
HMA-288829 When text type mailing template was used in Email process box then text was missing in the received mail.
HMA-288565 In the Email Box - when user added Ampersand in Subject Line, after re-running the process additional symbols in the email subject line were added.
HMA-288597 In Windows environment user received "failed to receive status" response from listener nodes.
HMA-285653 Version - Hive SQL Generating Issue
APAR PO06266, DEF 224540 When different users accessed different flowcharts at the same time, in some environments, irrelevant flowcharts were displayed in a Campaign.

If this issue does not occur in your environment, set the following parameters in JVM to reverse this fix.

HMA-303656 Changes not replicating in audience process box
HMA-304838 All contact history deleted after disabling log to contact history and rerun of mail list failed with an error.
HMA-302456 Incorrect value displayed on summery pane of Campaign Custom attribute in case of decimal digits.
HMA-302399 An error occurred when maximum number of expressions in a list was 1000 and Campaign had more than 1000 offers associated with it on the Summary Tab.
HMA-294571 An error occurred when the rows were selected in the target cell spreadsheet and were moved up and down.
HMA-292987 Users were unable to connect to the Oracle libraries, when Campaign 11.1.00.listener was installed on AIX the Oracle libora4d.
HMA-267288 Unable to use apostrphe in text string in derived field or user varaiable.
HMA-285603 It took about 45 seconds when tried to open an offer for editing and eventually for saving ('Save Changes'), each time was taking about 45 seconds.
HMA-298004 An error occurred on process parameters tab of any process box.
HMA-298826 Plain text passwords were observed in campaignweb.log, ac_web.log, flowchart log when DEBUG logging was enabled.
HMA-293611 An error occurred while running FastUpgrade scripts in the execution of database upgrade task.
HMA-290905 When fields were mapped to a mapped table in Snapshot process box, not all fields displayed in the Snapshot process box.
HMA-295972 Target Cell Spreadsheets (TCS) page did not render correctly, if cell contained drop down type Custom cell attribute.
HMA-302445 Campaign listener crashed on activeSession.udb.
HMA-301014 Flowchart failed with 701 error with .ses file went missing. Also flowcharts failed with 11116 error.
HMA-302437 Partition1 folder was missing and converted into file causing system unusuable.
HMA-291021 Multi-thread UBX ETL hot fix in 11.0.1 caused out of memory.
HMA-300054 Newly Schedule flowchart on trigger failed platform scheduler utility-Multiple users.
HMA-296400 Save and run process function broke when upstream processe did not run.
HMA-304849 Reflected Cross-Site Scripting || Security vulnerabilities reported by client.
HMA-299050 Cell Code did not not generate automatically for the last cell when using four and more cells in Segment.
HMA-288426 Disabled medium strength SSL ciphers supported by Optimize.
HMA-302467 Clustered listeners allowed same flowchart to be executed at same time on different listeners under certain scenario.
HMA-282757 Users were unable to view logs in the UI for the session flowcharts which were migrated from 8.6.x.
HMA-282629 Could not use year more than "2038" in date field of Platform scheduler.