[Spacewalk-list] Malformed utf-8 character in oracle db

[Silvio.Schanz at elektrobit.com]

Hi Sascha,

I hit the same error within my oracle to postgres migration and 
I found your message with a little websearch for this error.

This little quick and dirty hack solved the problem for me:

1. Login to the Oracle-Webgui 
2. Start the Object Browser
3. Navigate to "rhnpackagechangelogdata"
3. Take a look at my broken export (It stopped at id 1238746)
4. Query the id 1238746 and its data.
5. Changed the text to "20080717-1 More cyrillic coverage"
6. Apply the changes

After these steps the export was successful. 

Regards,
  Silvio

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Sascha Bendix
Sent: Wednesday, June 22, 2011 2:08 PM
To: 'spacewalk-list at redhat.com'
Subject: Re: [Spacewalk-list] Malformed utf-8 character in oracle db

Hi,

first of sorry for the long delay on this topic.

Michael Mráka wrote:
> % > Currently I get during the spacewalk-dump-schema the following
> message:
> % > Malformed UTF-8 character (fatal) at 
> /usr/bin/spacewalk-dump-schema line % > 121.
> % >
> % > It seems that there is a non-UTF-8 encoded character in somewhere 
> around % > changelog entry 685488. Could that be the case?
>
> could you check whether this patch fixes your issue?

I'm sorry to say that it didn't fix it. Still get the same error:

# spacewalk-dump-schema --db=xe --user=spacewalk --password=XXX ...
686925  Dan Walsh <dwalsh at redhat.com> 3.6.2-5   - Define openoffice as an x_domain      2009-01-15 12:00:00     2011-03-09 11:20:48
Malformed UTF-8 character (fatal) at /usr/bin/spacewalk-dump-schema line 121.
685488  Nicolas Mailhot <nicolas.mailhot at laposte.net>        

Any other patches I can try?

Regards,

Sascha


--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.


_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list


----------------------------------------------------------------
Please note: This e-mail may contain confidential information
intended solely for the addressee. If you have received this
e-mail in error, please do not disclose it to anyone, notify
the sender promptly, and delete the message from your system.
Thank you.