Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

ASE-related components

SAP ASE for Business Suite

  • BC-DB-SYB
  •   BW-SYS-DB-SYB

Standalone ASE

  • BC-SYB-ASE

(If you use ASE as a repository database for BO, please select this.)

Information sent to SAP support

Errorlog / trace (Window edition)

Installation log

  • c:\Program Files\sapinst_instdir\

ASE log
  • C:\sybase\<SID>\ASE-16_0\install\<SID>.log
  • C:\sybase\<SID>\ASE-16_0\install\<SID>_BS.log
  • C:\sybase\<SID>\ASE-16_0\install\<SID>_JSAGENT.log
  • C:\sybase\<SID>\<SID>.cfg

  Network log

  • C:\user\sap\<SID>\DVEBMGS00\work\ 

*Please change to appropriate drive letter.

sybdiag 

KBA 1642301 - SYB: Collecting diagnostic data for Sybase ASE support
https:// support.wdf.sap.corp/sap/support/notes/1642301

System log
sm21

Run time error
st22

Other
for performance issue

  • st06(OS monitor)
  • st03n(workload monitor)
  • stad(single statistical record)

 

Useful link for Adaptive Server Enterprise

SCN, Wiki

 Sybase Channels

 Adaptive Server Enterprise Channel

 SAP ASE Home

SAP Applications on SAP Adaptive Server Enterprise (SAP ASE) http:// scn.sap.com/community/ase/content

Manual site

SAP official manual site http://help.sap.com/adaptive-server-enterprise

 Sybase old manual site http://infocenter.sybase.com/help/index.jsp

 Business Suite on ASE Guide http://service.sap.com/instguides

 -> SAP NetWeaver -> SAP NetWeaver <Release> ->Operations (monitoring and operating) -> Database-Specific Guides ->SAP DBA Guide: Sybase Adaptive Server Enterprise

FAQ

KBA 2162183 - SYB: Frequently Asked Questions for SAP ASE

Getting Started with SAP Applications Using SAP Adaptive Server Enterprise

SAP Note: 1680803 SYB: SAP Adaptive Server Enterprise - Best Practice for SAP ERP and SAP BW Sybase

 

Keyword tips in SAP Support Knowledge Search

If you see a database error in ASE errorlog, you should search it by a database error in ASE errorlog than a error in system log (sm21).

The errorlog format of ASE is various, but I support two following representative things here.

ŸError with a error number
ŸStack trace
EX1) Can you search effective Note/KBA in each pattern if you input what kind of keyword?

 

Error Number: 1105.

What keyword is most appropriate to find answer ?.

 server  Error: 1105, Severity: 17, State: 2
server  Can't allocate space for object 'DBH_MSG_LOG' in database 'saptools' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

server  Error: 1105, Severity: 17, State: 4
server  Can't allocate space for object 'syslogs' in database 'sybmgmtdb' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

Error with a error number

  • Search with ‘ASE’ ＋ Error number
  • Please add a word from error message if many results are returned

 

EX2) system exception

What keyword is most appropriate ?

kernel  attempted read from memory location FFFFFFFFFFFFFFFF from instruction at location 0x000000000159FC87
kernel  Adaptive Server Enterprise system exception (0xc0000005) generated by a storage access violation.
kernel  Symbolic stack trace information is successfully loaded
kernel  pc: 0x000000000159FC87 tdsrecv__process_batchparam+ 0x967 (0x000000000767F4E0, ………………
kernel  pc: 0x000000000159FF90 tdsrecv__dynexec_batch+ 0xd0 (0x00000000A34413F0 , ………………
kernel  pc: 0x00000000015A0756 tdsrecv__dynexec+ 0x1a6 (0x000000007E5D8490 , ………………
kernel  pc: 0x0000000000BA1C2C tdsrecv_dynamic+ 0x4b118c (0x000000000767F730 , ………………
kernel  pc: 0x000000000050EA13 conn_hdlr+ 0xc53 (0x0000000029627D50 , ………………
kernel  pc: 0x000000000065965F kpntwrapper+ 0x4f (0x0000000000000000 , ………………
kernel  pc: 0x00007FFDD1AB3B49 CreateFiberEx+ 0x271 (0x0000000000000000 , ………………
kernel  end of stack trace, spid 53, kpid 7667771, suid 6
kernel  DUMP OF LOADED MODULES:-

 

Stack trace
  • Search with “System exception” + function in the top of stack trace
  • If terminate_process or ex_raise in stack trace, please select a function just before that
  • It is favorable for all functions to accord
  • If there is no result, please change the keyword to “signal” or ”infected” instead of ”system exception”

 

  • No labels