Hi All,

 

Here is a great titbit for when you are having blackboard errors and get a ERROR ID like:

For reference, the Error ID is 6cc69cc6-12a6-44c7-a933-544eb7033690.

If you right click on the page and chose view source(in IE) or View Frame Source(in FF) at the bottom of the page you will have a java error (called a stack trace) this gives a better idea of why the failure may of occurred, and positing that to the list may enable us to give a better response.

 

 

Here is an example of a stack trace.

 

2009-03-22 11:45:13 - A database error occurred.<P><span class="captionText">For reference, the Error ID is 9fbbbcde-85b4-4620-bde8-
8002d8e2e023.</span> [blackboard.persist.PersistenceException]
2009-03-22 11:45:13 - A database error occurred.<P><span class="captionText">For reference, the Error ID is 9fbbbcde-85b4-4620-bde8-
8002d8e2e023.</span> - blackboard.persist.PersistenceException: A database error occurred.
at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:165)
at blackboard.persist.impl.NewBaseDbPersister.doUpdate(NewBaseDbPersister.java:144)
at blackboard.persist.impl.NewBaseDbPersister.doPersist(NewBaseDbPersister.java:102)
at blackboard.persist.announcement.impl.AnnouncementDbPersisterImpl.persistSimple(AnnouncementDbPersisterImpl.java:81)
at blackboard.platform.announcement.service.impl.AnnouncementManagerImpl.resetPosition(AnnouncementManagerImpl.java:145)
at blackboard.platform.announcement.service.impl.AnnouncementManagerImpl.deleteAnnouncement(AnnouncementManagerImpl.java:123
)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at blackboard.db.TransactionInterfaceFactory$TransactionHandler$1.run(TransactionInterfaceFactory.java:73)
at blackboard.db.ConnectionManager.performTransaction(ConnectionManager.java:296)
at blackboard.db.TransactionInterfaceFactory$TransactionHandler.invoke(TransactionInterfaceFactory.java:89)
at $Proxy47.deleteAnnouncement(Unknown Source)
at blackboard.webapps.blackboard.announcement.struts.AnnouncementAction.delete(AnnouncementAction.java:352)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:266)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:167)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:446)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at blackboard.struts.BbActionServlet.service(BbActionServlet.java:92)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor227.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at blackboard.platform.servlet.ContentTypeFilter.doFilter(ContentTypeFilter.java:56)
at sun.reflect.GeneratedMethodAccessor238.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:218)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at blackboard.platform.servlet.RequestSessionFilter.handleRequest(RequestSessionFilter.java:390)
at blackboard.platform.servlet.RequestSessionFilter.doFilter(RequestSessionFilter.java:195)
at sun.reflect.GeneratedMethodAccessor237.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:218)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:595)
Root Cause:
java.sql.SQLException: ORA-01407: cannot update ("BB_BB60"."ANNOUNCEMENTS"."ORDER_NUM") to NULL

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at blackboard.persist.impl.ModificationQuery.doExecute(ModificationQuery.java:74)
at blackboard.persist.impl.UpdateQuery.doExecute(UpdateQuery.java:215)
at blackboard.persist.impl.Query.executeQuery(Query.java:126)
at blackboard.persist.impl.AbstractBaseDbPersister$DbConnectivityPrivilege.run(AbstractBaseDbPersister.java:241)
at java.security.AccessController.doPrivileged(Native Method)
at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:147)
at blackboard.persist.impl.NewBaseDbPersister.doUpdate(NewBaseDbPersister.java:144)
at blackboard.persist.impl.NewBaseDbPersister.doPersist(NewBaseDbPersister.java:102)
at blackboard.persist.announcement.impl.AnnouncementDbPersisterImpl.persistSimple(AnnouncementDbPersisterImpl.java:81)
at blackboard.platform.announcement.service.impl.AnnouncementManagerImpl.resetPosition(AnnouncementManagerImpl.java:145)
at blackboard.platform.announcement.service.impl.AnnouncementManagerImpl.deleteAnnouncement(AnnouncementManagerImpl.java:123
)

 

Regards

Garry

 

Hi Sandra

 

We've had a similar problem in courses with large numbers of announcements.  Have you tried dragging the announcement to the end of the list?  We've found this to work and allow you to edit or delete the announcement in most cases.

------------------------------------------------

Blackboard Support
Academic Technologies Group
IT Services
University of the West of England
Bristol
BS16 1EJ
Email: [log in to unmask]
Tel: 0117 32 85735 Ext: 85735
Fax: 0117 32 81002

 

From: Blackboard/Courseinfo userslist [mailto:[log in to unmask]] On Behalf Of MURRAY M.R.
Sent: 23 September 2009 14:04
To: [log in to unmask]
Subject: Re: Blackboard 9 - can't remove or edit an old announcement

Sandra,

 

My guess is that the announcement was posted by a user whose account no longer exists or is otherwise blocked from the course. We’ve come across a couple of these. One way round is to temporarily reinstate the user’s enrolment – not ideal. Your TSM might know of another fix J

 

HTH

 

Malcolm.

 

 

---
Dr Malcolm Murray

Learning Technologies Team Leader
IT Service
Durham University

 

Hi,

Anyone finding this a problem?

We have an announcement that was copied over at rollover – it refuses to be edited or deleted – we get the following message.

The specified object was not found.

For reference, the Error ID is 6cc69cc6-12a6-44c7-a933-544eb7033690.

Wednesday, 23 September 2009 13:53:21 o'clock BST

Sandra PartingtonT

E-Learning Manager

City and Islington College

City and Islington College Beacon Status, rated as outstanding by Ofsted and winner of the Queen's Anniversary Prize 2007. Disclaimer: This email, including any attachments, is intended for the recipient(s) named above. It may contain confidential or privileged information and should not be read, copied, otherwise used by any other person. The content of this email is that of the author and does not necessarily represent the views of the college. For further information visit our website http://www.candi.ac.uk or for general enquiries call +44 207 700 9333