Table of Contents

Search

  1. Preface
  2. PWX-10000 to PWX-10999
  3. PWX-11000 to PWX-15999
  4. PWX-16000 to PWX-23999
  5. PWX-25000 to PWX-35999
  6. PWX-36000 to PWX-36999
  7. PWX-37100 to PWX-37999
  8. PWX-38500 to PWX-38999
  9. DTL_BMG003 to DTL_RPS105I
  10. infacmd pwx Error Messages
  11. PWXPC Error Messages
  12. Abend, Return, and Reason Codes in PowerExchange Messages

Message Reference Volume 2

Message Reference Volume 2

PWX-37432

PWX-
37432

Error: Connection to DDL catalog tables in schema
schema_name
on MySQL server
server_name
failed. Connection attempt used user name
user_name
and password
password
.
PowerExchange could not connect to the catalog tables that store DDL changes for registered MySQL source tables by using the specified MySQL server name, catalog schema name, user name, and password.
MySQL change capture processing fails to start.
Ensure that any CATSCHEMA, CATSERVER, CATUSERNAME, and CATPASSWORD parameter values specified in the MYSQL CAPI_CONNECTION statement are correct. If the optional CATSERVER, CATUSERNAME, and CATPASSWORD parameters are not specified, PowerExchange uses the source database server name, user name, and password. Also verify that the catalog tables were created within the specified schema and that the specified user credentials have authority to connect to the server and catalog tables. For more information, see the preceding ODBC messages related to this error.

0 COMMENTS

We’d like to hear from you!