I upgraded to 2.0.5 to see if this will rectify the previous problem. Everything looks fine, but I can't log in. I've reset my password, changed it, but nothing. I can see all the users in the database...
Weird. It took me really long to get it configured again, and I had to change a couple of things in the web.config to get it to work with Sharepoint Services: All of these settings I got from my previous web.config which used to work fine...

Added this in the httpHandlers element:
< clear / >
            < add verb="" path=".aspx" type="System.Web.UI.PageHandlerFactory, System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" / >

Changed the httpModules settings from:
< add name="GeminiHttpModule" type="Gemini.GeminiHttpModule, CounterSoft.Gemini" / >
to:
< add name="Session" type="System.Web.SessionState.SessionStateModule"/ >

Also changed validateRequest in the <pages > element to false.

Ok, I'm going to go nuts! :P

The login problem has been solved now... I changed validateRequest back to true... that did the trick. But unfortunately I am back to my original problem :'(

• Can't create or update issues. NO entries in the Error Log.
• Can't update user security
• Can't create new user
  
• Can update an Issue Resolution...
  
• Can update Security Schemes
  

Seems like Gemini is running under a read only sql user. Is your database in read only mode?

I also thought it might be that at first. But then I wouldn't be able to update anything, at this stage I can update certain things... I did double check the read-only in any case...

Thanks.

Hi All,

I'm having the exact same issue. Did you find a resolution to this?

I've tried the connection and it its writeable (I tested by inserting a row into the errorlog table). File Permissions all look good.

I can change existing users firstnames and surnames, but it says an error occurred when creating new issues, updating new issues.... all the same problems as Thea was having before.

Any help would be good!

What are the exact errors?

Hi,

Its hard to say because none are logged into the error log. Is there anything I can do to get the exception text? I've turned off custom errors but don't get anywhere, just the standard error page. When I click on the View Log there are no events from today (just timeouts from three days ago).

Can I add any sections to the webconfig file to email me on every exception?

Here is the current state of play :

Everything is readable
Incidents Can't be created
Incidents Can't be edited
Incident Comments can be edited
Incident Comments can't be created
Users can be edited
Users can't be created.
Incident Status can't be updated (Resolution, Issue worker etc)
Can't Create new Projects
Can't Create new resolutions

If you want I can try to make a screen cast presentation so you can see my actions on the screen.

Your help is appreciated.

How big is your database? Can you zip it and send to us or put on FTP?

I will ask my manager if thats OK.

I presume I can rubbish the data?

Yes. Please send details to support@countersoft.com and put the URL for this thread in the message, if you can upload the data.

Hi,

Sorry, after some discussion I can't send over the databse as there is too much data there to rubish and there is some quite sensitive information there.

Now, as an Idea could you send me over a sample Sql 2000 database so I could do a RedGate DBCompare on it with my one? This may hightlight some issues?

I did ask before but haven't heard back as to wether its possible to trap the error thats being generated in a email or something. This would really help as it can't seem to write to the databate (errors are logged in the db!)

Do you perhaps have a debug version thats got some hook in the Global.aspx.cs file to catch all Application_OnError events?

Thanks for your help, I'm really struggling with this. I'm sure that if I could get an some sort of error message it may help.

You can create a new database using the scripts that are within the Gemini zip you have downloaded.

Maybe some SQL objects are under another owner?

I've tried using the sa account connection, still get the same problems.

I'll run the setup and compate the db's might shed some light on the problem...

At last...


Looks like I found the problem.

When I imported the data over from the previous Database it removed the Identity seed from 2-3 of the tables. I've added this back in and it appears to be working as normal.

Thanks to all those who made suggestions!

Thanks for sharing your solution.