SAP system language preassigned on the logon screen must be deleted during the logon

** Myself

Problem

If the system language or the language set under the user defaults should still be used, the language preassigned on the logon screen must be deleted during the logon.

This can also be done via a shortcut with an empty language parameter.

In addition, this new behavior can be deactivated again using a switch in the SAP LOGON options.

You must import a disp+work package with at least the patch level that is specified under "SP Patch Level".            

At present, the new function is activated only in the 721 kernel.                                                         

The transfer of the SAPLOGON language takes place as of SAP GUI for Windows 730. See SAP Note 1727111.      

Note: The transfer of the SAPLOGON language cannot yet be suppressed with SAPGUI patch level 0.                                                                                          

In SAP releases < 740, customer-specific texts are no longer taken into account on the logon screen (SAP Note 205487).

SAP Note

1727111 - Language preassignment on SAP LOGON logon screen

1608882 - Logon screen and SAPLOGON language

2134798 - Logon screen and SAPLOGON language: Switchable

Solution (SAP profile)  

   diag/ignore_sap_logon_language = 1.

** Myself

Unable to launch the application sap enterprise services repository  ESR SAP PI

http://www.hostaname:port/dir

-> Administrator

->  Java Web Start Administration

->   Check status   initialization status

If OK show -> 

          

        Else -> Restore Archives and generate New signature.

Problem brtools invalid user name/password (from lost some OPS$ user)

 ** Myself

brconnect -u / -c -f stats -t oradict_stats

BR0801I BRCONNECT 7.00 (34)

BR0805I Start of BRCONNECT processing: ceklcwpo.sta 2013-01-30 20.53.48

BR0484I BRCONNECT log file: /oracle/QAS/sapcheck/ceklcwpo.sta

BR0280I BRCONNECT time stamp: 2013-01-30 20.53.48

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance QAS failed

#go to sql command 

select username from dba_users;

USERNAME

------------------------------

OPS$QASADM

SAPSR3

SYS

SYSTEM

SAP BI BEx Analyzer Error IWB_HTML_HELP_URL_GET

** Myself

BEx Analyzer Error  IWB_HTML_HELP_URL_GET

[Client can be access help.sap.com]

sr13-> PlainHtmlHttp

Variant:		Documentation
Platform:		WN32
Area:		IWBHELP
Server Names:		help.sap.com
Path:		saphelp_erp60_sp/helpdata
Language:		EN

Save-> Test connect  BEx Analyzer again.

SAP Error R3load Phase from Installation New or Export/Import Heterogeneous System copy (Not Recommend may be duplicate/lost some data)

** Myself
Message

(TSK) ERROR: TSK.bck  file already seems to exist       a previous run may not have been finished cleanly file .TSK possibly corrupted job finished with  error(s)

Example

File name = SAPAPPL2_1.TSK.bck and SAPAPPL2_1.TSK

Solve

Run R3load for merge file then rerun sapinst or R3setup

Logon <sidadm>

 ->go to install/export/import directory from sapinst or R3setup

->run  R3load  to merge TSK and TSK.bck file

# Case Export heterogeneous with command file

R3load -merge_bck -e SAPAPPL2_1.cmd

# Case Import heterogeneous with command file

SAP Transport Request "Running" status "Hang" "Stuck"

** Myself

1)Delete this request from STMS.
STMS->
 import overview->
  select system(DEV,QAS,PRD) ->
   import monitor -> 
     select running -> delete entry

2)Check /usr/sap/trans/tmp  and find XX.LOC (Transport Lock file)
in /usr/sap/trans/tmp rename XX.LOC to XX.LOC.old 


3)Check tables TMSTLOCKR and TMSTLOCKP in SE16.
Delete record if not 0

SAPGui and SAPLPD Problem Thai Font solve by Substitution/Replace for Window Vista/7 [Thai]

** Myself
For SAPGUI solve by replace font Window XP for Display
For SAPLPD solve by replace font Window XP and Substitution for printing

Font Substitution	Result
Sub cordiaUPC  font win7	OK.
Sub cordiaUPC  font winXP   # Copy XP font replace win7 C:\windows\fonts	OK.
Sub cordiaNew  font win7	no OK. Can’t translate อ่านไม่ออก
Sub cordiaNew  font winXP # Copy XP font replace win7 C:\windows\fonts	no OK. Can’t translate อ่านไม่ออก
Sub angsanaUPC font win7	no OK. สระลอย
Sub angsanaUPC font winXP # Copy XP font replace win7 C:\windows\fonts	OK.
Add /eH (control unicode to thsapwin) & sub angsanaUPC font win7	no OK. สระลอย
Add /eH (control unicode to thsapwin) & sub angsanaUPC font winXP # Copy XP font replace win7 C:\windows\fonts	OK.
No Sub courierNew font win7	no OK. Can’t translate อ่านไม่ออก

Fix SAPGUI problem thai font ่ ้ ำ ี ๋ ์ ๋ ๊ for Window Vista/7 [Thai]

