SAP Knowledge Base Article - Preview

3079859 - SUM is unable to execute UPDATE-STATISTI

Symptom

You are SUM is unable to run update index statistics due to driver issues, reported from file UPDATE_STATS_SYBTaskExecutorService_07.ERR

java.lang.ClassNotFoundException: com.sybase.jdbc4.jdbc.SybDriver
       at java.net.URLClassLoader.findClass(URLClassLoader.java:444)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:480)
       at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:384)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:413)
       at java.lang.Class.forName0(Native Method)
       at java.lang.Class.forNameFW(Class.java:362)
       at java.lang.Class.forName(Class.java:270)
       at com.sap.sdt.db.tools.syb.SQLHelper.getConnection(SQLHelper.java:1320)
       at com.sap.sdt.db.tools.syb.SQLHelper.<init>(SQLHelper.java:57)
       at com.sap.sdt.db.tools.syb.SQLMain.main(SQLMain.java:45)
com.sybase.jdbc4.jdbc.SybDriver Exception in thread "main" java.lang.ClassNotFoundException:
com.sybase.jdbc4.jdbc.SybDriver
       at java.net.URLClassLoader.findClass(URLClassLoader.java:444)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:480)
       at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:384)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:413)
       at java.lang.Class.forName0(Native Method)
       at java.lang.Class.forNameFW(Class.java:362)
       at java.lang.Class.forName(Class.java:270)
       at com.sap.sdt.db.tools.syb.SQLHelper.getConnection(SQLHelper.java:1320)
       at com.sap.sdt.db.tools.syb.SQLHelper.<init>(SQLHelper.java:57)
       at com.sap.sdt.db.tools.syb.SQLMain.main(SQLMain.java:45)

From UPDATE-STATISTICS-PRE-DEPLOY-SYB_07.0.LOG:
<!--LOGHEADER[START]/--> <!--HELP[Manual modification of the header may cause parsing problem!]/-->
<!--LOGGINGVERSION[2.0.7.1006]/-->
<!--NAME[/usr/sap/install_<SID>/SUM/sdt/log/SUM/UPDATE-STATISTICS-PRE-DEPLOY-SYB_07.LOG]/-->
<!--PATTERN[UPDATE-STATISTICS-PRE-DEPLOY-SYB_07.LOG]/-->
<!--FORMATTER[com.sap.tc.logging.TraceFormatter(%d [%6s]: %m)]/-->
<!--ENCODING[UTF8]/--> <!--FILESET[0, 20, 10485760]/-->
<!--PREVIOUSFILE[UPDATE-STATISTICS-PRE-DEPLOY-SYB_07.19.LOG]/-->
<!--NEXTFILE[UPDATE-STATISTICS-PRE-DEPLOY-SYB_07.1.LOG]/-->
<!--LOGHEADER[END]/--> Jul 19, 2021 1:57:20 PM [Info ]: Configuration has been built from input file /usr/sap/install_<SID>/SUM/sdt/config/ExecuteTasks_SYB.xml.
Jul 19, 2021 1:57:20 PM [Info ]: Global configuration has been built from input file /usr/sap/install_<SID>/SUM/sdt/config/ExecuteTasks_SYB.xml.
Jul 19, 2021 1:57:20 PM [Info ]: AS Java process ID 691, name com.sap.sdt.db.tools.syb.SQLMain has been started.
Jul 19, 2021 1:57:20 PM [Info ]: Command line: /usr/sap/install_<SID>/SUM/jvm/jre/bin/java -Dsap.runtime.vm.allow=*;SAP*;1.*;* -cp /usr/sap/<SID>/J20/exe/sybjdbc/jconn42.jar:/usr/sap/install_<SID>/SUM/sdt/lib/sdt_db_SYB.jar:. com.sap.sdt.db.tools.syb.SQLMain /usr/sap/<SID>/J20/exe/sybjdbc/jconn42.jar jdbc:sybase:Tds:beu<SID>cj:4901/<SID>?ENABLE_FUNCTIONALITY_GROUP=1 SAPSR3DB <SecureField> UPDATE_STATS_SYB skip=false
Jul 19, 2021 1:57:20 PM [Info ]: Standard out: /usr/sap/install_<SID>/SUM/sdt/log/SUM/UPDATE_STATS_SYBTaskExecutorService_07.OUT
Jul 19, 2021 1:57:20 PM [Info ]: Process ID 691 has been started. Jul 19, 2021 1:57:20 PM [Info ]: Waiting for process ID 691, name java to finish.
Jul 19, 2021 1:57:20 PM [Info ]: Process ID 691, name java has been finished, exit code 1.
Jul 19, 2021 1:57:20 PM [Error ]: The following problem has occurred during step execution: com.sap.sdt.util.diag.DiagException: Error while executing Task with input file ExecuteTasks_SYB.xml and task UPDATE_STATS_SYB. Error while processing the result. Cannot Update Index Statistics; for more information
see /usr/sap/install_<SID>/SUM/sdt/log/SUM/UPDATE_STATS_SYB*.*. Could not execute '/usr/sap/install_<SID>/SUM/jvm/jre/bin/java -cp /usr/sap/<SID>/J20/exe/sybjdbc/jconn42.jar:/usr/sap/install_<SID>/SUM/sdt/lib/sdt_db_SYB.jar:. com.sap.sdt.db.tools.syb.SQLMain /usr/sap/<SID>/J20/exe/sybjdbc/jconn42.jar jdbc:sybase:Tds:beu<SID>cj:4901/<SID>?ENABLE_FUNCTIONALITY_GROUP=1 SAPSR3DB <SecureField> UPDATE_STATS_SYB skip=false', return code '1'.
Check if process output file(s) '/usr/sap/install_<SID>/SUM/sdt/log/SUM/UPDATE_STATS_SYBTaskExecutorService.OUT', '/usr/sap/install_<SID>/SUM/sdt/log/SUM/UPDATE_STATS_SYBTaskExecutorService.ERR' have been created. . beul092091:<SID>adm 198> pwd /usr/sap/install_<SID>/SUM/sdt/log/SUM


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions
  • SUM 1.0 SP25

Product

SAP Solution Manager 7.2

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.