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

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
    ACCEPTED ANSWER

    Re: itic 7.2.2 datasource query failed

    ‏2011-10-06T09:51:41Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: itic 7.2.2 datasource query failed

      ‏2012-03-01T09:28:54Z  in response to SystemAdmin
      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
        ACCEPTED ANSWER

        Re: itic 7.2.2 datasource query failed

        ‏2012-03-01T10:18:38Z  in response to SystemAdmin
        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
    ACCEPTED ANSWER

    Re: itic 7.2.2 datasource query failed

    ‏2012-05-01T09:15:46Z  in response to SystemAdmin
    Hi,

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

    Thanks in advance
  • clopez
    clopez
    1 Post
    ACCEPTED ANSWER

    Re: itic 7.2.2 datasource query failed

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

      Re: itic 7.2.2 datasource query failed

      ‏2013-01-24T08:46:29Z  in response to clopez
      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
        ACCEPTED ANSWER

        Re: itic 7.2.2 datasource query failed

        ‏2013-01-24T10:07:03Z  in response to HMSalman
        Hi,
        Issue resolved after correct the database name
        • RewanthReddy
          RewanthReddy
          1 Post
          ACCEPTED ANSWER

          Re: itic 7.2.2 datasource query failed

          ‏2013-07-29T12:31:30Z  in response to HMSalman

          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)