cancel
Showing results for 
Search instead for 
Did you mean: 

RC 8 for db_truncate_table for table SERVTYPE

Former Member
0 Kudos

Hi guys,

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"

I've checked SAP Note:

Note 1147789 - SGEN does not generate all loads after release upgrade

but it does not apply since we're on SAP_BASIS 620.

Platform

Windows 2008 Server x64

SQL Server 2005 SP3

SQL_Latin1_General_CP850_BIN2

SAP R/3 4.7 x200

SAP Kernel 6.40 Patch 347 x64 (Sep 10 2010)

SAP_BASIS 620 Patch 69

Any ideas on how to solve this problem?

Thank you!

Bruno Pereira.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Any information you get in dev_w0 file?

Former Member
0 Kudos

Hi Sunil,

Information from dev_w0 relating to this issue is as follows:

C  DbSlRead - Error 13 (dbcode 2812) on open
C  DbSlRead - <##Y3SAPDEV8dev00000046480000002878163329>
C  DbSlRead - Error 13 (dbcode 2812) on fetch
C  DbSlRead - <##Y3SAPDEV8dev00000046480000002878163329>
C  dbdsmss: DBSL13 SQL2812
C  Could not find stored procedure 'sap_get_dep_partobjs'.
C  ExecuteAndFlush return code: 0x80040e14 Stmt: [sap_atomic_defaultbind ' ', 'SERVTYPE', 'APPLSERVER' ]
C  DbSlExecute - Error 103 (dbcode 2812) on DDLExecute
C  DbSlExecute - <sap_atomic_defaultbind ' ', 'SERVTYPE', 'APPLSERVER' >
C  dbdsmss: DBSL103 SQL2812
C  Could not find stored procedure 'sap_atomic_defaultbind'.
C  DbSlRead - Error 13 (dbcode 2812) on open
C  DbSlRead - <##Y3SAPDEV8dev00000046480000002885163329>
C  DbSlRead - Error 13 (dbcode 2812) on fetch
C  DbSlRead - <##Y3SAPDEV8dev00000046480000002885163329>
C  dbdsmss: DBSL13 SQL2812
C  Could not find stored procedure 'sap_get_dep_partobjs'.

Bruno Pereira

Answers (1)

Answers (1)

Former Member
0 Kudos

I was able to solve this issue the following way:

1. Delete SP sap_atomic_defaultbind via MSSPROCS on SAP level

2. Delete SP sap_atomic_defaultbind via SQL Ent. Manager on db level

3. Create SP sap_atomic_defaultbind via SQL Ent. Manager on db level

4. Create table SERVTYPE via SE14

5. Create SP sap_get_columns_of_indexes via MSSPROCS on SAP level

6. Create missing indexes via DB02 > Checks > Database <-> ABAP/4 Dictionary > Create in DB

Thank you for your help anyway!

Bruno Pereira

0 Kudos

Hi Bruno,

Could you please elaborate the steps which would be helpful to us to solve the issue...:)

Thanks and regards,

Satish Kalakuntla.....