SAP Knowledge Base Article - Preview

2138650 - Solution Manager upgrade fails in CREATE_SHADOW_SCHEMA_SYB task in java part - SAP ASE for BS

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.