" /> GIM Re aggregation Issues - Genesys CTI User Forum

Author Topic: GIM Re aggregation Issues  (Read 1708 times)

Offline anandapriyan

  • Full Member
  • ***
  • Posts: 115
  • Karma: -1
GIM Re aggregation Issues
« on: July 28, 2017, 07:23:31 AM »
Advertisement
Team,
We tried to change the timezone for GIM, So we tried to perform reaggregation.
Before running reaggregation process, We truncated the Ag2 tables. And we tried to run re aggregation by the following steps.
1.Make sure that no jobs are running.
2.Run the following command for reaggregation in autonomous mode.
java -jar agg\GIMAgg.jar -user=Username -pass=Password -jdbcurl=jdbc:jtds:sqlserver://host_name;DatabaseName=DatabaseName -insertPendingAgg ALLSETS:2014-05-01:2016:03:31.
3.Then we started the aggregation using admin console.
4. Then we get the message [b]Unable to get aggregation lock in 75 seconds[/b] & Failed to acquire lock:
Kindly looking forward your response.

Offline anandapriyan

  • Full Member
  • ***
  • Posts: 115
  • Karma: -1
Re: GIM Re aggregation Issues
« Reply #1 on: July 28, 2017, 01:48:38 PM »
Team,

Whether the following command executes correctly in the 8.1.4 version.
java -jar agg\GIMAgg.jar -user=Username -pass=Password -jdbcurl=jdbc:jtds:sqlserver://host_name;DatabaseName=DatabaseName -insertPendingAgg ALLSETS:2014-05-01:2016:03:31.

Since insertPendingAgg mentioned as introduced in 8.1.4 version or later. Currently we are using GIM version 8.1.103 version. Kindly looking forward for your suggestions.

Offline anandapriyan

  • Full Member
  • ***
  • Posts: 115
  • Karma: -1
Re: GIM Re aggregation Issues
« Reply #2 on: August 01, 2017, 09:15:25 AM »
Team,

We are running the following reaggreation-command in autonomous mode.

[b]java -jar agg\GIMAgg.jar -user=<User_name>-pass=<password>-jdbcurl=jdbc:jtds:sqlserver://<Database_Host_name>:<Port_name>;DatabaseName=<Database_name>-levelOfLog=.:INFO,Agg:FINEST -insertPendingAgg ALLSETS:1464719400:1501180200
[/b]
After this execution, the command windows display the following message

[b]Agg.Dispatch Finished processing aggregation requests, no pending requests found[/b]

But no data available in the Ag2 tables.

Do we want to run aggregation job, after this command execution, or before the command execution.

Kindly looking forward for your suggestions.