Support Topics Documentation Slack YouTube Blog

App data export failed

Hello Backendless,

We experienced failed exports on two apps today. Problem is with Users table, log file shows the following:

23:55:58 EXPORT Export started
23:55:58 EXPORT Exporting table: GeoPoint
23:55:58 EXPORT Exporting table: Installations
23:55:58 EXPORT Exporting table: Profiler
23:55:58 EXPORT Exporting table: DeviceRegistration
23:55:58 EXPORT Exporting table: Users
23:55:58 EXPORT Exporting table Users failed Exception:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’ udt.Users., blUserLocale, udt.Users., udt.Users., udt.Users., `udt.Us’ at line 1

	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	com.mysql.jdbc.Util.getInstance(Util.java:408)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)
	com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
	org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:310)
	com.backendless.tasks.impex.DataTableExporter.execute(DataTableExporter.java:88)
	com.backendless.tasks.impex.ExportTask.export(ExportTask.java:157)
	com.backendless.tasks.impex.ExportTask.execute(ExportTask.java:115)
	com.backendless.taskman.Task.run(Task.java:131)
	java.lang.Thread.run(Thread.java:745)

23:55:58 EXPORT Generating export.zip
23:55:58 EXPORT Uploading export.zip to File Service
23:55:58 EXPORT Export finished

App ID’s are:
F05D61F0-4611-10A2-FF2A-D2108FF89400
8D2F7B46-2237-EB55-FF70-EFF3C44ED400

Please advise, and thanks in advance for your help!

Best regards,

Rick Cataldo

Hi Rick,

We are aware of this problem. It has already been fixed and we plan to deploy the fix to the production servers on Monday.

Kind regards,
Mark

Thanks, Mark!