Absent Member.
Absent Member.
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?
0 Likes
9 Replies
Fleet Admiral
Fleet Admiral

Need more detail about messages wich you have got. (exactly text, screenshots,...)
0 Likes
Absent Member.
Absent Member.

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,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
0 Likes
Absent Member.
Absent Member.

Dear sir,
I have attached a snapshot and please check what is the main problem behind this issue. Your answer and solution would be appreciable and valuable.

Thanks,
0 Likes
Absent Member.
Absent Member.

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,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
0 Likes
Absent Member.
Absent Member.

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
0 Likes
Absent Member.
Absent Member.

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,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
0 Likes
Absent Member.
Absent Member.

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,
0 Likes
Absent Member.
Absent Member.

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,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.