Blank Schema comparison HTML reports through command line

gahuja

Hi

all my reports for oracle schema comparison are coming as blank when i run through command line

Also from GUI occasionally I'm getting below error whicl generating HTML report

'.',hexadecimal value 0x07,is an invalid character....I"m not sure if it's the same error in the background and the front end

but mainly i need report from commandline...I'm giving the error from GUI for reference in case it helps

below is the syntax and the output message

M:>"C:Program FilesRed GateSchema Compare for Oracle 3sco32" -source star_ro_user/XXXXXXX@qnyb3r70{STAGING} -target star_ro_user/XXXXXXXX@DNYB3R10{STAGING} /report:"M:Report_STAGING.html" -reporttype:Simple /reportselectedobjects /script-file "M:Script_STAGING.sql" -behavior script-header -behavior define-off

Schema Compare for Oracle: activated, edition: standard, serial number: XXXXXXXXXX
Schemas found STAGING
Schemas found in Target STAGING
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 667 differences
Generating report
Calculating dependencies
Finding issues with deployment
Preparing actions
Generating actions
Creating script text

PhilScrace

Thanks very much for notifying us of this problem. We have reproduced your problem and will provide you with a link to a build which contains the fix. We really appreciate you helping us to improve the Oracle product.
Regards

Phil Scrace
Test Engineer Oracle Deployement Suite

gahuja

Thanks Phil

I'll really appreciate if you can give the timeline by when you will be able to provide the build

I'm working on project so need to plan accordingly

Thanks
Gagan

PhilScrace

Having played around with this a little more it appears that this is not a bug in the sense that there is a problem with the tool; if one removes the '/reportselectedobjects' switch the report will be populated with ALL changes. To populate the scripts file one must use the '/deploy' switch.

If our documentation is unclear or misleading we will definitely change it:

http://documentation.red-gate.com/displ ... +interface

Please do let me know.

gahuja

Hello

Now I'm getting the below error which I get while doing comparison from the GUI also alll the time

also the HTML report generated now is not blank but failed with below error

Also please confirm that without /deploy switch I'll not be able to create deployment script? I repeat I don't want to deply the changes but only want the HTML report and deployment script to be created

"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: XXXXXXXXXXXXXXXXX
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
C:Usersgahuja4>

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

We've dealt with this elsewhere (fixed it) see viewtopic.php?f=118&t=77872