Skip to Content

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.


Be the first to leave a comment
You must be Logged on to comment or reply to a post.