IVT fail after MDM install
Hi all,
I installed MDM v11 on CentOS 6.5 with Oracle DB 12c using this guide https://www.ibm.com/developerworks/community/wikis/home?lang=ru#!/wiki/W2c3ebf603f05_4460_8e8b_a26780b35b45/page/Installing%20InfoSphere%20MDM%20Version%2011%20on%20Linux%20using%20the%20custom%20installation%20process I have such warnings after install:
Internal error: UID should end with 'E', 'W', or 'I': BOTH_IVT_FAILED
Install Verification Test did not pass. Install Verification Test response files are located at '/opt/IBM/MDM/E550/mdm/IVT/testCases/xml/response', '/opt/IBM/MDM/E550/mdm/IVT/testCases/xml_virtual/response'. Physical and Virtual MDM Install Verification Test did not pass. Please re-run Install Verification Test manually.
I attached installation manager log with this warnings.
I tried to re-rerun IVT:
[wsadmin@ibmmdmv11 IVT]$ ./TestClient.sh soap testCases/xml/ mdmadmin mdmadmin
./TestClient.sh: line 25: [: soap: integer expression expected
./TestClient.sh: line 47: [: /opt/IBM/WebSphere/AppServer: integer expression expected
The WAS security is enabled.
url: file:/opt/IBM/MDM/E550/mdm/IVT/lib/com.ibm.mdm.clientutils.ivt.jar
properties load path: /opt/IBM/MDM/E550/mdm/IVT/properties/TestClient.properties
Nothing happened after this output, script just hangs, so I killed it.
Also I found log MDM_HOME/logs/database/Virtual/mad_ant_bootstrap_datasource.log:
Running ODBC SQL statement [select 1 from dual;]...
Executing /opt/IBM/MDM/E550/mdm/mds/bin/madsql
/opt/IBM/MDM/E550/mdm/mds/bin/madsql: STATE=HY000, CODE=28040, MSG=[InitiateSystems][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol
Return Code: 1, Time elapsed: 0.467 sec
So, does MDM v11 support Oracle 12c? Maybe I should switch to version 11gR2?
Best regards,
Evgeniy
Hi Evgeniy.
Please be adviced MDM v11 does not support Oracle 12c. For MDM v11 you have to use oracle version 11gR2.
Oracle 12c support is available in a MDM v11.3. MDM v11.3 released a few weeks ago.
Thanks for your reply
I installed 11gR2 instead of 12c, but error still remains the same. I found this bug http://www-01.ibm.com/support/docview.wss?uid=swg1IC99966 But I don't know how to apply it to my problem.
Please email me the following logs to investigate the problem.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a standard set of logs we ask for MDM11.0/11.3 installation troubleshooting
$HOME/var/ibm/InstallationManager/logs
(Make sure you zip and attache everything what is in $HOME/var/ibm/InstallationManager/logs folder, for example
run $jar -cvf mdm_installer_logs.zip $HOME/var/ibm/InstallationManager/logs
then attache mdm_installer_logs.zip to email or PMR.
<MDM_HOME>/mds/logs
<MDM_HOME>/logs/database
<MDM_HOME>/IVT/logs
<MDM_HOME>/IVT/testCases/xml/response
<MDM_HOME>/IVT/testCases/xml_virtual/response
WAS server SystemOut.log, SystemErr.log, ffdc folder
(Please use zip or tar for archiving logs and do not use any Windows specific archives, which can't be used on Linux)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I received MDMv11 installation logs. See my respond in attached doc.
Hi,
You can run as per below. Please go to MDM\MDS\Scripts and run the following command.
madconfig.bat list_datasources will give you the DSN name like
C:\IBM\MDM\mds\scripts>madconfig.bat list_datasources
Buildfile: build.xml
Trying to override old definition of task EncryptDBPassword
Trying to override old definition of task CreateDBObjects
madenv_init:
madenv_exec_init:
madenv_odbc_driver_init:
list_datasources:
MDMDB_E001 - IBM Infosphere MDM DB2 Wire Driver (A4E02261F9D7FD9CC81005F60876711
C)
run the following
madconfig.bat test_datasource -Dmad.db.name=MDMDB -Dmad.db.dsn=MDMDB_E001
Response:
C:\IBM\MDM\mds\scripts>madconfig.bat test_datasource -Dmad.db.name=MDMDB -Dmad.d
b.dsn=MDMDB_E001
Buildfile: build.xml
Trying to override old definition of task EncryptDBPassword
Trying to override old definition of task CreateDBObjects
madenv_init:
madenv_exec_init:
madenv_odbc_driver_init:
test_datasource:
Running ODBC SQL statement [select 1 from sysibm.sysdummy1;]...
Executing C:\IBM\MDM\mds\bin\madsql.exe
1
Return Code: 0, Time elapsed: 2.542 sec
BUILD SUCCESSFUL