Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    6

    Unanswered: Db Connect Error

    While upgrading from 4.0b TO 4.7 in SAP R/3 in shadow instance 01 , we r getting the follow. error which is attached as follows.which is nothing but log file.

    --------------------------------------------------
    trc file: "dev_w21", trc level: 1, release: "620"
    ---------------------------------------------------
    *
    * ACTIVE TRACE LEVEL 1
    * ACTIVE TRACE COMPONENTS all, M
    *
    B
    B Thu Mar 04 17:43:45 2004
    B create_con (con_name=R/3)
    B Loading DB library 'C:\usr\sap\put\exe\dbmssslib.dll' ...
    B
    B Thu Mar 04 17:43:47 2004
    B Library 'C:\usr\sap\put\exe\dbmssslib.dll' loaded
    B Version of 'C:\usr\sap\put\exe\dbmssslib.dll' is "620.02", patchlevel (0.1270)
    B
    B Thu Mar 04 17:43:48 2004
    B New connection 0 created
    M systemid 560 (PC with Windows NT)
    M relno 6200
    M patchlevel 0
    M
    M Thu Mar 04 17:43:49 2004
    M patchno 674
    M intno 20020600
    M pid 2884
    M
    M ***LOG Q0Q=> tskh_init, WPStart (Workproc21 2884) [dpxxdisp.c 1028]
    I MtxInit: -2 0 0
    M
    M Thu Mar 04 17:43:51 2004
    M DpShMCreate: sizeof(wp_adm) 16544 (752)
    M DpShMCreate: sizeof(tm_adm) 1690816 (8412)
    M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
    M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
    M DpShMCreate: sizeof(comm_adm) 192000 (384)
    M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
    M DpShMCreate: SHM_DP_ADM_KEY (addr: 058A0040, size: 1981584)
    M DpShMCreate: allocated sys_adm at 058A0040
    M DpShMCreate: allocated wp_adm at 058A0560
    M DpShMCreate: allocated tm_adm_list at 058A4600
    M DpShMCreate: allocated tm_adm at 058A4628
    M DpShMCreate: allocated wp_ca_adm at 05A412E8
    M DpShMCreate: allocated appc_ca_adm at 05A45938
    M DpShMCreate: allocated comm_adm_list at 05A470A8
    M DpShMCreate: allocated comm_adm at 05A470C0
    M DpShMCreate: allocated ca_info at 05A75EC0
    M DpShMCreate: allocated wall_adm at 05A75EC8
    X EmInit: MmSetImplementation( 2 ).
    X <ES> client 21 initializing ....
    X Using implementation std
    M <EsNT> Memory Reset enabled as NT default
    X ES initialized.
    M
    M Thu Mar 04 17:43:52 2004
    M calling db_connect ...
    C
    C Thu Mar 04 17:43:54 2004
    C SQLOLEDB Provider Release:08.10.9031
    C
    C Thu Mar 04 17:43:56 2004
    C CheckConnection: line 39141. hr: 0x80040e09 SELECT permission denied on object 'sysobjects', database 'UPG', owner 'dbo'.
    C HandleOledbError [CheckConnection,line 39141]: Error/Message: (err 229, sev 0), SELECT permission denied on object 'sysobjects', database 'UPG', owner 'dbo'.
    B ***LOG BY2=> sql error 0 performing CON [dblink#1 @ 419] [dblink 0419 ]
    B ***LOG BY0=> <message text not available> [dblink#1 @ 419] [dblink 0419 ]
    M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1102]
    M in_ThErrHandle: 1
    M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8437]
    M
    M Info for wp 21
    M
    M stat = 4
    M reqtype = 5
    M act_reqtype = -1
    M tid = -1
    M mode = 255
    M len = -1
    M rq_id = -1
    M rq_source = 255
    M last_tid = 0
    M last_mode = 0
    M rfc_req = 0
    M report = > <
    M action = 0
    M tab_name = > <
    M
    M ************************************************** ***************************
    M *
    M * LOCATION SAP-Server upgrade_UPG_01 on host upgrade (wp 21)
    M * ERROR tskh_init: db_connect
    M *
    M * TIME Thu Mar 04 17:43:56 2004
    M * RELEASE 620
    M * COMPONENT Taskhandler
    M * VERSION 1
    M * RC 13
    M * MODULE thxxhead.c
    M * LINE 8569
    M * COUNTER 1
    M *
    M ************************************************** ***************************
    M
    M Entering TH_CALLHOOKS
    M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
    M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]
    M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 237]
    M Entering ThSetStatError
    M Entering ThReadDetachMode
    M call ThrShutDown (1)...
    M ***LOG Q02=> wp_halt, WPStop (Workproc21 2884) [dpnttool.c 346]

    ---------------------------------
    after this error our disp+work does not get started in SAP R/3.

    Waiting for ur reply ASAP on this issue.

    rgds/........

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Ensure the account use to upgrade does have required privileges on involved SQL server database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    6
    Hi ,
    Actually it was working before , but in the phase called NTACT_PREMV
    Upgrade r3up thorows me out with error ...
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ~~~~~~~~~~~~~~~
    MV40ANT and RETURN CODE in PN000304.UPG
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~
    2EETP399XRead table " ": pgntab call: table not found.
    2AETP399 Table " ": unknown error -9
    1 ETP111 exit code : "12"
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    mean time when i check shadow instance i.e. (01) disp failed to start.

    This is due to DISPATCHER EMERGENCY SHUTDOWN .

  4. #4
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    6
    Hi ,
    Actually it was working before , but in the phase called NTACT_PREMV
    Upgrade r3up thorows me out with error ...
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ~~~~~~~~~~~~~~~
    MV40ANT and RETURN CODE in PN000304.UPG
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~
    2EETP399XRead table " ": pgntab call: table not found.
    2AETP399 Table " ": unknown error -9
    1 ETP111 exit code : "12"
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    mean time when i check shadow instance i.e. (01) disp failed to start.

    This is due to DISPATCHER EMERGENCY SHUTDOWN .

    I just want to crack this error with regards to MS SQL

    Thu Mar 04 17:43:56 2004
    C CheckConnection: line 39141. hr: 0x80040e09 SELECT permission denied on object 'sysobjects', database 'UPG', owner 'dbo'.
    C HandleOledbError [CheckConnection,line 39141]: Error/Message: (err 229, sev 0), SELECT permission denied on object 'sysobjects', database 'UPG', owner 'dbo'.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The error represents :
    By default, login will not have permission to Insert, Select, Update or Delete records in the referenced table.

    Test same login in Query Analyzer by trying to select on a table in the database after you have logged in with the new username and password.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    6
    according to requirement of error how should i go ahead to grant permission ?

    please can you give me indetail ?

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    CheckConnection: line 39141. hr: 0x80040e09 SELECT permission denied on object 'sysobjects', database 'UPG', owner 'dbo'.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Logon to SQL server with SA account and use GRANT statement to grant required permissions.

    Refer to SQL Server books online for more information on GRANT statement.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  8. #8
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    6
    Lot of thanks Satya !!!

  9. #9
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    6
    Lot of thanks Satya !!!

  10. #10
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

    Thumbs up

    Assumed, problem is resolved!
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •