1. Home
  2. Portal
  3. RE: Unable to register portal instance

RE: Unable to register portal instance

ibrahim magdy, modified 8 Years ago.
Unable to register portal instance
New Member Posts: 20 Join Date: 7/14/10 Recent Posts
hello every one i am using liferay DXP 7 and SQL server data base i have the below exception and i am not able to figure out what is the problem
Note : the portal works fine even with this exception

08:57:13,979 WARN [ServerService Thread Pool -- 233][PortalInstanceLifecycleListenerManagerImpl:111] Unable to register portal instance {mvccVersion=1, companyId=20116, accountId=20118, webId=liferay.com,
thumbnail
Jorge Díaz, modified 8 Years ago.
RE: Unable to register portal instance
Liferay Master Posts: 753 Join Date: 1/9/14 Recent Posts
That warn trace is written in PortalInstanceLifecycleListenerManagerImpl.java in case of error during PortalInstanceLifecycleListener instances registration:
_log.warn("Unable to register portal instance " + company, e);

In that line, you can see exception is also written to log. Please post the full stacktrace.

Perhaps portal is working fine, but there is a unregistered PortalInstanceLifecycleListener that will cause trouble in one module
ibrahim magdy, modified 8 Years ago.
RE: Unable to register portal instance
New Member Posts: 20 Join Date: 7/14/10 Recent Posts
thanks for your reply the stack trace is attached

Attachments:

thumbnail
Jorge Díaz, modified 8 Years ago.
RE: Unable to register portal instance
Liferay Master Posts: 753 Join Date: 1/9/14 Recent Posts
Your exception is a known issue of Liferay DXP: LPS-59510 - java.sql.BatchUpdateException: Data truncation on startup of Liferay on SQL Server 2012 and SQL Server 2008r2.

The root cause of the issue is in SQL Server database schema that sometimes causes a data truncation.

The LPS is private so you will not be able to see it.
You can ask for a solution to Liferay support or you can change to other database, error seems to be reproduced only in SQL Server.
ibrahim magdy, modified 8 Years ago.
RE: Unable to register portal instance
New Member Posts: 20 Join Date: 7/14/10 Recent Posts
thank you for clarification
thumbnail
Ravi Kumar Gupta, modified 6 Years ago.
RE: Unable to register portal instance
Liferay Legend Posts: 1302 Join Date: 6/24/09 Recent Posts

This is still the case with MySQL 5.6.

 

2019-01-23 06:44:24.204 WARN  [main][PortalInstanceLifecycleListenerManagerImpl:140] Unable to register portal instance {mvccVersion=1, companyId=20099, accountId=20101, webId= .... 

thumbnail
Arun Das, modified 6 Years ago.
RE: Unable to register portal instance
Regular Member Posts: 166 Join Date: 7/23/12 Recent Posts

Hi,

DXP 7.1 is certified for MySQL 5.7, not sure on 5.6 . Since its DXP, you can open a ticket with Liferay.

 

Arun