SM Platform - Create AMERICA_ENGLISH index failed.

cavagnaro · June 13, 2019, 7:16pm

I only have 1 node

Health:
1560453217 14:13:37 elasticsearch green 1 1 0 0 0 0 0 0 - 100.0%

Nodes:
172.117.179.119 13 92 0 md * DOM-RRCT10

Indices:
what is supposed to come here?

janisk · June 13, 2019, 7:43pm

Later when indexer will be able to connect to ES, it will create one.

cavagnaro · June 13, 2019, 7:44pm

Yeah.. That is the issue right now. Totally blind on what is Indexer doing

Enviado de meu SM-G9650 usando o Tapatalk

janisk · June 13, 2019, 7:45pm

What url you used to check ES status? What is in the esNodes environment variable?

cavagnaro · June 13, 2019, 7:48pm

Didn’t find that environment variable. Documentation doesn’t mention it at all.
The URL was the mentioned at docs, http://server:9200/_cluster/health
And it is green

Enviado de meu SM-G9650 usando o Tapatalk

janisk · June 13, 2019, 7:50pm

Hmm… try to create it in system variables and restart IIS. Support told me about that variable.

cavagnaro · June 13, 2019, 7:52pm

What should be the value?

Enviado de meu SM-G9650 usando o Tapatalk

janisk · June 13, 2019, 7:54pm

“http://server:9200”, if you are using default 9200 port

cavagnaro · June 13, 2019, 8:25pm

Willing to kiss you!! The environment variable was there but with a wrong value and there was that port 8080! Fuck sake!
Now, I am getting this at Web logs

2019-06-13T15:16:55.222 Std 09900 WARN SQL Error: SELECT Id FROM partitionTbl WHERE name IN() Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ca.a[a](String A_0, DbParameter[] A_1, Int32 A_2, cb A_3, ICollection`1 A_4, Boolean A_5)

Any idea?

janisk · June 13, 2019, 8:35pm

Just for your information, I’m a man I have Latvian name pronounced as Yanis.
But OK I can accept it, one kiss will not kill me.

cavagnaro · June 13, 2019, 8:36pm

I know you are a man hahaha don’t care [emoji23][emoji23][emoji23] you just deserve, an Italian kiss [emoji1787][emoji1787][emoji1787][emoji1787]

Enviado de meu SM-G9650 usando o Tapatalk

janisk · June 13, 2019, 8:44pm

Looks like there must be something in the brackets after IN. Will check what is in that partitions table on proper system tommorow. Maybe you are missing some option in SM config? Default workgroup or how it was called there?

cavagnaro · June 13, 2019, 9:37pm

Nope, can’t find any missing info.

Saw this at Wireshark while doing a search

}GET /speechminer/api/v1/speakerTypes HTTP/1.1 Host: 172.17.79.19 Accept: application/json, text/plain, */* User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36 Referer: http://172.17.79.19/speechminer/pages/ui/ Accept-Encoding: gzip, deflate Accept-Language: es-ES,es;q=0.9 Cookie: AuthenticationType=Genesys; .ASPXAUTH=13C118D0968CCBA5B7C451722E6D6603629A8E23D9BAFBB18330091D562055DED63DECE7FCA566B56B3C7D98F7CE43713B9BB8903A61A37C7CF2D5EC9CB50FF7AC2CF7D72285FB24B24956DAACF2C87BD8AB832AAFF7C07FF1B43B90B8D358B9CCADEA4A58FE219CA986E34F74A01342; ASP.NET_SessionId=kpr1pf3twgfp32ev4sre3hxg X-Forwarded-For: 172.22.10.240 Cache-Control: max-stale=0 Connection: Keep-Alive X-BlueCoat-Via: 615971f7a9aabed0
HTTP/1.1 200 OK
Cache-Control: no-cache
Pragma: no-cache
Content-Type: application/json; charset=utf-8
Expires: -1
Accept-Ranges: bytes
Server: Microsoft-IIS/8.5
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
Date: Thu, 13 Jun 2019 21:17:51 GMT
Content-Length: 187

{
“items”: [
{
“id”: 1,
“name”: “agent”
},
{
“id”: 2,
“name”: “customer”
}
],
“href”: “api/v1/speakertypes”,
“statusCode”: 0
}GET /speechminer/api/v1/interactions?searchId=11 HTTP/1.1
Host: 172.17.79.19
Accept: application/json, text/plain, /
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36
Referer: http://172.17.79.19/speechminer/pages/ui/
Accept-Encoding: gzip, deflate
Accept-Language: es-ES,es;q=0.9
Cookie: AuthenticationType=Genesys; .ASPXAUTH=13C118D0968CCBA5B7C451722E6D6603629A8E23D9BAFBB18330091D562055DED63DECE7FCA566B56B3C7D98F7CE43713B9BB8903A61A37C7CF2D5EC9CB50FF7AC2CF7D72285FB24B24956DAACF2C87BD8AB832AAFF7C07FF1B43B90B8D358B9CCADEA4A58FE219CA986E34F74A01342; ASP.NET_SessionId=kpr1pf3twgfp32ev4sre3hxg
X-Forwarded-For: 172.22.10.240
Cache-Control: max-stale=0
Connection: Keep-Alive
X-BlueCoat-Via: 615971f7a9aabed0

HTTP/1.1 500 Internal Server Error
Cache-Control: no-cache
Pragma: no-cache
Content-Type: application/json; charset=utf-8
Expires: -1
Accept-Ranges: bytes
Server: Microsoft-IIS/8.5
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
Date: Thu, 13 Jun 2019 21:17:51 GMT
Content-Length: 123

{
“statusCode”: -1,
“errorMessage”: “The operation cannot be completed. Please contact your System Administrator.”

janisk · June 14, 2019, 1:56pm

In the working system I have following request in the Web log:

Running SQL Command: SELECT Id FROM partitionTbl WHERE name IN (N'Users',N'Outbound Users',N'Email Users',N'/ϰa𢠧rupa/janisk')

Here we have listed all four Access Groups I assigned to user which is signing into SM. Seems your user does not have any.

cavagnaro · June 14, 2019, 4:09pm

Yes and no.
Was a permissions issue with the Role.
Genesys guy connected yesterday and fixed.
Thanks for the help!

Enviado de meu SM-G9650 usando o Tapatalk