[resolved] Incorrect syntax near the keyword 'top' In TalendBPM.

One Star

[resolved] Incorrect syntax near the keyword 'top' In TalendBPM.

Hi,
I have configured Talend Bpm runtime container Back end with SQL SERVER(2012). I have created tables successfully in the Databases. but while opening bpm portal we are getting an exception like "Unable get cases from server" in red colour and also in the log file we are getting an exception like below. please find the following attachmnet
07:08:55,744 | ERROR | tp1892124631-165 | rnate.util.JDBCExceptionReporter  234 | 246 - talend-bpm-server - 5.10.0 | Incorrect syntax near the keyword 'top'.
07:08:55,745 | ERROR | tp1892124631-165 | vices.impl.DefaultCommandService   48 | 246 - talend-bpm-server - 5.10.0 | exception while executing command org.ow2.bonita.facade.rest.RESTServerAPIInterceptorCommand@5ec13917: Unexpected Exception arrived in Bonita: could not execute query
07:08:55,996 | ERROR | qtp1892124631-99 | t.provider.GenericObjectProvider   95 | 215 - talend-bpm-deployer - 5.10.0 | Error while decoding <org.ow2.bonita.facade.exception.BonitaInternalException>
  <detailMessage>Unexpected Exception arrived in Bonita: could not execute query
</detailMessage>
  <cause class="org.hibernate.exception.SQLGrammarException">
    <detailMessage>could not execute query</detailMessage>
    <cause class="com.microsoft.sqlserver.jdbc.SQLServerException">
      <detailMessage>Incorrect syntax near the keyword &apos;top&apos;.</detailMessage>
      <stackTrace>
        <trace>com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)</trace>
        <trace>com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)</trace>
        <trace>com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)</trace>
        <trace>com.microsoft.sqlserver.jdbc.SQLServe
can any one please help me 
Thanks in advance.

Employee

Re: [resolved] Incorrect syntax near the keyword 'top' In TalendBPM.

Hi jillu, 
Talend BPM is only certified for MS SQL Server 2008 R2 (not SQL Server 2012 which you use). Any change to switch back to 2008 R2?
Dietmar 
One Star

Re: [resolved] Incorrect syntax near the keyword 'top' In TalendBPM.

Thanks dlenzen,
we Resolved the issue.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch