SAP Knowledge Base Article - Preview

3194789 - Failed to start service on PO system - SAP ASE for Business Suite.

Symptom

  • Java system failed to start due to the error below.

    [std_server0.out]
    Caused by: com.sybase.jdbc4.jdbc.SybSQLException: J2EE_CONFIG not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

  • Isql connection was working and the J2EE_CONFOG table exists in the <SID> DB.

    isql -USAPSR3DB -P<password> -S<SID> -w999 -X

    use <SID>
    go

    select * from sysobjects where name like "%J2EE_CONFIG%"
    go

    select top 1 * from J2EE_CONFIG
    go

    --1 row returns.

  • R3trans -X returned the following message.

    [ASE Error SQL924][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Database '<SID>' is already open and can only have one user at a time.
    [ASE Error SQL4001][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cannot open default database '<SID>'.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Netweaver on JAVA (all versions)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.