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@shutterfly.com  |o. 650.610.5173 | m. 812.369.3537
>
>
>
>
>
>
>
>
> On 9/29/15, 2:00 PM, "Adrian Klaver" <adrian.klaver@aklaver.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@shutterfly.com_  |o. 650.610.5173 | m. 812.369.3537
>>>
>>>
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com
>


--
Adrian Klaver
adrian.klaver@aklaver.com