SM Platform - Create AMERICA_ENGLISH index failed.

[Kubig]

GIA is for speech analysis. GIR requires ES cluster just for IRWS, not even for SM. I also suppose your ES cluster is running on different port then 8080.

[Janis]

You are right for SM versions up to 8.5.510. Index files are used for searching in these versions. Starting from 8.5.511 index is moved to external Elasticsearch server.
From Administration Guide:
"Support for Elasticsearch: The solution no longer uses Lucene to store the index for search and retrieval purposes.
The solution now uses Elasticsearch, which is a more scalable search engine based on a distributed storage that
streamlines the backup process and provides robust functionality around data integrity. As a result, all index data must
be migrated from Lucene to Elasticsearch as part of the upgrade. For details, refer to Install, Configure and Run Elasticsearch"

[Kubig]

Thanks for clarification. Good news about the ES cluster requirement. I have to update my LAB environment to keep knowledge up-to-date

[cavagnaro]

[quote author=Janis link=topic=11354.msg51781#msg51781 date=1560409147]
After looking into your log, I would recommend to check ES logs and Wireshark trace for communication with ES cluster.
You can check ES status with commands like:
curl 'localhost:9205/_cat/health?v'
curl 'localhost:9205/_cat/nodes?v'
curl 'localhost:9205/_cat/indices?v'
[/quote]


ES logs show almost nothing actually. According to Genesys is not the core where the indexer runs. Indexer is a web app on IIS that consumes ES only.
I also noticed that 8080 port, but no clue about it, never configured such port during installation phase.

[Janis]

You have to install ES and check if it is up and running.
Indexer app in IIS is reading Windows Environment Variable "esNodes" to connect to ES cluster. The value is semicolon separated string of all ES nodes "http://ES_Node_1:<ES_port>;http://ES_Node_2:<ES_port>;http://ES_Node_3:<ES_port>". The default port is 9200.

You can check ES in browser as well. Use links:
http://<any_ES_node>:<ES_port>/_cat/health?v
http://<any_ES_node>:<ES_port>/_cat/nodes?v
http://<any_ES_node>:<ES_port>/_cat/indices?v

[cavagnaro]

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:
<blank> what is supposed to come here?

[Janis]

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

[cavagnaro]

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


Enviado de meu SM-G9650 usando o Tapatalk

[Janis]

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

[cavagnaro]

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

[Janis]

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

[cavagnaro]

What should be the value?

Enviado de meu SM-G9650 usando o Tapatalk

[Janis]

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

[cavagnaro]

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




[quote]
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)
[/quote]


Any idea?

[Janis]

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.