SYMPTOM
Error occurred when trying to create Metadata shell on MySQL database from Strategy 10.4 on Linux.
But there is no problem to connect to MySQL database.
And checking the database, all tables are created correctly.
Below errors can be found in MACfgWiz.xml log.
Message1:
Error:
Ignoring failed drop table SQL execution. DROP TRIGGER DSSMDOBJTRIG
Stack Trace: java.sql.SQLException: Execute Query failed.
Message 2:
Configuration Wizard Bridge is not available
Stack Trace: com.Strategy.tools.macfgwiz.backbone.base.ConfigurationException: Configuration Wizard bridge for Windows is not available.
Message 3:
Internal Exception caught!
Stack Trace: com.Strategy.web.objects.admin.serverconfig.ServerConfigException: (Internal System Error : Exception detected in XMLRequest :: Execute. host's address is not a valid AF_INET or AF_INET6 address)
Here Message 1 and Message 2 are not related and can be ignored.
Only Message 3 is related to this issue.
CAUSE
This might be caused by the incorrect host name setting in specific environment.
The host defined in Hostname is not the same with the one in /etc/hosts so that it causes host resolution problem for MySQL server.
ACTION
Correct the host name settings and recreate the metadata shell from scratch although the tables may be created already.
