on 11-13-2014 11:09 AM
Hi experts,
When i was running the SPAM for basis upgrade (SAPKB73103), the server automatically stops stops and shows the below error.
But when i again logged , i got the following error.
Please Help . I am in a critical situation as none of the users wasn't bale to logging.
Awaiting yours earliest reply
Regards
Praveen
Hi All,
Make sure that you have enough space in db to run the SPAM.
Regards
Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Janardhan
Hope this query helps to you
ALTER FUNCTION [dbo].[GetDBSize]
(
@db_name NVARCHAR(100)
)
RETURNS TABLE
AS
RETURN
SELECT
database_name = DB_NAME(database_id)
, log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))
FROM sys.master_files WITH(NOWAIT)
WHERE database_id = DB_ID(@db_name)
OR @db_name IS NULL
GROUP BY database_id
Thanks
AK
Try by setting login/quiet_mode=0
Refer note:1824283
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The first screen shot says that the main import is in process. Assuming that the DIR_TRANS is set to /usr/sap/trans you should in fact check the logs present under /usr/sap/trans/tmp directory as the logs are first created here and once a specific task of the patching activity has been completed it will move the log to the /usr/sap/trans/log directory.
I would check the work process trace files (latest) in the work directory to know more about the termination of work process with the underlying database.
You should also make sure that the database is running without any issues.
Cheers
Reagan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
- Check the tp and R3trans process on OS level.
- Also do check the /usr/sap/trans/tmp is getting updated or not.
If logs are getting updated then you need to wait for an hour and don't kill the tp and R3trans process at OS level.
So you don't need to worry , since program are getting change and so you are getting the errors.
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashuthosh,
This error occured in our server at 4.30 pm. but when i checked at /usr/sap/trans/tmp folder, one file has updated on 4.00 pm.
I already searched in net and also in scn. But some of the discussions there indicating that after some time (say 15 min.) the error gets automatically closed.
Awaiting ur earliest reply
Regards
Praveen
Hi,
Can you please check the Support package logs under /usr/sap/trans/log and also check dev_w* logs under work directory.
You can also attach the logs here so that we can check.
Regards,
Nirmal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.