Blank Schema comparison HTML reports through command line

• 
  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

  PhilScrace November 03, 2014 05:23

  - 0 +
• 
  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

  gahuja November 03, 2014 05:58

  - 0 +
• 
  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.

  PhilScrace November 03, 2014 06:07

  - 0 +
• 
  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 November 03, 2014 06:53

  - 0 +
• 
  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

  gahuja November 03, 2014 21:33

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

  richardjm November 06, 2014 05:38

  - 0 +

Add comment

Please sign in to leave a comment.