Re: Issue with TPT and Postgresql ODBC Driver

Hi

The manager being used is unixODBC.

I made a couple of changes to my ODBC.INI file. Now I am getting the
following error:
—
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
STATE=I, CODE=0,
MSG='['
—

ODBC.INI

[OPDB3]
Driver=/var/odbc/usr/lib64/psqlodbc.so
Description=PostgresSQL Connection to OPDB
Database=<DB Name>
HostName=<Host Name>
LogonID=
MaxPoolSize=100
MinPoolSize=0
PortNumber=<Port Number>
--

Aravindh Varadharaju | DevOps Engineer
avaradharaju(at)shutterfly(dot)com |o. 650.610.5173 | m. 812.369.3537

On 9/29/15, 2:59 PM, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:

>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