on 10-09-2018 3:47 PM
Hi Experts, I am having this ABAP DUMP frequently in my BW production system please help me to resolve this error.
Category ABAP Server Resource Shortage
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 09.10.2018 01:50:51
Short text
SQL error 0 while accessing table "BTCJOBEPP".
What happened?
Database error text: "[Microsoft][SQL Server Native Client 10.0][SQL
Server]Violation of PRIMARY KEY constraint 'ALCLASTOOL~0'. Cannot insert
duplicate key in object 'bwp.ALCLASTOOL'. The duplicate key value is
(SysInfoVS_StorOpsWrite, 010, SAP-DEFAULT)."
Hi Syed,
This should be an authorization issue.
Check the execution user and run an authorizations trace to ensure that all necessary roles exist.
Br, Andras
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bartosz,
I have searched for the sap note you have mentioned in sap support portal but there is no particular thing about the said error, so it would be appreciated more if you help me with the more specific solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Andras.
This program is running with the user SAPSYS which is a system user. while i am looking for the user in SU01 its showing that user doesn't exist.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure if that helps, but I found a SAP Note that is worth checking.
2246358 - Unnecessary INSERTs on tables ALCLASTOOL and ALTIDTOOL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.