SAP Solution Manager Installation with Sybase ASE on Linux
I have installed test system SAP Solution Manager Installation with Sybase ASE on Linux. Please find the procedure I followed:
Filesystems:
| Mount | Size |
|---|---|
| /sapmnt/SMP | 2GB |
| /usr/sap/trans | 2GB |
| /usr/sap/SMP | 15GB |
| /usr/sap/ccms | 5GB |
| /usr/sap/DAA | 3GB |
| /sybase/SMP | 102GB |
| /sybase/SMP/sybsystem | 2GB |
| /sybase/SMP/sybtemp | 3GB |
| /sybase/SMP/saptemp | 3GB |
| /sybase/SMP/sapdiag | 4GB |
| /sybase/SMP/sapdata1 | 100GB |
| /sybase/SMP/saplog1 | 14GB |
Installation with SWPM
Invoke sapinst
Select product –> SAP Solution Manager 7.1 SR 1 –> SAP Sybase ASE –> Central System –> Central System
Provide path of SWPM Installation kernel
Provide path of SAP Sybase ASE database
Don’t edit default paths
Provide path of Java components export
Enter the Diagnostic Agent SID. Default value is DAA
Review the summary and Proceed with Installation
Errors faced during Installation:
ERROR 2014-04-27 15:02:44.397 [iaxxinscbk.cpp:224]
CJS-00030 Assertion failed: Resource setting ‘max memory size’ is incorrect; refer to the installation documentation to solve this.
ERROR 2014-04-27 15:02:44.398
CJSlibModule::writeError_impl()
MUT-03025 Caught ESAPinstException in module call: .
ERROR 2014-04-27 15:02:44.835 [sixxcstepexecute.cpp:901]
Solution:
Add below entries in file /etc/sysctl.conf
# for SAP Sybase ASE
kernel.randomize_va_space=0
#SAP Settings
kernel.msgmni = 1024
kernel.sem = 1250 256000 100 1024
vm.max_map_count = 1000000
(SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
rc = 99, table “DDNTF”
(SQL error 30128)
error message returned by DbSl:
[ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size
(IMP) ERROR: ExeFastload: rc = 2
(DB) INFO: DDNTF~0 created
(DB) INFO: DDNTF_CONV_UC created
(SYB_IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
rc = 99, table “DDNTF_CONV_UC”
(SQL error 30128)
error message returned by DbSl:
[ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size
(IMP) ERROR: ExeFastload: rc = 2
(DB) INFO: DDNTF_CONV_UC~0 created
(DB) INFO: DDNTT created
(SYB_IMP) ERROR: DbSlEndModify failed
rc = 99, table “DDNTT”
(SQL error 30128)
error message returned by DbSl:
[ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size
(IMP) ERROR: EndFastload: rc = 2
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX “DDNTT~0” ON “DDNTT” ( “TABNAME” ) )
DbSlExecute: rc = 99
(SQL error 1505)
error message returned by DbSl:
[ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is ‘””‘
(DB) INFO: DDNTT_CONV_UC created
(SYB_IMP) ERROR: DbSlEndModify failed
rc = 99, table “DDNTT_CONV_UC”
(SQL error 30128)
error message returned by DbSl:
[ASE Error SQL30128:HY000]Data overflow. Increase specified column size or buffer size
(IMP) ERROR: EndFastload: rc = 2
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX “DDNTT_CONV_UC~0” ON “DDNTT_CONV_UC” ( “TABNAME” ) )
DbSlExecute: rc = 99
(SQL error 1505)
error message returned by DbSl:
[ASE Error SQL1505]Create unique index aborted on duplicate key. Primary key is ‘””‘
(DB) INFO: disconnected from DB
/usr/sap/SMP/SYS/exe/run/R3load: job finished with 6 error(s)
Soltution:
Upgraded kernel with latest patch levels
Reference:
1688468 – Sybase ASE: R3load import using bcp is failing
Use dbsl patch 210
1606654 – SYB: SAP Business Suite 7i2010 on Sybase ASE
/usr/sap/SMP/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#21 $ SAP
/usr/sap/SMP/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Mar 18 2014 19:48:04
/usr/sap/SMP/SYS/exe/run/R3load -i SMIMCONT1.cmd -dbcodepage 4103 -l SMIMCONT1.log -c 99000000 -loadprocedure fast
(DB) ERROR: db_connect rc = 256
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/SMP/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/SMP/SYS/exe/run/R3load: END OF LOG: 20140428144454
sapserver:smpadm 51> R3load -testconnect
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
R3load: START OF LOG: 20140428221545
R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#21 $ SAP
R3load: version R7.20/V1.4 [UNICODE]
Compiled Mar 18 2014 19:48:04
R3load -testconnect
(DB) ERROR: db_connect rc = 256
(DB) ERROR: DbSlErrorMsg rc = 99
R3load: job finished with 1 error(s)
R3load: END OF LOG: 20140428221557
STARTED DATABASE:
sapserver:smpadm 76> startdb
starting database SMP …
Log file: /sybase/SMP/startdb.log
parse level 0: identified message ‘Database ‘master’ is now online.’
parse level 1: identified message ‘Database ‘tempdb’ is now online.’
parse level 2: identified message ‘Database ‘sybsystemprocs’ is now online.’
parse level 3: identified message ‘Recovery complete.’
Recovery Complete
startdb completed successfully
sapserver:smpadm 77>
sapserver:smpadm 77> R3load -testconnect
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
R3load: START OF LOG: 20140428224235
R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#21 $ SAP
R3load: version R7.20/V1.4 [UNICODE]
Compiled Mar 18 2014 19:48:04
R3load -testconnect
(DB) INFO: connected to DB
(DB) INFO: disconnected from DB
R3load: job completed
R3load: END OF LOG: 20140428224235
EsRegisterEmCheck: Register EmGetEsHandles at 1324d97
DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE
MPI: dynamic quotas disabled.
MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%
Fri Apr 29 12:00:38 2014
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 4.0.1 4.0.1 5.1) [dpxxdisp.c 1706]
***LOG Q0K=> DpMsAttach, mscon ( sapserver) [dpxxdisp.c 12725]
*** DP_FATAL_ERROR => DpMsAttach: local hostname ‘sapserver’ is resolved to loopback address (cf. SAP note 1054467 for details)
*** DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
kill(4194,0) successful -> process alive
killing W0-4194 (SIGUSR2)
kill(4195,0) successful -> process alive
killing W1-4195 (SIGUSR2)
kill(4198,0) successful -> process alive
killing W2-4198 (SIGUSR2)
kill(4199,0) successful -> process alive
killing W3-4199 (SIGUSR2)
commented entries in /etc/hosts
#127.0.0.2 sapserver.site sapserver
192.168.19.15 sapserver sapserver.local.com
If any queries, please leave comment on this blog.