Hi Tianjiao_Li, I am connected to the server, my SQL Search version is 3.1.5.2031 and the SQL Server is a 2017. I tried to reindex but nothing happened, I looked for the log file and I got this:
06 Sep 2018 10:54:23.544 [207] INFO DatabaseObjectStorage - Inserting job steps into index
06 Sep 2018 10:54:23.545 [215] INFO DatabaseObjectStorage - Inserting objects into index
06 Sep 2018 10:54:23.556 [207] INFO DatabaseObjectStorage - Done
06 Sep 2018 10:54:23.557 [207] INFO DatabaseObjectStorage - Inserting jobs into index
06 Sep 2018 10:54:23.594 [215] INFO DatabaseObjectStorage - Done objects
06 Sep 2018 10:54:23.595 [215] INFO DatabaseObjectStorage - Inserting columns into index
06 Sep 2018 10:54:23.595 [207] INFO DatabaseObjectStorage - Done
06 Sep 2018 10:54:23.598 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event:
[
{
"eventType": "index.objects",
"headers": {
"productId": "sql-search",
"productVersion": "3.1.5.2031",
"eventUuid": "a73b4da6-c38a-4234-8fb6-6e003df40ac5",
"usageUserId": "052859d7-15da-44c9-8e43-070cda91a885",
"sessionUuid": "ee0c30bd-c7fb-4502-84c5-0d2337871bdb",
"createdTimeUtc": "2018-09-06T17:54:23Z"
},
"payload": {
"index-type": "full",
"time-taken": "53",
"objects-updated": "662"
}
}
]
06 Sep 2018 10:54:23.617 [215] INFO DatabaseObjectStorage - Done columns
06 Sep 2018 10:54:23.618 [215] INFO DatabaseObjectStorage - Inserting objects into index
06 Sep 2018 10:54:23.625 [215] INFO DatabaseObjectStorage - Done objects
06 Sep 2018 10:54:23.643 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event:
[
{
"eventType": "search",
"headers": {
"productId": "sql-search",
"productVersion": "3.1.5.2031",
"eventUuid": "295ff4e5-e02b-4f29-bb0d-b02ed6c45ea2",
"usageUserId": "22af9272-a50e-417f-b837-d076a84e6672",
"sessionUuid": "c7226706-782c-4be4-aca8-7b7af5e42fd8",
"createdTimeUtc": "2018-09-06T17:54:23Z"
},
"payload": null
}
]
06 Sep 2018 10:54:24.520 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents
Number of submitted usage events = 1
HTTP status code = 204 NoContent
Response body =
06 Sep 2018 10:54:24.521 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 2 events:
[
{
"eventType": "index.objects",
"headers": {
"productId": "sql-search",
"productVersion": "3.1.5.2031",
"eventUuid": "c687debb-5ccd-42fb-b261-92f87abd099a",
"usageUserId": "052859d7-15da-44c9-8e43-070cda91a885",
"sessionUuid": "ee0c30bd-c7fb-4502-84c5-0d2337871bdb",
"createdTimeUtc": "2018-09-06T17:54:23Z"
},
"payload": {
"index-type": "full",
"time-taken": "80",
"objects-updated": "235"
}
},
{
"eventType": "search",
"headers": {
"productId": "sql-search",
"productVersion": "3.1.5.2031",
"eventUuid": "a387692e-4251-4a16-b050-319ca5b9d00b",
"usageUserId": "052859d7-15da-44c9-8e43-070cda91a885",
"sessionUuid": "ee0c30bd-c7fb-4502-84c5-0d2337871bdb",
"createdTimeUtc": "2018-09-06T17:54:23Z"
},
"payload": {
"searched-databases": "multiple",
"search-string-length": "13"
}
}
]
06 Sep 2018 10:54:24.559 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://productusage.red-gate.com/v1/usageevents
Number of submitted usage events = 1
HTTP status code = 204 NoContent
Response body =
06 Sep 2018 10:54:24.825 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents
Number of submitted usage events = 2
HTTP status code = 204 NoContent
Response body =
/ comments
- Community
- SQL Search
- How can I add a server in SQL Search
Hi Tianjiao_Li,I am connected to the server, my SQL Search version is 3.1.5.2031 and the SQL Server is a 2017.I tried to reindex but nothing happened, I looked for the log file and I got this:
06 S...
0 votes