Is the problem only with the "My Work" page?

Please make sure that in your web.config you have updated the FullGeminiURL and connection string.

I too am having a similar issue. I guess similar because I too am wondering if there is a way to not call error.aspx. I can move through the application fine but whenever I do anything that performs a form submission -- try to add a new isse, new comment, even events that do javascript: _doPostBack(), I get the error.aspx and when I view the error log there are no entries. I know this sounds a bit cliche but seriously this app worked perfectly until today. Even email. I'll try to supply as much detail as I can think of:

WIN2K3 Ent.
SQL Server 2005
Gemini 2.0.5
ASP.net 1.1.4332
WSE 2.0 sp3
I installed using .msi installer supplied. Using the default location got everything (web.config)  working well. Then moved files to final location updated the path in IIS. Everything worked fine in the new location. After a few days (today), I get the behaviors listed above. I even went as far as unistalling the app with the .msi, dropping the virtual directory, rebooting, downloading a fresh copy of 2.0.5 and re-installing. Still no luck. I have tried creating a separate app pool, no luck. I can log on to the database and perform CRUD using the Gemini user that would go in the connect string. So I don't believe there is an issue with write permissions in db. Plus the app pulls data fine to display in any other page. Everything in web.config seems to be correct. At least by appearence. (I'm sure someone will ask if FullGeminiURL is written correctly, yes it is). There might be two questions in here.
1. What would cause the app to throw an error (call error.aspx) but not write to the errorlog.
2. What do the files or processes that do a form submission have in common that when they break might lead to uncovering a missed config setting or something outside of Gemini i.e. .net itself. It is not entirely impossible that I could have easily, not knowingly mind you, screwed something up in the .net environment or its users. It seems like that might be the only variable I haven't been able to nail down. I'll post this for now and let someone chew on it for while and hopefully someone might ask the right question that might shed some light on this issue. Oh yea, I get this while logged into Gemini as an admin so the permissions to create issues, etc. are there. Thanks in advance for any help.
-sean

Hi,

Yes, I have ensured that the "FullGeminiURL" is correct.

The issue occurs whenever I try and do anything related to issues - using the "My Work" link, attempting to post a new issue, list unassigned issues etc..

Any help would be most appreciated; as mentioned above, stopping error.aspx being called and just displaying a generic application error would help!

TIA

Rob

Can you try and install a new 2.0.5 instance pointing it to a new 2.0.5 database?

If it works, try pointing it to the upgraded database.

Hi,

The upgraded files pointing to a new database works fine - so I'm guessing there's an issue with the upgraded database structure from v1.9.1 to v2.0.5.

Any hints on what should be done? I ran the "Upgradev2.0.sql" script in the "upgrades" folder  followed by the "Createprocs.sql" script. Is there some other order I should use?

TIA,

Rob

Is it possible for you to send us a backup of your database?

Hi,

I'm afraid I can't really do that as it contains sensitive data and is over 300Mb in size.

Is there any other advice you can give me? Are there any constraints that may have changed between v1.9.1 and v2.0.5? Is there any way to capture the error messages (be they SQL or ASPX derived)?

Rob

Check that you do not have items that are not in the lookups, such as priority id, resolution id etc.. 

As far as I can tell there aren't any problems like that.

However I've just realised that, when attempting to register a new user, that fails too - it appears to be some database-driven tasks that are failing. Perhaps the stored procs are not correct? The security context is fine (as I can log in using Enterprise Manager and make changes as the user) so it isn't a permissions problem.

Otherwise, what I can attempt to do is run a DTS job from the old database to a new, clean one, table by table, until I get to the cause of the problem.

Any help greatly appreciated!

Rob

Try and run Gemini using an sa account.

Hi,

I'm already doing that in my development environment!

Rob

Is your database full?

There should be an error logged in the errorlog table. The possible reasons that this will not happen are:

1. Database is full
2. Connection string is wrong (read only?)

Hi,

1. The database is not full (set to grow automatically anyways but has plenty of free space).

2. The connection string is fine - I wouldn't be able to log in if it wasn't.

Any other advice?