Known issues in Unica Campaign 12.0

Table 1.
ID	Known issues
306157	Platform Scheduled flowcharts are not executed after upgrade. To overcome this, execute Quartz Job update tool. After Campaign or Unica Platform upgrade installer execution quartzjobtool.sh / bat utility must be executed. This utility requires to be executed to update the Quartz Jobs (existing schedules) in the Unica application. Perform the following steps to execute the utility: Navigate to PLATFORM_HOME/tools/bin Run quartzjobtool.sh /bat. This script execution enables the existing schedules to be compatible with v12.0 Unica applications.
306383	UBX RegisterEndPoint utility execution is failing with ClassNotFoundException. To overcome this, copy below jar files from CAMPAING_HOME/tools/lib directory into CAMPAIGN_HOME/tools/UBXTools/lib directory. byte-buddy-1.9.11.jar classmate-1.3.4.jar hibernate-jpa-2.1-api-1.0.2.jar javax.persistence-api-2.2.jar jboss-logging-3.3.2.Final.jar After this remove ejb3-persistence.jar and hibernate3.jar from CAMPAIGN_HOME\tools\UBXTools\lib.
300159	HTTP Communication error occurs, while saving flowchart if Unica Platform and Campaign applications are using the same JNDI. It is suggested to use separate JNDIs for Platform and Campaign applications.
295574	Deployment of Campaign application in WebSphere application server failed due to `java.lang.NoClassDefFoundError: javax.el.ELManager`. Users are required to add `javax.el-3.0.1-b11.jar` in the WAS server lib directory. They can download `javax.el-3.0.1-b11.jar` from https://mvnrepository.com/artifact/org.glassfish/javax.el/3.0.1-b11.
306075	While installing on MariaDB - `aco_extra_indexes<DB>.sql` execution completed with error while creating duplicate key for index.. This error can be ignored.
306110, 306108	While deploying or starting Campaign application, it throws errors related to module-info.class, and warning related to obsolete hibernate namespace. These can be ignored.
304803	Getting "jcc][t4][10217][10310][4.14.111] Connection read-only mode is not enforceable after the connection has been established." warnings in WebSphere console log. No impact on application side. These can be ignored.
306095	Production documentation links on Campaign installer are broken. See the documentation available along with product installers.
306229	Create flowchart API using REST is failing with error. This will be available in upcoming fix packs. Please get in touch with support for quick fix.
303532	With MariaDB as system database Optimize, Maillist or Calllist process box execution fail with error 10646. You must enable In DB Optimization in flowchart advance settings to resolve this error.
13460	When the Export to File option is unchecked on the Fulfillment tab of the Mail List process, the Summary File option is enabled but should not be.
175825	When `defaultBehaviorWhenOutputToFile` is set to `Create New File`, it works only when you select a new output (export) file for the first time. If you try to change the existing output file and select a new output file, then the option `Append to Existing Data` gets selected by default. It can be changed manually to `Create New File`.
APAR 198495, PO05293, 198494	For a custom macro, if a user account has assigned as Not Granted permission for a stored object (Custom Macros, Flowchart Templates, Stored Derived Fields, etc.), the custom macro can be used to edit, delete, add, move all stored objects regardless of permissions.
204347	LARGE_DATA: Browser Crash - Mail List process box with 700 segments - Save with 512 offers to each segment.
211253	File-based input with multiple columns containing date in different format does not read the date correctly.
212890	Boolean type column on Amazon Redshift is recognized as 'Test' field type in table mapping.
220474	When the column name of the source table contains Non-ASCII characters and is long (probably longer than 10 x 3bytes characters in UTF8), the Snapshot process does not run because the temp table is not created.
220705	Profiling count for Dimension table fields is incorrect and profiling percentage is displayed as 100% even if profiling is in progress.
APAR 222047, PO06172, 222049	Unica Campaign extract process does not write to DB2 database when flowchart is configured with two extract processes and the second extract process contains a derived field that uses French accented characters in the name of the derived field.
APAR 225568, PO06304, 225572	`temptablepostexecutionsql` is not run when selecting coremetrics segment.
230340	Inconsistent behavior for the Mail list process is observed when the data filter is assigned to Effective date on the Parameters tab in a new Mail list process when compared to an edited existing Mail list process. The Mail list process does not output a datetime derived field in the output log file. Changing the effective date parameter values might cause execution failure of the Mail list.
230606	In a flowchart where fields are extracted and used in a Mail list process, the fields under Extract Node on the Personalization tab of the Mail list process are different before and after running the process.
231859	While using the Chrome browser, it takes around 20 seconds to respond while loading the Personalization tab of the Mail list process if it contains large number of treatments and offers assigned. For example, a Mail list process with 250 cells, each cells with multiple offers, each offer having multiple attributes.
232502	A Mail list performance issue occurs when the user changes the input in any way and there is a delay when initially switching tabs. After the user changes the input and switches to the Treatment or Process tab for the first time, there is a delay of around 10-15 seconds depending on the number of inputs selected. After this initial delay, there is no delay until the input is changed.
232835	The Campaign application performance is affected and sometimes an exception error message is displayed on the Campaign pages when the application is used for a longer time (some days) with continuous usage. You must restart your Campaign web application and Campaign Listeners
238789	While using the Chrome browser, when a user opens a Mail list with 600 cells having multiple offers assigned to each cell, the application stops responding. While using the Internet Explorer 11 browser, nothing is displayed in the Mail list process box.
239142	When the Audience process fails because of an incorrect Count filter expression, and the user removes the filter expression, adds a Condition, and runs the Audience process again, the process fails. The Condition is not considered and instead the previous Count filter expression is used resulting in the failure. To run the Audience process successfully, you must re-open the Audience process configuration window, click the Condition, Save and Close. The Audience process now considers the Condition and runs successfully.
APAR 243895, PO06966, 243897	A space character is converted to `''` while profiling.
PMR 223848, 245664	Irrelevant flowcharts turned up in a Campaign when different users access different flowcharts at the same time, the wrong flowchart seems to be displayed.
248007	Hive Performance: PRE -Single Insert statements executed for loading data in temp tables (extract) when used with Hive takes 19 minutes for 2000 records.
PMR 269280, 269765	Truncate does not function for the DB2 database. The `DeleteAsTruncate` property specifies whether, when an output process is configured to `REPLACE TABLE`, Campaign uses `TRUNCATE TABLE` or deletes from the table. When the value is `TRUE`, Campaign runs a `TRUNCATE TABLE` from the table. When the value is `FALSE`, Campaign runs a `DELETE FROM` from the table. The default value depends on the database type, with a large number of clients moving from Oracle to DB2 the difference in performance is extremely noticeable. The comparison in performance in Snapshots and Mail lists for customers leaving Oracle to DB2 is drastic.
269785	For the Chrome and Safari browsers, when the locale is set as Japanese, the labels overlap the buttons in the Save template window.
270528	Use and Profile buttons remains enabled for the Select process when the user selects some table fields and then applies the search filter in the Select process such that it does not return any matching table.
270814	Users cannot select values from the On a trigger drop down by using the mouse on the Scheduler page.
271642	A `"Please wait....."` message is displayed multiple times in console mode installation while upgrading from version 10.1 and also for new Installation
271676	The Extract table on the DB2 and Oracle databases is not deleted when In-DB optimization is unchecked.
272253	The Campaign application performance is affected when a user opens the Table mapping window and more than 500 tables are mapped.
2968	Hot keys are not implemented on most of the windows. In the Dojo implementation it is not possible to use keyboard shortcuts to activate certain functions. Instead the user must click buttons.
PMR 266519, 75262	Clicking Return to previous page distorts the user interface in some cases. Use the links within the products to navigate, rather than the browser controls.
N/A	When Unica Campaign is deployed in an application server cluster environment with 80 port, the Campaign navigation URL should not contain this port number. For example: `http://<host>.<domain>:80/Campaign should be changed to http://<host>.<domain>/Campaign`. Change the value of the `serverURL` property under Campaign\|navigation on the Settings > Configuration page.
N/A	Mail List process box gets unconfigured with error `"31606: History table are changed"` on Flowchart run. There is no issue if the history tables are mapped prior to building a flowchart and adding a Mail List process. If you do not follow step 1, you can still map the history tables after the error appears. If you edit the flowchart and configure the process box, the process will run.
N/A	After migrating non-ASCII data to Campaign, in some cases you cannot open Campaign flowcharts on the target system. Session flowcharts open successfully. To work around this issue, remigrate the campaigns in overwrite mode. You can then open the flowcharts.
TT 062333	Information related to associated products does not appear in offer on Marketing Operations. When an offer created in Campaign with products associated with it is imported in Marketing Operations, information about the associated products is not available in Marketing Operations.
270655	Table Mapping : Table name containing @ is supported while mapping a table, special characters like @ are should not be supported in Table names. Since Table name containing @ is supported since some time, this functioning is not updated now.
283637	When user has one maillist PB configured in the flowchart and he adds another maillist PB in the same flowchart, it is observed that All the values from already configured in treatment tab, Parameters tab, Personalisation tab of new Maillist PB appear automatically in any new dragged maillist PB.
281389	While running Campaign in the Upgrade mode, the installer should read the installation properties files from the previous version response files as we had that response available at the install location from the previous installation. However, it does not read the installation properties files from the earlier version response files.
280623	In Sample PB if we specify '3' in "# of Samples/Output Cells" field and Configure [sample1] with 3 samples having sample sizes as 50%, 50% and "All remaining records" respectively based on "Random Sample method" then after running Flowchart if we reopen the Sample PB "Process run results will be lost. Continue?" message is displayed in sample PB when remaining All check boxed is check.
283101	CHROME: "Unable to notify roles/permission changes to Campaign, eMessage OD may be out of sync". On clicking save changes for the Security Policy displays the following pop-up, this happens just first time after user logs in and changes anything in the policy and clicks save changes. Also, this is reproducible just on CHROME. Tested on Chrome V64 and V65.
282844	Campaign Offer doesn’t sort on 'Channel' & 'Eff./Exp.Dates'. After clicking on every column the offers below it should be sorted in ascending order. If you click on the same column the second time, the offers beneath it should be sorted in the descending order.
283695	Segment process box execution failed with extract enabled to User database for the IMPALA user DB. This error does not reproduce when extracting to Unica Campaign server.
284436	Platform.war and campaign.war in ear file deployment will not work in Weblogic 12.2.1, work around is to deploy campaign.war and unica.war separately
288228	If the date field uploaded to IMC side is not in mm/dd/yyyy format, the email process box fails to execute. This data format is required by IMC Importlist API. It works accurately if DELIM_M_D_YYYY(mm/dd/yyyy) format is used for date while uploading to IMC using importlist API.
289135	TOMCAT : Occasionally Unica Platform or Campaign does not gets started after deploying in tomcat application server. Workaround : delete Campaign and Platform directory available inside Tomcat webapps directory and delete the content of work directory from the path where Tomcat is installed.
304945	Refresh command does not refresh the master listener priority or weight, if you need to make changes in priority or weight you require to take a downtime and restart the application.

306157

Platform Scheduled flowcharts are not executed after upgrade. To overcome this, execute Quartz Job update tool. After Campaign or Unica Platform upgrade installer execution quartzjobtool.sh / bat utility must be executed. This utility requires to be executed to update the Quartz Jobs (existing schedules) in the Unica application. Perform the following steps to execute the utility:

Navigate to PLATFORM_HOME/tools/bin
Run quartzjobtool.sh /bat. This script execution enables the existing schedules to be compatible with v12.0 Unica applications.

306383

UBX RegisterEndPoint utility execution is failing with ClassNotFoundException. To overcome this, copy below jar files from CAMPAING_HOME/tools/lib directory into CAMPAIGN_HOME/tools/UBXTools/lib directory.

byte-buddy-1.9.11.jar
classmate-1.3.4.jar
hibernate-jpa-2.1-api-1.0.2.jar
javax.persistence-api-2.2.jar
jboss-logging-3.3.2.Final.jar
After this remove ejb3-persistence.jar and hibernate3.jar from CAMPAIGN_HOME\tools\UBXTools\lib.

300159

HTTP Communication error occurs, while saving flowchart if Unica Platform and Campaign applications are using the same JNDI.

It is suggested to use separate JNDIs for Platform and Campaign applications.

295574

Deployment of Campaign application in WebSphere application server failed due to

java.lang.NoClassDefFoundError:
                                javax.el.ELManager

. Users are required to add javax.el-3.0.1-b11.jar in the WAS server lib directory. They can download javax.el-3.0.1-b11.jar from https://mvnrepository.com/artifact/org.glassfish/javax.el/3.0.1-b11.

306075

While installing on MariaDB - aco_extra_indexes<DB>.sql execution completed with error while creating duplicate key for index.. This error can be ignored.

306110, 306108

While deploying or starting Campaign application, it throws errors related to module-info.class, and warning related to obsolete hibernate namespace. These can be ignored.

304803

Getting "jcc][t4][10217][10310][4.14.111] Connection read-only mode is not enforceable after the connection has been established." warnings in WebSphere console log. No impact on application side. These can be ignored.

306095

Production documentation links on Campaign installer are broken. See the documentation available along with product installers.

306229

Create flowchart API using REST is failing with error. This will be available in upcoming fix packs. Please get in touch with support for quick fix.

303532

With MariaDB as system database Optimize, Maillist or Calllist process box execution fail with error 10646. You must enable In DB Optimization in flowchart advance settings to resolve this error.

13460

When the Export to File option is unchecked on the Fulfillment tab of the Mail List process, the Summary File option is enabled but should not be.

175825

When defaultBehaviorWhenOutputToFile is set to Create New File, it works only when you select a new output (export) file for the first time. If you try to change the existing output file and select a new output file, then the option Append to Existing Data gets selected by default.

