<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoPlainText>The postgreSQL import stage of the migration is failing on me.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>It bombs out with this error message:<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>ERROR: invalid byte sequence for encoding "UTF8": 0xeda080<o:p></o:p></p><p class=MsoPlainText>HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".<o:p></o:p></p><p class=MsoPlainText>CONTEXT: COPY rhnpackagechangelogdata, line 136452<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>I found a posting from July where someone had a similar problem. You had him apply a patch to the spacewalk-dump-schema script. I went to apply the same patch and found it to already be there.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Here's a snippit from that old post:<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>On Tue, Jul 12, 2011 at 02:01:19PM +0000, <a href="mailto:Silvio.Schanz@elektrobit.com">Silvio.Schanz@elektrobit.com</a> wrote:<o:p></o:p></p><p class=MsoPlainText>> Hi,<o:p></o:p></p><p class=MsoPlainText>> <o:p></o:p></p><p class=MsoPlainText>> fgrep -B1 rhnpackagerepodata spacewalk-oracle.dmp ...<o:p></o:p></p><p class=MsoPlainText>> -- Types for rhnpackagerepodata: DOUBLE PRECISION BLOB BLOB BLOB DATE <o:p></o:p></p><p class=MsoPlainText>> DATE<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Can you apply the following patch to your spacewalk-dump-schema and dump and import the schema again, to see if it addresses the problem for you?<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>diff --git a/utils/spacewalk-dump-schema b/utils/spacewalk-dump-schema index e391111..0068ed4 100755<o:p></o:p></p><p class=MsoPlainText>--- a/utils/spacewalk-dump-schema<o:p></o:p></p><p class=MsoPlainText>+++ b/utils/spacewalk-dump-schema<o:p></o:p></p><p class=MsoPlainText>@@ -115,7 +115,7 @@ sub process_table {<o:p></o:p></p><p class=MsoPlainText> if (ref $row->[$i] and ref $row->[$i] eq 'ARRAY') { # user types<o:p></o:p></p><p class=MsoPlainText> no warnings 'uninitialized';<o:p></o:p></p><p class=MsoPlainText> $row->[$i] = "(@{[ join ',', @{$row->[$i]} ]})";<o:p></o:p></p><p class=MsoPlainText>- } elsif ($types[$i] eq 'unknown') { # blobs<o:p></o:p></p><p class=MsoPlainText>+ } elsif ($types[$i] eq 'unknown' or $types[$i] eq 'BLOB') { # blobs<o:p></o:p></p><p class=MsoPlainText> $row->[$i] =~ s!(.)! sprintf "<a href="file:///\\\%2503o">\\\\%03o</a>", ord($1) !seg;<o:p></o:p></p><p class=MsoPlainText> } else {<o:p></o:p></p><p class=MsoPlainText> $row->[$i] =~ s!([\x00-\x1f\x5c])! sprintf "<a href="file:///\\x%2502x">\\x%02x</a>", ord($1) !seg;<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>The patch apparently worked for the other guy. When I check the oracle dump, I find the same 'Types' line:<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>-- Types for rhnpackagerepodata: DOUBLE PRECISION BLOB BLOB BLOB DATE DATE copy rhnpackagerepodata(package_id,primary_xml,filelist,other,created,modified) from stdin;<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Any idea's?<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Since I have to scheduled downtime in advance, it's taking me a while to try out your suggestions and make any progress. I appreciated the quickness of your previous responses.<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Cheers,<o:p></o:p></p><p class=MsoPlainText>--james<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>