" /> [RESOLVED] GIM Agg failed to lock - Genesys CTI User Forum

Author Topic: [RESOLVED] GIM Agg failed to lock  (Read 1803 times)

Offline n3vek7

  • Full Member
  • ***
  • Posts: 137
  • Karma: 3
    • ITKB
[RESOLVED] GIM Agg failed to lock
« on: February 14, 2017, 06:37:30 AM »
Advertisement
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 !
« Last Edit: March 09, 2017, 01:39:10 PM by n3vek7 »

Offline n3vek7

  • Full Member
  • ***
  • Posts: 137
  • Karma: 3
    • ITKB
Re: GIM Agg failed to lock
« Reply #1 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.