Forums

Home » Liferay Social Office

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
evans notcker
Dashboard navigation menu not Available
August 13, 2012 5:53 PM
Answer

evans notcker

Rank: New Member

Posts: 22

Join Date: March 23, 2012

Recent Posts

Hi,

After installation of Social Office 2.0 on liferay-6.1.1-CE-GA2 using marketplace, the Dashboard navigation menu isn't not available on the user private page (see the screenshot)



Thanks
Attachments:
Jonathan Lee
RE: Dashboard navigation menu not Available
August 13, 2012 6:36 PM
Answer

Jonathan Lee

LIFERAY STAFF

Rank: New Member

Posts: 14

Join Date: September 16, 2010

Recent Posts

Hi

I would be happy to help you with your issue, but I will need more information from you before I can troubleshoot for you.

1. Where did you download your portal 6.1 GA2? Was it from liferay.com download page? Or did you build your portal from SVN from the latest revision?
2. What application server are you using?
3. Can you provide the system log when you installed Social Office.
4. Did you change or remove any Roles or Site Templates after Social Office is installed.

I am suspecting the installation of your Social Office is corrupted, and it might be because the revision of your portal is not correct. I discovered this similar bug on the latest portal build on SVN, but it shouldn't be in the release version of CE 6.1. GA2

Please let me know more information and I will look into this.
evans notcker
RE: Dashboard navigation menu not Available
August 14, 2012 1:25 AM
Answer

evans notcker

Rank: New Member

Posts: 22

Join Date: March 23, 2012

Recent Posts

Hi Jonathan,

1. I have downloaded portal 6.1 CE GA2 in the liferay.com web site
2. I'm using the portal 6.1 CE GA2 bundled with tomcat

4. NO i don't change anything for roles and Site Templates

3. I have some errors in the System log (the complete log is in the attach file) :

