installation of GeoLiteCity

Aster
dsc
Fan

installation of GeoLiteCity

Hi,

i try to install GeoLiteCity out from the Analytics package by using:

act -h 10.211.56.101 -U db_superuser -w db_superuser -c '\install geolite128_database/GeoLiteCityv6.dat; '

the command fails with An error has occurred during command execution: SyncConnection.cpp:144.

any idea?

3 REPLIES
Teradata Employee

Re: installation of GeoLiteCity

Hi,

I got the same error , when I tried to load some data while the replication factor of the Aster Appliance was changed. Does it occur still?

Regards,

Jens

dsc
Fan

Re: installation of GeoLiteCity

Hi Jens,

actuall it does. I suspect some thing of timeout. Because if i run the installation script it stops at some point.

Have you been able to fix it?

Dieter

Teradata Employee

Re: installation of GeoLiteCity

Hi Dieter,

I was able to track down the following error within the loaded the csv by using head -n input.csv > small.csv and loading small.csv until I found the following error:

Loading tuples using node '145.225.116.201'.

ERROR:  value too long for type character varying(16)

line 51790, column quality: "Bad.ConfigurationError"

After ALTERing the table (adjusting the Column type), I was able to load in the data just fine.

Hope this helps,

Jens