Skip to main content
A
Anonymous
June 29, 2012
Answered

Patching Connect & DB

  • June 29, 2012
  • 1 reply
  • 1947 views

Hi,

Back again...

I note the latest Adobe Connect patch is 8.2.2.

I believe we are at 8.2.0.1 (if the Breeze folder is anything to go by).

How does one check the current version/build level?

Also, within the update packages there are sql packages (e.g. update-xxxxxxx.sql).

How are these applied.

Many thanks for any assistance.

guhwuh.

    This topic has been closed for replies.
    Correct answer aniketsharad

    Hmmm...

    With reference to http://kb2.adobe.com/cps/927/cpsid_92717.html

    Point 4: Apply the SQL to the Adobe Connect database instance: "update-2961764.sql"

    This suggest it's outwith the patch installer executable.

    If I run the sql against the database I get...

    Msg 2812, level 16, State 62, Line 6

    Could not find stored procedure 'updateLogger'.

    START TRANSACTION 0

    TRANSACTION CNT -1

    START...

    Msg 208, Level 16, State 1, Line 78

    Invalid object name 'PPS_FIELD_NAMES'.

    Msg 2812, level 16, State 62, Line 6

    Could not find stored procedure 'updateLogger'.

    Query completed with errors.

    I wasn't expecting that; have others witnessed similar?


    Script needs to be manually executed on the Connect DB after stopping Connect Services. You actually need to execute the script manually as 8.2.2 is a patch and not a regular Connect installer which would automate everything.

    Secondly, from what I can make out from this error - seems you had executed the script on a DB other than DB dedicated for Connect. Please try executing it on Connect DB.

    Thanks

    Aniket

    1 reply

    Jorma_at_Knox
    Jorma_at_Knox
    Legend
    June 29, 2012

    The fastest way I know of identifying what version of Connect you are on is by going to a login screen for your server and placing your mouse cursor over the 'Help' link on the bottom left of the page. It will list your version of Connect as a tool tip.

    You can also add version.txt to your Connect server URL and it will display the version of Connect you are using and the Service Packs applied to it.

    For example http://realeyesconnect.adobeconnect.com/version.txt

    The sql updates should be applied when running the updates for Connect.

    A
    Anonymous
    July 2, 2012

    Thank you Jorma, the version.txt method is delightfully simple.

    If I could trouble you further though...

    Re: The sql updates should be applied when running the updates for Connect

    For my clarity, is this an automated part of the update process (the update can apply it because the database server is known to Connect)

    or does the sql code file need to be run manually on the database server?

    Thanks, as always, for any help.

    Jorma_at_Knox
    Jorma_at_Knox
    Legend
    July 2, 2012

    The sql updates that come as part of the Connect updater, should apply automatically to the sql db that the Connect account it tied to. I don't know the specifics of it, but you should call Platinum Support for those details, if you are current on your M&S.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices