MS Access ReplicationID cannot be converted into String

Anonymous — Sat, 16 Nov 2024 13:48:01 GMT

Hi,
I'm working with talend and want to migrate some data from an M$ Access(tm) database into postgresql. The job consists of the simple tAccessInput -> tMap -> tPosgresqlOutput components. The problem is that one of the columns in the accessdb is of the type "replication id". After retrieving the schema talend treats the DB type "GUID" as "String".
When I start the job I got the following error message, unfortunately in German:

java.sql.SQLException: Numerischer Wert außerhalb des Gültigkeitsbereichs. bei Spalte 1 (VersionGUID)

A translation could be: numerical value out of (valid) range
First I tried to change the value in talend, but then I get null values from the GUID-column. My workaround was to add an additional (string) column to the access database and updated it via the "StringFromGUID"-Method in Access. Now I can work with that column, but I think this is not the best solution. I tried to use the access functions in the talend query phrase, but this didn't work either. if I'm using the StringFromGUID-Method it say "unknown function", using str() leads to "incompatible data types".
Thanks in advance!

Re: MS Access ReplicationID cannot be converted into String

Radnip — Mon, 28 Jun 2010 12:14:52 GMT

I'm getting the same issue... did you end up resolving it?

Re: MS Access ReplicationID cannot be converted into String

Anonymous — Tue, 27 Jul 2010 13:47:21 GMT

I'm getting the same issue... did you end up resolving it?

No, I just used my workaround 😕

Re: MS Access ReplicationID cannot be converted into String

_AnonymousUser — Sat, 06 Oct 2012 23:26:25 GMT

Does anyone have better answer to this, I'm really stuck.

topic Re: MS Access ReplicationID cannot be converted into String in Talend Studio

MS Access ReplicationID cannot be converted into String

Re: MS Access ReplicationID cannot be converted into String

Re: MS Access ReplicationID cannot be converted into String

Re: MS Access ReplicationID cannot be converted into String