on 06-29-2011 1:15 PM
In Solution Manager Diagnostics in Solution Manager we have registered
a connection to a Business Objects Enterprise xi3 DB
which is running on a SQL Server 2008 Database platform.
The SQL Server instance name is JDGSBOBPRD00\JDGSBOBPRD00
The database name is JDGSBOBPRD00
This was successful and we where able to connect via the Solution
Manger dbacockpit transaction to the Business Objects Enterprise xi3 DB
and run the various other transactions available in dbacockpit.
When we try to add a CCMS Check Database via the Jobs DBA Planning
Calendar it works and the entry is create in the calendar.
If I try run the job by clicking Execute I get this error:
"14262 [Microsoft][SQL Server Native Client10.0][SQL Ser ver]The
specified @job_name ('SAP CCMS Check Datab ase JDGSBOBP [20110621151811-2-151811]') does not"
When I look at the SQL Server Database via SQL Server Management Studio
I don't see any job relating to the CCMS Check Database.
So it the error I get makes sense as the job does not exist.
From the Preview tab when you create a CCMS Check Database job, I see
the following SQL commands that are generated to create the job:
exec msdb..sp_add_job @originating_server = '(local)',@job_name = "SAP
CCMS Check Database
JDGSBOBP [20110621142338-7-030000]",@enabled = 1,@description = "SAP
CCMS JOB",@start_step_id
= 1, @category_name = NULL,@category_id = NULL
exec msdb..sp_add_jobstep @job_id = null,@job_name = 'SAP CCMS Check
Database JDGSBOBP
[20110621142338-7-030000]',@step_id = 1,@step_name = 'CCMS-
Step1 ',@subsystem = 'TSQL',
@command = 'declare @exeStmt nvarchar(2000) exec
SAPSolMan710.sap_new_dbcheck
@dbName="JDGSBOBP",@outputfile="$(ESCAPE_NONE(SQLDIR))
\CCMS_CHECK_DB_HIST_2011.txt",
@bkupSim = "Y",@exeStmt = @exeStmt OUTPUT',@database_name
= 'JDGSBOBP',@output_file_name =
'$(ESCAPE_NONE(SQLDIR))\CCMS_CHECK_DB_HIST_2011.txt',@flags = 2
dbcc checkdb( JDGSBOBP ) with no_infomsgs
exec msdb..sp_add_jobschedule @job_id = null,@job_name = 'SAP CCMS
Check Database JDGSBOBP
[20110621142338-7-030000]',@name = 'CCMS-sche1',@enabled = 1,@freq_type
=8,@freq_interval = 1,
@freq_subday_type = 1,@freq_subday_interval = 0,@active_start_date =
20110626,
@active_start_time = 30000 ,@freq_recurrence_factor = 1
exec msdb..sp_add_jobserver @job_name = 'SAP CCMS Check Database
JDGSBOBP
[20110621142338-7-030000]',@server_name = '(local)'
I noticed that the DB Name is "JDGSBOBP" and the the actual name
is "JDGSBOBPRD00" so it looks like only the first 8 characters are used.I did find SAP Note 1413688 but dont think this applies to my situation.Is there any work around concerning this problem?
Hello Gareth,
I work in the development team for SQL Server porting on NetWeaver products and I work a lot with the Solution Manager integration.
Can you please open a customer message for this problem in component BC-DB-MSS? This sounds like a new problem to me.
Thank you,
Leslie Moser
Microsoft SQL Server Support
SAP Database Development - Microsoft Platforms (Redmond, WA)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Leslie, I have logged a message. Got this reply
Dear Customer,
I am the responsible developer for this transaction(Planning
calendar). and I connected to teh system and checked the problem..
Thanks for the detailed description of the problem..
I also debugged the Planning calendarreports and was able to create
the Dbcc checkdb job in your SQL Agent.. Please delete the job in
your SQL Server as I don't have remote access at OS level.
I will check with my colleague about this and update the message later.
Thanks and Best Regards
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.