com.dotmarketing.exception.DotDataException: Error Clearing Field 'description' for Structure with id: 7bb66a89-03f0-444b-8562-a6187f76c336


Solutions on the web

Solution icon of github
Error Clearing Field 'description' for Structure with id: 7bb66a89-03f0-444b-8562-a6187f76c336

Solution icon of github
Error Clearing Field 'price1' for Structure with id: f65ef197-7425-4202-a5f4-5e6fd1c6e302

Stack trace

com.dotmarketing.exception.DotDataException: Error Clearing Field 'description' for Structure with id: 7bb66a89-03f0-444b-8562-a6187f76c336
	at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.clearField(ESContentFactoryImpl.java:2293)[dotcms_3.6.1_cfa5586.jar:?]
	at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.cleanField(ESContentletAPIImpl.java:845)[dotcms_3.6.1_cfa5586.jar:?]
	at com.dotmarketing.portlets.contentlet.business.ContentletAPIInterceptor.cleanField(ContentletAPIInterceptor.java:385)[dotcms_3.6.1_cfa5586.jar:?]
	at com.dotmarketing.quartz.job.DeleteFieldJob.execute(DeleteFieldJob.java:116)[dotcms_3.6.1_cfa5586.jar:?]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:223)[dot.quartz-all-1.8.6_2.jar:?]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)[dot.quartz-all-1.8.6_2.jar:?]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The data types text and varchar are incompatible in the not equal to operator.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)[sqljdbc42.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:284)[sqljdbc42.jar:?]
	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)[tomcat-dbcp.jar:8.0.18]
	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)[tomcat-dbcp.jar:8.0.18]
	at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.clearField(ESContentFactoryImpl.java:2275)[dotcms_3.6.1_cfa5586.jar:?]
	... 5 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 6 days ago
3 times, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 6 months ago
102 more bugmates