Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: No Longer Reproducible
    • Affects Version/s: 1.2.0 GA1
    • Fix Version/s: None
    • Component/s: General
    • Labels:
      None
    • Environment:
      All

      Description

      09 Dec 2013 09:25:06,754 ERROR [UserSiteManager:313] Unable to update user site My Documents (joanna.wang)
      09 Dec 2013 09:25:06,754 ERROR [UserSiteManager:315] Unable to run insert stmt on object com.liferay.sync.model.UserSite@d1f7c6a4: INSERT INTO `UserSite` (`accountId` ,`companyId` ,`description` ,`enabled` ,`filePath` ,`friendlyURL` ,`groupId` ,`lastRemoteSyncTime` ,`name` ,`site` ,`socialOfficeSite` ,`type` ,`typeSettings` ,`userSiteState` ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      java.sql.SQLException: Unable to run insert stmt on object com.liferay.sync.model.UserSite@d1f7c6a4: INSERT INTO `UserSite` (`accountId` ,`companyId` ,`description` ,`enabled` ,`filePath` ,`friendlyURL` ,`groupId` ,`lastRemoteSyncTime` ,`name` ,`site` ,`socialOfficeSite` ,`type` ,`typeSettings` ,`userSiteState` ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22)
      at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:124)
      at com.j256.ormlite.stmt.StatementExecutor.create(StatementExecutor.java:394)
      at com.j256.ormlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:308)
      at com.j256.ormlite.dao.BaseDaoImpl.createOrUpdate(BaseDaoImpl.java:334)
      at com.liferay.sync.modules.documentlibrary.server.manager.UserSiteManager.updateUserSite(UserSiteManager.java:304)
      at com.liferay.sync.modules.documentlibrary.server.manager.UserSiteManager.resetUserSites(UserSiteManager.java:266)
      at com.liferay.sync.gui.desktop.properties.PropertiesUtil.saveProperties(PropertiesUtil.java:95)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindowHandler.saveProperties(PropertiesWindowHandler.java:186)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindowBinder$3.widgetSelected(PropertiesWindowBinder.java:71)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindow.doOpen(PropertiesWindow.java:582)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindow$1.run(PropertiesWindow.java:162)
      at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
      at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
      at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      at com.liferay.sync.gui.desktop.trayicon.TrayIconHandler.openTrayIcon(TrayIconHandler.java:197)
      at com.liferay.sync.gui.desktop.DesktopSyncClient._doRun(DesktopSyncClient.java:241)
      at com.liferay.sync.gui.desktop.DesktopSyncClient.run(DesktopSyncClient.java:135)
      at com.liferay.sync.gui.desktop.DesktopSyncClient.main(DesktopSyncClient.java:88)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at com.liferay.sync.gui.desktop.DesktopSyncClientLoader.main(DesktopSyncClientLoader.java:39)
      Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_CA ON PUBLIC.USERSITE(GROUPID)"; SQL statement:
      INSERT INTO `UserSite` (`accountId` ,`companyId` ,`description` ,`enabled` ,`filePath` ,`friendlyURL` ,`groupId` ,`lastRemoteSyncTime` ,`name` ,`site` ,`socialOfficeSite` ,`type` ,`typeSettings` ,`userSiteState` ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) [23505-172]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
      at org.h2.message.DbException.get(DbException.java:169)
      at org.h2.message.DbException.get(DbException.java:146)
      at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:83)
      at org.h2.index.PageBtree.find(PageBtree.java:121)
      at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:148)
      at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:101)
      at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:104)
      at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:95)
      at org.h2.table.RegularTable.addRow(RegularTable.java:124)
      at org.h2.command.dml.Insert.insertRows(Insert.java:126)
      at org.h2.command.dml.Insert.update(Insert.java:86)
      at org.h2.command.CommandContainer.update(CommandContainer.java:79)
      at org.h2.command.Command.executeUpdate(Command.java:235)
      at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:154)
      at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:140)
      at com.j256.ormlite.jdbc.JdbcDatabaseConnection.insert(JdbcDatabaseConnection.java:175)
      at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:89)
      ... 28 more
      09 Dec 2013 09:25:06,755 ERROR [UserSiteManager:313] Unable to update user site Liferay HR
      09 Dec 2013 09:25:06,756 ERROR [UserSiteManager:315] Unable to run insert stmt on object com.liferay.sync.model.UserSite@c1976f9: INSERT INTO `UserSite` (`accountId` ,`companyId` ,`description` ,`enabled` ,`filePath` ,`friendlyURL` ,`groupId` ,`lastRemoteSyncTime` ,`name` ,`site` ,`socialOfficeSite` ,`type` ,`typeSettings` ,`userSiteState` ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      java.sql.SQLException: Unable to run insert stmt on object com.liferay.sync.model.UserSite@c1976f9: INSERT INTO `UserSite` (`accountId` ,`companyId` ,`description` ,`enabled` ,`filePath` ,`friendlyURL` ,`groupId` ,`lastRemoteSyncTime` ,`name` ,`site` ,`socialOfficeSite` ,`type` ,`typeSettings` ,`userSiteState` ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22)
      at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:124)
      at com.j256.ormlite.stmt.StatementExecutor.create(StatementExecutor.java:394)
      at com.j256.ormlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:308)
      at com.j256.ormlite.dao.BaseDaoImpl.createOrUpdate(BaseDaoImpl.java:334)
      at com.liferay.sync.modules.documentlibrary.server.manager.UserSiteManager.updateUserSite(UserSiteManager.java:304)
      at com.liferay.sync.modules.documentlibrary.server.manager.UserSiteManager.resetUserSites(UserSiteManager.java:266)
      at com.liferay.sync.gui.desktop.properties.PropertiesUtil.saveProperties(PropertiesUtil.java:95)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindowHandler.saveProperties(PropertiesWindowHandler.java:186)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindowBinder$3.widgetSelected(PropertiesWindowBinder.java:71)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindow.doOpen(PropertiesWindow.java:582)
      at com.liferay.sync.gui.desktop.properties.PropertiesWindow$1.run(PropertiesWindow.java:162)
      at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
      at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
      at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      at com.liferay.sync.gui.desktop.trayicon.TrayIconHandler.openTrayIcon(TrayIconHandler.java:197)
      at com.liferay.sync.gui.desktop.DesktopSyncClient._doRun(DesktopSyncClient.java:241)
      at com.liferay.sync.gui.desktop.DesktopSyncClient.run(DesktopSyncClient.java:135)
      at com.liferay.sync.gui.desktop.DesktopSyncClient.main(DesktopSyncClient.java:88)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at com.liferay.sync.gui.desktop.DesktopSyncClientLoader.main(DesktopSyncClientLoader.java:39)
      Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_CA ON PUBLIC.USERSITE(GROUPID)"; SQL statement:
      INSERT INTO `UserSite` (`accountId` ,`companyId` ,`description` ,`enabled` ,`filePath` ,`friendlyURL` ,`groupId` ,`lastRemoteSyncTime` ,`name` ,`site` ,`socialOfficeSite` ,`type` ,`typeSettings` ,`userSiteState` ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) [23505-172]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
      at org.h2.message.DbException.get(DbException.java:169)
      at org.h2.message.DbException.get(DbException.java:146)
      at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:83)
      at org.h2.index.PageBtree.find(PageBtree.java:121)
      at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:148)
      at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:101)
      at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:104)
      at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:95)
      at org.h2.table.RegularTable.addRow(RegularTable.java:124)
      at org.h2.command.dml.Insert.insertRows(Insert.java:126)
      at org.h2.command.dml.Insert.update(Insert.java:86)
      at org.h2.command.CommandContainer.update(CommandContainer.java:79)
      at org.h2.command.Command.executeUpdate(Command.java:235)
      at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:154)
      at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:140)
      at com.j256.ormlite.jdbc.JdbcDatabaseConnection.insert(JdbcDatabaseConnection.java:175)
      at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:89)
      ... 28 more

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 49 weeks, 1 day ago

                Packages

                Version Package