Re: Error in running DBT2

Hi All,

Just adding the actual error again.

I run the the *dbt2-pgsql-build-db -w 1 *

Output directory of data files: current directory

*Generating data files for 1 warehouse(s)...*
*Generating item table data...*
*BEGIN*
*ERROR: invalid byte sequence for encoding "UTF8": 0xf9*
*CONTEXT: COPY item, line 1*
*ROLLBACK*

This pattern the above found many times. Please guide me through!!!

Regards,
Rohit Goyal

On Tue, May 20, 2014 at 9:15 AM, Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)com> wrote:

> Hi All,
>
>
>
> On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
>
>>
>> On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)com>wrote:
>>
>>> This pattern the above found many times. Please guide me through!!!
>>>
>>
>> IIRC, people have been working around this by setting
>> standard_conforming_strings to "off". It really ought to be fixed in a
>> principled way, though -- the real issue here is that dbt2 has severe
>> bit-rot.
>>
>>
> Sorry for so asking so late. I thought the error is resolved.
>
> I changed standard_conforming_strings to "off" in *postgresql.conf.* and
> then I run *dbt2-pgsql-build-db -w 1 script again. *
> But, I am still facing the same error. Please tel me what else I can do to
> resolve the issue.
>
> Regards,
> Rohit Goyal
>
>> --
>> Peter Geoghegan
>>
>
>
>
> --
> Regards,
> Rohit Goyal
>

--
Regards,
Rohit Goyal