Incorrect syntax near 'REPEATABLEREAD'

[Former Member]

Hi Guys,

I'm almost finished with the DB migration (SAP 4.6C system from Windows NT/MS SQL 7 to Windows 2003/MS SQL Server 2005).I started SAP, it went all green in SAP MMC but it's inaccessible from SAP Logon pad.

Here are the error I found from the dev_w* logs.

C  HandleOledbError [ExecuteAndFlush,line 30856]: Error/Message: (1018), Incorrect syntax near 'REPEATABLEREAD'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.

C  DbSlPrepare - Error 99 (dbcode 1018) on proc. creation

C  DbSlPrepare - <CREATE PROCEDURE Y8E000017F2B43J2356D010SINFut01 @P000 varchar(40) = ' ', @P001 varchar(1) = ' ' AS

C  SELECT TOP      1 "SQLX" AS c ,"EDTX" AS c ,"DBNA" AS c ,"CLAS" AS c ,"TYPE" AS c ,"OCCURS" AS c ,"SUBC" AS c ,"APPL" AS c ,"SECU" AS c ,"CNAM" AS c ,"CDAT" AS c ,"VERN" AS c ,"LEVL" AS c ,"RSTAT" AS c ,"RMAND" AS c ,"RLOAD" AS c ,"R3RELEASE" AS c ,"R3MODIFY" AS c ,"UNAM" AS c ,"UDAT" AS c ,"UTIME" AS c ,"DATALG" AS c ,"VARCL" AS c ,"DBAPL" AS c ,"FIXPT" AS c ,"SSET" AS c ,"SDATE" AS c ,"STIME" AS c ,"IDATE" AS c ,"ITIME" AS c ,"LDBNAME" AS c ,"UCCHECK" AS c FROM "D010SINF" (UPDLOCK REPEATABLEREAD)  WHERE "PROG" = @P000 AND "R3STATE" = @P001>

B  ***LOG BY4=> sql error 1018   performing SEL on table D010SINF   [dbrepo  3351 ]

B  ***LOG BY0=> Incorrect syntax near 'REPEATABLEREAD'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. [dbrepo  3351 ]

B  *** ERROR => missing return code handler

I have also attached 1 dev_w* log for your reference.

Appreciate your help on this. Thanks!

dev_w20.txt.zip

[Sriram2009 · Accepted solution]

Hi Krisel

1.  Have you tried minimum SAPGUI 7.20 with SP 13 & Above?

2. Could you check this SAP Note correction on your SAP version?

          1071794 - Conversion on SQL Server 2005 / 4.6C fails

BR

SS

[Former Member · Accepted solution]

Hi Krisel,

Is the issue resolved, And have you upgraded your kernel along with DBSL library, if not request you to do same and re-try the migration.

Hope this helps.

Regards,

Ram

[Former Member · Accepted solution]

Thanks for the responses! It has been resolved by updating the Kernel 4.6D with the latest patches available in the SAP Marketplace archive (SAPEXE, SAPEXEDB, dw and DBSL).