Some information about my environment:
TAD4D uses, as it must be, DB2 database.
TAMIT uses a SQL server 2008 database.
I followed the instructions showed in TAMIT infocenter to create the data sources, the mapping and loading the TAD4D72toDPA72.fsn to use those expressions and mapping settings.
But when I execute the command line executeMapping with all the required parameters, the following error shows:
======================================================== Start mapping execution Mapping: TADD-to-TAMIT ======================================================== 21 Sep 2011 16:26:42:400 [ERROR] -------------------------------- Error Number: 1 Error Message: Data source query failed Error occurred during: Retrieving class instances Error occurred in: DataSource.getClassInstances() Operation failed on: Target Class: Deployed Asset, Target Parent Class: root Read Data Source: TADD722, Class: Node, Parent Class: null SQL being executed: select t2467.nodevm_id from tlmsrv.nodevm_v t2467 order by t2467.DEPTH Error resolution action: Class skipped due to error 21 Sep 2011 16:26:42:400 [ERROR] Error Message: Data source query failed DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=TLMSRV.NODEVM_V, DRIVER=3.53.70 Error occurred during: Executing a prepared statement query Error occurred in: JDBCConnection._query() SQL being executed: select t2467.nodevm_id from tlmsrv.nodevm_v t2467 order by t2467.DEPTH Error trace: com.mro.fusion.dbInterface.jdbc.JDBCConnection._query(Unknown Source) com.mro.fusion.dbInterface.jdbc.JDBCConnection.query(Unknown Source) com.mro.fusion.providerInterface.Provider.executeQuery(Unknown Source) com.mro.fusion.providerInterface.Provider.getClassInstance(Unknown Source) com.mro.fusion.om.DataSource.getClassInstances(Unknown Source) com.mro.fusion.engine.EngInstanceCursor.<init>(Unknown Source) com.mro.fusion.engine.EngInstanceCursor.createNew(Unknown Source) com.mro.fusion.engine.EngMapper.performMap(Unknown Source) com.mro.fusion.engine.EngMapper.performMap(Unknown Source) com.mro.fusion.engine.EngineMain.go(Unknown Source) com.mro.fusion.engine.EngineMain.go(Unknown Source) com.mro.fusion.engine.EngineMain.initialize(Unknown Source) com.mro.fusion.engine.EngineMain.<init>(Unknown Source) com.mro.fusion.engine.EngineMain.doMain(Unknown Source) com.mro.fusion.engine.EngineMain.main(Unknown Source)
I can log in to ITIC (startFusion.bat) and look to the data sources and mappings by using the same user/password combination that I am using with the executeMapping.bat command. So the problem might now be related to credentials.
Am I missing some step to make the integration? Any idea about what I can do to solve it?
Thanks in advance. Regards. Andres.