sp_dumptrans not working at dbacockpit

Hi Jan,

I am looking your help,

sp_dumptrans "SID" is working fine at database level, but same sql statement not working at DBACOCKPIT.

Thanks

siva

SAP Managed Tags:
SAP Adaptive Server Enterprise

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Couple of ideas.

(1) Check which user you are running as - is it different via DBA cockpit

(2) Check database context -

Could you supply the error(s) produced?

Cheers

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Chris,

Please find below screen shot .

Thanks

Siva

Hi Jan,

What is the is syntax for sp_dumptrans at DBACOCKPIT ?

I am giving like below , Is it correct or not?

sp_dumptrans 'SID'

Thanks

Siva

Dear Siva,

I'd execute it like this:

exec saptools..sp_dumptrans SID

Also, there was a glitch in the code of sp_dumptrans which would prevent it from running in job scheduler .

please downloaded the latest version of it , adapt it to your system and retry.

HTH

Tilman

Dear Tilman,

Getting below error.

Thanks

Siva

Cannot see whole message but looks like you are in the wrong database?

Hi.

Some SQL-commands are not working when executed in DBA Cockpit's 'SQL command line'. Do you get the same issue when you use this command in the DBA planning calendar?

Regards,

Jan

Hi ,

I have mentioned like below command. Its not wokring.

exec saptools..sp_dumptrans SID

Thanks

siva

Jan,

I encountered the same issue with Kilari. (Although I also have issue on scheduling job in dba cockpit, you can see my message nearby).

To your question: the sp_dumpdb and sp_dumptrans work perfect within isql command line !!

But somehow they won't work in DBA Planning Calendar and SQL Command Line UI.

Due to this issue with Sybase stored procedure, I can't use DBAcockpit to schedule my backup activity. If you or somebody really make it work, please share ur experience.

Now my last resort is to create Windows BATCH file which runs "isql -Usapsa .....< call_sp_dumpxx.sql" to trigger transaction log dump and db dump. To make it automatically, I createed two Windows Schedule Tasks: hourly and daily.

Hi Jan,

I created message to sap also 10 days back. But they are not giving reply.

Thanks

Siva

Hi Siva, hi Wilson.

Sorry, I'm very busy the last days and did not find any time to help here in the SCN. I will check in more details later today.

I know that the basic setup is working as I tried it myself and I know that SAP IT is relying on this setup for all their production systems running on Sybase ASE. Can you also give me the number of your ticket, maybe I can have a look there, too.

Regards,

Jan

Hi Jan,

Please find message no below.

sp_dumptrans ( 976290 / 2012 )

Thanks

Siva

Hi Siva.

I just added some remarks to the other thread. If you don't have a response to your ticket yet I would reconsider the priority and maybe calling support asking for a speed-up. And please attach as much information into the ticket as possible. In this case opening a connection will most likely help primary support in getting back with a solution.

One additional idea: Do you have the same issue with the database dump as with the transaction dumps? Is there a database dump running in parallel (until ASE 15.7.0.021 dump trans cannot run while dump database is running; starting with this release this has changed)

Best regards,

Jan

Hi Jan,

I have seen another thread. That is not problem in my system. And I am executing only sp_dumptrans.

What is the correct syntax for sp_dumptrans at DBACOCKPIT?

Thanks

Siva

Hi.

The syntax is

exec saptools..sp_dumptrans <SID>

This is to be used in the planning calendar, not in the SQL command line of DBA Cockpit.

Regards,

Jan

Hi guys,

First of all, my apologies for my English.

I had exactly the same problem

If I done the backup using isql it works without any problem!

Here is syntax that I used

"dump database DEV to "F:\BackupDB\DEV\bck.Online.DEV.dmp"

When I scheduled the same request on the planning calendar DBA Cockpit, the system doesn't do anything. After a long moment the status of the action comes red,I don't have any log to check the error.

Screenshots:

If you find a solution, share it please.

Thank you

Alcino,

From the syntax of your SQL parameter screen, I doubt that an ending double quot " is missing after your dump file path string.

Hi Wilson,

Thanks for you reply.

The double quot isn't the problem...

I scheduled a new action and the result was the same .

Hi guys,

I have solved my problem!

We have a DEV and QAS system, running on the same server with 2 DB instances. So the problem was the JSagent, it was only started for the QAS instance.

I started it for the DEV instance, after the scheduled and backup works successfully.

use sybmgmtdb

sp_js_wakeup "start_js",1

I hope my solution helped.

Hi Am,

How to check logs and how to start jsagent?

Thanks

siva

Siva,

Alcino has correct information for starting JS

(http://manuals.sybase.com/onlinebooks/group-as/asg1252e/jsusers/@Generic__BookTextView/1034)

Logs? Check ASE log and Backup server logs under $SYBASE/$SYBASE_ASE/install (or wherever configured to be)

Hi,

I have done What Alcino suggested. but still not working.

Thanks

siva

Hi Jan,

I downloaded sp_dumptrans again ,I dropped sp_dumptrans old one and I reinserted after the sp_dumptrans not working .

Can you please check below screen shot.

Thanks

Siva

Siva,

Try this:

isql -Usapsa -PXXXXX -SMED -Dsaptools -i /path/to/sp_dumptrans.sql

isql -Usapsa -PXXXXX -SMED -Dsaptools -i /path/to/sp_dumpdb.sql

isql -Usapsa -PXXXXX -SMED -i /path/to/setup_logthreshold.sql

Hi,

Same issue.

Hi.

Can you log in to the database as user 'sapsa' and run the following commands?

select db_name()

and

select * from saptools..sysobjects where name LIKE 'sp_dump%'

Regards,

Jan

Hi Jan,

please find below screen shot

Thanks

siva

Hi. I can only see one screenshot with results of the second statement. Do you have the results of the first statement, too?

What you can see is that the sp_dumptrans was not created in the saptools database. Please check if the creation of the sp was done correctly.

Regards,

Jan

Hi Jan

please find below.

Can you check previous screen shots also.

thanks

Siva

Thanks

Siva

Hi Siva.

Based on your screenshots we can be sure that user sapsa connects to the right database (saptools). Also we see that there is a stored procedure sp_dumpdb but no stored procedure sp_dumptrans.

The command to create sp_dumptrans looks right for me. Can you please check that the file sp_dumptrans.sql contains code to create this stored procedure? Most likely something is going wrong during creation of the stored procedure. In fact it is not created at all.

Regards,

Jan

Hi Jan,

I think there is a problem in scripts because I executed old sp_dumptrans its working fine.

Please find both file attachment.

Thanks

Siva

Hi jan,

I have downloaded again and reinserted sp_dumptrans , Now its working fine at database level but DBACOCKPIT level is not working.

Thanks

siva

Hi Jan,

Is there any solution for this issue?

In my production is working fine .

Thanks

Siva

Is there a problem with the connection from DBACOCKPIT - in that chained transaction mode is set on for the connection?

Ask a Question

Top Q&A Solution Author

User

Count