Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: tim.reeve on July 31, 2013, 03:42:57 PM

Title: GIM Re-aggregation issue
Post by: tim.reeve on July 31, 2013, 03:42:57 PM

Hi,  I'm trying to re-aggregate some old data in our GIM database, using the following command:

java -jar agg\GIMAgg.jar -user=*user* -pass=*password* -jdbcurl=jtds:sqlserver://*host*:*port*;DatabaseName=*gim*
-insertPendingAggRaw ALLTENANTS:ALLSETS:1375225200:1375310700

I'm getting this error:

'java.sql.SQLException: No suitable driver found for...'  and then my jdbcurl provided with the command.

I'm running gim version 8.1.103.03 with continuous aggregation, and running the command from the gim install directory.

So my jdbcurl is wrong by the looks of it, but not sure which particular aspect, so any suggestions welcome.

Thanks,

Title: Re: GIM Re-aggregation issue
Post by: Kubig on August 01, 2013, 08:39:58 AM

Correct your URL to:

[code]
java -jar agg\GIMAgg.jar -user=*user* -pass=*password* -jdbcurl=jdbc:jtds:sqlserver://*host*:*port*;DatabaseName=*gim*
-insertPendingAggRaw ALLTENANTS:ALLSETS:1375225200:1375310700
[/code]

your format of JDBC URL is wrong.

Title: Re: GIM Re-aggregation issue
Post by: tim.reeve on August 01, 2013, 08:56:43 AM

Thanks Kubig, do you know the correct format?  I copied the format from the raa deployment and user guides, or so I thought.

Title: Re: GIM Re-aggregation issue
Post by: tim.reeve on August 01, 2013, 09:40:29 AM

Nevermind I have got it working now.  The Reporting & Analytics Aggregates 8.1 Deployment Guide.pdf is incorrect, but the user guide is right.  Depl guide has:

jdbcurl=jtds:sqlserver://<dbhost>:<dbport>;DatabaseName=<dbname>

and User guide:

-jdbcurl=[color=red]jdbc[/color]:jtds:sqlserver://octopus:1433;DatabaseName=Widgets

Title: Re: GIM Re-aggregation issue
Post by: Kubig on August 01, 2013, 10:36:42 AM

I wrote the right format in my first answer - look carefuly.

Title: Re: GIM Re-aggregation issue
Post by: tim.reeve on August 01, 2013, 10:45:23 AM

Yes so you did, apologies I didn't see the first sentence, obvious though it seems now!  :-[

Thanks for your help.