Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sutorcen
Starting Member
2 Posts |
 Posted - 2011-07-20 : 07:19:20
|
| Hi everyone.I am in a strange situation. The story goes like this.I’m an IT manager at a company, but my specialty has nothing to do with SQL databases. The company that provided us our CRM software has closed… for good. So there is no one to support their software. I can handle basic database problems but now some procedures are starting to crash. Mainly whenever I try to delete something from within the CRM software. Either a time out error or a script error.Is there a chance, that any of you may be able to help me, If I provided here all the error messages and anything else you need?Please let me know before I start posting. Thank you in advance. |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-07-20 : 08:28:54
|
While we could probably help debugging or addressing individual issues... it might be in your interest to find a consultant or consulting firm that could be a resource for your company. Even if the consultant doesn't have experience in the CRM software that you have, experience with SQL and experience supporting other software will help. And, if you find one you like, they will likely build some familiarity with the software - which may make successive issues easier (quicker/cheaper) to resolve.My $.02Corey I Has Returned!! |
 |
|
|
Sutorcen
Starting Member
2 Posts |
Posted - 2011-07-20 : 10:09:26
|
| Thanks for the advice Seventhnight, thought about that also. :)I have some questions.The problems always occur when I try to delete something from inside the software. Usually the error message reads like thisError occurred –(some numbers)routine “name of routine” encountered an error in form “name of form”(I would post a screenshot but it’s in Greek. Also I write routine in the translated error message above, because that is what it’s saying in Greek. It could of course mean process)I can’t seem to find neither the said routine, nor the said form in my SQL Server Enterprise Manager under the CRM’s database name. Am I even looking in the right place?Also when I try to manually delete the entry from the database I get this weird message. “Another user has modified the contents of this table or view; the database row you are modifying no longer exist in the database.” ?????????Let’s start with those. Thanks again for your time. |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-07-20 : 10:56:29
|
Well, the first error referencing 'routine' and 'form' are more likely to be errors from the application (whatever flavor that may be: WebApp, WinApp, etc...)As for DB error, I don't recognize it right away (which doesn't mean much  ), but I would guess it is either a Transaction issue or somekind of Trigger issue. I'm leaning towards a transaction issue: something like the app attempted to delete the record, but hasn't committed the transaction yet...Hopefully someone else has seen this  CoreyI Has Returned!! |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-07-20 : 12:12:45
|
| Ouch -- you could be in a bad place depending on how popular that CRM software was / how *retarded* it was when accessing the db.Suggestions:1) Find out what the database looks like. Is it definitely a SQL SERVER DB? If so can you access it in management studio? Do you even have any credentials to get on there and look about?2) Assuming you can actually get onto the db. Have a look at the programmability objects. If you are *really* lucky then there may be some nicely named procs for adding, updating, deleting content.3) Same goes for tables -- maybe (just maybe) it won't be a mess of terribly named, horrifically connected, crud with names like [FF453213]4) Look to see if you can export the data. Then move to another solution.In all honesty I'm expecting that, even if you can get onto the db and look around, it'll be a mess.obviously we'll help as much as we can but....... Sorry dude, that's a tough situation to be in.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-20 : 13:47:36
|
| If I were to take a shot in the dark, I'd rebuild indexes. This may resolve the timeout errors.A lot of "managed applications" forget this part.As for the other error, it's due to the application downloading recordsets and allowing users to work on them, then re-submit 'em.Don't manually delete entries through the GUI. Use T-SQL DELETE statements.All that said, I agree with Corey that your best bet is to find a local consultant. |
|
|
|
|
|
|
|
|
Help needed. IT Company that supported us closed.