Skip to main content
January 8, 2014
Answered

Connect 7 Error after Upgrade to Connect 9

  • January 8, 2014
  • 1 reply
  • 683 views

I have just upgraded my test environment to Connect 9 successfully but when i log in I get an Adobe Acrobat Connect 7 Profesional error. I didn't get this when we were on Connect 8. Here is the error message in full

Adobe Acrobat Connect 7 Professional

error-internal-error-title

error-internal-error-body

Request Details:
============================ 
<actions mode="multiple">
  <action name="report-my-meetings">
    <param name="sort-date-begin">desc</param>
    <param name="filter-expired"/>
    <param name="include-user-count">false</param>
    <param name="filter-like-name"/>
    <order-by name="sort-date-begin"/>
    <orientation order="descending"/>
  </action>
</actions> +


Response Details: 
============================ 
<results>
  <status code="some-errors"/>
  <result>
    <status code="ok"/>
    <sco-nav>
      <sco sco-id="470507" type="tree" icon="folder" depth="0">
        <name>Training Catalog</name>
      </sco>
    </sco-nav>
  </result>
  <result>
    <status code="internal-error">
      <exception>[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'b'.</exception>
    </status>
  </result>
</results> +

Any ideas as to what might be causing this?

    This topic has been closed for replies.
    Correct answer

    I contacted Adobe support to get help with this issue and thought I would add what we did to fix this issue incase any one else has a similar problem. The main issues were resolved when we found that I hadnt changed the compatibilty level of the database when I copied the database to a new server. Once this was changed form SQL 2000 to SQL2008 the issues went away. I believe Adobe Connect 9 requires that the database be a SQL 2008 database or higher.

    Right click on the database and select properties

    Go to Options and change Compatitbilty Level to SQL Server 2008 (100)

    Hope this helps

    1 reply

    Jorma_at_Knox
    Legend
    January 8, 2014

    Looks like a SQL DB issue. It is possible you are facing a situation where the DB scheme didn't update properly, or missed an update. Contact Support and the SQL update scrips for versions 7-9 and run those. See if that resolves the issue.

    Correct answer
    January 28, 2014

    I contacted Adobe support to get help with this issue and thought I would add what we did to fix this issue incase any one else has a similar problem. The main issues were resolved when we found that I hadnt changed the compatibilty level of the database when I copied the database to a new server. Once this was changed form SQL 2000 to SQL2008 the issues went away. I believe Adobe Connect 9 requires that the database be a SQL 2008 database or higher.

    Right click on the database and select properties

    Go to Options and change Compatitbilty Level to SQL Server 2008 (100)

    Hope this helps

    Jorma_at_Knox
    Legend
    January 28, 2014

    Thank you for sharing the solution. I'm glad you solved the issue.