Re: Issue with TPT and Postgresql ODBC Driver

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.

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