Hello,

I am using SQL Server Database as my Reporsitory for the report caster.

But when I try to generate the tables for that database using the CreateUtil, it gives me the following Exception:

Start creating...
CREATE TABLE BOTSCHED .... Fail
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'IN'.
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'IN'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3065)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at ibi.broker.apputil.SCHDBConstructor.create_SQL(SCHDBConstructor.java:253)
at ibi.broker.apputil.SCHDBConstructor.create_SQL(SCHDBConstructor.java:270)
at ibi.broker.apputil.SCHDBConstructor.create(SCHDBConstructor.java:154)
at ibi.broker.apputil.SCHCreateDBs.makeDB(SCHCreateDBs.java:269)
at ibi.broker.apputil.SCHCreateDBs.buildDBs(SCHCreateDBs.java:199)
at ibi.broker.apputil.SCHCreateDBs.buildSchedDBs(SCHCreateDBs.java:206)
at ibi.broker.SCHCreateUtil.create(SCHCreateUtil.java:568)
at ibi.broker.SCHCreateUtil.main(SCHCreateUtil.java:410)
CREATE UNIQUE INDEX IDXSCHED ON BOTSCHED ( SCHEDULEID ) .... Fail

Please suggest me,

Thanks

Hi Kamesh,
A quick search of the techsupport site and the
hits all point to...
Remove the DBname from the ReportCaster Server Configuration under Repository
Hope that helps.

Hello Rich,
You are right, removing the dbname works.

After I restarted the Reportcaster server, tried getting in to reportcaster console but after I logged in it throws me a error saying 'Unable to communicate to the distribution server .... '

Any idea about that error,

Thanks
Kamesh

Goto webfocus client console and there will be a setting under reportcaster you need to change.

Finally found the solution to this issue. The sqlserver driver has to be in Tomcat classpath. Once I add that it worked fine.

Thanks for all your inputs,