Re: Issue with TPT and Postgresql ODBC Driver

On 09/29/2015 02:53 PM, Aravindh Varadharaju wrote:
> Hi Adrian
>

CCing list.

> I am not quite sure about that. But I have iODBC set up on the server. So
> I think that we use iODBC manager.

Probably worth finding out as your original report had:

MSG='[DataDirect][ODBC lib] Unicode converter truncated character’

DataDirect would be from Progress, if I am following correctly. So
either the driver you are using is the Progress one or the manager is.

>
> Aravindh Varadharaju | DevOps Engineer
> avaradharaju(at)shutterfly(dot)com |o. 650.610.5173 | m. 812.369.3537
>
>
>
>
>
>
>
>
> On 9/29/15, 2:47 PM, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>> 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
>

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