on 12-12-2007 7:56 PM
I am getting the following error with my backups in DB13:
SQL Job information ******************************
Jobname: SAP CCMS Check Database QAS [20070821103322-0-010000]
Type: TSQL
DB-Name: QAS
For Run: 20071211 01:00:00
Job history information *****************************
Stepname: Step1
Command: qas.sap_new_dbcheck @dbname="QAS",@outputfile="$(ESCAPE_NONE(SQLDIR))\
CCMS_CHECK_DB_HIST_2007.txt"
Status: (failure)
Message: 201
Severity: &nbs p; 16
Duration: 0 hours(s) 0 min(s) 0 sec(s)
Last msg: Executed as user: IEUA\SAPServiceQAS. Procedure or function 'sap_new_d
bcheck' expects parameter '@dbName', which was not supplied. [SQLSTATE
42000] (Error 201). The step failed.
<----
End of Job Step History -
>
Job history information *****************************
I'm not exactly sure what is configured wrong since this server is configured exactly the same as my other servers and my other servers are having no issues with backups. Any help would be appreciated. Thank you!
Hi Connie,
>Last msg: Executed as user: IEUA\SAPServiceQAS. Procedure or >function 'sap_new_d
>bcheck' expects parameter '@dbName', which was not supplied.
Please check tnsnames.ora or sqlnet.ora for missing entries.
Also read this note 1057855
Regards,
Jeff
null
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please check SAP note 1057855.
REgards,
Guenther
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Last night we deleted the job and rescheduled it which seemed to fix the problem. I'm not exactly sure what the entire cause was but it seems to be working fine now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am new to SAP so please chime in anyone!
however maybe I can assist. Have you checked and confirmed that you dbname parameter is set correctly using DB03 > Active Parameters? It looks like it is set to QAS.
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 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.