Professional Web Applications Themes

Cant Serialize transaction - Macromedia ColdFusion

A new error i'm seeing on our development server with Blackstone (redhat & oracle).. When updating or inserting, i get this: [Macromedia][Oracle JDBC Driver][Oracle]ORA-08177: can't serialize access for this transaction Has anyone else seen this?...

  1. #1

    Default Cant Serialize transaction

    A new error i'm seeing on our development server with Blackstone (redhat &
    oracle).. When updating or inserting, i get this:

    [Macromedia][Oracle JDBC Driver][Oracle]ORA-08177: can't serialize access for
    this transaction

    Has anyone else seen this?

    szhark Guest

  2. #2

    Default Re: Cant Serialize transaction

    This issue may have to do with updates made to client variable processing. Are
    you storing client variables in you Oracle database? If so test using a
    dedicated datasource for clientvar storage. It can point to the same database
    as your application's main datasource. But a unique DSN may keep the client
    variable datasource settings from impacting your application queries. Let me
    know your results.

    kasmit4 Guest

  3. #3

    Default Re: Cant Serialize transaction

    Hello szhark,
    Please update the init.ora file on your Oracle server to have the attribute
    serializable set true. We suspect the reason for this error is you have set
    serializable set false.

    CFMX 6.1 (with updates) and CFMX 7 try to process your client variable
    transactions using isolation level SERIALIZABLE.

    Let me know if this does not resolve your problem.

    ksmith Guest

  4. #4

    Default Re: Cant Serialize transaction

    Creating a unique DSN for the client variables has resolved this problem.. thanks for the responses.
    szhark Guest

  5. #5

    Default Re: Cant Serialize transaction

    We are getting the same error message (Solaris 8 and Oracle 9.2.0.4). We have
    already set up a unique DSN for the client variable storage. When we changed
    the init.ora serializable parameter to true, ColdFusion could not even connect
    to the database. Does anyone have any other suggestions?

    KathyK Guest

  6. #6

    Default Re: Cant Serialize transaction

    Give us the version of CF you are using. If cfmx 6.1 install updater1 and the client variable hotfixes listed for it. If using cfmx7 install the ulative hotfix 3 as soon as it publishes.
    kasmit4 Guest

  7. #7

    Default Re: Cant Serialize transaction

    We are using CFMX 7. Any idea when the ulative hotfix 3 will be published?
    KathyK Guest

Similar Threads

  1. Serialize a Dataset
    By Tom_B in forum ASP.NET Web Services
    Replies: 1
    Last Post: May 21st, 04:55 PM
  2. Serialize web control
    By Ahab Guirguis in forum ASP.NET Building Controls
    Replies: 1
    Last Post: December 17th, 08:25 AM
  3. serialize / unserialize
    By Chris Mosser in forum PHP Development
    Replies: 3
    Last Post: September 2nd, 11:57 AM
  4. Transaction id and transaction isolation
    By Alex in forum Informix
    Replies: 3
    Last Post: July 23rd, 09:33 PM
  5. Serialize question
    By Kairi Zikpin in forum ASP.NET General
    Replies: 0
    Last Post: July 1st, 02:15 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139