[Error] Integration between ICD and Bigfix Inventory

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.

1 Like

Can you login to the ITIC GUI and verify that your BigFix Inventory credentials work there?

Yes, before execute mapping, i set up data sources in ITIC GUI, and the credentials was correct.

I suggest that you enable Debug level logging

log4j.logger.fusion.provider.temsuaapi=DEBUG

in the data/properties/logging.properties file.

Hi,

I have BigFix Platform 9.5.4 with Inventory 9.2.7.0 in DB2 10.5f5 and CD 7.6.0.2.

When i run with DEBUG i receive more information but…:

            Start mapping execution
            Mapping: teste2

========================================================

05 Mai 2017 09:45:29:716 [INFO] calling getAllComputerKeys()
05 Mai 2017 09:45:29:716 [INFO] calling method - api/import_status.json
05 Mai 2017 09:45:29:716 [INFO] REQUEST_URL: https://172.16.3.218:9081/api/import_status.json
05 Mai 2017 09:45:41:330 [INFO] calling method - api/sam/computers.json
05 Mai 2017 09:45:41:331 [INFO] REQUEST_URL: https://172.16.3.218:9081/api/sam/computers.json?columns[]=id&columns[]=name&
05 Mai 2017 09:45:54:478 [INFO] calling getComputers() - ids=[1, 2, 3, 4, 5, 6, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 87, 107, 111, 127, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 172, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198]
05 Mai 2017 09:45:54:479 [INFO] lengthForCriteria=7809
05 Mai 2017 09:45:54:479 [INFO] calling method - api/sam/computers.json
05 Mai 2017 09:45:54:479 [INFO] REQUEST_URL: https://172.16.3.218:9081/api/sam/computers.json?criteria={“or”:[[“id”,"=",“1”],[“id”,"=",“2”],[“id”,"=",“3”],[“id”,"=",“4”],[“id”,"=",“5”],[“id”,"=",“6”],[“id”,"=",“21”],[“id”,"=",“22”],[“id”,"=",“23”],[“id”,"=",“24”],[“id”,"=",“25”],[“id”,"=",“26”],[“id”,"=",“27”],[“id”,"=",“28”],[“id”,"=",“29”],[“id”,"=",“30”],[“id”,"=",“31”],[“id”,"=",“32”],[“id”,"=",“33”],[“id”,"=",“34”],[“id”,"=",“35”],[“id”,"=",“36”],[“id”,"=",“37”],[“id”,"=",“38”],[“id”,"=",“39”],[“id”,"=",“40”],[“id”,"=",“41”],[“id”,"=",“42”],[“id”,"=",“43”],[“id”,"=",“44”],[“id”,"=",“45”],[“id”,"=",“46”],[“id”,"=",“47”],[“id”,"=",“87”],[“id”,"=",“107”],[“id”,"=",“111”],[“id”,"=",“127”],[“id”,"=",“130”],[“id”,"=",“131”],[“id”,"=",“132”],[“id”,"=",“133”],[“id”,"=",“134”],[“id”,"=",“135”],[“id”,"=",“136”],[“id”,"=",“137”],[“id”,"=",“138”],[“id”,"=",“139”],[“id”,"=",“140”],[“id”,"=",“141”],[“id”,"=",“146”],[“id”,"=",“147”],[“id”,"=",“148”],[“id”,"=",“149”],[“id”,"=",“150”],[“id”,"=",“151”],[“id”,"=",“152”],[“id”,"=",“153”],[“id”,"=",“154”],[“id”,"=",“155”],[“id”,"=",“156”],[“id”,"=",“157”],[“id”,"=",“158”],[“id”,"=",“159”],[“id”,"=",“160”],[“id”,"=",“161”],[“id”,"=",“162”],[“id”,"=",“163”],[“id”,"=",“164”],[“id”,"=",“165”],[“id”,"=",“166”],[“id”,"=",“167”],[“id”,"=",“168”],[“id”,"=",“169”],[“id”,"=",“170”],[“id”,"=",“172”],[“id”,"=",“174”],[“id”,"=",“175”],[“id”,"=",“176”],[“id”,"=",“177”],[“id”,"=",“178”],[“id”,"=",“179”],[“id”,"=",“180”],[“id”,"=",“181”],[“id”,"=",“182”],[“id”,"=",“183”],[“id”,"=",“184”],[“id”,"=",“185”],[“id”,"=",“186”],[“id”,"=",“187”],[“id”,"=",“188”],[“id”,"=",“189”],[“id”,"=",“190”],[“id”,"=",“191”],[“id”,"=",“192”],[“id”,"=",“193”],[“id”,"=",“194”],[“id”,"=",“195”],[“id”,"=",“196”],[“id”,"=",“197”],[“id”,"=",“198”]]}&columns[]=id&columns[]=remote_id&columns[]=datasource_name&columns[]=dns_name&columns[]=name&columns[]=last_seen&columns[]=os&columns[]=ip_address
05 Mai 2017 09:46:01:253 [DEBUG] IEMSchemaFactory:cleanupEmptySubclasses(Long,Map) ENTRY
05 Mai 2017 09:46:01:254 [DEBUG] IEMSchemaFactory:cleanupEmptySubclasses(Long,Map) NOTE outputComputer after cleanup:{Name=srv-bigfix-prd, TCPIP=[{Ip address=172.16.3.218}, {Ip address=192.168.122.1}], Operating System=[{Os=Linux Red Hat Enterprise Server 7.3 (3.10.0-514.el7.x86_64), Manufacturer=Red Hat, Os name=Linux Red Hat Enterprise Server 7.3 (3.10.0-514.el7.x86_64)}], Remote id=7533781, Last seen=2017-05-04 23:01:25.0, Dns name=srv-bigfix-prd.incm.int, Id=1, Datasource name=Data Source}
05 Mai 2017 09:46:01:254 [DEBUG] IEMSchemaFactory:cleanupEmptySubclasses(Long,Map) EXIT
05 Mai 2017 09:46:01:255 [DEBUG] IEMSchemaFactory:cleanupEmptySubclasses(Long,Map) ENTRY
05 Mai 2017 09:46:01:255 [DEBUG] IEMSchemaFactory:cleanupEmptySubclasses(Long,Map) NOTE outputComputer after cleanup:{Name=DSI-PRG-AD01, TCPIP=[{Ip address=172.16.12.214}], Operating System=[{Os=Win7 6.1.7601, Manufacturer=Microsoft, Os name=Win7 6.1.7601}], Remote id=6558604, Last seen=2017-05-04 18:14:55.0, Dns name=DSI-PRG-AD01.incm.int, Id=2, Datasource name=Data Source}

