Sample Header Ad - 728x90

Visual Studio 2010 Shell Error - is it Causing this SQL Server error?

0 votes
1 answer
513 views
Visual Studio 2010 Isolated Shell has the infamous "Invalid License Data. Reinstall" error. I have SSMS 2014. I have tried reinstalling several times, I installed Visual Studio 2013 but SSMS doesn't recognize it. When I attempt to open SSMS, it says something like components missing, reinstall. So when I repair it installs the same VS 2010 with same issue. We have an application with a SQL Server backend database. We have a vendor catalog and then import items to our item database. However, it fails and gives this error code below. So my question is: Could this VS 2010 error be causing this error or is this likely an unrelated issue? > mscorlib 06/18/2016 8:20:42 PM LoadSettings Object reference not > set to an instance of an object. > at PosBeData.Settings.LoadSettings() PosBeData 06/18/2016 8:20:43 PM Time > > Update To: 06/19/2016 12:20 AM 06/18/2016 8:32:47 PM frmImportAdd > String or binary data would be truncated. The INSERT statement > conflicted with the FOREIGN KEY constraint "FK_UPC_Item". The conflict > occurred in database "PosBe", table "dbo.Item", column 'Item_ID'. The > INSERT statement conflicted with the FOREIGN KEY constraint > "FK_VendorPartNo_Item". The conflict occurred in database "PosBe", > table "dbo.Item", column 'Item_ID'. The statement has been terminated. > The statement has been terminated. The statement has been terminated. > > 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 : at > System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage > reqMsg, IMessage retMsg) at > System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& > msgData, Int32 type) at > PosBeData.PosBeService.GetAddCatalogItems(dtoV_VendorCatalog[] > VendorCatalogItems, String Import_CD, Int32 Category_ID, Int32 > Sub_Category_ID, Boolean CreateInventory, Boolean CreateCase, String > Default_Mfg, UserAuth ua) at > PosBeData.V_VendorCatalogCollection.AddSelectedItems(String Import_CD, > Int32 Category_ID, Int32 Sub_Category_ID, Boolean CreateInventory, > Boolean CreateCase, String Default_Mfg) at > PosBe.frmVendorCatalog.AddItemsThread() mscorlib
Asked by justwondering (3 rep)
Jun 19, 2016, 01:01 AM
Last activity: Jun 21, 2016, 11:57 AM