[sims] Urgent Help needed !! Can't logon to sims.net

[artfulmatt]

Hi guys,

 

We have been experiencing sims running very slow and was advised to run the indexing patch....Ran the patch which never finished and received an error ( I don't know what the error was as I was never there to see it)

 

Anyway we can no-longer login to sims with an error stating :-

 

"unable to set application role"

 

Any Ideas ???

 

Thanks in advance

[kmount]

Can you restore a back up from before the patch and confirm all is OK?

[artfulmatt]

I've never had to do a restore - just to check, can I simply copy the restored DB (to another location) then attach the db's?

[artfulmatt]

OK....completed restore and everything ok

[rh91uk]

I;d be interested to know why the patch knocked it out ... once you've contacted your LA support team could you let us know? What was the patch #?

[artfulmatt]

It was the indexing patch - It was knocked out because users still had active connections in SQL (we use xenapp so although they may not connected, their session is still active within SQL) I still have one connection active who I can't seem to kick out ?

 

Ran :-

 

SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,

loginame as LoginName

FROM sys.sysprocesses

WHERE dbid > 0

GROUP BY dbid, loginame

 

Shows active connections, I still have one on the sims DB ??

[rh91uk]

Have you tried restarting the SQL service? Usually does the trick for us (but oh so dirty!)

[matt40k]

sp_who2 would be a quicker way to do it.

 

Also dbattach with /restoreui at the end of the command would allow you to restore the backup it took prior to the patch. (should end \dbattach.exe" /restoreui)

 

Guess I know what I'll be doing in the morning

[artfulmatt]

PMSL....What you doing on here ;-D

 

You have some emails in your inbox at work lol

 

OK - so is that using dbattach

[matt40k]

I get around

 

I know, problem with leaving at 4pm.

 

sp_who2 in management studio.

[artfulmatt]

No the restore ??

[artfulmatt]

What time you back in - in the morning?

[matt40k]

Ah yes, dbattach /restoreui - restore those pesky .bak. Had a quick look at the reindex patch (6635) - it reindexes then runs a dbcc (checks the database) - hopefully it hasn't found anything!! But that would be why it didn't complete - cause it didn't complete it was left in single user mode, or more likely, it couldn't go into single user mode because "someone" was logged in. If it's the latter, dbattach must lock it in some "special" way.

 

In at 8am.

[matt40k]

Before I forget... again.

 

SIMS sets the database to single user mode, then to multi user mode (I think), then applies the patch. It appears the citrix users aren't being logged off, just disconnected, which leaves a open SIMS connection, because of the homepage widgets, every few secs they reconnect to SIMS database, it appears, they have grabbed the one and only open connection. Quick fix would be to logon to SQL Management Studio and set it back to multi user, cause dbattach\patch hasn't got a connection to set it back.

 

Next question is, if it was applied as SA, would it be fine?

 

Anyway, SMIS made a tool to lock out all the SIMS user logins (I'm not sure it works with trusted logins) which should solve the problem.