Written by Go to your program
T-code SE38 : Zxxxxxx
select display
T-code SE38 : RSVARENT (for delete protection)
T-code SE38 : delete and check again
Share on Facebook
Posts by
Delete or modify protection program variant
BW SEM : Error when run BEx
I found error when my consultant try to run web report from BEx. Browser always running on BEx Analysis like this
http://epq:50000/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?TEMPLATE=ZXXX
I compared from EPD and EPQ, it different. All these iViews are found in the portal at
Portal Content > Content Provided by SAP > Platform AddOns > Business Intelligence > iViews
on EPD
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex3x
BEx Web (RRI) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.rritransaction
on EPQ
BEx Launcher pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex
BEx Launcher (Format SAP BW 3.x) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex3x
BEx Launcher (Transactions for RRI) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.rritransaction
I try to fix it untill I got new error. I can not browse Portal Content > Content Provided by SAP > Platform AddOns > Business Intelligence > iViews
it show error
“9:54:49 AM Error com.sap.ip.bi.bex_broadcaster pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews”
READ MORE »
J2EE : JCmon monitor menu example
/sapmnt/
1 START_SCS01_
DEFAULT.1.PFL START_SCS01_
DEFAULT.2.PFL bak-20081001a
DEFAULT.PFL core
DEFAULT.PFL.orig dev_enrepsig
JdbcCon.log dev_ensmon
START_ERS05_std-sys-1 dev_ensmon.old
START_JC00_
START_SCS01_
START_SCS01_
START_SCS01_
START_SCS01_
[Thr 1] MtxInit: -2 0 0
READ MORE »
Solaris : zip and compress files
zip file
# tar cvf – audit_201102* | gzip -c > audit_201102.tar.gz
unzip file
# gzip -cd audit_201011.tar.gz | tar xfv -
remove and ask before confirm
# rm -i audit_201102* (do not delete file .tar.gz)
Portal : SAP notes for NWDI_CMSADM user on portal
Note 896427 – NWDI Admin User/Password update
Note 877804 – NWDI communication user in central SLD server
SAP Enqueue Analysis
SQL command :
SQL> COLUMN EVENT FORMAT a30;
SQL> SELECT
2 event,
total_waits,
3 4 time_waited,
5 avg_ms,
6 round(RATIO_TO_REPORT(TIME_WAITED)OVER()*100)PERCENT
7 from
8 (SELECT
9 SUBSTR(EVENT,1,30) EVENT,
10 TOTAL_WAITS,
11 TIME_WAITED,
12 ROUND(TIME_WAITED_MICRO/TOTAL_WAITS/1000,2) AVG_MS
13 FROM V$SYSTEM_EVENT
14 WHERE
15 WAIT_CLASS != ‘idle’ AND
16 EVENT NOT IN
17 (‘db file parallel write’,'log file parallel write’,
18 ‘log file sequential read’,'control file parallel write’,
‘control file sequential read’,'Log archive I/O’)
19 20 UNION
21 SELECT ‘CPU’ EVENT,NULL,VALUE,NULL
22 FROM V$SYSSTAT
23 WHERE STATISTIC# = 12
24 ORDER BY 3 DESC)
25 WHERE ROWNUM <=10;
EVENT TOTAL_WAITS TIME_WAITED AVG_MS PERCENT
—————————— ———– ———– ———- ———-
SQL*Net message from client 3909276122 1.6511E+10 42.24 81
db file sequential read 3611229673 1289634393 3.57 6
rdbms ipc message 13365176 974207627 728.91 5
CPU 767306206 4
log file sync 26707350 297795901 111.5 1
read by other session 797062395 233188784 2.93 1
enq: TX – row lock contention 45655383 170080074 37.25 1
RMAN backup & recovery I/O 76442209 85095872 11.13 0
Streams AQ: qmn coordinator id 55336 74544752 13471.29 0
Streams AQ: qmn slave idle wai 27279 74544046 27326.53 0
10 rows selected.
Share on FacebookSSH access without password
1. Modify /etc/ssh/ssh_config
add line
RSAAuthentication yes
IdentityFile /.ssh/id_rsa
1.1 restart ssd
/lib/svc/method/sshd restart
2. Generate key on both server (or only 1 server)
root@machine1 # ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (//.ssh/id_rsa): /.ssh/id_rsa
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /.ssh/id_rsa.
Your public key has been saved in /.ssh/id_rsa.pub.
The key fingerprint is:
2f:43:fa:9d:44:fd:bc:dd:86:90:19:5a:b3:30:49:5d root@qa2-sys-1
root@machine1 # pwd
/.ssh
root@machine1 # ls
authorized_keys id_rsa id_rsa.pub
3. copy id_rsa.pub to other server in name authorized_keys
root@machine1 # scp id_rsa.pub machine2:/.ssh/authorized_keys
The authenticity of host ‘machine2 (machine2)’ can’t be established.
RSA key fingerprint is eb:b3:57:5a:c3:be:54:bd:e6:9c:df:78:3e:40:4a:c0.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added ‘machine2′ (RSA) to the list of known hosts.
Password:
id_rsa.pub 100% |*************************************************************| 224 00:00
4.file on other server
authorized_keys id_rsa id_rsa.pub known_hosts
root@machine2 # cat known_hosts
192.168.151.132 ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEAvHQPcwdBpTMVbtQFJ4itL2qesdrTCnvlGe3lAryqKRPpS4NApOuWcD+IKY2T+kd33DwKCqfYu/gWtoWT7ogyroFT5qilKj0bo4iGgn64nfxGIKd3sLf3L6tNrf+arXUQwqmGP8bzumHDgubFIFn3opx3YXl2yn5Um9xtYYsM9M0=
root@ecp-db-00 #
5. copy
root@machine1 # scp -rp machine2:/oracle/PRD/mirrlogA/log_g11m2.dbf /oracle/PRD/mirrlogA/log_g11m2.dbf
log_g11m2.dbf 100% |*************************************************************| 300 MB 00:17
SAP Enqueue Analysis
SQL Comamnd :
COLUMN EVENT FORMAT a30;
SELECT
event,
total_waits,
time_waited,
avg_ms,
round(RATIO_TO_REPORT(TIME_WAITED)OVER()*100)PERCENT
from
(SELECT
SUBSTR(EVENT,1,30) EVENT,
TOTAL_WAITS,
TIME_WAITED,
ROUND(TIME_WAITED_MICRO/TOTAL_WAITS/1000,2) AVG_MS
FROM V$SYSTEM_EVENT
WHERE
WAIT_CLASS != ‘idle’ AND
EVENT NOT IN
(‘db file parallel write’,'log file parallel write’,
‘log file sequential read’,'control file parallel write’,
‘control file sequential read’,'Log archive I/O’)
UNION
SELECT ‘CPU’ EVENT,NULL,VALUE,NULL
FROM V$SYSSTAT
WHERE STATISTIC# = 12
ORDER BY 3 DESC)
WHERE ROWNUM <=10;
READ MORE »
SAP Note Viewer for iPhone available (Free)
search for “SAP Note Viewer for iPhone” on your itune. you can put oss-user/password fr search note on your iphone…. please try
Share on FacebookSAP Jco : Easy to setup step by step (example)
Neccessary files
1. libsapjco3.so
2. sapjco3.jar
3. /oracle/PRD/102_64/jdbc/lib/nls_charset12.jar
4. /oracle/PRD/102_64/jdbc/lib/ojdbc14.jar
Step to step :
1. Check JAVA VM (if Java Connector 3 up will run on JAVA 1.5 up)
SAP-SERVER:oraprd 46% java -version
java version “1.5.0_12″
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)
2. Cretae SAPJco folder and put require files on folder
SAP-SERVER:oraprd 50% pwd
/oracle/PRD/SAPJco
SAP-SERVER:oraprd 49% ls -al
total 13608
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 .
drwxr-xr-x 23 oraprd dba 1536 Feb 12 16:06 ..
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 jco_server
-rw-r–r– 1 oraprd dba 5784736 Feb 12 17:47 libsapjco3.so
-rw-r–r– 1 oraprd dba 1149431 Feb 12 17:47 sapjco3.jar
3. Create folder for application (jco_server) and put source files (.java) in here
SAP-SERVER:oraprd 58% pwd
/oracle/PRD/SAPJco/jco_server
SAP-SERVER:oraprd 59% ls -al
total 24
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r–r– 1 oraprd dba 9650 Feb 12 17:48 JCO_SERVER.java
4. modify JCO_SERVER.java connect to other host
Example :
Properties connectProperties = new Properties();
connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST,”SAP-SERVER”);
connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, “03″);
connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, “900″);
connectProperties.setProperty(DestinationDataProvider.JCO_USER, “inf01″);
connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, “sapcpic”);
connectProperties.setProperty(DestinationDataProvider.JCO_LANG, “th”);
connectProperties.setProperty(DestinationDataProvider.JCO_POOL_CAPACITY, “3″);
connectProperties.setProperty(DestinationDataProvider.JCO_PEAK_LIMIT, “10″);
createDataFile(DESTINATION_NAME2, “jcoDestination”, connectProperties);
Properties servertProperties = new Properties();
servertProperties.setProperty(ServerDataProvider.JCO_GWHOST,”SAP-SERVER”);
servertProperties.setProperty(ServerDataProvider.JCO_CONNECTION_COUNT, “2″);
servertProperties.setProperty(ServerDataProvider.JCO_GWSERV, “sapgw00″);
servertProperties.setProperty(ServerDataProvider.JCO_PROGID, “JCO_SERVER”);
servertProperties.setProperty(ServerDataProvider.JCO_REP_DEST, “ABAP_AS_WITH_POOL”);
createDataFile(SERVER_NAME1, “jcoServer”, servertProperties);
String url = “jdbc:oracle:thin:@EXTERNAL-SERVER:1521:PROD”;
String userName = “user”;
String password = “passwd”;
5. Check environment
SAP-SERVER:oraprd 72% env
HOME=/oracle/PRD
PATH=/oracle/PRD/102_64/bin:/oracle/PRD:/usr/sap/PRD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb
LOGNAME=oraprd
HZ=
TERM=vt100
SHELL=/bin/csh
MAIL=/var/mail/oraprd
TZ=Asia/Bangkok
PWD=/oracle/PRD/SAPJco/jco_server
USER=oraprd
SAPSYSTEMNAME=PRD
DIR_LIBRARY=/usr/sap/PRD/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/oracle/PRD/102_64/lib
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=PRD
dbs_ora_schema=SAPSR3
ORACLE_SID=PRD
DB_SID=PRD
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/PRD/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/PRD
6. Add CLASSPATH and LD_LIBRARY_PATH
set environment CLASS_PATH (for c shell)
% setenv CLASSPATH .:/oracle/PRD/SAPJco/sapjco3.jar:/oracle/PRD/102_64/jdbc/lib/ojdbc14.jar:/oracle/PRD/102_64
/jdbc/lib/nls_charset12.jar:/oracle/PRD/SAPJco/jco_server
add JCO path to LD_LIBRARY_PATH
% setenv LD_LIBRARY_PATH /oracle/PRD/SAPJco:$LD_LIBRARY_PATH
Tips : unset environment
unsetenv CLASSPATH
!!! Set this environment to logon environment too
7. Compile sorce code
SAP-SERVER:oraprd 64% cd /oracle/PRD/SAPJco/jco_server
SAP-SERVER:oraprd 59% ls -al
total 24
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r–r– 1 oraprd dba 9650 Feb 12 17:48 JCO_SERVER.java
SAP-SERVER:oraprd 66% javac -classpath .:/oracle/PRD/SAPJco/sapjco3.jar:/oracle/PRD/102_64/jdbc/lib/ojdbc14.jar:
/oracle/PRD/102_64/jdbc/lib/nls_charset12.jar:/oracle/PRD/SAPJco/jco_server JCO_SERVER.java
SAP-SERVER:oraprd 69% ls -al
total 42
drwxr-xr-x 2 oraprd dba 512 Feb 13 10:58 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r–r– 1 oraprd dba 538 Feb 13 10:58 JCO_SERVER$MyStateChangedListener.class
-rw-r–r– 1 oraprd dba 769 Feb 13 10:58 JCO_SERVER$MyThrowableListener.class
-rw-r–r– 1 oraprd dba 2695 Feb 13 10:58 JCO_SERVER$StfcConnectionHandler.class
-rw-r–r– 1 oraprd dba 3772 Feb 13 10:58 JCO_SERVER.class
-rw-r–r– 1 oraprd dba 9650 Feb 12 18:01 JCO_SERVER.java
8. run application
$ java -d64 JCO_SERVER &
or
$ nohup java -d64 JCO_SERVER &