Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2011
    Location
    Poland
    Posts
    21

    Question Unanswered: SQL Server system exception (0xc0000005) generated by a storage access violation

    Hi all,

    Today I have some problems with my Sybase ASE 12.5 running on Windows 2003 Server.

    When I'm trying to start rep agent on my database I'm getting the following error in server's log file:

    03:00000:00066:2012/04/19 08:20:08.18 server Started Rep Agent on database, 'central' (dbid = 4).
    03:00000:00066:2012/04/19 08:20:08.18 kernel ksctsetlocale: connectivity library error. Operation: cs_locale(CS_SET CS_SYB_SORTORDER PlCiAi_cp1250).
    03:00000:00066:2012/04/19 08:20:08.18 kernel kscssetlocale: connectivity library error. Operation: cs_config().
    03:00000:00066:2012/04/19 08:20:10.59 kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00A30001 (Symbol not found)(0x00000000, 0x00000000, 0x00000000, 0x00000000)
    03:00000:00066:2012/04/19 08:20:10.60 kernel end of stack trace, spid 66, kpid 4194368, suid 0
    03:00000:00066:2012/04/19 08:20:10.60 kernel ************************************
    03:00000:00066:2012/04/19 08:20:10.60 kernel curdb = 4 pstat = 0x10000 lasterror = 0
    03:00000:00066:2012/04/19 08:20:10.60 kernel preverror = 0 transtate = 1
    03:00000:00066:2012/04/19 08:20:10.60 kernel curcmd = 0 program = <rep agent>
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00B01A9D (Symbol not found)(0x01BEF64C, 0x77E61A60, 0x77E64598, 0xFFFFFFFF)
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00B01A9D (Symbol not found)(0x01BEF64C, 0x01BEF404, 0x0000270F, 0x00000002)
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00ADACFA (Symbol not found)(0x00400040, 0x00000002, 0x0000270F, 0x00000000)
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00ADA984 (Symbol not found)(0x00400040, 0x00000001, 0x00000000, 0x00000000)
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00A9472B (Symbol not found)(0x00400040, 0xFFFFFFFF, 0xC0000005, 0x0772A2B0)
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00407343 (Symbol not found)(0xC0000005, 0x77BC6CD5, 0x01BEF9E0, 0x00000000)
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00A8895B (Symbol not found)(0x07F2089C, 0x00000000, 0x00000000, 0x07F2089C)
    03:00000:00066:2012/04/19 08:20:10.60 kernel pc: 0x00A89487 (Symbol not found)(0x00A89383, 0x07F2089C, 0x00905A4D, 0x00000003)
    03:00000:00066:2012/04/19 08:20:10.62 kernel pc: 0x77E6482F kernel32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    03:00000:00066:2012/04/19 08:20:10.62 kernel end of stack trace, spid 66, kpid 4194368, suid 0

    And Rep Agent simply hanging. I can't even stop it. Only way to restart rep agent is to restart whole instance. After db server restart when I'm trying to start rep agent the error is occuring again (and so on...).

    Can anyone help me with that case?
    Did anyone have similar broblem and got some solution?

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi,

    Try to check if the 'Character Set' and the 'Sort order' are equal on the rep server and the ase.
    from the error, i bet on sort order being diferent.

    Command - sp_helpsort



    Good luck.

  3. #3
    Join Date
    Mar 2011
    Location
    Poland
    Posts
    21
    Hi,

    It wasn't problem with sort order, there were problem with transaction log on database. That's why the rep agent won't run.

    Here is how I solved it:

    on dbs
    dbcc settrunc('ltm', 'ignore')
    dump tran central truncate_only
    dump database central
    dbcc settrunc('ltm', 'valid')

    on rs rssd:
    rs_zeroltm data_server, database

    after that everything starts working.

    According to sort order I have no idea how to do it.
    When I'm trying to set the same sort order on rssd as it is set on dbs
    sp_configure "default sortorder id", 219

    I'm getting following information:

    Cannot reconfigure server to use sort order ID 219, because the row for its underlying character set (ID 22) does not exist in syscharsets.

    Any idea how to change it?

Posting Permissions

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