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
You are viewing an article from our legacy "FastTrack"
publication program, made available for informational purposes. Articles
in this program were published without a requirement for independent
editing or verification and are provided"as is" without
guarantee.
Before using any information from this article, independently verify its
suitability for your situation and project.
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 ?