Importing

leopdurr

I am getting this error when I try to import records into my DB

Importing business object Boat

Unable to determine data values for aggregate function=EXISTS due to the following exception com.bas.basserver.persistence.PersistenceException Error executing a query SELECT COUNT() FROM HY_BOAT AS Boat INNER JOIN HY_BASE AS Boat_BoatDefaultBase ON Boat.BoatDefaultBase_RID=Boat_BoatDefaultBase.ID WHERE (((Boat.BoatName='Aricia of Liverpool') AND (Boat_BoatDefaultBase.ID='Antigua & Barbuda')) AND (Boat.BoatID<>1.0)) message is Conversion failed when converting the varchar value 'Antigua & Barbuda' to data type int.
37 1 records have been processed.
Unable to determine data values for aggregate function=EXISTS due to the following exception com.bas.basserver.persistence.PersistenceException Error executing a query SELECT COUNT() FROM HY_BOAT AS Boat INNER JOIN HY_BASE AS Boat_BoatDefaultBase ON Boat.BoatDefaultBase_RID=Boat_BoatDefaultBase.ID WHERE (((Boat.BoatName='Bavaria 40 Mystery') AND (Boat_BoatDefaultBase.ID='Antigua & Barbuda')) AND (Boat.BoatID<>1.0)) message is Conversion failed when converting the varchar value 'Antigua & Barbuda' to data type int.

aware_support

The message is obvious, isn't it?

"Conversion failed when converting the varchar value 'Antigua & Barbuda' to data type int."

The system is expecting integer in this field and you are providing text...

chris29

If Boat_BoatDefaultBase.ID a related object you are trying to link the row to a default base just use the attribute used to join the two objects.

eg (assuming Boat is related to BoatDefaultBase and Name is the attribute)

Boat.BoatDefaultBase.Name = 'Antigua & Barbuda'

On import Aware will look up the name and link it for you.