Return
-
Title
Gettting error after setting the Stat Central Agent to work with DB2 Support -
Description
Gettting error after setting the Stat Central Agent to work with DB2 Support, following the Stat Installation instructions. -
Cause
In order to communicate properly with PeopleSoft in DB2 databases, the Stat Central Agent needs to work with DB2 Support, however if your DB2 database is not in a z/OS Mainframe then we will get this error message:
ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 29) JBAS014613: Operation ("add") failed - address: ([("subsystem" => "datasources"),("jdbc-driver" => "ibmJDBCDriver")]) - failure description: "JBAS010441: Failed to load module for driver [com.ibm.db2.jcc]"
-
Resolution
There are three jar files in the module.xml found in the <STAT_HOME>\app\modules\com\ibm\db2\jcc\main\module.xml
1 - db2jcc.jar2 - db2jcc_license_cisuz.jar3 - db2jcc_license_cu.jarIf your DB2 database is not on a z/OS Mainframe, then we do not need the (db2jcc_license_cisuz.jar), so in this case, the module.xml should look like this:<module xmlns="urn:jboss:module:1.1" name="com.ibm.db2.jcc"><resources><resource-root path="db2jcc.jar"/><!-- <resource-root path="db2jcc_license_cisuz.jar"/> --><resource-root path="db2jcc_license_cu.jar"/><!-- Insert resources here --></resources> …Then you can restart the Stat Central Agent and the error message will disappear.