#1 2009-01-16 10:55:22

**_domenico_**

problem to connect with the meeting room

hi there
i setup two server one for sql and one for pro connect 7
everything works fine but after i installed the SP1 for pro connect
i can access to the server i can create the meeting room
but if i try to access im getting an error

The selected resource does not exist

any idea?

regards

domenico

**_santhony_**

Re: problem to connect with the meeting room

Take a look in  your debug.log file and see what errors show up.

**_domenico_**

Re: problem to connect with the meeting room

hi there thanks for the reply but on the debug log i don't see any relevant error......

**_domenico_**

Re: problem to connect with the meeting room

i found the error in the debug file :
[01-19 11:54:22] web-8 (e) ERROR OCCURRED IN  com.macromedia.airspeed.db.SQLServerUtilityQueries.lockTableExclusive
[01-19 11:54:22] web-8 (d)  0ms spid:54 com.macromedia.airspeed.db.SQLServerUtilityQueries.lockTableExclusive
[01-19 11:54:22] web-8 (d) Exception caught in DBRows.populate(), e=java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'PPS_MEETING_START_LOCKS'.
[01-19 11:54:22] web-8 (d)  0ms spid:54 com.macromedia.airspeed.db.SQLServerUtilityQueries.setIsolationLevel(Disable Isolation)
[01-19 11:54:22] web-8 (d) RoomAssetManager Returning MEETING_START_LOCKS for 714001 after 0ms
[01-19 11:54:22] web-8 (d) SQL: UPDATE PPS_TRANSCRIPTS SET ASSET_ID=?,STATUS=? WHERE TRANSCRIPT_ID=?
[01-19 11:54:22] web-8 (d)  0ms spid:54 update com.macromedia.breeze.model.Transcript(null,"N","714101")
[01-19 11:54:22] web-8 (d) SQL: SELECT a.asset_id, a.physical_path, a.byte_count, a.file_count, a.date_end, s.account_id  FROM pps_assets a, pps_sco_assets sa, pps_scos s  WHERE a.asset_id = sa.asset_id AND sa.sco_id = ? AND sa.asset_type = 3 AND s.sco_id = sa.sco_id  AND sa.version = ?
[01-19 11:54:22] web-8 (d) SQL: SELECT max(version) AS version FROM pps_sco_assets WHERE sco_id = ?
[01-19 11:54:22] web-8 (d)  0ms spid:54 com.macromedia.breeze.sco.DAL.getMaxVersion("714001")
[01-19 11:54:22] web-8 (d) 15ms spid:54 com.macromedia.breeze.sco.DAL.getMeetingActiveAsset("714001",0)
[01-19 11:54:22] web-8 (d) <status code="no-data"/>
[01-19 11:54:22] web-8 (d) com.macromedia.airspeed.StatusException$NoData: <status code="no-data"/>
[01-19 11:54:22] web-8 (d)     at com.macromedia.airspeed.Rows.getRow(Rows.java:56)

any idea?

**_santhony_**

Re: problem to connect with the meeting room

Sounds like the upgrade may not have went as well as it should have. I would take this error and escalate to Adobe Support to see if they can help you out.

Did you check your DB for PPS_MEETING_START_LOCKS?