Hi, I am trying to use the Hornbill data export tool.
my config file is setup as follows:
{
"APIKey": "*****",
"InstanceID": "*****",
"Database":{
"Driver": "mssql",
"Server": "WFSQLTEST",
"Database": "Hornbill_AD_export",
"Authentication": "Windows",
"UserName": "svcintSqlServer2",
"Password": "*****",
"Port": 3389,
"Encrypt": false
},
"Reports":[
{
"ReportID":209,
"ReportName":"Test update of Active Directory",
"DeleteReportInstance": true,
"DeleteReportLocalFile": false,
"Database":{
"TableName":"tblAD_Update",
"PrimaryKey":"samaccountname",
"Mapping":{
"SamacCountName":"samaccountname",
"GeneralTelephone":"generaltelephone",
"OrganisationDepartment":"OrganisationDepartment",
"AddressStreet":"addressstreet",
"ManagersamAccount":"managersamaccount"
}
}
}
]
}
after I run the utility exe I get the following output from the log file
2019/06/26 13:54:20 ---- Hornbill Data Export Tool v1.2.0 ----
2019/06/26 13:54:20 Flag - Configuration File: conf.json
2019/06/26 13:54:20 Flag - Debug: false
2019/06/26 13:54:20 [DEBUG] Loading Config File: D:\Hornbill data export - TEST/conf.json
2019/06/26 13:54:20 Instance ID: walthamforest
2019/06/26 13:54:20 [DEBUG] Connecting to Database Server: WFSQLTEST
2019/06/26 13:54:20
2019/06/26 13:54:20 Running Report: Test update of Active Directory [209]
2019/06/26 13:54:20 Checking Report Run ID [923] for completion...
2019/06/26 13:54:23 Checking Report Run ID [923] for completion...
2019/06/26 13:54:23 Retrieving CSV Report File Test update of Active Directory_923.csv...
2019/06/26 13:54:23 Retrieved report data from D:\Hornbill data export - TEST/reports/Test update of Active Directory_923.csv
2019/06/26 13:54:23 Processing 4 Records from Test update of Active Directory_923.csv...
2019/06/26 13:55:23 [ERROR] [DATABASE] Ping Error: read tcp [::1]:49464->[::1]:3389: wsarecv: An existing connection was forcibly closed by the remote host.
2019/06/26 13:55:23 [ERROR] Unable to map any values from the returned record:
2019/06/26 13:55:23 [RECORD] {"addressstreet":"92 Leyton Green Rd E10 6DA","generaltelephone":"020 1111 2222","managersamaccount":"STorres-Catmur","organisationdepartment":"Chief Executives","samaccountname":"LGiles"}
2019/06/26 13:55:23 [MAPPINGS] null
2019/06/26 13:56:23 [ERROR] [DATABASE] Ping Error: read tcp 10.135.21.63:49504->10.135.21.63:3389: wsarecv: An existing connection was forcibly closed by the remote host.
2019/06/26 13:56:23 [ERROR] Unable to map any values from the returned record:
2019/06/26 13:56:23 [RECORD] {"addressstreet":"Cedar Wood House Fulbourne Rd E17 4EE","generaltelephone":"020 3333 4444","managersamaccount":"JBasey","organisationdepartment":"Families and Homes","samaccountname":"RWilliams"}
2019/06/26 13:56:23 [MAPPINGS] null
2019/06/26 13:57:23 [ERROR] [DATABASE] Ping Error: read tcp 10.135.21.63:49546->10.135.21.63:3389: wsarecv: An existing connection was forcibly closed by the remote host.
2019/06/26 13:57:23 [ERROR] Unable to map any values from the returned record:
2019/06/26 13:57:23 [RECORD] {"addressstreet":"Walthamstow Assembly Hall Town Hall Complex, Forest Rd E17 4JF","generaltelephone":"020 7777 4444","managersamaccount":"NAlavi","organisationdepartment":"Neighbourhood and Commercial Services","samaccountname":"JBasey"}
2019/06/26 13:57:23 [MAPPINGS] null
2019/06/26 13:58:23 [ERROR] [DATABASE] Ping Error: read tcp [::1]:49592->[::1]:3389: wsarecv: An existing connection was forcibly closed by the remote host.
2019/06/26 13:58:23 [ERROR] Unable to map any values from the returned record:
2019/06/26 13:58:23 [RECORD] {"addressstreet":"Rowan House 1 Cecil Rd E11 3HF","generaltelephone":"020 8888 1111","managersamaccount":"RBlack","organisationdepartment":"Economic Growth","samaccountname":"STorres-Catmur"}
2019/06/26 13:58:23 [MAPPINGS] null
2019/06/26 13:58:23 Processing Complete
2019/06/26 13:58:23 ====Report Processing Statistics====
2019/06/26 13:58:23 * Test update of Active Directory [209]
2019/06/26 13:58:23 * Total Records Found: 4
2019/06/26 13:58:23 * Rows Affected: 0
2019/06/26 13:58:23 * Successful Queries: 0
2019/06/26 13:58:23 * Failed Queries: 4
2019/06/26 13:58:23 Deleting Report Run Instance...
2019/06/26 13:58:44 [ERROR] Post https://mdh-p01-api.hornbill.com/walthamforest/xmlmc//reporting/?method=reportRunDelete: read tcp 10.135.21.63:49461->78.129.173.117:443: wsarecv: An established connection was aborted by the software in your host machine.