Ask Questions and Find Answers
Important:
Ask is now read-only. You can review any existing questions and answers, but not add anything new.
But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:
discuss.liferay.com
RE: 6.2 to DXP 7.1 Upgrade- Audience Targeting
Hi,
I am upgrading from 6.2 to DXP 7.1. Took the production dump to the new environment with DXP 7.1 and did the database upgrade. Now after this can somebody help me with the next steps, what i need to do for the Audience Targeting upgrade. In 6.2 i had audience-targeting (v1.1.5).
Thanks
Gopal
I am upgrading from 6.2 to DXP 7.1. Took the production dump to the new environment with DXP 7.1 and did the database upgrade. Now after this can somebody help me with the next steps, what i need to do for the Audience Targeting upgrade. In 6.2 i had audience-targeting (v1.1.5).
Thanks
Gopal
Gopal Prasad Satapathy, modified 6 Years ago.
Junior Member
Posts: 51
Join Date: 3/29/18
Recent Posts
Hello,
Getting following exception during the upgrade process for Audience Targeting.
2019-07-31 10:04:09.090 ERROR [main][com_liferay_portal_upgrade_impl:97] bundle com.liferay.portal.upgrade.impl:2.0.16 (499)[com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands(2221)] : The activate method has thrown an exception
com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.content.targeting.anonymous.users.service_3.0.0 [1032] has invalid content in tables.sql:_create table CT_AU_AnonymousUser (_ uuid_ VARCHAR(75) null,_ anonymousUserId LONG not null primary key,_ companyId LONG,_ userId LONG,_ userName VARCHAR(75) null,_ createDate DATE null,_ modifiedDate DATE null,_ lastIp VARCHAR(75) null,_ typeSettings TEXT null_); [Sanitized]
2019-07-31 10:04:09.098 WARN [main][com_liferay_portal_upgrade_impl:103] bundle com.liferay.portal.upgrade.impl:2.0.16 (499)[com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker(2219)] : Could not get service from ref {com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands}={osgi.command.scope=upgrade, service.id=4219, service.bundleid=499, service.scope=bundle, osgi.command.function=[check,execute,executeAll,list],
component.name=com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands, component.id=2221}
2019-07-31 10:04:09.124 ERROR [main][com_liferay_portal_upgrade_impl:97] bundle com.liferay.portal.upgrade.impl:2.0.16 (499)[com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands(2221)] : The activate method has thrown an exception
com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.content.targeting.anonymous.users.service_3.0.0 [1032] has invalid content in tables.sql:_create table CT_AU_AnonymousUser (_ uuid_ VARCHAR(75) null,_ anonymousUserId LONG not null primary key,_ companyId LONG,_ userId LONG,_ userName VARCHAR(75) null,_ createDate DATE null,_ modifiedDate DATE null,_ lastIp VARCHAR(75) null,_ typeSettings TEXT null_); [Sanitized]
Any pointer towards solution would be of great help
Thanks
Getting following exception during the upgrade process for Audience Targeting.
2019-07-31 10:04:09.090 ERROR [main][com_liferay_portal_upgrade_impl:97] bundle com.liferay.portal.upgrade.impl:2.0.16 (499)[com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands(2221)] : The activate method has thrown an exception
com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.content.targeting.anonymous.users.service_3.0.0 [1032] has invalid content in tables.sql:_create table CT_AU_AnonymousUser (_ uuid_ VARCHAR(75) null,_ anonymousUserId LONG not null primary key,_ companyId LONG,_ userId LONG,_ userName VARCHAR(75) null,_ createDate DATE null,_ modifiedDate DATE null,_ lastIp VARCHAR(75) null,_ typeSettings TEXT null_); [Sanitized]
2019-07-31 10:04:09.098 WARN [main][com_liferay_portal_upgrade_impl:103] bundle com.liferay.portal.upgrade.impl:2.0.16 (499)[com.liferay.portal.upgrade.internal.registry.UpgradeStepRegistratorTracker(2219)] : Could not get service from ref {com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands}={osgi.command.scope=upgrade, service.id=4219, service.bundleid=499, service.scope=bundle, osgi.command.function=[check,execute,executeAll,list],
component.name=com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands, component.id=2221}
2019-07-31 10:04:09.124 ERROR [main][com_liferay_portal_upgrade_impl:97] bundle com.liferay.portal.upgrade.impl:2.0.16 (499)[com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands(2221)] : The activate method has thrown an exception
com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.content.targeting.anonymous.users.service_3.0.0 [1032] has invalid content in tables.sql:_create table CT_AU_AnonymousUser (_ uuid_ VARCHAR(75) null,_ anonymousUserId LONG not null primary key,_ companyId LONG,_ userId LONG,_ userName VARCHAR(75) null,_ createDate DATE null,_ modifiedDate DATE null,_ lastIp VARCHAR(75) null,_ typeSettings TEXT null_); [Sanitized]
Any pointer towards solution would be of great help
Thanks
Hi Gopal,
Could you please provide the steps you're following and the Liferay 6.2 EE and 7.1 DXP versions you're using?
Are you installing the compatible version of Audience Targeting for Liferay 7.1?
Thanks
Could you please provide the steps you're following and the Liferay 6.2 EE and 7.1 DXP versions you're using?
Are you installing the compatible version of Audience Targeting for Liferay 7.1?
Thanks
Gopal Prasad Satapathy, modified 6 Years ago.
Junior Member
Posts: 51
Join Date: 3/29/18
Recent Posts
Hello Eduardo,
Just to update, i re-executed the upgrade process and following are the observations:
1=>The upgrade completed with following error. Complete log attached(output04-08-2019-1.log)
2019-08-04 11:44:08.127 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.content.targeting.anonymous.users.service_3.0.0 [977] has invalid content in tables.sql:_create table CT_AU_AnonymousUser (_ uuid_ VARCHAR(75) null,_ anonymousUserId LONG not null primary key,_ companyId LONG,_ userId LONG,_ userName VARCHAR(75) null,_ createDate DATE null,_ modifiedDate DATE null,_ lastIp VARCHAR(75) null,_ typeSettings TEXT null_); [Sanitized]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'CT_AU_AnonymousUser' already exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
This time we had AT 3.0.0 in the DXP 7.1
2=> While the upgrade was running it took around 14 Hours to complete and noticed that significant time was used for Audience Target related tables(alter/update operations). Mainly for CT_Analytics_AnalyticsEvent & CT_Analytics_AnalyticsReferrer tables which has row count as 54744339 & 105391825 respectively.
Please suggest how to deal with this situation.
Thanks
Gopal
Just to update, i re-executed the upgrade process and following are the observations:
1=>The upgrade completed with following error. Complete log attached(output04-08-2019-1.log)
2019-08-04 11:44:08.127 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.content.targeting.anonymous.users.service_3.0.0 [977] has invalid content in tables.sql:_create table CT_AU_AnonymousUser (_ uuid_ VARCHAR(75) null,_ anonymousUserId LONG not null primary key,_ companyId LONG,_ userId LONG,_ userName VARCHAR(75) null,_ createDate DATE null,_ modifiedDate DATE null,_ lastIp VARCHAR(75) null,_ typeSettings TEXT null_); [Sanitized]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'CT_AU_AnonymousUser' already exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
This time we had AT 3.0.0 in the DXP 7.1
2=> While the upgrade was running it took around 14 Hours to complete and noticed that significant time was used for Audience Target related tables(alter/update operations). Mainly for CT_Analytics_AnalyticsEvent & CT_Analytics_AnalyticsReferrer tables which has row count as 54744339 & 105391825 respectively.
Please suggest how to deal with this situation.
Thanks
Gopal
Gopal Prasad Satapathy, modified 6 Years ago.
Junior Member
Posts: 51
Join Date: 3/29/18
Recent Posts
Gopal Prasad Satapathy, modified 6 Years ago.
Junior Member
Posts: 51
Join Date: 3/29/18
Recent Posts
Hello Eduardo ,
In 6.2, Audience Targeting 1.1.5 is installed
6.2 environment has following -->
Loading product and patch information...
Product information:
* installation type: binary
* build number: 6210
* service pack version:
- available SP version: 18
- installable SP version: 18
* patching-tool version: 22
* time: 2019-04-24 14:01Z
* plugins: Analytics Hook Hook, Catalyst, Ehcache Cluster EE Web, Index Checker Portlet, Kaleo Workflow EE Web, Link Scanner Portlet, Marketplace Portlet, Portal 6.2 Compatibility Hook for Audience Targeting, SAML 2.0 Provider EE Portlet, Simulator Hook Hook, Solr 4 Search Engine EE Web, User Export Import Portlet, athome-layouttpl Layouttpl, XXXXXX-assetpublisher-hook Hook, XXXXXX-javascript-hook Hook, XXXXXX-language-hook Hook, XXXXXX-search-hook Hook,
Currently installed patches: hotfix-26945-6210
Available patches: portal-145-6210, hotfix-26945-6210
Detailed patch list:
[ D] portal-145-6210 :: Currently not installed; Won't be installed: the same issues were fixed in the following patch(es): hotfix-26945-6210 :: Built for LIFERAY
[*I] hotfix-26945-6210 :: Installed; Will be installed. :: XXXXXXXXX-18 :: Built for XXXXXXXX
DXP 7.1 environment has following -->
Loading product and patch information...
Product information:
* installation type: binary
* build number: 7110
* service pack version:
- available SP version: 2
- installable SP version: 2
* patching-tool version: 2.0.11
* time: 2019-07-30 16:25Z
* host: XXXXXX-liferay-36-p8fzl (48 cores)
* plugins: Liferay User Synchronization, XXXXXX4me-dxp-theme
Currently installed patches: dxp-11-7110
Available patches: hotfix-739-7110, dxp-10-7110, dxp-11-7110
Detailed patch list:
[ o] hotfix-739-7110 :: Currently not installed; Won't be installed: Cannot be installed as it's not compatible with dxp-11 :: 4868 :: Built for XXXXXXXXX
[ -] dxp-10-7110 :: Currently not installed; Won't be installed: dxp-11 contains the fixes included in this one :: Built for LIFERAY
[*I] dxp-11-7110 :: Installed; Will be installed. :: Built for LIFERAY
For upgrade following procedure was followed.
1.The 6.2 database and doc/lib dump was imported to another environment with DXP 7.1
2. As per liferay documentation the indexing was disabled and db upgrade was run using the upgrade tool
Initially with only core upgrade upgrade was successful but during startup Audience Target would start upgrading and will through error.Now this time i did the whole upgrade again and ended up with error as shared before.Attaching the complete upgrade log for reference.
Could you please specify at which step i need to install the latest Audience Targeting (i guess latest one is 3.0.0)?
Thanks
Gopal
In 6.2, Audience Targeting 1.1.5 is installed
6.2 environment has following -->
Loading product and patch information...
Product information:
* installation type: binary
* build number: 6210
* service pack version:
- available SP version: 18
- installable SP version: 18
* patching-tool version: 22
* time: 2019-04-24 14:01Z
* plugins: Analytics Hook Hook, Catalyst, Ehcache Cluster EE Web, Index Checker Portlet, Kaleo Workflow EE Web, Link Scanner Portlet, Marketplace Portlet, Portal 6.2 Compatibility Hook for Audience Targeting, SAML 2.0 Provider EE Portlet, Simulator Hook Hook, Solr 4 Search Engine EE Web, User Export Import Portlet, athome-layouttpl Layouttpl, XXXXXX-assetpublisher-hook Hook, XXXXXX-javascript-hook Hook, XXXXXX-language-hook Hook, XXXXXX-search-hook Hook,
Currently installed patches: hotfix-26945-6210
Available patches: portal-145-6210, hotfix-26945-6210
Detailed patch list:
[ D] portal-145-6210 :: Currently not installed; Won't be installed: the same issues were fixed in the following patch(es): hotfix-26945-6210 :: Built for LIFERAY
[*I] hotfix-26945-6210 :: Installed; Will be installed. :: XXXXXXXXX-18 :: Built for XXXXXXXX
DXP 7.1 environment has following -->
Loading product and patch information...
Product information:
* installation type: binary
* build number: 7110
* service pack version:
- available SP version: 2
- installable SP version: 2
* patching-tool version: 2.0.11
* time: 2019-07-30 16:25Z
* host: XXXXXX-liferay-36-p8fzl (48 cores)
* plugins: Liferay User Synchronization, XXXXXX4me-dxp-theme
Currently installed patches: dxp-11-7110
Available patches: hotfix-739-7110, dxp-10-7110, dxp-11-7110
Detailed patch list:
[ o] hotfix-739-7110 :: Currently not installed; Won't be installed: Cannot be installed as it's not compatible with dxp-11 :: 4868 :: Built for XXXXXXXXX
[ -] dxp-10-7110 :: Currently not installed; Won't be installed: dxp-11 contains the fixes included in this one :: Built for LIFERAY
[*I] dxp-11-7110 :: Installed; Will be installed. :: Built for LIFERAY
For upgrade following procedure was followed.
1.The 6.2 database and doc/lib dump was imported to another environment with DXP 7.1
2. As per liferay documentation the indexing was disabled and db upgrade was run using the upgrade tool
Initially with only core upgrade upgrade was successful but during startup Audience Target would start upgrading and will through error.Now this time i did the whole upgrade again and ended up with error as shared before.Attaching the complete upgrade log for reference.
Could you please specify at which step i need to install the latest Audience Targeting (i guess latest one is 3.0.0)?
Thanks
Gopal
Attachments:
As this is all on EE/DXP, I'd suggest to open a ticket with support. Upgrading is supported, and if there are problems, the team might be interested to document it for future upgrades (or be able to point you to such documentation that they might already have written)
Copyright © 2025 Liferay, Inc
• Privacy Policy
Powered by Liferay™