SAP BDLS failing – Syntax Error in Program SAPLRSSTATMAN

Hi All,

During recent System Refresh, we have faced issue in SAP – Global Batch Trace System where BDLS for Logical System Conversion is failing with Syntax Error in table “/BI0/SREQUID”.

According to SAP, this issue is capture on SAP Note – 2133885.

for successful BDLS run (Logical System Conversion), we have implemented above note by SNOTE(no manual steps) on the system & re run BDLS again.

Setting email alert in SUM / SAPup & EHPi

While upgrading SAP system through EHPi / SUM & SAPup, we always keep our session alive to check where our tool got stuck or where it’s required user input. if you close the session and tool get stuck so your upgrade time will increase & you didn’t meet up with your deadline, we also faced the same issue. Later on we have read the SUM guide that you can set the alerting so you will get an email/sms during stuck or requires user input.

This is something tricky, however i will try to explain this in easy words.

1. Create a notepad file and save this file as .vbs ext.(example: email.vbs) and save the below contents. However you require Email address, SMTP port & SMTP server address.

Set objMessage = CreateObject(“CDO.Message”)

objMessage.Subject = “SUM Upgrade Update”

objMessage.From = “from@from.com

objMessage.To = “to@to.com

objMessage.TextBody = “SUM tool requires user inputs”

objMessage.AddAttachment “e:usrsapEC5SUMabaptmpupalert.log”

‘==This section provides the configuration information for the remote SMTP server.

‘==Normally you will only change the server name or IP.

objMessage.Configuration.Fields.Item _

(“http://schemas.microsoft.com/cdo/configuration/sendusing”) = 2

‘Name or IP of Remote SMTP Server

objMessage.Configuration.Fields.Item _

(“http://schemas.microsoft.com/cdo/configuration/smtpserver”) = “Your mail server IP address

‘Server port (typically 25)

objMessage.Configuration.Fields.Item _

(“http://schemas.microsoft.com/cdo/configuration/smtpserverport”) = 25

objMessage.Configuration.Fields.Update

‘==End remote SMTP server configuration section==

objMessage.Send

—————————————————————————————————————————————

MAKE SURE THAT SMTP SERVICE IS RUNNING ON YOUR HOST WHERE YOU ARE GIVING THIS SCRIPT.

You can write multiple recipients in “objMessage.To = “to@to.com” this file separating by commas.

NO NEED TO CHANGE THIS LINE

 “objMessage.AddAttachment  e:usrsapEC5SUMabaptmpupalert.log”

AS TOOL  AUTOMATICALLY CREATES A FILE WITH REQUIRED DETAIL & MAIL TO YOU AS ATTACHMENT.

2. Create a notepad file with .bat ext.(email.bat) and call this vbs script(email.vbs) through this file. (as upgrade tool only recognize batch file)

 

3. Setting in upgrade tool & Test the settings.

 

4. You will received email like this.

If  you find any difficulty while configuring alert setting, you can reach me at adil(at)adilfahim.com.