Hi,
When i executed mapping receive:
[ERROR] Error in callMethod, message=Your database is offline/inaccessible or your database server credentials are incorrect or have expired. Please contact your IBM BigFix Analytics administrator or refer to tema.log for more information.
, url: https://172.16.3.218:9081/api/sam/software_facts.json?criteria={“or”:[[“computer_id”,"=",“1”],[“computer_id”,"=",“2”],[“computer_id”,"=",“3”],[“computer_id”,"=",“4”],[“computer_id”,"=",“5”],[“computer_id”,"=",“6”]]}&columns[]=computer_id&columns[]=discoverable_guid&columns[]=catalog_dimension.software_title_name&columns[]=catalog_dimension.publisher_name&columns[]=catalog_dimension.software_title_version_name&columns[]=catalog_dimension.software_title_release_name&columns[]=catalog_dimension.version&columns[]=first_used&columns[]=last_used&columns[]=valid_from&columns[]=valid_to&columns[]=updated_at&columns[]=signature_count&columns[]=total_time&columns[]=total_runs&columns[]=avg_run_time&columns[]=avg_runs_per_day&columns[]=process&columns[]=deleted
Try this URL in Web Browser, you may need to login to SUA first
02 Mai 2017 16:33:33:921 [ERROR] Exception in callMethod, class=java.io.IOException, message=null, url: https://172.16.3.218:9081/api/sam/software_facts.json?criteria={“or”:[[“computer_id”,"=",“1”],[“computer_id”,"=",“2”],[“computer_id”,"=",“3”],[“computer_id”,"=",“4”],[“computer_id”,"=",“5”],[“computer_id”,"=",“6”]]}&columns[]=computer_id&columns[]=discoverable_guid&columns[]=catalog_dimension.software_title_name&columns[]=catalog_dimension.publisher_name&columns[]=catalog_dimension.software_title_version_name&columns[]=catalog_dimension.software_title_release_name&columns[]=catalog_dimension.version&columns[]=first_used&columns[]=last_used&columns[]=valid_from&columns[]=valid_to&columns[]=updated_at&columns[]=signature_count&columns[]=total_time&columns[]=total_runs&columns[]=avg_run_time&columns[]=avg_runs_per_day&columns[]=process&columns[]=deleted
Try this URL in Web Browser, you may need to login to SUA first
java.io.IOException
at com.mro.fusion.dbInterface.temsua.TEMSUAConnection.callMethod(TEMSUAConnection.java:1281)
at com.mro.fusion.dbInterface.temsua.TEMSUAConnection.getSoftware(TEMSUAConnection.java:672)
at com.mro.fusion.providerInterface.TEMSUA20Provider.getComputer(TEMSUA20Provider.java:523)
at com.mro.fusion.providerInterface.TEMSUA20Provider.getInstance(TEMSUA20Provider.java:595)
at com.mro.fusion.om.DataSource.getInstance(DataSource.java:856)
at com.mro.fusion.engine.EngInstanceCursor.(EngInstanceCursor.java:148)
at com.mro.fusion.engine.EngInstanceCursor.createNew(EngInstanceCursor.java:319)
at com.mro.fusion.engine.EngMapper.performMap(EngMapper.java:828)
at com.mro.fusion.engine.EngMapper.performMap(EngMapper.java:238)
at com.mro.fusion.engine.EngineMain.go(EngineMain.java:1617)
at com.mro.fusion.engine.EngineMain.go(EngineMain.java:462)
at com.mro.fusion.engine.EngineMain.initialize(EngineMain.java:1818)
at com.mro.fusion.engine.EngineMain.(EngineMain.java:233)
at com.mro.fusion.engine.EngineMain.doMain(EngineMain.java:573)
at com.mro.fusion.engine.EngineMain.main(EngineMain.java:422)
*
Done
02 Mai 2017 16:33:33:927 [ERROR]
Error Number: 1
Error Message: Data source query failed
Error occurred during: Retrieving instance(s)
Error occurred in: DataSource.getInstance()
Operation failed on: Target Class: Deployed Asset, Target Parent Class: root
Read Data Source: IBM_SUA2.2150, Class: Computer, Parent Class: null
Error resolution action: Class skipped due to error
02 Mai 2017 16:33:33:928 [ERROR]
Error Message: Internal error
java.io.IOException
Error trace:
com.mro.fusion.providerInterface.TEMSUA20Provider.getInstance(TEMSUA20Provider.java:702)
com.mro.fusion.om.DataSource.getInstance(DataSource.java:856)
com.mro.fusion.engine.EngInstanceCursor.(EngInstanceCursor.java:148)
com.mro.fusion.engine.EngInstanceCursor.createNew(EngInstanceCursor.java:319)
com.mro.fusion.engine.EngMapper.performMap(EngMapper.java:828)
com.mro.fusion.engine.EngMapper.performMap(EngMapper.java:238)
com.mro.fusion.engine.EngineMain.go(EngineMain.java:1617)
com.mro.fusion.engine.EngineMain.go(EngineMain.java:462)
com.mro.fusion.engine.EngineMain.initialize(EngineMain.java:1818)
com.mro.fusion.engine.EngineMain.(EngineMain.java:233)
com.mro.fusion.engine.EngineMain.doMain(EngineMain.java:573)
com.mro.fusion.engine.EngineMain.main(EngineMain.java:422)
02 Mai 2017 16:33:33:936 [INFO]
Mapping execution completed
Mapping: IEMtoSCCD
Execution time: 00:00:50
Deployed Assets created: 0
Records created: 0
Records updated: 0
Records deleted: 0
Errors: 1
NRS GUIDs created: 0
NRS errors: 0
NRS records updated on Alternate Keys: 0
NRS records found as duplicate: 0
NRS records deleted because of duplicate: 0
NRS warnings due to duplicate data: 0
========================================================
Done
Mapping execution completed.
Some errors occured.
See log file for details.
Mapping execution terminated.
02 Mai 2017 16:33:33:945 [FATAL] Mapping execution terminated.
Integration Composer has finished.