NEXT VALUE FOR SAP MII

[Former Member]

Hello ,

I created Sequencing in SQL Server 2012 database . I am trying to get the sequence number using NEXT VALUE FOR function in MII  .

SELECT NEXT VALUE FOR PROJECT_SEQ AS PROJECT_ID . I am getting below error

com.microsoft.sqlserver.jdbc.SQLServerException: NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set, or the query contains TOP or OFFSET.

THE NEXT VALUE FOR function doesn't support the ROWCOUNT , TOP or OFFSET in the query but looks like MII internally is sending ROWCOUNT.  Is there any way to bypass ROWCOUNT in MII ?

Thanks,

Naresh

[Former Member · Accepted solution]

Helllo Everyone ,

SAP has released patch to set Max Rows via JDBC Checkbox to ignore the Max row count.

Thanks,

Naresh

[schfer_christian · Accepted solution]

Hi Naresh, can you give us please the information about where to configure that option and what was the note for that ?

thank you

[former_member185280 · Accepted solution]

http://service.sap.com/sap/support/notes/2295221

[swaroop_anasane]

Hi Naresh,

Possibly one reason is RowCount in General Tab of query template that keep on checking no. of rows returned and does a crop on result.

You need to find a work around to serve the purpose, there are lots of sql server operators you can you to achieve the same.

Thanks and Regards,

Swaroop