08:01:01,847 ERROR [pool-2-thread-3][InstanceUtil:78] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:193)
at com.liferay.portal.service.persistence.LayoutPersistenceImpl.updateImpl(LayoutPersistenceImpl.java:579)
at com.liferay.portal.service.persistence.LayoutPersistenceImpl.updateImpl(LayoutPersistenceImpl.java:1)
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:257)
at com.liferay.portal.service.impl.LayoutLocalServiceImpl.addLayout(LayoutLocalServiceImpl.java:268)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
at com.liferay.portal.service.impl.LayoutLocalServiceVirtualLayoutsAdvice.invoke(LayoutLocalServiceVirtualLayoutsAdvice.java:197)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice.invoke(LayoutLocalServiceStagingAdvice.java:107)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.security.pacl.PACLAdvice.invoke(PACLAdvice.java:51)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy27.addLayout(Unknown Source)
at com.liferay.portal.service.LayoutLocalServiceUtil.addLayout(LayoutLocalServiceUtil.java:347)
at com.liferay.so.util.LayoutUtil.addLayout(LayoutUtil.java:65)
at com.liferay.so.util.InstanceUtil.setupLayoutSetPrototypeSite(InstanceUtil.java:266)
at com.liferay.so.util.InstanceUtil.initLayoutSetPrototype(InstanceUtil.java:86)
at com.liferay.so.util.InstanceUtil.initInstance(InstanceUtil.java:73)
at com.liferay.so.hook.upgrade.v2_0_2.UpgradeCompany.doUpgrade(UpgradeCompany.java:37)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
at com.liferay.so.hook.upgrade.UpgradeProcess_2_0_2.doUpgrade(UpgradeProcess_2_0_2.java:37)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
at com.liferay.portal.deploy.hot.HookHotDeployListener.updateRelease(HookHotDeployListener.java:2456)
at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1927)
at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1580)
at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:563)
at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:273)
at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:188)
at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:216)
at com.liferay.portal.deploy.hot.HotDeployImpl.fireDeployEvent(HotDeployImpl.java:96)
at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:27)
at com.liferay.portal.kernel.servlet.PluginContextListener.fireDeployEvent(PluginContextListener.java:151)
at com.liferay.portal.kernel.servlet.PluginContextListener.doPortalInit(PluginContextListener.java:141)
at com.liferay.portal.kernel.util.BasePortalLifecycle.portalInit(BasePortalLifecycle.java:42)
at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:64)
at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:56)
at com.liferay.portal.kernel.util.BasePortalLifecycle.registerPortalLifecycle(BasePortalLifecycle.java:52)
at com.liferay.portal.kernel.servlet.PluginContextListener.contextInitialized(PluginContextListener.java:103)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4779)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5273)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1099)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1621)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:122)
at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:218)
at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:95)
at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:50)
at com.liferay.portal.service.persistence.LayoutPersistenceImpl.updateImpl(LayoutPersistenceImpl.java:574)
... 68 more
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:119)
... 72 more
Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE4\xB8\xBB\xE9\xA1\xB5...' for column 'name' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 78 more
08:01:01,855 INFO [pool-2-thread-3][UpgradeProcess:207] Upgrading com.liferay.so.hook.upgrade.v2_0_2.UpgradeUser
08:01:01,862 INFO [pool-2-thread-3][UpgradeProcess:207] Upgrading com.liferay.so.hook.upgrade.v2_0_2.UpgradeGroup
08:01:01,954 ERROR [pool-2-thread-3][InstanceUtil:78] com.liferay.portal.DuplicateRoleException
com.liferay.portal.DuplicateRoleException
at com.liferay.portal.service.impl.RoleLocalServiceImpl.validate(RoleLocalServiceImpl.java:1304)
at com.liferay.portal.service.impl.RoleLocalServiceImpl.addRole(RoleLocalServiceImpl.java:142)
at com.liferay.portal.service.impl.RoleLocalServiceImpl.addRole(RoleLocalServiceImpl.java:98)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy87.addRole(Unknown Source)
at com.liferay.portal.service.RoleLocalServiceUtil.addRole(RoleLocalServiceUtil.java:292)
at com.liferay.so.util.InstanceUtil.setupRole(InstanceUtil.java:542)
at com.liferay.so.util.InstanceUtil.initInstance(InstanceUtil.java:69)
at com.liferay.so.hook.events.StartupAction.doRun(StartupAction.java:54)
at com.liferay.so.hook.events.StartupAction.run(StartupAction.java:36)
at com.liferay.portal.kernel.events.InvokerSimpleAction.run(InvokerSimpleAction.java:42)
at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvent(HookHotDeployListener.java:1177)
at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvents(HookHotDeployListener.java:1239)
at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1595)
at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:563)
at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:273)
at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:188)
at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:216)
at com.liferay.portal.deploy.hot.HotDeployImpl.fireDeployEvent(HotDeployImpl.java:96)
at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:27)
at com.liferay.portal.kernel.servlet.PluginContextListener.fireDeployEvent(PluginContextListener.java:151)
at com.liferay.portal.kernel.servlet.PluginContextListener.doPortalInit(PluginContextListener.java:141)
at com.liferay.portal.kernel.util.BasePortalLifecycle.portalInit(BasePortalLifecycle.java:42)
at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:64)
at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:56)
at com.liferay.portal.kernel.util.BasePortalLifecycle.registerPortalLifecycle(BasePortalLifecycle.java:52)
at com.liferay.portal.kernel.servlet.PluginContextListener.contextInitialized(PluginContextListener.java:103)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4779)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5273)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1099)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1621)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)
08:01:03,007 INFO [pool-2-thread-3][HookHotDeployListener:690] Hook for so-hook is available for use
08:01:03,086 INFO [pool-2-thread-3][HotDeployImpl:178] Deploying so-welcome-theme from queue
08:01:03,087 INFO [pool-2-thread-3][PluginPackageUtil:1033] Reading plugin package for so-welcome-theme
Aug 14, 2012 8:01:03 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
08:01:03,295 INFO [pool-2-thread-3][ThemeHotDeployListener:87] Registering themes for so-welcome-theme
08:01:05,122 INFO [pool-2-thread-3][ThemeHotDeployListener:100] 1 theme for so-welcome-theme is available for use
08:01:05,147 INFO [liferay/hot_deploy-1][HotDeployMessageListener:142] Group or layout set prototype already exists for company liferay.com
Attachments: systemlog.rtf (54.1k)
Leonard Osang
RE: Dashboard navigation menu not Available
September 20, 2012 2:50 AM
Answer

