2 Replies Latest reply on Nov 21, 2011 2:57 PM by 901334

    OGG Extract process abended with error 600 - VAM Client Report <CAUSE OF FA

    akatoracle
      Hi,

      Trying to setup GG from source Mysql to Target oracle 11g.

      After setting up with initial setup and definitions ,starting of extract process at mysql failing with following error message.

      =

      010-11-10 20:41:24 INFO OGG-01229 Oracle GoldenGate Manager for MySQL, mgr.prm: Connected to [::ffff:127.0.0.1]:7809.
      2010-11-10 20:41:24 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, mgr.prm: Command received from GGSCI on host[::ffff:127.0.0.1] (START EXTRACT EMASTR ).
      2010-11-10 20:41:25 INFO OGG-00992 Oracle GoldenGate Capture for MySQL, emastr.prm: EXTRACT EMASTR starting.
      2010-11-10 20:41:25 INFO OGG-00993 Oracle GoldenGate Capture for MySQL, emastr.prm: EXTRACT EMASTR started.
      2010-11-10 20:41:25 INFO OGG-01055 Oracle GoldenGate Capture for MySQL, emastr.prm: Recovery initialization completed for target file ./dirdat/em000006, at RBA 948.
      2010-11-10 20:41:25 INFO OGG-01478 Oracle GoldenGate Capture for MySQL, emastr.prm: Output file ./dirdat/em is using format RELEASE 10.4.
      2010-11-10 20:41:25 INFO OGG-01026 Oracle GoldenGate Capture for MySQL, emastr.prm: Rolling over remote file ./dirdat/em000006.
      2010-11-10 20:41:25 INFO OGG-01053 Oracle GoldenGate Capture for MySQL, emastr.prm: Recovery completed for target file ./dirdat/em000007, at RBA 948.
      2010-11-10 20:41:25 INFO OGG-01057 Oracle GoldenGate Capture for MySQL, emastr.prm: Recovery completed for all targets.
      2010-11-10 20:41:25 INFO OGG-00182 Oracle GoldenGate Capture for MySQL, emastr.prm: VAM API running in single-threaded mode.
      2010-11-10 20:41:25 INFO OGG-01515 Oracle GoldenGate Capture for MySQL, emastr.prm: Positioning to begin time Aug 18, 2010 8:53:43 PM.
      2010-11-10 20:41:25 ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, emastr.prm: VAM function VAMInitialize returned unexpected result:
      error 600 - VAM Client Report <CAUSE OF FAILURE : Failed to get file statistics WHEN FAILED : While initializing Last Modified time vs FileName HashMap WHERE FAILED :
      MySQLBinLog Reader Module CONTEXT OF FAILURE : No Information Available!>.
      2010-11-10 20:41:25 ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, emastr.prm: PROCESS ABENDING.

      =

      Please review and let me know in case of any clarification.

      Thanks
        • 1. Re: OGG Extract process abended with error 600 - VAM Client Report <CAUSE OF FA
          user13726806
          I fought with this ( ERROR OGG-00146 VAM function VAMInitialize returned unexpected result: error 600 - VAM Client Report <CAUSE OF FAILURE : Failed to get file statistics
          WHEN FAILED : While initializing Last Modified time vs FileName HashMap
          WHERE FAILED : MySQLBinLog Reader Module
          CONTEXT OF FAILURE : No Information Available!>.)
          for a while until I discovered that I had more binlogs in the binlog.index file than actual files. I had been clearing binlogs based on age with a find command. I'm moving to using the purge binary logs mysql command to do this as it updates the binlog.index also. Note: MySQL recommends you NOT manually edit the binlog.index while MySQL is up as it may "confuse" mysql.
          • 2. Re: OGG Extract process abended with error 600 - VAM Client Report <CAUSE OF FA
            901334
            Hi All,

            Facing the extact same error and unable to get around it. I am using OGG 11.1 and MySQL 5.5. MySQL is running on our windows 7 enterprise edition and Windox XP enviornment , same issues in both the enviroment.

            Any help is highly appreciated.

            Thanks in advance.

            -Ron