Problem in schedulling the jobs after sp12

[Former Member]

Hi all,

Recently in my landscape i have updgraded the basis and abap support packages from SP11 to SP14. We have finished the support packages successfully and the problem is in DB13. I have understand that there is no more DB13 in Sp12 , hererafter only DBAcockpit.

In DBACOCKPIT i am not able to schedule the backup for database. it throws an error like

Executed as user: Administrator. DBCC execution completed. If

DBCC printed error messages, contact your system administrator. [SQLS

TATE 01000] (Message 2528) Cannot open backup device 'R3DUMP0'. Devic

e error or device off-line. See the SQL Server error log for more deta

ils. SQLSTATE 42000 (Error 3201) BACKUP DATABASE is terminating abn

ormally. SQLSTATE 42000 (Error 3013). The step failed.

The problem while schedulling the backup i am not able to find the device type.

Now my questions are follows.

Here my device type is disk. But i am not able to mention the option DBAcockpit (I have mentioned in enterprise manager device type as a disk and with the path for the back up device.).

As per the note 1027512 and 1057855 i have deleted all the jobs as per the note , but now i try to reshdule the jobs by running the script but there is no use.

it throws an error as Could not find stored procedure 'dv0.sap_repl_db13jobcmds'.

I hope i can reschdule the back up by solving this 2 issues, but i have tried several sap notes which is not useful for me. If anyone have suggestion on the same,kindly help me.

Regards

Vijay

[Former Member]

Hi,

Could not find stored procedure 'dv0.sap_repl_db13jobcmds'

dv0 is sid of your sap system ( in small letters) ?

regards,

kaushal?

[Former Member]

Hi kaushal,

Thanks for your reply. Yes i have tried both , But as per the note they mentioned to execute the query with your SID as small letter.

But i have tried both. Still no use.

regards

Vijay

[Former Member]

Hi,

Execute following (case sensitive)

USE [SID]
GO

DECLARE	@return_value int

EXEC	@return_value = [sid].[sap_repl_db13jobcmds]
		@schema = sid

SELECT	'Return Value' = @return_value

GO

where SID = Your sap system id in Upper case

sid = Your sap system id in lower case.

regards,

kaushal

[Former Member]

Hi kaushal,

Again thanks. But there is no improvement. Still i am receiving the sam error.

I tried this ,, with my administrator login,,,he is the dbo owner

USE DV0

GO

DECLARE @return_value int

EXEC @return_value = dv0.sap_repl_db13jobcmds

@schema = dv0

SELECT 'Return Value' = @return_value

GO

Server: Msg 2812, Level 16, State 62, Line 4

Could not find stored procedure 'dv0.sap_repl_db13jobcmds'.

Regards

Vijay

[Former Member]

Hi,

it's strange why it's not executed.

if you are using SQL server 2000 then launch SQL Enterprise manager

in databse -> expand your SID -> double click on stored procedure

did you find sap_repl_db13jobcmds procedure?

regards,

kaushal

[Former Member]

Hi kaushal,

You are right. I verified the same and this stored procedure is also in under the database.

I dont know how to execute..Still surfing in SDN.

Any diea.

Regards

Vijay

[Former Member]

Hi,

Try following

Open SAP Query analyzer.

from tools -> object browser -> show/hide

now under object browser expand your sap database

then expand stored procedure

right click on sid.sap_repl_db13jobcmds -> script object to new window as -> Execute

regards,

kaushal

[Former Member]

Hi,

If you are still not able to succeed then do following.

login into SAP System

run tcode SA38 -> MSSPROCS -> execute

under procedure name select -> sap_repl_db13jobcmds -> right click select execute script -> Execute ( F8)

regards,

kaushal

[Former Member]

Hi kaushal,

First of all thanks for your time.

After the completion of SP14 , I immediately ran the report and adn executed the script but no use.

Then i followed your another suggestion by running the script in query analyser. As a output i got no rows affected. But i manually run the jobs in enterprise manager. Its worked for me and it resolved my issue.Atlast the backup completed successfully

Thanks for your effort.

Regards

Vijay