05 Mai 2017 09:46:01:379 [DEBUG] IEMSchemaFactory:cleanupEmptySubclasses(Long,Map) EXIT
05 Mai 2017 09:46:01:380 [INFO] calling getSoftware(), computer ids=[1, 2, 3, 4, 5, 6, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 87, 107, 111, 127, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 172, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198]
05 Mai 2017 09:46:01:380 [INFO] calling method - api/sam/software_facts.json
05 Mai 2017 09:46:01:380 [INFO] REQUEST_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”],[“computer_id”,"=",“21”],[“computer_id”,"=",“22”],[“computer_id”,"=",“23”],[“computer_id”,"=",“24”],[“computer_id”,"=",“25”],[“computer_id”,"=",“26”],[“computer_id”,"=",“27”],[“computer_id”,"=",“28”],[“computer_id”,"=",“29”],[“computer_id”,"=",“30”],[“computer_id”,"=",“31”],[“computer_id”,"=",“32”],[“computer_id”,"=",“33”],[“computer_id”,"=",“34”],[“computer_id”,"=",“35”],[“computer_id”,"=",“36”],[“computer_id”,"=",“37”],[“computer_id”,"=",“38”],[“computer_id”,"=",“39”],[“computer_id”,"=",“40”],[“computer_id”,"=",“41”],[“computer_id”,"=",“42”],[“computer_id”,"=",“43”],[“computer_id”,"=",“44”],[“computer_id”,"=",“45”],[“computer_id”,"=",“46”],[“computer_id”,"=",“47”],[“computer_id”,"=",“87”],[“computer_id”,"=",“107”],[“computer_id”,"=",“111”],[“computer_id”,"=",“127”],[“computer_id”,"=",“130”],[“computer_id”,"=",“131”],[“computer_id”,"=",“132”],[“computer_id”,"=",“133”],[“computer_id”,"=",“134”],[“computer_id”,"=",“135”],[“computer_id”,"=",“136”],[“computer_id”,"=",“137”],[“computer_id”,"=",“138”],[“computer_id”,"=",“139”],[“computer_id”,"=",“140”],[“computer_id”,"=",“141”],[“computer_id”,"=",“146”],[“computer_id”,"=",“147”],[“computer_id”,"=",“148”],[“computer_id”,"=",“149”],[“computer_id”,"=",“150”],[“computer_id”,"=",“151”],[“computer_id”,"=",“152”],[“computer_id”,"=",“153”],[“computer_id”,"=",“154”],[“computer_id”,"=",“155”],[“computer_id”,"=",“156”],[“computer_id”,"=",“157”],[“computer_id”,"=",“158”],[“computer_id”,"=",“159”],[“computer_id”,"=",“160”],[“computer_id”,"=",“161”],[“computer_id”,"=",“162”],[“computer_id”,"=",“163”],[“computer_id”,"=",“164”],[“computer_id”,"=",“165”],[“computer_id”,"=",“166”],[“computer_id”,"=",“167”],[“computer_id”,"=",“168”],[“computer_id”,"=",“169”],[“computer_id”,"=",“170”],[“computer_id”,"=",“172”],[“computer_id”,"=",“174”],[“computer_id”,"=",“175”],[“computer_id”,"=",“176”],[“computer_id”,"=",“177”],[“computer_id”,"=",“178”],[“computer_id”,"=",“179”],[“computer_id”,"=",“180”],[“computer_id”,"=",“181”],[“computer_id”,"=",“182”],[“computer_id”,"=",“183”],[“computer_id”,"=",“184”],[“computer_id”,"=",“185”],[“computer_id”,"=",“186”],[“computer_id”,"=",“187”],[“computer_id”,"=",“188”],[“computer_id”,"=",“189”],[“computer_id”,"=",“190”],[“computer_id”,"=",“191”],[“computer_id”,"=",“192”],[“computer_id”,"=",“193”],[“computer_id”,"=",“194”],[“computer_id”,"=",“195”],[“computer_id”,"=",“196”],[“computer_id”,"=",“197”],[“computer_id”,"=",“198”]]}&columns[]=computer_id&columns[]=discoverable_guid&columns[]=default_product_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
05 Mai 2017 09:46:11:157 [INFO] calling method - api/sam/software_facts.json
05 Mai 2017 09:46:11:158 [INFO] REQUEST_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”],[“computer_id”,"=",“21”],[“computer_id”,"=",“22”],[“computer_id”,"=",“23”],[“computer_id”,"=",“24”],[“computer_id”,"=",“25”],[“computer_id”,"=",“26”],[“computer_id”,"=",“27”],[“computer_id”,"=",“28”],[“computer_id”,"=",“29”],[“computer_id”,"=",“30”],[“computer_id”,"=",“31”],[“computer_id”,"=",“32”],[“computer_id”,"=",“33”],[“computer_id”,"=",“34”],[“computer_id”,"=",“35”],[“computer_id”,"=",“36”],[“computer_id”,"=",“37”],[“computer_id”,"=",“38”],[“computer_id”,"=",“39”],[“computer_id”,"=",“40”],[“computer_id”,"=",“41”],[“computer_id”,"=",“42”],[“computer_id”,"=",“43”],[“computer_id”,"=",“44”],[“computer_id”,"=",“45”],[“computer_id”,"=",“46”],[“computer_id”,"=",“47”],[“computer_id”,"=",“87”],[“computer_id”,"=",“107”],[“computer_id”,"=",“111”],[“computer_id”,"=",“127”],[“computer_id”,"=",“130”],[“computer_id”,"=",“131”],[“computer_id”,"=",“132”],[“computer_id”,"=",“133”],[“computer_id”,"=",“134”],[“computer_id”,"=",“135”],[“computer_id”,"=",“136”],[“computer_id”,"=",“137”],[“computer_id”,"=",“138”],[“computer_id”,"=",“139”],[“computer_id”,"=",“140”],[“computer_id”,"=",“141”],[“computer_id”,"=",“146”],[“computer_id”,"=",“147”],[“computer_id”,"=",“148”],[“computer_id”,"=",“149”],[“computer_id”,"=",“150”],[“computer_id”,"=",“151”],[“computer_id”,"=",“152”],[“computer_id”,"=",“153”],[“computer_id”,"=",“154”],[“computer_id”,"=",“155”],[“computer_id”,"=",“156”],[“computer_id”,"=",“157”],[“computer_id”,"=",“158”],[“computer_id”,"=",“159”],[“computer_id”,"=",“160”],[“computer_id”,"=",“161”],[“computer_id”,"=",“162”],[“computer_id”,"=",“163”],[“computer_id”,"=",“164”],[“computer_id”,"=",“165”],[“computer_id”,"=",“166”],[“computer_id”,"=",“167”],[“computer_id”,"=",“168”],[“computer_id”,"=",“169”],[“computer_id”,"=",“170”],[“computer_id”,"=",“172”],[“computer_id”,"=",“174”],[“computer_id”,"=",“175”],[“computer_id”,"=",“176”],[“computer_id”,"=",“177”],[“computer_id”,"=",“178”],[“computer_id”,"=",“179”],[“computer_id”,"=",“180”],[“computer_id”,"=",“181”],[“computer_id”,"=",“182”],[“computer_id”,"=",“183”],[“computer_id”,"=",“184”],[“computer_id”,"=",“185”],[“computer_id”,"=",“186”],[“computer_id”,"=",“187”],[“computer_id”,"=",“188”],[“computer_id”,"=",“189”],[“computer_id”,"=",“190”],[“computer_id”,"=",“191”],[“computer_id”,"=",“192”],[“computer_id”,"=",“193”],[“computer_id”,"=",“194”],[“computer_id”,"=",“195”],[“computer_id”,"=",“196”],[“computer_id”,"=",“197”],[“computer_id”,"=",“198”]]}&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
05 Mai 2017 09:46:21:511 [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”],[“computer_id”,"=",“21”],[“computer_id”,"=",“22”],[“computer_id”,"=",“23”],[“computer_id”,"=",“24”],[“computer_id”,"=",“25”],[“computer_id”,"=",“26”],[“computer_id”,"=",“27”],[“computer_id”,"=",“28”],[“computer_id”,"=",“29”],[“computer_id”,"=",“30”],[“computer_id”,"=",“31”],[“computer_id”,"=",“32”],[“computer_id”,"=",“33”],[“computer_id”,"=",“34”],[“computer_id”,"=",“35”],[“computer_id”,"=",“36”],[“computer_id”,"=",“37”],[“computer_id”,"=",“38”],[“computer_id”,"=",“39”],[“computer_id”,"=",“40”],[“computer_id”,"=",“41”],[“computer_id”,"=",“42”],[“computer_id”,"=",“43”],[“computer_id”,"=",“44”],[“computer_id”,"=",“45”],[“computer_id”,"=",“46”],[“computer_id”,"=",“47”],[“computer_id”,"=",“87”],[“computer_id”,"=",“107”],[“computer_id”,"=",“111”],[“computer_id”,"=",“127”],[“computer_id”,"=",“130”],[“computer_id”,"=",“131”],[“computer_id”,"=",“132”],[“computer_id”,"=",“133”],[“computer_id”,"=",“134”],[“computer_id”,"=",“135”],[“computer_id”,"=",“136”],[“computer_id”,"=",“137”],[“computer_id”,"=",“138”],[“computer_id”,"=",“139”],[“computer_id”,"=",“140”],[“computer_id”,"=",“141”],[“computer_id”,"=",“146”],[“computer_id”,"=",“147”],[“computer_id”,"=",“148”],[“computer_id”,"=",“149”],[“computer_id”,"=",“150”],[“computer_id”,"=",“151”],[“computer_id”,"=",“152”],[“computer_id”,"=",“153”],[“computer_id”,"=",“154”],[“computer_id”,"=",“155”],[“computer_id”,"=",“156”],[“computer_id”,"=",“157”],[“computer_id”,"=",“158”],[“computer_id”,"=",“159”],[“computer_id”,"=",“160”],[“computer_id”,"=",“161”],[“computer_id”,"=",“162”],[“computer_id”,"=",“163”],[“computer_id”,"=",“164”],[“computer_id”,"=",“165”],[“computer_id”,"=",“166”],[“computer_id”,"=",“167”],[“computer_id”,"=",“168”],[“computer_id”,"=",“169”],[“computer_id”,"=",“170”],[“computer_id”,"=",“172”],[“computer_id”,"=",“174”],[“computer_id”,"=",“175”],[“computer_id”,"=",“176”],[“computer_id”,"=",“177”],[“computer_id”,"=",“178”],[“computer_id”,"=",“179”],[“computer_id”,"=",“180”],[“computer_id”,"=",“181”],[“computer_id”,"=",“182”],[“computer_id”,"=",“183”],[“computer_id”,"=",“184”],[“computer_id”,"=",“185”],[“computer_id”,"=",“186”],[“computer_id”,"=",“187”],[“computer_id”,"=",“188”],[“computer_id”,"=",“189”],[“computer_id”,"=",“190”],[“computer_id”,"=",“191”],[“computer_id”,"=",“192”],[“computer_id”,"=",“193”],[“computer_id”,"=",“194”],[“computer_id”,"=",“195”],[“computer_id”,"=",“196”],[“computer_id”,"=",“197”],[“computer_id”,"=",“198”]]}&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
05 Mai 2017 09:46:21:511 [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”],[“computer_id”,"=",“21”],[“computer_id”,"=",“22”],[“computer_id”,"=",“23”],[“computer_id”,"=",“24”],[“computer_id”,"=",“25”],[“computer_id”,"=",“26”],[“computer_id”,"=",“27”],[“computer_id”,"=",“28”],[“computer_id”,"=",“29”],[“computer_id”,"=",“30”],[“computer_id”,"=",“31”],[“computer_id”,"=",“32”],[“computer_id”,"=",“33”],[“computer_id”,"=",“34”],[“computer_id”,"=",“35”],[“computer_id”,"=",“36”],[“computer_id”,"=",“37”],[“computer_id”,"=",“38”],[“computer_id”,"=",“39”],[“computer_id”,"=",“40”],[“computer_id”,"=",“41”],[“computer_id”,"=",“42”],[“computer_id”,"=",“43”],[“computer_id”,"=",“44”],[“computer_id”,"=",“45”],[“computer_id”,"=",“46”],[“computer_id”,"=",“47”],[“computer_id”,"=",“87”],[“computer_id”,"=",“107”],[“computer_id”,"=",“111”],[“computer_id”,"=",“127”],[“computer_id”,"=",“130”],[“computer_id”,"=",“131”],[“computer_id”,"=",“132”],[“computer_id”,"=",“133”],[“computer_id”,"=",“134”],[“computer_id”,"=",“135”],[“computer_id”,"=",“136”],[“computer_id”,"=",“137”],[“computer_id”,"=",“138”],[“computer_id”,"=",“139”],[“computer_id”,"=",“140”],[“computer_id”,"=",“141”],[“computer_id”,"=",“146”],[“computer_id”,"=",“147”],[“computer_id”,"=",“148”],[“computer_id”,"=",“149”],[“computer_id”,"=",“150”],[“computer_id”,"=",“151”],[“computer_id”,"=",“152”],[“computer_id”,"=",“153”],[“computer_id”,"=",“154”],[“computer_id”,"=",“155”],[“computer_id”,"=",“156”],[“computer_id”,"=",“157”],[“computer_id”,"=",“158”],[“computer_id”,"=",“159”],[“computer_id”,"=",“160”],[“computer_id”,"=",“161”],[“computer_id”,"=",“162”],[“computer_id”,"=",“163”],[“computer_id”,"=",“164”],[“computer_id”,"=",“165”],[“computer_id”,"=",“166”],[“computer_id”,"=",“167”],[“computer_id”,"=",“168”],[“computer_id”,"=",“169”],[“computer_id”,"=",“170”],[“computer_id”,"=",“172”],[“computer_id”,"=",“174”],[“computer_id”,"=",“175”],[“computer_id”,"=",“176”],[“computer_id”,"=",“177”],[“computer_id”,"=",“178”],[“computer_id”,"=",“179”],[“computer_id”,"=",“180”],[“computer_id”,"=",“181”],[“computer_id”,"=",“182”],[“computer_id”,"=",“183”],[“computer_id”,"=",“184”],[“computer_id”,"=",“185”],[“computer_id”,"=",“186”],[“computer_id”,"=",“187”],[“computer_id”,"=",“188”],[“computer_id”,"=",“189”],[“computer_id”,"=",“190”],[“computer_id”,"=",“191”],[“computer_id”,"=",“192”],[“computer_id”,"=",“193”],[“computer_id”,"=",“194”],[“computer_id”,"=",“195”],[“computer_id”,"=",“196”],[“computer_id”,"=",“197”],[“computer_id”,"=",“198”]]}&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
05 Mai 2017 09:46:21:517 [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: BigFixInv, Class: Computer, Parent Class: null
Error resolution action: Class skipped due to error

05 Mai 2017 09:46:21:517 [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)

05 Mai 2017 09:46:21:525 [INFO]

            Mapping execution completed
            Mapping: teste2
            Execution time: 00:00:51
            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.
05 Mai 2017 09:46:21:534 [FATAL] Mapping execution terminated.
Integration Composer has finished.
[root@srv-itic-prd bin]#

Can you help me?

I found something like : 401 Unauthorized + {“error”:“There is no match for the provided user name
and password”}
When no token is provided.
How i can provide a token?

1 Like

what happens when you try to run the api query in browser?

{“error” : “There is no match for the provided user name and password. If you are usisng Active Directory, ensure the user name is followed by a domain name, for example username@domain.com.”}

I’m not use domain user.

Are you supplying credentials on the command line when you run the executeMapping script or are you using a properties file? Are they the same credentials you use in the ITIC GUI application?

@filipemo any update from this issue?? i am also getting same problem

@itsmpro92 any update for this issue?? me also getting same issue

@balagovindh After additional research - to resolve this issue you will need to open a PMR and request ITIC 7.6.0.3 HotFix 2.

Thank you @itsmpro92 … Can we find Hotfix2 in Fix central or else will go with PMR and request for Hotfix 2

@balagovindh Unfortunately, it is not available at Fix Central.

okay… @itsmpro92 have you gone through Request software deployment from IBM Controldesk through BigFix(which we integrated with BigFix)