Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: n3vek7 on February 14, 2017, 06:37:30 AM

Title: [RESOLVED] GIM Agg failed to lock
Post by: n3vek7 on February 14, 2017, 06:37:30 AM

Hello guys,

I' struggling with RAA 8.5 on a new server.. everything was installed fine but it seems to be incomplete on the aggregation level of GIM.
I don't have any tables AG2_* in my GIM database. Any script to run? It seems tables should be created by the process, according to the deployment guide...

I keep getting this error ;
[code]2017-02-14 03:39:44,546 ERROR Agg.Lock    20000 Failed to acquire lock
2017-02-14 03:39:44,546 ERROR Agg.Lock    20000 SQLState: S0002
2017-02-14 03:39:44,546 ERROR Agg.Lock    20000 Vendor:  208
2017-02-14 03:39:44,546 ERROR Agg.Lock    20000 com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'AGR_LOCK'.
2017-02-14 03:39:44,546 ERROR Agg.Lock    20000 Stack Trace:[/code]

I haven't found this table/object anywhere and google can't help me or even knowledge base from Genesys.
I've tried to add more rights (sysadmin) to the user of the schema where GIM Database is hosted.

Any idea?
I'm running MS SQL Server 2012 on Windows 2012R2 64 bits server.

agg folder is under GIM execution folder and the jar is loaded correctly.

Best regards !

Title: Re: GIM Agg failed to lock
Post by: n3vek7 on March 09, 2017, 01:38:51 PM

Oh, by the way, I fixed this by re-installing GIM...
I think the 1st run of GIM failed due to missing access to MS SQL Database. After that, those tables (some AGR_*) were not existing.