Speechminer failed to load

[najwan]

We install speechminer and we are trying to connect SMconfig using speechminer authenitcation
username: administrator
password: password
And using SQL authentication and login it is failing and the below exceptions is returned:

SMConfig failed to load - Number was less than the array's lower bound in the first dimension.
Parameter name: srcIndex

Please we need your help to advise.

-------------------------
Thanks,
Najwan

[cavagnaro]

So using SM authentication works but not Sql one, is that it?
Post your configuration and architecture

Enviado de meu E6633 usando Tapatalk

[Kubig]

Was the DB script executed without any errors?

[najwan]

Dears Thanks  for your reply below is the description of what we have:
We are running all the speechminer components on one VM and the database on another VM
below are the details steps performed:

• Front End Installation
o The image is located on .1.121 on desktop folder name is speechminer
o Installation Type: Recordings UI
o Components
 Uplatform
 Smart
 SMconfig
 Ulogger
 SMupgrade
 Interaction Receiver
o Language Selection: English USA
• Database Installation (the database is installed on .76)
o Run the speechminer on the SQL server
o Select Database component
o Database Credentials
 DB Server: GENDEC
 DB Name: speechminer_ver8_5_3
 Username: sa
 DB password: p@ssw0rd
o Install
o Reboot
o Open database and make sure tables are created
o Deploy SQL CLR by executing the below query on the master database:
use [master]
create ASYMMETRIC KEY SQLCLRTestKey FROM EXECUTABLE FILE =
'C:\Program Files (x86)\Genesys\Software\Support\sqlclr.XmlSerializers.dll.'
GO
use [master]
CREATE LOGIN SQLCLRTestLogin FROM ASYMMETRIC KEY SQLCLRTestKey
GO
use [master]
GRANT  EXTERNAL ACCESS ASSEMBLY TO SQLCLRTestLogin

Make sure to use the local path instead of the shared path to avoid any errors when executing the SQL query.

o Run another query

XEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr_enabled', 1
GO
RECONFIGURE
GO

o Browse to C:\Program Files (x86)\Genesys\Software\Support.
 Before running the below script and to avoid errors we created 3 accounts named: Reports, Platform,Web as sys admin and mapped to the master database noting that these steps are not mentioned in the deployment guide.
• Run the SQLCLR.sql script




o Configuring Recovery Model
 Set the recovery model of the speechminer database to simple


o Open the table dbo.cmrsParams
 Edit the rows do the modifications as below
 RP_authorization: password
 MCP_authorization: password

o Open the table dbo.configserver

 Configure RCSURL: http://192.168.1.121:8080/rcs
 Configure HTCCURL: http://192.168.1.77:8080/

• Create Folder Hierarchy
o Create one folder named DATA and share it ( We created on .76) followed by the below subfolders
 Backup
 Filtered
 Grammars
 Index
 Indexbackup
 Input
 Store
• Login to SMconfig and we are still getting the same error

Please advise and thanks in advance.


----------------
Regards,
Najwan

[Kubig]

What is your MSSQL architecture, version, etc.?What is SM version installed?

I do not recommend to make any updates in SM database , except Assymetric key configuration. I never encountered this issue while installing DB part by installation wizard. Did you check the install log whether all is clear there? I suspect that there should be some errors related to the database part of installation.

BTW: Your deployment configuration seems to be little bit rookie as you are using default values and all what is mentioned in docs even the analytic part of solution is not used there. Strongly recommend to learn about the solution and get understand how it works in general - not just follow the doc without any further doubts.

[najwan]

We are using MSSQL 2008 R2 standard edition 10.50.4000 consisting of single node and sMConfig version is 8.5.300.136

-------------
Regards,
Najwan.

[Kubig]

As first try to check the installation log for DB errors. In case no success, try to use the latest version of SM (there are lot of bugs fixed)