Topic
  • 8 replies
  • Latest Post - ‏2013-07-29T12:31:30Z by RewanthReddy
SystemAdmin
SystemAdmin
57 Posts

Pinned topic itic 7.2.2 datasource query failed

‏2011-10-06T08:44:01Z |
hi everyone!

Purpose:
migrate data from one database to another one
Software used:
ITIC 7.2.2
TAD4D 7.2.2.1 (i used before 7.2.2 - error the same)
MAXIMO 7.1
DB2 9.7 with 2 databases tlma & maxdb71

after creating mapping in ITIC and filling in excecutemapping.bat fields
set MAPPINGNAME=mapping3
set REPOSITORYUSER=maximo
set REPOSITORYPWD=pwd
set SOURCEUSER=tlmsrv
set SOURCEPWD=pwd
set TARGETUSER=maximo
set TARGETPWD=pwd

i try to run this bat file to fill maxdb71 database with data i need

then i get an error message:

========================================================
Start mapping execution
Mapping: mapping3
========================================================

06 Oct 2011 03:28:34:532 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: disc2, 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
06 Oct 2011 03:28:34:532 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)
06 Oct 2011 03:28:34:532 INFO
========================================================
Mapping execution completed
Mapping: mapping3
Execution time: 00:00:00
nulls created: 0
Records created: 0
Records updated: 0
Records deleted: 0
Errors: 1

NRS GUIDs created: 0
NRS records updated on Alternate Keys: 0
NRS records found as duplicate: 0
NRS records deleted because of duplicate: 0
========================================================

06 Oct 2011 03:28:34:532 FATAL Mapping execution terminated.
__________________________________________________

are any solutions about this problem?

