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) en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/integrations/importers/49.aspxthreadId=49serdun M serdun (serdun@yandex.ru)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) Wed, 13 Apr 2011 12:58:08 -04002011-04-26T15:52:03-04:00/Support/Forum/integrations/importers/49.aspxmessageId=102David J (adam.sandman+support@inflectra.com) 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? Wed, 13 Apr 2011 14:21:01 -04002011-04-13T14:21:01-04:00/Support/Forum/integrations/importers/49.aspx#reply102messageId=103serdun M serdun (serdun@yandex.ru) Yes, we just using Version: 3.0.3 ( Thanks! Wed, 13 Apr 2011 14:48:51 -04002011-04-13T14:48:51-04:00/Support/Forum/integrations/importers/49.aspx#reply103messageId=104David J (adam.sandman+support@inflectra.com)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.Wed, 13 Apr 2011 20:55:21 -04002011-04-13T20:55:21-04:00/Support/Forum/integrations/importers/49.aspx#reply104messageId=114David J (adam.sandman+support@inflectra.com) We have released an updated version of the importer that traps the NULL values safely and displays them as (Unknown Name) Tue, 19 Apr 2011 15:20:41 -04002011-04-19T15:20:41-04:00/Support/Forum/integrations/importers/49.aspx#reply114messageId=117serdun M serdun (serdun@yandex.ru) 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 Wed, 20 Apr 2011 09:40:09 -04002011-04-20T09:40:09-04:00/Support/Forum/integrations/importers/49.aspx#reply117messageId=121David J (adam.sandman+support@inflectra.com)We are actively working with Jama software right now to try and determine what changed in their API.Wed, 20 Apr 2011 18:56:07 -04002011-04-20T18:56:07-04:00/Support/Forum/integrations/importers/49.aspx#reply121messageId=124David J (adam.sandman+support@inflectra.com)We have just released an updated version of the importer that fixes the issue for Jama Contour v3.0.3 and greater.Tue, 26 Apr 2011 15:52:02 -04002011-04-26T15:52:02-04:00/Support/Forum/integrations/importers/49.aspx#reply124