on 11-17-2010 12:00 PM
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.
Any information you get in dev_w0 file?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.