Forums de discussion

Dashboard navigation menu not Available

evans notcker, modifié il y a 11 années.

Dashboard navigation menu not Available

New Member Publications: 22 Date d'inscription: 24/03/12 Publications récentes
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
thumbnail
Jonathan Lee, modifié il y a 11 années.

RE: Dashboard navigation menu not Available

New Member Publications: 14 Date d'inscription: 16/09/10 Publications récentes
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, modifié il y a 11 années.

RE: Dashboard navigation menu not Available

New Member Publications: 22 Date d'inscription: 24/03/12 Publications récentes
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

Pièces jointes:

Leonard Osang, modifié il y a 11 années.

RE: Dashboard navigation menu not Available

New Member Publications: 2 Date d'inscription: 18/09/12 Publications récentes
Hi guys,

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

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost:3306/lportal?useUnicode=true&characterEncoding=UTF-8
&useFastDateParsing=false
jdbc.default.username=username
jdbc.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, modifié il y a 11 années.

RE: Dashboard navigation menu not Available

New Member Publications: 2 Date d'inscription: 18/09/12 Publications récentes
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:

CREATE DATABASE dbname CHARACTER SET utf8
Phillip Roe, modifié il y a 11 années.

RE: Dashboard navigation menu not Available

New Member Publications: 6 Date d'inscription: 10/07/12 Publications récentes
HI there,

I upgraded from 6.1.0 CE to this version 6.1.1 and I have the same problem of the missing Dashboard.

Are you suggesting to create a new database in MySQL again and move the original data to this new database?
The problem is to access the dash board to do the backup tasks. There is no access to manage the sites, as there is no access to the Control Panel. Is there another way to access the functionalities of Control Panel without the dashboard?

Thank you very much for your help.
Best regards,

Phillip


Leonard Osang:
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:

CREATE DATABASE dbname CHARACTER SET utf8
Phillip Roe, modifié il y a 11 années.

RE: Dashboard navigation menu not Available

New Member Publications: 6 Date d'inscription: 10/07/12 Publications récentes
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, modifié il y a 11 années.

RE: Dashboard navigation menu not Available

New Member Publications: 2 Date d'inscription: 23/10/12 Publications récentes
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, modifié il y a 10 années.

RE: Dashboard navigation menu not Available

New Member Envoyer: 1 Date d'inscription: 30/03/11 Publications récentes
Hi all,

Do you found a solution?

Regards,
Kamel.
Phillip Roe, modifié il y a 10 années.

Re: [Liferay Forums][Liferay Social Office] RE: Dashboard navigation menu n

New Member Publications: 6 Date d'inscription: 10/07/12 Publications récentes
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