Office 365 error “SyntaxError: Unexpected token '<', ..."
written-by
Madeleine Clay
How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!
While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.
legacy-article
learn-legacy-article-disclaimer-text
Issue
- Sometimes editing a document if Office 365 fails with the error
SyntaxError: Unexpected token '<', ...
- When that happens, the following errors are thrown in the logs
ERROR [https-jsse-nio-8443-exec-10][BatchingBatch:134] HHH000315: Exception executing batch [java.sql.BatchUpdateException: Duplicate entry '12345' for key 'IX_54148667'], SQL: insert into DLOpenerFileEntryReference (groupId, companyId, userId, userName, createDate, modifiedDate, referenceKey, referenceType, fileEntryId, type_, dlOpenerFileEntryReferenceId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERROR [https-jsse-nio-8443-exec-10][SqlExceptionHelper:142] Duplicate entry '12345' for key 'IX_54148667'
ERROR [https-jsse-nio-8443-exec-10][PortletServlet:109] Unable to process portlet com_liferay_document_library_web_portlet_DLAdminPortlet: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch
javax.portlet.PortletException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch
at com.liferay.portal.kernel.portlet.bridges.mvc.BaseMVCActionCommand.processAction(BaseMVCActionCommand.java:56) ~[portal-kernel.jar:?]
at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.callActionMethod(MVCPortlet.java:393) ~[portal-kernel.jar:?]
at com.liferay.portal.kernel.portlet.LiferayPortlet.processAction(LiferayPortlet.java:75) ~[portal-kernel.jar:?]
[...]
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core.jar:5.6.7.Final]
[...]
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:109) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core.jar:5.6.7.Final]
[...]
Caused by: java.sql.BatchUpdateException: Duplicate entry '12345' for key 'IX_54148667'
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:223) ~[mysql.jar:8.3.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchWithMultiValuesClause(ClientPreparedStatement.java:716) ~[mysql.jar:8.3.0]
[...]
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '12345' for key 'IX_54148667'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) ~[mysql.jar:8.3.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql.jar:8.3.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912) ~[mysql.jar:8.3.0]
[...]
Resolution
- This issue is resolved by the fix for LPD-59105
did-this-article-resolve-your-issue