Re: Issue with TPT and Postgresql ODBC Driver

On 09/29/2015 02:23 PM, Aravindh Varadharaju wrote:
> Hi Adrian
>
>
> My TPT script is used to copy a table from Postgres to Teradata. My
> ODBC.INI was not quite right. So I fixed the ODBC.INI but could not get it
> work with TPT.

What is your ODBC manager?

>
> This is my ODBC setup:
> --
> [ODBC Data Sources]
> OPDB=PostgresSQL Connection to OPDB
>
>
> [OPDB]
> Driver=/var/odbc/usr/lib64/psqlodbcw.so
> Description=PostgresSQL Connection to OPDB
> Database=<Database Name>
> HostName=<Host Name>
> LogonID=opdb_read
> MaxPoolSize=100
> MinPoolSize=0
> PortNumber=5432
> --
>
>
>
>
> Aravindh Varadharaju | DevOps Engineer
> avaradharaju(at)shutterfly(dot)com |o. 650.610.5173 | m. 812.369.3537
>
>
>
>
>
>
>
>
> On 9/29/15, 2:00 PM, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>> On 09/29/2015 11:23 AM, Aravindh Varadharaju wrote:
>>> Hi
>>>
>>> I am trying to use Postgresql ODBC Unicode Driver to pull data from
>>> Postgres Database into Teradata through Teradata Parallel Transporter.
>>> When I run the TPT scripts it is throwing an error as shown below:
>>> --
>>> ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
>>> STATE=S1000, CODE=0,
>>> MSG='[DataDirect][ODBC lib] Unicode converter truncated
>>> character¹
>>
>> Looks like you are still using DataDirect.
>>
>> Can you supply more information on how your ODBC is setup?
>>
>> Also what the TPT script is doing?
>>
>>>
>>> ‹
>>> The same script is working with Postgresql driver from Progress.
>>>
>>> Can you give me a hint or point me in the right direction to get this
>>> resolved?
>>>
>>> *Aravindh Varadharaju* | DevOps Engineer
>>>
>>> _avaradharaju(at)shutterfly(dot)com_ |o. 650.610.5173 | m. 812.369.3537
>>>
>>>
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com