MS SQL 2012 SGEN ERROR

[Former Member]

Dear Experts,

We're experiencing the following problem:

- Tx SGEN, when we click on the "continue" button on the software components selection screen we get this error:

"RC 8 for db_truncate_table for table SERVTYPE Message no. TSGEN235"

- Tx SM21, the system log show this error " SGEN           BY  2 Database error 15016 at EXE"

We hva installed ERP6 EHP4 on windows server 2012 x64, MS SQL Server 2012 R2

Thanks in advance for your help

[Former Member · Accepted solution]

Hi all,

The issue is solved, i have installed SQL Server 2008 SPS 3 on windows server 2012 R2 on basic slipstream mode wish support the installation of SQL Server 2008 on Windows 2012.

SQL Server 2008, basic slipstream steps - SQL Server Setup - Site Home - MSDN Blogs

Thank for your help.

[Former Member]

Hi Sriram.

Our SAP ERP 6.0 EHP4 is based on SAP BASIS SPS 2, it's a new installation and i'm affraid that if i want to upgarde this system to SPS 11 by SUM, the operation fails !!

Any idea how we should planned our upgrade !!

[Matt_Fraser]

Tarik,

Are you on NetWeaver 7.01 (7.0 EhP1)? If so, then sps11 is the minimum support stack for SQL 2012 support. The MSSPROCS report you're trying to run, etc, will require this before you can proceed.

You should be able to apply the most recent sps to your system, however. SAP does support new installations onto SQL 2012 as long as you immediately apply the updated sps right after the installation is complete. Why do you think SUM won't work?

Also, bear in mind that sps11 is a minimum; there's no reason not to go for the latest available sps -- you don't have to go to precisely sps11, just at least sps11.

Regards,

Matt

[Sriram2009]

Hi

I think you have to follow steps

1. Install the MS Sql 2008 with ERP 6.0 EHP4 SPS 2

2. Do the upgrade from SPS 2 to minimum SPS 11

3. Upgrade the database to MS SQL 2012

at this stage you may not have upgrade SPS

BR

SS

[Matt_Fraser]

Another point to consider is that for ERP 6.04 / NW 7.01 you don't have to use SUM to apply support pack stacks if you don't want to. In fact, I wouldn't. You can still use SPAM for the ABAP support packs and JSPM for the Java support packs (if you have any Java systems in the ERP landscape, such as a Portal). SUM will work, but it will probably be quicker and easier with SPAM in this circumstance.

[Former Member]

thank you for your help,

I have followed the instructions of the SAP note 196584, but when i run the MSSPROCS report, i can't find these options :

1. Execute all" is selected
2. Hit option "Execute SQL

Below Screen shots :

I have also checked the dev_w0 log file :

Tue Nov 25 16:56:26 2014

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]

A 

A Tue Nov 25 16:56:36 2014

A  *GENER* starting remote generation: RSPARAGENLOD (requested by W4)

Thanks for your help !!

[Sriram2009]

Hi

1. Could you share you SP level ?

2. Could you refer the SAP Note for minimum requirement to support MS Sql  2012.

1651862 - Release planning for Microsoft SQL Server 2012

3. Refer the SCN thread

BR

SS

[former_member182657]

Hi Tarik,

Addition to the SAP Note 1965384 as suggested by Shkelzen,kindly check with note   1701412 - IBM i: RSREGENLOD fails

If still the issue persists try to patch the kernel with latest available and check again.

Regards,

Gaurav

[hasanajsh]

Hi Tarik,

Did you check Note 1965384.

Although it describes an error after the upgrade, it might be the same situation too, as the error is the same.

Regards

[former_member188883]

Hi Tarik,

Please refer to solution in thread http://scn.sap.com/thread/1831916

Hope this helps.

Regards,

Deepak Kori