Postgres Pro
Downloads
Home   >   mailing lists

Thread: Issue with TPT and Postgresql ODBC Driver

Issue with TPT and Postgresql ODBC Driver

From
Aravindh Varadharaju
Date:
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’

—
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  



Attachment

Re: Issue with TPT and Postgresql ODBC Driver

From
Adrian Klaver
Date:
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

Re: Issue with TPT and Postgresql ODBC Driver

From
Adrian Klaver
Date:
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

Re: Issue with TPT and Postgresql ODBC Driver

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


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: Issue with TPT and Postgresql ODBC Driver

From
Adrian Klaver
Date:
On 09/29/2015 03:30 PM, Aravindh Varadharaju wrote:
> 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='['
> —

See here:


http://www.info.teradata.com/htmlpubs/DB_TTU_15_10/index.html#page/Load_and_Unload_Utilities/B035_2436_035K/2436ch10.079.01.html

"The ODBC operator is a producer operator that enables universal open
data access to retrieve data from any non-Teradata ODBC-compliant data
sources. The ODBC operator is optimized and certified to work with
either Progress DataDirect or Simba ODBC drivers. Attempting to use this
operator with any other ODBC driver may have unexpected results and
possible decreased performance."


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: Issue with TPT and Postgresql ODBC Driver

From
Aravindh Varadharaju
Date:
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@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

Re: Issue with TPT and Postgresql ODBC Driver

From
Aravindh Varadharaju
Date:
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@shutterfly.com  |o. 650.610.5173 | m. 812.369.3537








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