Stardraw Forums

error when syncronising products

http://forums.stardraw.com/Topic10929.aspx

By Robert Nilsson - 10/3/2013 9:32:30 AM

Hi!
I installed S7 on a new computer and when i start the program it will sync the product list.
Every time it does this i get this error: Any ideas on what this can be?

0fba5872-5d42-4f34-8f28-7050f6678164
b4e7c3cf-af62-44e0-a938-c1ff458ac223
2013-10-03 09:48:02
Microsoft Windows NT 6.1.7601 Service Pack 1
4.0.30319.1008 : .NET v2.0 (Service Pack 2) (Media Center)
6.1.7601.17514
Exception details:
Exception
A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK__Symbol__000000000000010E ]; 'INSERT INTO [Symbol]' params: GUID=e4b82ed1-5ff4-4051-9a1a-1df001713ba9, ProductGUID=3374ff9f-9629-4b29-b6b3-61ddd1518d68, EnvironmentGUID=509f0002-6441-4994-af7c-4a24049453ac, Name=BLU-100 12x8 Signal Processor with Digital Audio Bus, FileSize=1199, Deleted=False, DateLastModified=2012-03-14 09:29:00, Author=0, Data=System.Byte[],
at Stardraw.Project.Design.DbProductProvider.a(DataSet A_0)
at Stardraw.Project.Design.DbProductProvider.a(DataTable A_0)
at Stardraw.Project.Design.DbProductProvider.a()
Exception details:
SqlCeException
A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK__Symbol__000000000000010E ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at Stardraw.Project.Design.DbProductProvider.a(DataSet A_0
By David Snipp - 10/3/2013 1:54:40 PM

Robert,

This could be caused by a number of things, but the solution is to delete your application.sdf file which resides in "C:\ProgramData\Stardraw.com Ltd\Stardraw Design 7\1.0.0.0" and restart Stardraw Design 7.

You will have to be patient while your libraries are resynchronized but then you shouldn't see any further problems.

Do let us know how you get on.
By Robert Nilsson - 10/3/2013 5:39:01 PM

Hi David!

Many thanks for your help, I'll look further but i didn't manage to find that file or that folder on W7Pro
By Robert Nilsson - 10/9/2013 1:31:43 PM

Hi David!
Found it end deleted it, Works fine now. Thanks for your help!