- Topics: Active | Unanswered
Pages: 1
Topic closed
#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
Offline
#2 2009-01-16 17:11:21
- **_santhony_**
Re: problem to connect with the meeting room
Take a look in your debug.log file and see what errors show up.
Offline
#3 2009-01-19 05:36:43
- **_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......
Offline
#4 2009-01-19 07:21:54
- **_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?
Offline
#5 2009-01-20 00:04:45
- **_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?
Offline
Pages: 1
Topic closed