** Myself
่ ้ ำ ี ๋ ์ ๋ ๊
แก้ปัญหาการชดเชยสระ รวมถึงตำแหน่งของ space หรือ สระลอย เช่น ที่ถูก สีน้ำ  ที่ผิด ส ี น้ ำ

Sol1
Copy font from Window XP Replace Vista/7 to C:\Windows\Fonts

AngsanaUPC,Angsana New,Cordia New,CordiaUPC,Courier New,Courier Regular  [Regular/Bold/Italic]


Sol2
 Install New SAPGUI 720 with newer patch (after patch 8 up to 1X)

SAP Job Reorganize Spool requests are no longer deleted as of beginning of year 2011

** Myself
Solution I)
Apply Note 1532398 for solve because report RSPO1041 is invalid.
 
Solution II)
Maintain factory calendar (Refer Note 1532398 and Note 501670)
SCAL
->Factory calendar
->change
->ID: 01
-> valid to year 2XXX (Extend valid)
 
Solution III)
Create New Calendar and assign variant job reorg spool to new variant
Create New Calendar
SCAL
->Factory calendar
->New
->ID: YY
-> valid to year 2XXX (Extend valid)
Create New Variant
Se38
-> RSPO1041
->variants
->copy SAP&001 to New : ZXXX
-> Change
-> Calendar -> Factory calendar ID : YY (New Factory calendar)
Change New Variant to reorg spool job
Sm37
-> Job name : SAP_REORG_SPOOL and release
->Change
-> Step
-> Parameter ZXXX

Problem SAP Download Manager on Windows 7 & JDK v1.4.X Install completely no errors but run it nothing happens, nothing opens, no messages.

** Credit http://forums.sdn.sap.com
Start
-> SAP Download Manager or Download Manager (old version)

 or   





->Right click
  -> Compatibility
    -> Run this program in compatibility mode for: Windows Vista (Service Pack X)

SAP BASIS How to solve reorganization table online not finish completely and have a problem by BRSPACE tools

** Myself
How to solve reorganization table online not finish completely and have a problem by BRSPACE tools
Cause
- Connection loss during online reorganized.
- Cancel by admin,server,db.

 
How to brspace online reorganized logic
1) Determination of CREATE commands for target table and indexes based on DBMS_METADATA.GET_DDL
2) Creation of target table with naming convention <source_table>#$
3) Export of source table CBO statistics based on DBMS_STATS.EXPORT_TABLE_STATS
4) Copy of source table data to target table based on DBMS_REDEFINITION.START_REDEF_TABLE. This package will implicitly create a materialized view log MLOG$_<source_table> to track all changes that are performed on the source table while the reorganization is running.
5) Creation of target indexes with naming convention <source_index>#$
6) Import of source table CBO statistics to target table based on DBMS_STATS.IMPORT_TABLE_STATS
7) Finalizing of the online reorganization using DBMS_REDEFINITION.FINISH_REDEF_TABLE. In this step all changes in the materialized log are applied to the target table and the names of source and target table are exchanged.
7.1 The source table is dropped.
7.2 The „#$“ suffix of the target table indexes is removed.

SAP BASIS Note 384971 - System parameters for high interface load

** Credit SAP serivice.sap.com/notes ->Note 384971 - System parameters for high interface load

The adjustment may be critical in cases where the operating system does not have sufficient resources. Increasing the parameters also results in a decreased address space for transactions.

For 32-bit systems in particular, you must determine the system status first, and then increase the parameter values if required.

To do this, proceed as follows:
Call transaction ST11 to analyze the developer traces, dev_rd (Gateway), dev_disp (Dispatcher), dev_rfc* (RFC) and dev_w* (work processes).
Call transaction SM21 (syslog) to determine any terminations or bottlenecks.

Call transaction SM51 - Select server - Goto - Server information - WP-CA-blocks or APPC-CA-blocks --> Are the values reaching the maximum (see rdisp/appc_ca_blk_no and rdisp/wp_ca_blk_no)?

See Note 3223 for further information about these parameters. The note describes how to calculate the parameter values in the memory.

Transaction SMGW (Gateway Monitor) - Goto - Logged on Clients
This displays the number of clients or terminals logged on to the gateway of the instance --> does this value correspond to the expected number, and is there sufficient space for additional logons (see also gw/max_conn, for example)?

The parameter settings must be adjusted for a high interface load.

Set the following parameter settings in the instance profiles:


rdisp/tm_max_no: 2000 (higher values are possible)
Number of connections to an instance, including both dialog users and interfaces.

In case of SAP-RC=672 messages in the syslog, for example
17:38:50 DP Q0P maximum number of terminal connections reached
(number according to rdisp/tm_max_no = XXX)

rdisp/max_comm_entries: 2000 (higher values are possible)
Number of communications from and to an instance (not including dialog users).