It can be changed manually to Create New File.

APAR 198495, PO05293, 198494

For a custom macro, if a user account has assigned as Not Granted permission for a stored object (Custom Macros, Flowchart Templates, Stored Derived Fields, etc.), the custom macro can be used to edit, delete, add, move all stored objects regardless of permissions.

204347

LARGE_DATA: Browser Crash - Mail List process box with 700 segments - Save with 512 offers to each segment.

211253

File-based input with multiple columns containing date in different format does not read the date correctly.

212890

Boolean type column on Amazon Redshift is recognized as 'Test' field type in table mapping.

220474

When the column name of the source table contains Non-ASCII characters and is long (probably longer than 10 x 3bytes characters in UTF8), the Snapshot process does not run because the temp table is not created.

220705

Profiling count for Dimension table fields is incorrect and profiling percentage is displayed as 100% even if profiling is in progress.

APAR 222047, PO06172, 222049

Unica Campaign extract process does not write to DB2 database when flowchart is configured with two extract processes and the second extract process contains a derived field that uses French accented characters in the name of the derived field.

APAR 225568, PO06304, 225572

temptablepostexecutionsql is not run when selecting coremetrics segment.

230340

Inconsistent behavior for the Mail list process is observed when the data filter is assigned to Effective date on the Parameters tab in a new Mail list process when compared to an edited existing Mail list process. The Mail list process does not output a datetime derived field in the output log file. Changing the effective date parameter values might cause execution failure of the Mail list.

230606

In a flowchart where fields are extracted and used in a Mail list process, the fields under Extract Node on the Personalization tab of the Mail list process are different before and after running the process.

231859

While using the Chrome browser, it takes around 20 seconds to respond while loading the Personalization tab of the Mail list process if it contains large number of treatments and offers assigned. For example, a Mail list process with 250 cells, each cells with multiple offers, each offer having multiple attributes.

232502

A Mail list performance issue occurs when the user changes the input in any way and there is a delay when initially switching tabs. After the user changes the input and switches to the Treatment or Process tab for the first time, there is a delay of around 10-15 seconds depending on the number of inputs selected. After this initial delay, there is no delay until the input is changed.

232835

The Campaign application performance is affected and sometimes an exception error message is displayed on the Campaign pages when the application is used for a longer time (some days) with continuous usage. You must restart your Campaign web application and Campaign Listeners

238789

While using the Chrome browser, when a user opens a Mail list with 600 cells having multiple offers assigned to each cell, the application stops responding. While using the Internet Explorer 11 browser, nothing is displayed in the Mail list process box.

239142

When the Audience process fails because of an incorrect Count filter expression, and the user removes the filter expression, adds a Condition, and runs the Audience process again, the process fails. The Condition is not considered and instead the previous Count filter expression is used resulting in the failure. To run the Audience process successfully, you must re-open the Audience process configuration window, click the Condition, Save and Close. The Audience process now considers the Condition and runs successfully.

APAR 243895, PO06966, 243897

A space character is converted to '' while profiling.

PMR 223848, 245664

Irrelevant flowcharts turned up in a Campaign when different users access different flowcharts at the same time, the wrong flowchart seems to be displayed.

248007

Hive Performance: PRE -Single Insert statements executed for loading data in temp tables (extract) when used with Hive takes 19 minutes for 2000 records.

PMR 269280, 269765

Truncate does not function for the DB2 database. The DeleteAsTruncate property specifies whether, when an output process is configured to REPLACE TABLE, Campaign uses TRUNCATE TABLE or deletes from the table. When the value is TRUE, Campaign runs a TRUNCATE TABLE from the table. When the value is FALSE, Campaign runs a DELETE FROM from the table. The default value depends on the database type, with a large number of clients moving from Oracle to DB2 the difference in performance is extremely noticeable. The comparison in performance in Snapshots and Mail lists for customers leaving Oracle to DB2 is drastic.

