Recently in Calendar Application for College of Education Category

Last week we discovered a problem with the calendar application that I had put in production for Dr. Dana Ulveland of the College of Education. When attempting to view the main calendar, an error occurred for any calendar for which events had been approved. My initial feeling was that this was caused by some sort of rights issue on Aero, the Oracle server. My rationale was that, since I had copied an existing, working application into a new schema and changed the code to refer to the new schema, that the problem couldn't be with the code itself.

Analyzing this in detail today with Mike Ross, we discovered that select privileges had not been properly granted to public for a particuiar table. Mike discovered this as we compared the original calendar application and schema with the one I had copied. Once we granted select permissions to public, we could view the calendar.

I met with Dr. Ulveland this morning to give a demonstration of the latest version of the calendar application. On Thursday I completed the steps to copy the application to a new schema for his use. For this morning’s meeting, everything seemed to work fine.

This afternoon I revised the mailto links and event notification contact email addresses. Dr. Ulveland will now receive this email.

The program should work fine now.

As Yogi Berra would say, "It's deja vu all over again". Because of some changes in the LDAP login procedures implemented within PL/SQL, I will need to start over with my work on this project. This will be the fastest way to resolve login problems with the calendar. I will need to make another copy of the original calendar into the schema for the new application. Fortunately, I have these steps well-documented, so I expect to have this finished by Wednesday afternoon.

As of today, I have the calendar application working in a test environment within my schema on Aero. I met with Dr. Dana Ulveland this morning to give a demonstration of the application to date. My goal is to have the application in production by Friday, October 14. All that remains is to create an Oracle schema, migrate the application, change the permissions and update the URLs and package/procedure/function calls to reflect the new schema.

I will be working on a web-based calendar application for Dr. Dana Ulveland in the College of Education. He and I will meet on Monday, October 3, to discuss the details of the project.

I will be making a copy of an existing calendar application and implementing some needed changes. I have copied the existing Oracle-based application to my schema, in order to work on the project in a proper development environment. I still have a few details to work through with this copy before I begin the project at hand.

I look forward to working with this application.