Support Topics Documentation Slack YouTube Blog

CSV Import - Error exceeded the maximum allowed size (500 symbols)

Hi,
I’ve got the same problem like few days ago.
Here the content of the import log file:

10:20:02  IMPORT_DATA  Importing Started.
10:20:02  IMPORT_DATA  Preparing files to import
10:20:02  IMPORT_DATA  Copying of menusItems.csv, size: 0.004 MiB.
10:20:02  IMPORT_DATA  Creating temporary tables
10:20:02  IMPORT_DATA  Creating user's tables
10:20:02  IMPORT_DATA  Preparing menusItems table: initializing columns.
10:20:02  IMPORT_DATA  Import of tables failed: Property value for "additives" exceeded the maximum allowed size (500 symbols)
10:20:02  IMPORT_DATA  Importing failed. Exception:com.backendless.exceptions.persistence.InvalidEntitySizeException: Property value for "additives" exceeded the maximum allowed size (500 symbols)

		com.backendless.management.impex.manager.imports.data.CommonDatabaseUtils.ensureDataSize(CommonDatabaseUtils.java:48)
		com.backendless.management.impex.manager.imports.data.ImportDataManager.initColumn(ImportDataManager.java:761)
		com.backendless.management.impex.manager.imports.data.ImportDataManager.initColumns(ImportDataManager.java:746)
		com.backendless.management.impex.manager.imports.data.ImportDataManager.initTables(ImportDataManager.java:692)
		com.backendless.tasks.impex.ImportDataTask.doExecute(ImportDataTask.java:173)
		com.backendless.tasks.impex.ImportDataTask.executeImpl(ImportDataTask.java:124)
		com.backendless.tasks.impex.AbstractImportTask.execute(AbstractImportTask.java:83)
		com.backendless.taskman.Task.run(Task.java:136)
		com.backendless.taskman.TimeoutFixedThreadPoolExecutor.executeTaskWithTracker(TimeoutFixedThreadPoolExecutor.java:91)
		com.backendless.taskman.TimeoutFixedThreadPoolExecutor.lambda$invoke$0(TimeoutFixedThreadPoolExecutor.java:39)
		java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
		java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
		java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
		java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
		java.base/java.lang.Thread.run(Thread.java:834)

I’ve attached my cvs file that I’ve tried to import.

Thanks for your help!
Mario

menusItems.csv (3.9 KB)

Hello @Mario_Canevarollo

I just imported your csv file into my new app without any issues.
Could you please try one more time with a new app or provide us additional steps to reproduce the problem.

my log:

10:58:22  IMPORT_DATA  Importing Started.
10:58:22  IMPORT_DATA  Preparing files to import
10:58:22  IMPORT_DATA  Copying of menusItems.csv, size: 0.004 MiB.
10:58:22  IMPORT_DATA  Creating temporary tables
10:58:22  IMPORT_DATA  Creating user's tables
10:58:22  IMPORT_DATA  Preparing menusItems table: create schema.
10:58:23  IMPORT_DATA  Preparing menusItems table: initializing columns.
10:58:28  IMPORT_DATA  Preparing menusItems table: updating column related IDs.
10:58:28  IMPORT_DATA  Preparing menusItems table: initializing relations.
10:58:28  IMPORT_DATA  Checking denied and duplicate columns.
10:58:28  IMPORT_DATA  Resolving related table.
10:58:28  IMPORT_DATA  Getting meta-info about insetable tables.
10:58:28  IMPORT_DATA  Start import table: menusItems
10:58:28  IMPORT_DATA  Table 'menusItems' was imported at 0 seconds. Saved 42 records.
10:58:28  IMPORT_DATA  Finish import table: menusItems
10:58:28  IMPORT_DATA  Started restoring relations.
10:58:28  IMPORT_DATA  Clearing user data table cache.
10:58:28  IMPORT_DATA  Deleting temporary tables.
10:58:29  IMPORT_DATA  Finishing pointers export.
10:58:29  IMPORT_DATA  Restoring expiration tasks for DeviceRegistrations.
10:58:29  IMPORT_DATA  Import finished.

Regards, Vlad

It is so frustrating! Every time that I want to import new data into a table I get the same problem.
I can’t every time delete the table, recreate it and import finally the data. Also because I will lost my relations.

Is there an other way to import data to a table?

I don’t see any relations in the menusItems.csv file.
Could you please provide all the steps to reproduce the problem?

Here the video about the steps that I’ve followed.

ok, provide please your appId

My AppId:
AA0CC718-4B21-C574-FF0A-624EEA04DA00

Now I see where the problem is.
In your csv I can see that shortDescription is TEXT data type:

shortDescription({""constraints"":[],""type"":""TEXT""})

but in your data schema is “STRING” dataType specified.

I’m going to create an internal ticket to fix error message in the log output, however as a workaround I can propose you to change the column in the csv file to the following one:

shortDescription({""constraints"":[],""type"":""STRING"",""dataSize"":250,""dataSizeAuto"":false})

Regards, Vlad
Regards, Vlad

Ok, Now it works. Thanks a lot Vlad!
stay healthy