Hornbill data export - Database fails to update

[Richard Williams]

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.

[Steve G]

Hi @Richard Williams,

The issue is with your config, under Reports where it says "Database", this should be replaced with "Table" :

  

Apologies, the example config was incorrect on our wiki, but correct in the conf.json supplied on Github. I'll review and fix the wiki page now.

Kind regards,

Steve