thanks in advance!
Anton.
  • SystemAdmin
    SystemAdmin
    57 Posts

    Re: itic 7.2.2 datasource query failed

    ‏2011-10-06T09:51:41Z  
    Please upgrade ITIC. ITIC supports integration with TAD4D 7.2.2 from 7.2.2 FP1 level (7.2.2.1)

    Also please be advised, that TAMIT should be at least on 7.2.2 level

    Kind regards


    IBM employee
    TAD4D/LMT team
    Although I am an IBM employee, all views and opinions presented are my own.
    Contact product support if you need IBM's official advice.
  • SystemAdmin
    SystemAdmin
    57 Posts

    Re: itic 7.2.2 datasource query failed

    ‏2012-03-01T09:28:54Z  
    Please upgrade ITIC. ITIC supports integration with TAD4D 7.2.2 from 7.2.2 FP1 level (7.2.2.1)

    Also please be advised, that TAMIT should be at least on 7.2.2 level

    Kind regards


    IBM employee
    TAD4D/LMT team
    Although I am an IBM employee, all views and opinions presented are my own.
    Contact product support if you need IBM's official advice.
    I'm having similar problem.

    TAMIT 7.2.2.0
    ITIC 7.2.2 FP2
    TAD4D 7.5

    First error was this:
    
    01 Mar 2012 10:08:33:002 [ERROR] setDatabaseVersion: Exception running query to retrieve database version, will use pre-722 tables.
    


    
    01 Mar 2012 10:09:06:159 [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: TAD4D, Class: Node, Parent Class: 
    
    null SQL being executed:      SQL...   Error resolution action: Class skipped due to error     01 Mar 2012 10:09:06:159 [ERROR] Error Message:           Data source query failed DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=, DRIVER=3.53.70 Error occurred during:   Executing a prepared statement query Error occurred in:       JDBCConnection._query() SQL being executed:   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)
    
  • SystemAdmin
    SystemAdmin
    57 Posts

    Re: itic 7.2.2 datasource query failed

    ‏2012-03-01T10:18:38Z  
    I'm having similar problem.

    TAMIT 7.2.2.0
    ITIC 7.2.2 FP2
    TAD4D 7.5

    First error was this:
    <pre class="jive-pre"> 01 Mar 2012 10:08:33:002 [ERROR] setDatabaseVersion: Exception running query to retrieve database version, will use pre-722 tables. </pre>

    <pre class="jive-pre"> 01 Mar 2012 10:09:06:159 [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: TAD4D, Class: Node, Parent Class: null SQL being executed: SQL... Error resolution action: Class skipped due to error 01 Mar 2012 10:09:06:159 [ERROR] Error Message: Data source query failed DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=, DRIVER=3.53.70 Error occurred during: Executing a prepared statement query Error occurred in: JDBCConnection._query() SQL being executed: 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) </pre>
    OK, I found a solution. Table owner for DB2 doesn't mean Table owner but shema name. Than ITIC creates correct queries.
  • SystemAdmin
    SystemAdmin
    57 Posts

    Re: itic 7.2.2 datasource query failed

    ‏2012-05-01T09:15:46Z  
    Hi,

    I am also facing the same issue while importing data, can anyone help me in this..

    Thanks in advance
  • clopez
    clopez
    1 Post

    Re: itic 7.2.2 datasource query failed

    ‏2012-07-12T20:53:23Z  
    In ITIC, in the definition of the datasource to specify TAD4D7.2 Table Owner = ADM
    Carlos Lopez
    Paraguay
  • HMSalman
    HMSalman
    2 Posts

    Re: itic 7.2.2 datasource query failed

    ‏2013-01-24T08:46:29Z  
    • clopez
    • ‏2012-07-12T20:53:23Z
    In ITIC, in the definition of the datasource to specify TAD4D7.2 Table Owner = ADM
    Carlos Lopez
    Paraguay
    Hi,
    I have same issue in ITIC for TADDM2CCMDB
    Start mapping execution
    Mapping: TADDM-CCMDB-CI
    ========================================================

    24 Jan 2013 10:31:00:846 ERROR
    Error Message: Data source query failed
    DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2ADMIN.MAXVARS, DRIVER=3.53.70
    Error occurred during: Executing a SQL query
    Error occurred in: JDBCConnection._query()
    SQL being executed: select varvalue from DB2ADMIN.maxvars where varname = 'CICLASS'
    Error resolution action: Warned user
    Error trace:
    com.mro.fusion.dbInterface.jdbc.JDBCConnection._query(Unknown Source)
    com.mro.fusion.dbInterface.jdbc.JDBCConnection.query(Unknown Source)
    com.mro.fusion.util.Function.executeSQLStatement(Unknown Source)
    com.mro.fusion.util.Function.executeTargetSQL(Unknown Source)
    com.mro.fusion.util.Function.getColumnFromTarget(Unknown Source)

    24 Jan 2013 10:31:00:846 ERROR

    Error Message: Data source query failed
    DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2ADMIN.SYNONYMDOMAIN, DRIVER=3.53.70
    Error occurred during: Executing a SQL query
    Error occurred in: JDBCConnection._query()
    SQL being executed: select value from DB2ADMIN.synonymdomain where domainid='DATATYPE' and maxvalue='ALN'
    Error resolution action: Warned user
    Error trace:
    com.mro.fusion.dbInterface.jdbc.JDBCConnection._query(Unknown Source)
    com.mro.fusion.dbInterface.jdbc.JDBCConnection.query(Unknown Source)
    com.mro.fusion.util.Function.executeSQLStatement(Unknown Source)
    com.mro.fusion.util.Function.executeTargetSQL(Unknown Source)
    com.mro.fusion.util.Function.getColumnFromTarget(Unknown Source)

    I am also attaching the log for review i have stuck

    Please help me as soon as possible
    I have also open PMR regarding this issue.

    Attachments

  • HMSalman
    HMSalman
    2 Posts

    Re: itic 7.2.2 datasource query failed

    ‏2013-01-24T10:07:03Z  
    • HMSalman
    • ‏2013-01-24T08:46:29Z
    Hi,
    I have same issue in ITIC for TADDM2CCMDB
    Start mapping execution
    Mapping: TADDM-CCMDB-CI
    ========================================================

    24 Jan 2013 10:31:00:846 ERROR
    Error Message: Data source query failed
    DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2ADMIN.MAXVARS, DRIVER=3.53.70
    Error occurred during: Executing a SQL query
    Error occurred in: JDBCConnection._query()
    SQL being executed: select varvalue from DB2ADMIN.maxvars where varname = 'CICLASS'
    Error resolution action: Warned user
    Error trace:
    com.mro.fusion.dbInterface.jdbc.JDBCConnection._query(Unknown Source)
    com.mro.fusion.dbInterface.jdbc.JDBCConnection.query(Unknown Source)
    com.mro.fusion.util.Function.executeSQLStatement(Unknown Source)
    com.mro.fusion.util.Function.executeTargetSQL(Unknown Source)
    com.mro.fusion.util.Function.getColumnFromTarget(Unknown Source)

    24 Jan 2013 10:31:00:846 ERROR

    Error Message: Data source query failed
    DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2ADMIN.SYNONYMDOMAIN, DRIVER=3.53.70
    Error occurred during: Executing a SQL query
    Error occurred in: JDBCConnection._query()
    SQL being executed: select value from DB2ADMIN.synonymdomain where domainid='DATATYPE' and maxvalue='ALN'
    Error resolution action: Warned user
    Error trace:
    com.mro.fusion.dbInterface.jdbc.JDBCConnection._query(Unknown Source)
    com.mro.fusion.dbInterface.jdbc.JDBCConnection.query(Unknown Source)
    com.mro.fusion.util.Function.executeSQLStatement(Unknown Source)
    com.mro.fusion.util.Function.executeTargetSQL(Unknown Source)
    com.mro.fusion.util.Function.getColumnFromTarget(Unknown Source)

    I am also attaching the log for review i have stuck

    Please help me as soon as possible
    I have also open PMR regarding this issue.
    Hi,
    Issue resolved after correct the database name
  • RewanthReddy
    RewanthReddy
    1 Post

    Re: itic 7.2.2 datasource query failed

    ‏2013-07-29T12:31:30Z  
    • HMSalman
    • ‏2013-01-24T10:07:03Z
    Hi,
    Issue resolved after correct the database name

    Hi,

    I am facing following error while importing data from Microsoft SMS 2003 to TAMIT 7.2.2

    27 Jul 2013 00:51:47:989 [ERROR] 
    Error Message:           Data source query failed
                             The connection is closed
    Error occurred during:   Executing a prepared statement query
    Error occurred in:       JDBCConnection._query()
    SQL being executed:      select distinct t92."MACHINEID",t93."INSTANCEKEY",t93."CurrentTimeZone0",t93."Description0",t93."Domain0",t93."DomainRole00",t93."Manufacturer00",t93."Model0",t93."Name0",t93."NumberOfProcessors00",t93."PauseAfterReset00",t93."Roles0",t93."Status0",t93."SystemType00",t93."UserName0" from dbo.MACHINEGROUPXREF t92,dbo.Computer_System_DATA t93, dbo.MACHINEGROUPXREF t5 where (t5."MACHINEID"=?) and (t92.GROUPKEY=44 AND t92.ArchitectureKey=5) and (t92."MACHINEID"=t93."MACHINEID") and (t5."MACHINEID"=t92."MACHINEID" and t5."MACHINEID"=t93."MACHINEID")
    Values: |MACHINEID=2079528|
    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.getAllInstances(Unknown Source)
    com.mro.fusion.providerInterface.Provider.getAllInstances(Unknown Source)
    com.mro.fusion.providerInterface.Provider.getDistinctAllInstances(Unknown Source)
    com.mro.fusion.providerInterface.SMS20Provider.getAllInstances(Unknown Source)
    com.mro.fusion.om.DataSource.getAllInstances(Unknown Source)
    com.mro.fusion.engine.EngInstanceCursorGetAll.<init>(Unknown Source)
    com.mro.fusion.engine.EngInstanceCursor.createNew(Unknown Source)
    com.mro.fusion.engine.EngMapper.prepareSourceInstance(Unknown Source)
    com.mro.fusion.engine.EngMapper.prepareSourceInstancesForTarget(Unknown Source)
    com.mro.fusion.engine.EngMapper.createTargetInstance(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)