Database issue after migration to MSSQL12

[former_member209809]

Dear Experts,

I have recently migrated EREC ABAP only system from oracle 10.2 to MSSQL2012

After migration when i am testing system i am getting below issues

1) While opening DB02 error showing as

Object navigator: Method call call_action failed with return code
= Wrong release level of monitoring RFC interface

--------Report MSSPROC executed but it is showing release limitations

2) while running SGEN error coming as "

RC 8 for db_truncate_table for table SERVTYPE

-------in SE14 created indexes and adjusted DB but still issue is there.

System details are as follow

Basis release 701 Sp6

Windows 2012 R2

MSSQL 2012 SP1

Kernal 720 EXT patch 600

Warm Regards,

Sumit

[former_member184473 · Accepted solution]

Hello Sumit,

As per note 1651862:

Required minimum SAP Netweaver Support Package Stacks (SPSs) for SQL Server 2012 (SAP ABAP, SAP ABAP+JAVA stacks)

SAP EHP1 FOR SAP NETWEAVER 7.0 - SPS 11 (SAP BASIS 11, SAP BW 11)

If your system is running on a SPS lower than the one required above, you have to apply the minimum required SPS before upgrading/migrating to SQL Server 2012.

You must upgrade the SPS to 701 SPS 11 before migrating to SQL Server 2012.

As workaround, you can use SQL Server 2008 R2, which is fully supported with 701 systems (note 1076022).

Regards,

Eduardo Rezende

[former_member182657]

Hi,

Please follow SCN link

Regards,

Gaurav

[former_member209809]

Dear Gaurav,

i have already checked the above link but it is not relevent.

my DEV logs as are below

Thu Aug 21 12:06:13 2014

C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 7433]

C  (3701) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the table 'SERVTYPE', because it does not exist or you do not have permission.

C  DoExecutePrepStmt: stmt of NULL_STMTID

C  DROP TABLE [SERVTYPE]

C  dbdsmss: DBSL103 SQL3701

C  Cannot drop the table 'SERVTYPE', because it does not exist or you do not have permission.

C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 7433]

C  (15016) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]The default 'str_default' does not exist.

C  DoExecutePrepStmt: stmt of NULL_STMTID

C  sap_atomic_defaultbind ' ', 'SERVTYPE', 'APPLSERVER'

C  dbdsmss: DBSL99 SQL15016

C  The default 'str_default' does not exist.

B  ***LOG BY2=> sql error 15016      performing EXE        [dbds         578]

B  ***LOG BY0=> The default 'str_default' does not exist. [dbds         578]

B  ***LOG BY2=> sql error 15016      performing EXE        [dbacds       1017]

Warm Regards,

Sumit