Trello Importer: Requested too many cards with action loads

[Max Faul]

It seems like the Import From Trello option does not support many Trello cards.

I think this should be retrieved in batches rather than all at once.

com.atlassian.jira.plugins.importer.trello.fetch.TrelloParseException: Error "{"message":"Requested too many cards with action loads, please limit","error":"API_TOO_MANY_CARDS_REQUESTED"}" returned when getting cards for board with ID {1}.
	at com.atlassian.jira.plugins.importer.trello.fetch.TrelloParser.getCards(TrelloParser.java:86)
	at com.atlassian.jira.plugins.importer.trello.TrelloImporterClient.getTotalIssues(TrelloImporterClient.java:111)
	at com.atlassian.jira.plugins.importer.trello.TrelloImporterDataBean.getTotalIssues(TrelloImporterDataBean.java:105)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:407)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	at com.sun.proxy.$Proxy1576.doImport(Unknown Source)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:458)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:426)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.google.gson.JsonSyntaxException: java.lang.IllegalStateException: Expected BEGIN_ARRAY but was BEGIN_OBJECT at line 1 column 2
	at com.google.gson.Gson.fromJson(Gson.java:801)
	at com.google.gson.Gson.fromJson(Gson.java:756)
	at com.google.gson.Gson.fromJson(Gson.java:705)
	at com.atlassian.jira.plugins.importer.trello.fetch.TrelloParser.getCards(TrelloParser.java:83)
	... 33 more
Caused by: java.lang.IllegalStateException: Expected BEGIN_ARRAY but was BEGIN_OBJECT at line 1 column 2
	at com.google.gson.stream.JsonReader.beginArray(JsonReader.java:328)
	at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:79)
	at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:60)
	at com.google.gson.Gson.fromJson(Gson.java:790)
	... 36 more

[Petter Gonçalves · Accepted solution]

Hello Max,

Thank you for raising this question.

I believe the root cause of this issue is indeed the number of cards in your Trello boards that are causing the import to timeout. We have already reported a bug to fix this behavior:

- JsonSyntaxException: Expected BEGIN_ARRAY but was BEGIN_OBJECT error with Trello Importer

Please, feel free to watch this bug to be aware of any updates.

For now, the workaround we recommend you is to manually break the Trello board into a few smaller ones to avoid it from hitting the API limits.

Please, let me know if you still have any questions about it, Max.

[Max Faul]

Thank you for the reply. The workaround is not feasible for us. This bug is unfortunate, as it renders the functionality completely useless. I'll vote for the ticket although we won't be able to wait for the fix. We imported a csv extract from Trello (which contains limited info) and dedicated a team of people to go and manually import the attachments, comments, etc.

[Petter Gonçalves]

You are welcome, Max.

I'm sorry to hear that this workaround is not feasible for your team. I hope our developers can fix this bug soon.

Have a nice day!