Hi,

we have got a problem to preview worksheet on spagobi server 4.0,

while executing the query to generate a worksheet on spagobi server 4.0 we have this error : [The root cause of the error is: Syntaxe incorrect vers le mot clé 'As'.]


the datasource is configured properly.



We use SPAGOBI4.0 & SQL SERVER 2008. we have to use SQL SERVER


Please can some one help .




THIS IS THE SpagoBIQBEEngine.log




13 déc. 2013 10:11:44,120 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:85 - An unpredicted error occurred while executing LOAD_CROSSTAB_ACTION service.
The root cause of the error is: Syntaxe incorrecte vers le mot clé 'AS'.
13 déc. 2013 10:11:44,121 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:86 - The error root cause is: Syntaxe incorrecte vers le mot clé 'AS'.
13 déc. 2013 10:11:44,121 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:95 - The error root cause stack trace is:
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while persisting dataset
at it.eng.spagobi.engines.worksheet.services.AbstractWorksheetEngineAction.persistDataSet(AbstractWorksheetEngineAction.java:271)
at it.eng.spagobi.engines.worksheet.services.runtime.LoadCrosstabAction.service(LoadCrosstabAction.java:95)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:496)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:194)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)
Caused by: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error creating the temporary table with name TMPSBIQBE_biadmin
at it.eng.qbe.statement.AbstractQbeDataSet.persist(AbstractQbeDataSet.java:333)
at it.eng.spagobi.engines.worksheet.services.AbstractWorksheetEngineAction.persistDataSet(AbstractWorksheetEngineAction.java:255)
... 23 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Syntaxe incorrecte vers le mot clé 'AS'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
at it.eng.spagobi.utilities.temporarytable.TemporaryTableManager.executeStatement(TemporaryTableManager.java:480)
at it.eng.spagobi.utilities.temporarytable.TemporaryTableManager.createTableInternal(TemporaryTableManager.java:400)
at it.eng.spagobi.utilities.temporarytable.TemporaryTableManager.createTable(TemporaryTableManager.java:145)
at it.eng.qbe.statement.AbstractQbeDataSet.persist(AbstractQbeDataSet.java:330)
... 24 more
13 déc. 2013 10:11:44,123 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:96 - The error full stack trace is:
it.eng.spagobi.utilities.engines.SpagoBIEngineServiceException: An unpredicted error occurred while executing LOAD_CROSSTAB_ACTION service.
The root cause of the error is: Syntaxe incorrecte vers le mot clé 'AS'.
at it.eng.spagobi.utilities.engines.SpagoBIEngineServiceExceptionHandler.getWrappedException(SpagoBIEngineServiceExceptionHandler.java:77)
at it.eng.spagobi.engines.worksheet.services.runtime.LoadCrosstabAction.service(LoadCrosstabAction.java:177)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:496)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:194)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while persisting dataset
at it.eng.spagobi.engines.worksheet.services.AbstractWorksheetEngineAction.persistDataSet(AbstractWorksheetEngineAction.java:271)
at it.eng.spagobi.engines.worksheet.services.runtime.LoadCrosstabAction.service(LoadCrosstabAction.java:95)
... 22 more
Caused by: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error creating the temporary table with name TMPSBIQBE_biadmin
at it.eng.qbe.statement.AbstractQbeDataSet.persist(AbstractQbeDataSet.java:333)
at it.eng.spagobi.engines.worksheet.services.AbstractWorksheetEngineAction.persistDataSet(AbstractWorksheetEngineAction.java:255)
... 23 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Syntaxe incorrecte vers le mot clé 'AS'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
at it.eng.spagobi.utilities.temporarytable.TemporaryTableManager.executeStatement(TemporaryTableManager.java:480)
at it.eng.spagobi.utilities.temporarytable.TemporaryTableManager.createTableInternal(TemporaryTableManager.java:400)
at it.eng.spagobi.utilities.temporarytable.TemporaryTableManager.createTable(TemporaryTableManager.java:145)
at it.eng.qbe.statement.AbstractQbeDataSet.persist(AbstractQbeDataSet.java:330)
... 24 more