Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: najwan on May 02, 2017, 02:54:38 PM
-
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
-
So using SM authentication works but not Sql one, is that it?
Post your configuration and architecture
Enviado de meu E6633 usando Tapatalk
-
Was the DB script executed without any errors?
-
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
-
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.
-
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.
-
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)