Rank: Member
Joined: 7/24/2008(UTC)
Posts: 5
|
I have tried the import tool version 5.5 and 5.7. When am able to update existing products but I get an error when importing new products. The event logo shows the following error:
procedure: bvc_Product_i line: 52 Cannot insert the value NULL into column 'id', table 'BroadBay.dbo.bvc_Product'; column does not allow nulls. INSERT fails. Exception: System.Data.SqlClient.SqlException: procedure: bvc_Product_i line: 52 Cannot insert the value NULL into column 'id', table 'BroadBay.dbo.bvc_Product'; column does not allow nulls. INSERT fails. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning...
Our store version is the fiollowing
* 5.3.2.31............BVSoftware.Bvc5.Core.dll
Thanks for any help you can provide!
Jim
Broadbaycotton.com
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
There could be a database schema difference between the newer versions of BV and the version you are running that would cause this error. Can you upgrade your store to a newer version? |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 7/24/2008(UTC)
Posts: 5
|
Thanks - working on that now.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.