Vikky03

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-16
06:10
311 views
Problem In Sm 7.10
Hello Sir,
I am working on HP Service manager 7.10. and today i faced a problem by which i can't perform mass close to any event.This raises a problem " update error ", " unrecoverable error ", " error occured while adding a record ", " update cancelled by trigger " and many more. How this would be repaired and kindly tell me the following steps to how to resolve this issue?
I am working on HP Service manager 7.10. and today i faced a problem by which i can't perform mass close to any event.This raises a problem " update error ", " unrecoverable error ", " error occured while adding a record ", " update cancelled by trigger " and many more. How this would be repaired and kindly tell me the following steps to how to resolve this issue?
9 Replies
ALARMus

Fleet Admiral
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-16
07:34
Need more detail about messages wich you have got. (exactly text, screenshots,...)
Piku

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-16
07:44
Hi vikky,
It seems that during update adding to some other table is canceled.And update is doing trough the trigger.
Check you sm log file more details,it would surely have the trigger and table name.and your message will also have name and field due to which cancellation is happening.
hth,
It seems that during update adding to some other table is canceled.And update is doing trough the trigger.
Check you sm log file more details,it would surely have the trigger and table name.and your message will also have name and field due to which cancellation is happening.
hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Vikky03

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-16
08:29
Piku

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-16
09:28
Hi,
Error relates to something your DB space.
I suppose you disk space is full at DB level or either table space is full.
hth,
Error relates to something your DB space.
I suppose you disk space is full at DB level or either table space is full.
hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Vikky03

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-17
05:08
Thanks Piku,
Your answer is appreciated and valued. It's very urgent. Please tell me how to make it correct and what are the following steps to make it working. Lots of work are pending due to this one. If possible, can you please attach some screen-shots to how to make it correct?
Best Regards,
Vikky03
Your answer is appreciated and valued. It's very urgent. Please tell me how to make it correct and what are the following steps to make it working. Lots of work are pending due to this one. If possible, can you please attach some screen-shots to how to make it correct?
Best Regards,
Vikky03
Piku

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-17
06:18
Hi Vikky,
I do not know much at DB level.You should contacts your DB admin.
Did you checked your disk space on DB server?
I pointed out error about db size because error shows something about unable to allocate space.
regards,
I do not know much at DB level.You should contacts your DB admin.
Did you checked your disk space on DB server?
I pointed out error about db size because error shows something about unable to allocate space.
regards,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Vikky03

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-17
06:47
Dear piku,
I have checked the disk space, its 5.43 GB free. So, what is the main problem now. I'm eagerly waiting for your best solution.
Thanks,
I have checked the disk space, its 5.43 GB free. So, what is the main problem now. I'm eagerly waiting for your best solution.
Thanks,
Piku

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-17
09:58
sorry Vikky, I do not have solution or this since I am not familiar with sql database.
but it is clear from error message that it is due to logical size allocation to something object and file groups.
You should look for more details about sql object file space .
reagrds,
but it is clear from error message that it is due to logical size allocation to something object and file groups.
You should look for more details about sql object file space .
reagrds,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Assign Kudo, if found post useful and mark it accepted if solves the issue.


Cadet 2nd Class
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2011-05-17
12:06
Hi Vikky03,
error message looks to be clear, pls try this
(for MS SQL 2005, SQL 2000 and 2008 are similar):
open MS SQL Management Studio,
connect to sql server,
open Databases,
right click SM database and choose Properties,
choose Files,
select *data* file, scroll to "Autogrowth" column, click at "..." icon and "X Enable autogrowth" + "X Unrestricted".
HTH,
Michal
error message looks to be clear, pls try this
(for MS SQL 2005, SQL 2000 and 2008 are similar):
open MS SQL Management Studio,
connect to sql server,
open Databases,
right click SM database and choose Properties,
choose Files,
select *data* file, scroll to "Autogrowth" column, click at "..." icon and "X Enable autogrowth" + "X Unrestricted".
HTH,
Michal