Copy link to clipboard
Copied
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?
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 proper
...Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
Thank you for sharing the solution. I'm glad you solved the issue.