rdisp/max_arq: 2000 (= rdisp/max_comm_entries, higher values are possible)
Limits the maximum number of asynchronous messages
used for internal communication to make information known throughout the system.

This parameter must be set to the same value as rdisp/max_comm_entries
see also Note 311930.

gw/max_conn: 2000 (higher values possible)
Number of logical connections to a gateway, that is, the number of
connected gateways and external programs.

gw/max_sys: 2000
Maximum number of Gateway clients
Note that an R/3 server is only a single client with regard to Gateway.

SAP BASIS Manual Adjust SAP Note in snote for show “Corrections incompletely copied;see change display” Valid release

** Myself
Manual Adjust SAP Note in snote for show “Corrections incompletely copied;see change display” Valid release
Example st13 rsecnote show Security Note 1453541 valid all version (4.6C->ECC6 ) For ECC5,6 OK but 4.6C,4.7 Not OK
Manual apply 4.6C and 4.7

Select object -> RPUDTEM0

Go to line 408

Cut/Delete wrong code

copy

Show “Delta was changed”

Next step for another report

SAP BASIS SE14 DB Utility for Re-generate the table maintenance generator or adjusting the table of database and activation in SE14

** Myself
SE14 transaction is basically used to activate and adjust the database table, delete database table and make the table consistent we use SE14.
1) If you add any primary key to table , at that time when you activate the table it throws an error. So in this case you can use SE14 transaction to adjust and activate the table.
2)or if you change the key fields of any Table then this Change is not transported to another system and the program which is using this Table may give runtime Error/Dump.
We need to manually reflect the changes of the Table.
3) Or you have activity with Index and not pass , at that time when you activate the table pass but it throws an error. So in this case you can use SE14 transaction to adjust and activate the table.
Example1: If you change the length of a dataelement of a field, obviously the memory required to hold that field length may be more Or less. These memory area will get adjusted through SE14. ( Same for Key fields also).
This Transcation code is used to maintain the changes to the custom table that you had created.
Example2: You had created a Ztable with 4 fields and activated and maintanined the table with some new entries in it.
If you got a requirement to add a new filed or remove the existing field from the ztable then you will use the option called Database Utility. This option will adjust the new structure that you had chnaged/ added into the database so that it can place the data in the appropriate fields.
Se11

SAP BASIS Change Table/program from local object ($TMP) to transport Package

** Myself
Change Table/program from local object ($TMP) to transport Package
(But aware data on table because after transport SAP will create temp table and drop origal table and recreated)
- Go to SE80
-Dropdown list-> Local Objects
-Next Dropdown list-> Change SAP User owner (see from se11) and "Enter"
-$TMP->Dict.objs.->Database Tables
-Select table
- Rigth click-> more function-->Object Directory Entry.
- Change $TMP to Z<Package>

SAP BASIS Note 767673,1169524 Problem Job no longer in work process has 'Active' status and Program for periodic status query of jobs

Problem Job no longer in work process has 'Active' status and Program for periodic status query of jobs
## Refer Note 767673
## Refer Note 1169524

Symptom
In Transaction SM37, a background job has the status 'active'. However, if
you use Transaction SM50 to check the corresponding background work
process, you see that the job is no longer running in the process.

Solution
For Manual
- sm37
- Call the function 'Check status' to correct the job's status

For Automatic create periodic jobs
- Check SP

SAP BASIS Cleanipc,Clear ipc,ipcs,ipcrm,saposcol,sapstartsrv,kill all sap process

** Myself
## sapuser=prdadm ,SID Instance = D01,Instance Number=01
## in case run from root user  (Can  be apply with cluster solution)
su - prdadm -c "stopsap D01"
su - prdadm -c "stopsap sapstartsrv D01"
su - prdadm -c "cleanipc 01 remove"
su - prdadm -c "saposcol -k"
ps -ef | grep prdadm | awk '{print $2}' | xargs kill -9


For sap user
logon prdadm
stopsap D01

stopsap sapstartsrv D01

cleanipc 01 remove

saposcol -k

ps -ef | grep prdadm | awk '{print $2}' | xargs kill -9

 
## Can be use ipcrm for OS command replace with cleanipc command for SAP
#SAP Note 15372 - SAPcomm: error after SAP System restart

SAP BASIS Check not authorized su53

** Myself
mm01

SAP Note 1409604 Solve saposcol can’t catch information on server (VM guest)

** Myself
Saposcol start but can’t attach shared memory information.
st06

From SAP Note 1409604 (replace 110478) , Please perform vmware step mark red (Sap step mark blue)
Section 1: Work steps for all virtualization solutions
1. Install the Microsoft runtime environment.
To operate the new data collector, you require C-runtime 8.0

SAP Note 837404 search spro shotdump error in Ctrl F Find Search Function - Search Index

** Myself
Solve Search in spro shotdump Error in Ctrl+F Find/Search Function - Search
-- spro

-- search

------select “refresh in background”
Note 837404 - Error in Ctrl+F Find/Search Function - Search Index