Jump to content

Hornbill data export - Database fails to update


Recommended Posts

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.

Link to comment
Share on other sites

Hi @Richard Williams,

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

 image.png

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...