'.',hexadecimal value 0x07,is an invalid character

gahuja

Hi Phil
Below error is coming all the time creating schema comparison HTML simple report from GUI and command line,please help

'.',hexadecimal value 0x07,is an invalid character

Please see complete log below

C:Program FilesRed GateSchema Compare for Oracle 3sco32" -source star_ro_user/STAR_RO_USER@qnyb3r70{WEB} -target star_ro_user/STAR_RO_USER@DNYB3R10{WEB} /report:"M:Report_WEB.html" -reporttype:Simple /script-file "M:Script_WEB.sql" -behavior script-header -behavior define-off

Schema Compare for Oracle: activated, edition: standard, serial number:XXXXXXXXXX

Schemas found WEB
Schemas found in Target WEB
Checking that DataSources can be parsed
Checking Source star_ro_user/STAR_RO_USER@qnyb3r70 can be parsed
Parsing datasource string star_ro_user/STAR_RO_USER@qnyb3r70
Split DataSource into 3 components
star_ro_user | STAR_RO_USER | qnyb3r70
DataSource star_ro_user/STAR_RO_USER@qnyb3r70 is a TNS Connection
Looking for TNS name qnyb3r70 in Oracle home OraHome112_32
No TNS Entry for qnyb3r70 found, trying to connect using Oracle home OraHome112_32
Connection String = Data Source=qnyb3r70;User Id=star_ro_user;Password=STAR_RO_USER;Connection Timeout=60;Pooling=false;Unicode=true;
Checking Target star_ro_user/STAR_RO_USER@DNYB3R10 can be parsed
Parsing datasource string star_ro_user/STAR_RO_USER@DNYB3R10
Split DataSource into 3 components
star_ro_user | STAR_RO_USER | DNYB3R10
DataSource star_ro_user/STAR_RO_USER@DNYB3R10 is a TNS Connection
Looking for TNS name DNYB3R10 in Oracle home OraHome112_32
No TNS Entry for DNYB3R10 found, trying to connect using Oracle home OraHome112_32
Connection String = Data Source=DNYB3R10;User Id=star_ro_user;Password=STAR_RO_USER;Connection Timeout=60;Pooling=false;Unicode=true;
Reading dependency information
Registering database one
Registering database two
Comparing databases
Found 1061 differences
Generating report
Error: '', hexadecimal value 0x07, is an invalid character
Use -? for help

richardjm

I've just replied to your support ticket.

We believe this is some issue with our transform encountering invalid xml characters but we've so far failed to reproduce this.

Snapshots of the offending databases that exhibit the issue will help us track this down.

richardjm

I've replied to the customer via our support inbox but for reference I've fixed the issue which is related to the BEL character being used in a comment to represent a bullet.

This fix will be in the next release.