Blank Schema comparison HTML reports through command line

gahujagahuja Posts: 33
edited November 6, 2014 5:38AM in Schema Compare for Oracle
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

Comments

  • 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
  • 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
  • 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.
  • gahujagahuja Posts: 33
    edited November 3, 2014 9:43PM
    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>
  • 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
  • We've dealt with this elsewhere (fixed it) see viewtopic.php?f=118&t=77872
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
Sign In or Register to comment.