Physical Inventory Import File - Error Message (#2147217900)

Feb 05, 2009 2 Replies
G

We have just finished counting inventory and I want to upload the physical counts . I am trying to import a physical inventory file (Tab delimited) but I get the following error message before the import is aborted:



Error #-2147217900 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 42000) (NativeError: 468) No Help file available UPDATE [##ST_Validation_1] SET ImportStatus = 3 , ItemID = Item.ID FROM Item INNER JOIN [##ST_Validation_1] ON Item.ItemLookupCode [##ST_Validation_1].ItemLookupCode



Any insight into this would be appreciated.



Thanks, Gil



Vote
Twitter Facebook LinkedIn
A

GOto Store Administrator - log in wit SA password. Then access Database => Colation Setting - and when you get he screen press Enter to make the database Collation and SQL collation become the same.

Then all will work.

Vote
Twitter Facebook LinkedIn
M

Be wary if this is in an HQ Environment. if you start changing collations and HQ/Store collations are different, then HQ Client comms may stop working.

From within SO Admin, Database > Collation - Check the Server Collation is the same as the Database collation.

All Server/Database collations should be identical across the business.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required