269785

For the Chrome and Safari browsers, when the locale is set as Japanese, the labels overlap the buttons in the Save template window.

270528

Use and Profile buttons remains enabled for the Select process when the user selects some table fields and then applies the search filter in the Select process such that it does not return any matching table.

270814

Users cannot select values from the On a trigger drop down by using the mouse on the Scheduler page.

271642

A "Please wait....." message is displayed multiple times in console mode installation while upgrading from version 10.1 and also for new Installation

271676

The Extract table on the DB2 and Oracle databases is not deleted when In-DB optimization is unchecked.

272253

The Campaign application performance is affected when a user opens the Table mapping window and more than 500 tables are mapped.

2968

Hot keys are not implemented on most of the windows. In the Dojo implementation it is not possible to use keyboard shortcuts to activate certain functions. Instead the user must click buttons.

PMR 266519, 75262

Clicking Return to previous page distorts the user interface in some cases. Use the links within the products to navigate, rather than the browser controls.

N/A

When Unica Campaign is deployed in an application server cluster environment with 80 port, the Campaign navigation URL should not contain this port number. For example:

http://<host>.<domain>:80/Campaign should be changed to
http://<host>.<domain>/Campaign

. Change the value of the serverURL property under Campaign|navigation on the Settings > Configuration page.

N/A

Mail List process box gets unconfigured with error "31606: History table are changed" on Flowchart run.

There is no issue if the history tables are mapped prior to building a flowchart and adding a Mail List process.
If you do not follow step 1, you can still map the history tables after the error appears. If you edit the flowchart and configure the process box, the process will run.

N/A

After migrating non-ASCII data to Campaign, in some cases you cannot open Campaign flowcharts on the target system. Session flowcharts open successfully. To work around this issue, remigrate the campaigns in overwrite mode. You can then open the flowcharts.

TT 062333

Information related to associated products does not appear in offer on Marketing Operations. When an offer created in Campaign with products associated with it is imported in Marketing Operations, information about the associated products is not available in Marketing Operations.

270655

Table Mapping : Table name containing @ is supported while mapping a table, special characters like @ are should not be supported in Table names. Since Table name containing @ is supported since some time, this functioning is not updated now.

283637

When user has one maillist PB configured in the flowchart and he adds another maillist PB in the same flowchart, it is observed that All the values from already configured in treatment tab, Parameters tab, Personalisation tab of new Maillist PB appear automatically in any new dragged maillist PB.

281389

While running Campaign in the Upgrade mode, the installer should read the installation properties files from the previous version response files as we had that response available at the install location from the previous installation. However, it does not read the installation properties files from the earlier version response files.

280623

In Sample PB if we specify '3' in "# of Samples/Output Cells" field and Configure [sample1] with 3 samples having sample sizes as 50%, 50% and "All remaining records" respectively based on "Random Sample method" then after running Flowchart if we reopen the Sample PB "Process run results will be lost. Continue?" message is displayed in sample PB when remaining All check boxed is check.

283101

CHROME: "Unable to notify roles/permission changes to Campaign, eMessage OD may be out of sync". On clicking save changes for the Security Policy displays the following pop-up, this happens just first time after user logs in and changes anything in the policy and clicks save changes. Also, this is reproducible just on CHROME. Tested on Chrome V64 and V65.

282844

Campaign Offer doesn’t sort on 'Channel' & 'Eff./Exp.Dates'. After clicking on every column the offers below it should be sorted in ascending order. If you click on the same column the second time, the offers beneath it should be sorted in the descending order.

283695

Segment process box execution failed with extract enabled to User database for the IMPALA user DB. This error does not reproduce when extracting to Unica Campaign server.

284436

Platform.war and campaign.war in ear file deployment will not work in Weblogic 12.2.1, work around is to deploy campaign.war and unica.war separately

288228

If the date field uploaded to IMC side is not in mm/dd/yyyy format, the email process box fails to execute. This data format is required by IMC Importlist API. It works accurately if DELIM_M_D_YYYY(mm/dd/yyyy) format is used for date while uploading to IMC using importlist API.

289135

TOMCAT : Occasionally Unica Platform or Campaign does not gets started after deploying in tomcat application server. Workaround : delete Campaign and Platform directory available inside Tomcat webapps directory and delete the content of work directory from the path where Tomcat is installed.

304945

Refresh command does not refresh the master listener priority or weight, if you need to make changes in priority or weight you require to take a downtime and restart the application.