Item. Unknown database error (operation=, error=226).

SOLVED

Getting this error when trying to import an Item in IC.  

This is item # 89 in a list of 1093. Same format as all the other items with options set the same as some of the other items that did load.

Using Sage 300 6.2A (Pu 3) as well as SQL 2012.

Please advise. 

  • 0
    verified answer
    Importing from Excel? If so check that you are not mixing text and numbers in a column: all values in a column must be either text or numbers, but not mixed. Also check for blanks in columns: if so then enter a space in those columns. Blanks (null value) and spaces are not the same even though they appear the same.