App data export failed

General
1

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

2

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

3

Thanks, Mark!