Error 405 importing Excel file

[J Kohler]

I get Unable to add testcase ending at rowNumber.... Error: Unexpected response code: 405. I get this error on all 23 testcases in my file.

I've (eventually) successfully imported several other files with same file format - some JIRA fields, Zephyr fields, some JIRA custom fields.

Some fields may have been too large so I reduced their size. I've tried regenerating API keys, updated to latest Java version, reindexing JIRA and Zephyr, no luck. I'm out of ideas.

How do I get rid of this error and import my file?

I'm using zfj-importer-utility-0.36.jar and JIRA cloud JIRA v7.1.0-OD-06-005

[J Kohler]

Update: today I tried importing the same file again and it worked. The first file was imported ok except it failed to import 1 of 2 custom JIRA fields. The 2nd file I imported worked, importing all fields.

The importer is so useful when it works, but frustratingly inconsistent. Below is the log error from yesterday's failed attempts if it helps.

2016-02-11 20:35:17,255 ERROR [pool-4-thread-1] TestcaseImportManagerImpl.saveTestCase(981) | dispatch.classic.StatusCode: Unexpected response code: 405

at dispatch.classic.HttpExecutor$$anonfun$1.apply(executor.scala:53)
at dispatch.classic.HttpExecutor$$anonfun$1.apply(executor.scala:50)
at dispatch.classic.HttpExecutor$$anonfun$x$2.apply(executor.scala:41)
at dispatch.classic.HttpExecutor$$anonfun$x$2.apply(executor.scala:36)
at dispatch.classic.BlockingHttp$$anonfun$execute$1.apply(Http.scala:54)
at dispatch.classic.Http.pack(Http.scala:25)
at dispatch.classic.BlockingHttp$class.execute(Http.scala:53)
at dispatch.classic.Http.execute(Http.scala:21)
at dispatch.classic.HttpExecutor$class.x(executor.scala:36)
at dispatch.classic.Http.x(Http.scala:21)
at dispatch.classic.HttpExecutor$class.when(executor.scala:50)
at dispatch.classic.Http.when(Http.scala:21)
at dispatch.classic.HttpExecutor$class.apply(executor.scala:60)
at dispatch.classic.Http.apply(Http.scala:21)
at com.thed.zfj.rest.JiraService$.saveTestcase(JIRAServiceImpl.scala:206)
at com.thed.zfj.rest.JiraService$.saveTestcase(JIRAServiceImpl.scala:173)
at com.thed.zfj.rest.JiraService.saveTestcase(JIRAServiceImpl.scala)
at com.thed.service.impl.zie.TestcaseImportManagerImpl.saveTestCase(TestcaseImportManagerImpl.java:972)
at com.thed.service.impl.zie.TestcaseImportManagerImpl.importFileByChange(TestcaseImportManagerImpl.java:529)
at com.thed.service.impl.zie.TestcaseImportManagerImpl.importFileForByName(TestcaseImportManagerImpl.java:441)
at com.thed.service.impl.zie.AbstractImportManager.importSingleFiles(AbstractImportManager.java:163)
at com.thed.service.impl.zie.AbstractImportManager.importAllFiles(AbstractImportManager.java:81)
at com.thed.zfj.rest.JiraService$.startImport(JIRAServiceImpl.scala:106)
at com.thed.zfj.ui.ImportSwingApp$BaseMappingImporter$$anon$32.call(ImportSwingApp.scala:457)
at com.thed.zfj.ui.ImportSwingApp$BaseMappingImporter$$anon$32.call(ImportSwingApp.scala:454)
at scala.actors.threadpool.FutureTask.run(FutureTask.java:178)
at scala.actors.threadpool.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1060)
at scala.actors.threadpool.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:574)
at java.lang.Thread.run(Unknown Source)

2016-02-11 20:35:17,255 DEBUG [ForkJoinPool-1-worker-21] ImportSwingApp$$anon$21.applyOrElse(214) | Thu Feb 11 20:35:17 EST 2016 Unable to add testcase ending at rowNumber - 124. Error:Unexpected response code: 405

[Ivan Panasiuk]

I have the same error when trying to import my test cases via Excel file.

[Shrikant Bhalerao]

