Error import requirements from Jama Contour

Wednesday, April 13, 2011 12:58:08 PM
Hello!

We need import requirements from Jama Contour to SpiraTest.
And we use
But during the import of requirements we get an error:

Column 'Name' does not allow nulls.

Stack Trace:

Server stack trace:
   at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Inflectra.SpiraTest.AddOns.JamaContourAdapter.SpiraImportExport.IImportExport.Requirement_Create1(RemoteRequirement remoteRequirement, Int32 indentPosition)
   at Inflectra.SpiraTest.AddOns.JamaContourAdapter.ProcessThread.ProcessItem(wsItem jamaItem)

7 Replies
Wednesday, April 13, 2011 2:21:01 PM
Avatar
re: serdun on Wednesday, April 13, 2011 12:58:08 PM

It appears that there is a bug in the Jama Contour API that is causing one of the required fields (name) to come back as Null. This issue appears to be in Contour 3.0.3, is that the version you are using?

Wednesday, April 13, 2011 2:48:51 PM
Avatar
re: inflectra.adam on Wednesday, April 13, 2011
Yes,
Wednesday, April 13, 2011 8:55:21 PM
Avatar
re: serdun on Wednesday, April 13, 2011
We have escalated the issue to Jama Software, they should hopefully be releasing an updated version that fixes it. In the meantime in the next couple of days, we'll release an updated Importer that safely handles the null values as a temporary solution.
Tuesday, April 19, 2011 3:20:41 PM
Avatar
re: inflectra.adam on Wednesday, April 13, 2011

We have released an updated version of the importer that traps the NULL values safely and displays them as (Unknown Name)

Wednesday, April 20, 2011 9:40:09 AM
Avatar
re: inflectra.adam on Tuesday, April 19, 2011
We install new version Importer.
And now requirements loading in Spira, but with empty field "Name*:", rather, "Unknown (Null)"
Hope Jama that fixes it.

ps: screeshot http://upload.akusherstvo.ru/image349789.jpg



Wednesday, April 20, 2011 6:56:07 PM
Avatar
re: serdun on Wednesday, April 20, 2011
We are actively working with Jama software right now to try and determine what changed in their API.
Tuesday, April 26, 2011 3:52:02 PM
Avatar
re: inflectra.adam on Wednesday, April 20, 2011
We have just released an updated version of the importer that fixes the issue for Jama Contour v3.0.3 and greater.
Statistics
  • Started: Wednesday, April 13, 2011 12:58:08 PM
  • Last Reply: Tuesday, April 26, 2011 3:52:03 PM
  • Replies: 7
  • Views: 1449