Symptom
- update of NW fails with a error CREATE_SHADOW_SCHEMA_SYB task in Preprocessing phase fails due to sp_addUser command
- create login 'SAP'+@SID+'SH' command is missing in class file
- user SAPSIDSH creation failed.
- cat CREATE_SHADOW_SCHEMA_SYBTaskExecutorService_02.ERR
com.sybase.jdbc3.jdbc.SybSQLException: No login with the specified name exists.
at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:4135)
at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:3221)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:274)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:256)
at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(SybStatement.java:2499)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(SybStatement.java:2483)
at com.sybase.jdbc3.jdbc.SybCallableStatement.executeUpdate(SybCallableStatement.java:173)
at com.sap.sdt.db.tools.syb.SRSHelper.createUser(SRSHelper.java:440)
at com.sap.sdt.db.tools.syb.SRSHelper.createShadowSchema(SRSHelper.java:57)
at com.sap.sdt.db.tools.syb.SQLMain.main(SQLMain.java:51)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Solution Manager (SOLMAN)
- SAP NetWeaver (NW) - All versions
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP Solution Manager all versions
Keywords
sp_addlogin, create login, SAPSIDSH, 'SAP'+@SID+'SH' , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.