Leonard Osang

Rank: New Member

Posts: 2

Join Date: September 18, 2012

Recent Posts

Hi guys,

after installing Liferay 6.1.1 CE GA2 and switching to MYSQL JDBC connection via portal-ext.properties:

1jdbc.default.driverClassName=com.mysql.jdbc.Driver
2jdbc.default.url=jdbc:mysql://localhost:3306/lportal?useUnicode=true&characterEncoding=UTF-8
3&useFastDateParsing=false
4jdbc.default.username=username
5jdbc.default.password=password

I encounter the same issue as Evans.

When I install Social Office via Market Place or manually with a downloaded .lpkg file I get exactly the same exception in catalina.out, but only in MYSQL database mode.
Unfortunately the so-hook doesn't work properly after those exceptions.

In default HSQL mode the hook works for me with no problems.

Is there any solution for that issue?
It seems that some UpgradeProcesses are executed in the hook, i will try to start leaving some of them out (UpgradeProcess_2_0_2). Could that be a solution?

Thanks a lot,
leo
Leonard Osang
RE: Dashboard navigation menu not Available
September 24, 2012 8:49 AM
Answer

Leonard Osang

Rank: New Member

Posts: 2

Join Date: September 18, 2012

Recent Posts

found the problem:

After investigating the strange root cause in the exception stack I looked for problems in the database.
the MYSQL database for liferay needs the character set utf-8:

1CREATE DATABASE dbname CHARACTER SET utf8
Phillip Roe
RE: Dashboard navigation menu not Available
October 16, 2012 2:47 PM
Answer

Phillip Roe

Rank: New Member

Posts: 6

Join Date: July 10, 2012

Recent Posts

Hi Leonard,

I created a new database with UTF8 character set, and reloaded the backed up data.

The problem is still there. I noticed in the logs that there is an error that No role exists for company id Social Office User.

I have been looking how to create the role, but I could not find an application access to create ir as the Dashboard does not display.

Please, can u give me a hint how to solve the issue.

Best Regards,

Phillip
Denis Semenov
RE: Dashboard navigation menu not Available
November 1, 2012 8:59 AM
Answer

Denis Semenov

Rank: New Member

Posts: 2

Join Date: October 23, 2012

Recent Posts

Hi Phillip,

Have you found work around for this problem? I am also missing dashboard on LR 6.1.1 CE after SO was installed.

Regards, Denis
Kamel Azeg
RE: Dashboard navigation menu not Available
May 2, 2013 5:37 AM
Answer

Kamel Azeg

Rank: New Member

Posts: 1

Join Date: March 30, 2011

Recent Posts

Hi all,

Do you found a solution?

Regards,
Kamel.
Phillip Roe
Re: [Liferay Forums][Liferay Social Office] RE: Dashboard navigation menu n
May 2, 2013 9:52 AM
Answer

Phillip Roe

Rank: New Member

Posts: 6

Join Date: July 10, 2012

Recent Posts

Yes, delete the folder of the social installation and then reinstall to the actual life ray version.

Phillip Roe-Smithson
Tel:+56-2-8292-8644
Paradigma
Enviado desde mi iPhone

El 02-05-2013, a las 15:38, "Kamel Azeg from liferay.com" <forums@liferay.com> escribió:

> Hi all,
>
> Do you found a solution?
>
> Regards,
> Kamel.
>
>
> To view the thread, follow the link below:
> http://www.liferay.com/community/forums/-/message_boards/view_message/24264179
> --
> Thanks, Liferay.com Forums