Underscore in hostname for SAP system

Recently while working on SOLMAN 7.1 configuration, i faced a very weird situation where satellite system host name contained (_) underscore. however there is no issue with SAP & it’s working fine as expected.

Now the actual problem with SAP host agent, when you start configuring the same in SOLMAN & try to connect, it will throw you a very strange error.

Cannot establish connection with SAP hostagent webservice. Malformed URL: Not a Valid URL, Unexpected Character found*_*

however it’s accepting (-) but not (_) underscore.

i have raised a message to SAP & come up with below note.

2158591 – MalformedURLException from DAA when connecting to SAP Host Agent – Solution Manager 7.10
1817452 – FQDN – underscore in hostname or domain

There is no workaround for the same. you need to rename the system or system copy.

let me know if you have any other solution except system rename or copy.

SAP Table TRBAT contains lock entry: LOCKMARK

Yesterday i found that my auto import job in BW system got hanging & continuously running since half an hour. truck icon was there & in “Import Monitor” status is running. There is no other option for me rather then cancelling the import from Import Monitor – Right Click – Delete Entry.

I did some troubleshooting & found that “RDDIMPDP” job is running & finishing with below warning “Table TRBAT contains lock entry: LOCKMARK“.

While checking the both tables in SE16 “TRBAT” & “TRJOB”. i see old entries are exists over there. This need to be delete for overcome this issue. Entries from these tables can be delete from SM30. I did the same & run again “RDDNEWPP” in Client 000 & Productive Client by DDIC or respective user. This will schedule a new “RDDIMPDP” job.

These steps help me to resolve the issue & auto import job is running fine.

Leave comments if this helps you.

SAPJSF user stuck in update, all DIA process occupied

I have got a problem in SOLMAN 7.1 SP14 where when we did some mass changes in SOLMAN Portal & communication user SAPJSF occupied all the process. No one is able to login into system.

error_psm

We have tried killing process but it’s not successful.

As per the trace we found below error.

M ***LOG R1H=> ThRollOut, internal ( Roll Out) [thxxmem.c 1708]
M ThGetTransactionId: no transaction id found
M *** ERROR => ThRollOut: rollout with
level=ROLLIN_0,ROLLIN_1,ROLLIN_2, call_hooks=0,
short_roll_out=0, commit_after_roll=0 failed [thxxmem.c 1712]
M
{root-id=B884D97B881DA34EBFDD8276AE45BD38}_{conn-id=00000000000000000000000000000000}_0
M *** ERROR => ThRollOut: different uid in tm_adm 25306 and roll -1
[thxxmem.c 1724]
M
{root-id=B884D97B881DA34EBFDD8276AE45BD38}_{conn-id=00000000000000000000000000000000}_0
M *** ERROR => tm_adm: TID/UID/MODE/IMODE/BNAME/TERMINAL/TYPE
T110/U25306/M0/I0/SAPJSF /PRD-SOLMAN /32 [thxxmem.c
1732]
M
{root-id=B884D97B881DA34EBFDD8276AE45BD38}_{conn-id=00000000000000000000000000000000}_0
M *** ERROR => roll: TID/UID/MODE/IMODE/BNAME T0/U-1/M0/I0/
[thxxmem.c 1741]
M
{root-id=B884D97B881DA34EBFDD8276AE45BD38}_{conn-id=00000000000000000000000000000000}_0
M *** ERROR => last user rolled in: [thxxmem.c 1744]
M
{root-id=B884D97B881DA34EBFDD8276AE45BD38}_{conn-id=00000000000000000000000000000000}_0

*—-> Stack Back Trace <----* 000000000203FAC0 000000014195DA49 0000000003423520 disp+work!DumpStacks [ntstcdbg.c (566)] 000000000203FBC0 000000014028B744 0000000143333F30 disp+work!NTDebugProcess [ntstcdbg.c (400)] 000000000203FBF0 0000000140146570 000007E000013B76 disp+work!CTrcStack [dptstack.c (183)] 000000000203FD40 0000000140100BE0 0000000000000000 disp+work!ThRollOut [thxxmem.c (1747)] 000000000203FDF0 000000014011C693 FFFFFFFFFFFFFF00 disp+work!ThIErrHandle [thxxhead.c (12046)] 000000000203FE50 0000000140030FB9 0000000003423088 disp+work!ThStart [thxxhead.c (1185)] 000000000203FEF0 00000001400010B1 FFFFFFFF00000001 disp+work!DpMain [dpxxdisp.c (1198)] 000000000203FF20 0000000141CAD2F0 0000000002040000 disp+work!nlsui_main [thxxanf.c (80)] 000000000203FF50 000007FF9F4B1842 0000000000000000 disp+work!__tmainCRTStartup [crtexe.c (594)] 000000000203FF80 000007FFA0EEE379 0000000000000000 KERNEL32!BaseThreadInitThunk 000000000203FFD0 0000000000000000 0000000000000000 ntdll!RtlUserThreadStart ----------------------------------------------------------------------------------------------------- As per SAP there is 1 note for the same. 1885942 - Work process is assigned obsolete request We are running on Kernel 721 SP 600 & this note is not relevant to our patch level but as per SAP we need to below parameter because as of 720.710 or 721.330, premature logoffs are detected in the dispatcher, too. To activate it, you must set the following profile parameter: rdisp/dp_check_logoff = 1 So even if you are on PL600 the parameter rdisp/dp_check_logoff = 1 needs to be set manually to your default or instance profile.

SAP Charm Activation issues

Recently some issues has been occurred while working on Charm project creation in solar_project_admin in Solution Manager 7.1

After Activating Change Request Management in System Landscape — Change Management.

Click Refresh – then click Check – Below errors occurred

Error in Red: Domain check found differences

Cause: Difference in definition of Local Domain info & Solution Manager Domain info

Solution: Check the TMS domain in SLD for affected system, it’s showing wrong. go to ABAP system & trigger the latest System DATA to SLD(RZ70). LMDB will fetch the data from SLD then re run the check. issue will be resolved.

Error in Red: Error getting configuration of system

Cause: Related to RFC authorization

Solution: it’s not reading the data from SM_SYSTEM_TMW RFC. Check the authorization of that user SMTMSID in manage system & assign S_RFC role.

Check SAP note – 2225348 – ChaRM check Error getting the Configuration for System

P.S. note: Once you fix the RFC, you need to restart the tx solar_project_admin & click on project & again click on Refresh then check button to verify it should work.

Error in Yellow: TMS check not possible. Project **** not completely configured for QGM

Cause: QGM not configured.

Solution: Ignore the error if you are working on project only for Charm Activation.

Error in Red: CTS Service plug-in not installed in system or cCTS plugin status cannot be retrieved from SID. See Note 1688276

Cause: Parameters not updated in STMS or domain link issue.

Solution: There are different solution for this error, in my case. i have deleted & recreated domain link from Solman to STMS domain controller & update the required Parameters in STMS – Systems — Transport Tool. Redistribute the changes.

BW : RSA1 : You Can Only work in Client 001

Sometimes after system refresh with a different target client, below error has been occurred. This error occurred due to “BWMANDT” value of “RSADMINA” table in BW system where client has been defined.

Please change the same below:
SE37 – RS_MANDT_UNIQUE_SET
i_mandt – Target Client Value
Execute

Now client has been change as desired.

After changing the client when you again open the RSA1, you will see the below error.

“Logical System name has been changed for this system”

This error occurred as we have different logical system entry in “RSBASIDOC” table.

Deleting wrong logical system name.

SE37 – RSAR_LOGICAL_SYSTEM_DELETE

I_LOGSYS – wrong logical system name
I_FORCE_DELETE – X

Execute

Now open RSA1. it will start & show the POPUP of Data replication or Activation.

SAP Sybase ASE installation issue

While working on NW 7.40 installation on SAP Sybase, I found very weird issue where sapinst was not able to complete the step “Configuration of database components”

Solution: Please check the size of mount point /Sybase/SID. That should be around 8 GB free.

During installation of NW components Sybase also install TEMP DB which resides on /Sybase/SID mount point.

As per your requirement, please change the default size of temp DB in sapinst screen but make sure that your mount point /Sybase/SID should be enough to handle the same as other logs & temp file also save there.

SAP Sybase ASE Start / Stop Server Commands

While working on Installation of SAP Netweaver 7.40 on SYBASE DB ASE 16 PL5 on Linux OS, i have faced multiple errors. i thought it should be worth sharing to you all.

Mount Point requirement.

/sybase/(SID)
/sybase/(SID)/sapdata_1
/sybase/(SID)/sapdata_2
/sybase/(SID)/saplog_1

Sybase store all the database related binaries on /sybase/(SID) mount point. This mount point should be big enough to handle all the temp DB device, log data, log device, sybtemp, saptemp & other log files. Minimum – 20 GB, during installation it will ask you multiple inputs.

sapdata_1 & sapdata_2 – depends on your DB size. minimum – 150 GB each

saplog_1 – depends on log size. minimum – 100 GB

During installation, i stuck on database configuration & other steps, where i need to stop & start the SYBASE DB, there are 2 ways to perform the same (may be more) as i aware.

1. SYBASE Control Center
2. isql

I was working on isql to start stop my DB. (Please note once SAP installed successfully, “sa” user will lock automatically & only “sapsa” user will login. if you want to use “sa” user you need to unlock the same from isql command.

it’s recommended to start / stop DB from sap command only. (startsap DB / stopsap DB)

But if you have only installed Sybase DB so here is the way to start & stop through isql. here “sa” user will work because we have not installed SAP yet.

Stopping the SYBASE DB in Linux.

isql -Usa -Ppassword -S DBSID
2> shutdown
3> go

the above command will stop the SYBASE server & show the below output. now you cannot login into isql as server is down.
Msg 2812, Level 16, State 5:
Server ‘SID’, Line 1:
Stored procedure ‘help’ not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
Server SHUTDOWN by request.
ASE is terminating this process.
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

Starting the SYBASE DB in Linux

for starting you need to go install folder, that install folder is in your SYBASE_HOME. usually at below location.

/sybase/SID/ASE-16_0(Version)/install/RUN_SID

once you trigger the above command, SYBASE DB will start successfully & you can verify the process.

In Windows you can stop/start SYBASE DB by Windows Services.

How to delete already released transport/task

Recently i received a request from developer, he want to delete the task from a particular transport. Task is in already released status.

Here is the method to perform the same. however i don’t believe this is SAP recommended method. Please use it on your own risk.

1. Use transaction SE38 or SA38 and run program: RDDIT076
2. Set your request number and run the program
3. After request is shown double click on it
4. You should be able to change status from R to D

once you change the status to “D”, now go to SE01 and find the task. task again change to “Modifiable mode”.

You can delete the task successfully.

No data load into BW system for this metrics since (UTC)

Recently while working on technical monitoring in SOLMAN 7.1 SP 14, i faced multiple issues.

After configuration i am receiving emails in my mailbox but when i open the mail. i got the below error.

No data load into BW system for this metrics since (UTC)

no_data_found

for overcome this issue SAP suggest to import below note & reactivate the manage objects again in technical monitoring.

SAP note – 2288036

Correction has been delivered with SOLMAN 7.1 SP15