2016-06-20 23:12:50,675 ERROR [pool-9-thread-1] TestcaseImportManagerImpl.saveTestCase(981) | dispatch.classic.StatusCode: Unexpected response code: 405

at dispatch.classic.HttpExecutor$$anonfun$1.apply(executor.scala:53)
at dispatch.classic.HttpExecutor$$anonfun$1.apply(executor.scala:50)
at dispatch.classic.HttpExecutor$$anonfun$x$2.apply(executor.scala:41)
at dispatch.classic.HttpExecutor$$anonfun$x$2.apply(executor.scala:36)
at dispatch.classic.BlockingHttp$$anonfun$execute$1.apply(Http.scala:54)
at dispatch.classic.Http.pack(Http.scala:25)
at dispatch.classic.BlockingHttp$class.execute(Http.scala:53)
at dispatch.classic.Http.execute(Http.scala:21)
at dispatch.classic.HttpExecutor$class.x(executor.scala:36)
at dispatch.classic.Http.x(Http.scala:21)
at dispatch.classic.HttpExecutor$class.when(executor.scala:50)
at dispatch.classic.Http.when(Http.scala:21)
at dispatch.classic.HttpExecutor$class.apply(executor.scala:60)
at dispatch.classic.Http.apply(Http.scala:21)
at com.thed.zfj.rest.JiraService$.saveTestcase(JIRAServiceImpl.scala:206)
at com.thed.zfj.rest.JiraService$.saveTestcase(JIRAServiceImpl.scala:173)
at com.thed.zfj.rest.JiraService.saveTestcase(JIRAServiceImpl.scala)
at com.thed.service.impl.zie.TestcaseImportManagerImpl.saveTestCase(TestcaseImportManagerImpl.java:972)
at com.thed.service.impl.zie.TestcaseImportManagerImpl.importFileByEmptyRow(TestcaseImportManagerImpl.java:819)
at com.thed.service.impl.zie.AbstractImportManager.importSingleFiles(AbstractImportManager.java:157)
at com.thed.service.impl.zie.AbstractImportManager.importAllFiles(AbstractImportManager.java:81)
at com.thed.zfj.rest.JiraService$.startImport(JIRAServiceImpl.scala:106)
at com.thed.zfj.ui.ImportSwingApp$BaseMappingImporter$$anon$32.call(ImportSwingApp.scala:457)
at com.thed.zfj.ui.ImportSwingApp$BaseMappingImporter$$anon$32.call(ImportSwingApp.scala:454)
at scala.actors.threadpool.FutureTask.run(FutureTask.java:178)
at scala.actors.threadpool.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1060)
at scala.actors.threadpool.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:574)
at java.lang.Thread.run(Unknown Source)

2016-06-20 23:12:50,680 DEBUG [ForkJoinPool-1-worker-5] ImportSwingApp$$anon$21.applyOrElse(214) | Mon Jun 20 23:12:50 IST 2016 Book2.xlsx imported successfully..!

2016-06-20 23:12:50,680 DEBUG [ForkJoinPool-1-worker-5] ImportSwingApp$$anon$21.applyOrElse(214) | Mon Jun 20 23:12:50 IST 2016 Book2.xlsx imported successfully..!

Any idea guys? I am facing the same issue since yesterday but unable to find out why?

[Arun Ravindran]

Hi Shrikant

I am Arun from Zephyr Support

Can you check the url that you are entering in the "Url" placeholder of the importer is of "http" type or "https". If "http" kindly change to "https" and check.Generally this error occurs because of this

Thanks ZephyrSupport

[Andrew Batka]

It seems like this always happens and the only support help is to check the URL. Very frustrating!!

If we can log in and we have https:// what other issues could be giving us an Error:Unexpected response code: 405??

[Arun Ravindran]

Hi Andrew

I am Arun Ravindran, Product Support Manager of Zephyr and the below email/post came to our notice.We would like to help you out in resolving the issue and thereby help you use our product and its add ons to the full extent possible Please signup and login to our support portal "https://support.getzephyr.com/hc/en-us" using your email id.For issues or queries use the option "Submit a case"to raise a new ticket with us

Please note updates on the tickets will generate emails to you for notifying you.Its an un monitored/no-reply email box so always login to the support site and respond via ticket

Thanks Arun Ravindran ZephyrSupport