1. Home
  2. Point-Of-Sale Software
  3. Physical Inventory Import File - Error Message (#2147217900)

Physical Inventory Import File - Error Message (#2147217900)

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

Reply to
Gil
Loading thread data ...

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.

Reply to
Afshin

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.

Reply to
matthew.warr

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.