GIM Re-aggregation issue

[tim.reeve]

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,

[Kubig]

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.

[tim.reeve]

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

[tim.reeve]

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

[Kubig]

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

[tim.reeve]

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

Thanks for your help.