SAP Knowledge Base Article - Preview

2766965 - SolMan 7.2 SP08 Upgrade Error - Java Stack error during DROP-SHADOW-SCHEMA-SYB step - ASE BS

Symptom

During SUM DROP-SHADOW-SCHEMA-SYB step is failing to drop the shadow schema with the following error in the phase log:

 

Mar 4, 2019 1:23:45 PM [Info ]: Command line: /shadow/SUM/jvm/jre/bin/java -Dsap.runtime.vm.allow=*;SAP*;1.*;* -cp /usr/sap/XC1/DVEBMGS02/exe/sybjdbc/jconn4.jar:/shadow/SUM/sdt/lib/sdt_db_SYB.jar:. com.sap.sdt.db.tools.syb.SQLMain /usr/sap/XC1/DVEBMGS02/exe/sybjdbc/jconn4.jar jdbc:sybase:Tds:sapxc1:4911/XC1?ENABLE_FUNCTIONALITY_GROUP=1 sapsso <SecureField> DROP_SCHEMA_SYB SAPXC1SH

Mar 4, 2019 1:23:45 PM [Info ]: Standard out: /shadow/SUM/sdt/log/SUM/DROP_SCHEMA_SYBTaskExecutorService_06.OUT


The output file generated from this operation (ERR file contains less) shows the following:

 

getConnection(): getting Connection with following data ...
getConnection(): driverName: com.sybase.jdbc4.jdbc.SybDriver
getConnection(): jdbcURL: jdbc:sybase:Tds:sapxc1:4911/XC1?ENABLE_FUNCTIONALITY_GROUP=1
getConnection(): dbUser: sapsso
getConnection(): Connection to database obtained for [852] ms
getConnection(): Connected user is sapsso
isHADRSupported(): ASE Product Version to be checked: 16.0.03.05
isHADRSupported(): This ASE version does support HADR
getHADRMode(): hadr_mode = -1
clean active user sessions of SAPXC1SH
SQLException (killUserSessions): com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near '@p0'.

at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4202)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3319)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2763)
at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2747)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:336)
at com.sap.sdt.db.tools.syb.SRSHelper.killUserSessions(SRSHelper.java:841)
at com.sap.sdt.db.tools.syb.SRSHelper.dropShadowSchema(SRSHelper.java:37)
at com.sap.sdt.db.tools.syb.SQLMain.main(SQLMain.java:64)


Read more...

Environment

  • SAP SOLUTION MANAGER
  • SAP Adaptive Server Enterprise 16.0
  • SUM 1.0 SP22

Product

SAP Solution Manager 7.1

Keywords

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.