Error during strcture creation when running sh export_monitor.sh

[Former Member]

Hi all,

I have got the folowing error during SHELLEXPORT when running sh export_monitor.sh.

Error Log is :

vi export_monitor_cmd.properties

represtore:repadm 7> sh export_monitor.sh

+ /opt/IBMJava2-amd64-142/bin/java -showversion -Xmx1024m -cp ./.:./migmon.jar:. p.SecureStartup -Xmx1024m com.sap.inst.migmon.exp.ExportMonitor -dbType ORA

java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 2.2)

IBM J9SE VM (build 2.2, J2RE 1.4.2 IBM J9 2.2 Linux amd64-64 j9xa64142ifx-200708

J9VM - 20070807_1500_LHdSMr

JIT - r7_level20070315_1745)

Unloading of 'SAPDDIM' export package: OK

Unloading of 'SAPDFACT' export package: OK

Unloading of 'SAPDODS' export package: OK

Unloading of 'SAPSDOCU' export package: OK

Unloading of 'SAPSLOAD' export package: OK

Unloading of 'SAPAPPL1' export package: ERROR

Unloading of 'SAPPOOL' export package: OK

Unloading of 'SAPCLUST' export package: ERROR

Unloading of 'SAPUSER' export package: OK

Unloading of 'SAPUSER1' export package: OK

Unloading of 'SAPSSRC' export package: OK

Unloading of 'SAPSPROT' export package: OK

Unloading of 'SAPSLEXC' export package: OK

Unloading of 'SAPSDIC' export package: OK

Unloading of 'SAPAPPL2' export package: OK

ERROR: 2010-03-12 14:45:43 com.sap.inst.migmon.LoadTask run

Unloading of 'SAPAPPL1' export package is interrupted with R3load error.

Process 'R3load -e SAPAPPL1.cmd -l SAPAPPL1.log' exited with return code 2.

For mode details see 'SAPAPPL1.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: 2010-03-12 14:48:29 com.sap.inst.migmon.LoadTask run

Unloading of 'SAPCLUST' export package is interrupted with R3load error.

Process 'R3load -e SAPCLUST.cmd -l SAPCLUST.log' exited with return code 2.

For mode details see 'SAPCLUST.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

SAPAPPL1.log'

DbSl Trace: Error 1652 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1652 occurred when executing SQL stmt (parse error offset=1434)

(EXP) ERROR: DbSlExeRead failed

rc = 99, table "ACCTIT"

(SQL error 1652)

error message returned by DbSl:

ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

(DB) INFO: disconnected from DB

/usr/sap/REP/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/REP/SYS/exe/run/R3load: END OF LOG: 20100312144543

'SAPCLUST.log' file

DbSl Trace: Error 1652 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1652 occurred when executing SQL stmt (parse error offset=103)

(EXP) ERROR: DbSlExeRead failed

rc = 99, table "CDCLS"

(SQL error 1652)

error message returned by DbSl:

ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

(DB) INFO: disconnected from DB

/usr/sap/REP/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/REP/SYS/exe/run/R3load: END OF LOG: 20100312144829

TABLESPACE :

List of tablespaces for extension

Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB]

1 - PSAPSR3 30/0 365968384 89.93 36856768 365968384

2 - PSAPSR3700 19/0 126627840 60.37 50187648 126627840

3 - PSAPSR3USR 2/0 1069056 6.67 997760 1069056

4 - PSAPTEMP 6/0 26214400 22.18 20399104 26214400

5 - PSAPUNDO 3/0 18214912 0.00 18214720 18214912

6 - PSAPUNDO2 1/0 2048000 0.00 2047936 2048000

7 - SYSAUX 2/0 2445312 65.61 840832 2445312

8 - SYSTEM 2/0 2957312 29.29 2091072 2957312

Shell Export size :

cd shellexport/

represtore:orarep 34> du -cmsh *

5.6G ABAP

4.0K LABELIDX.ASC

5.6G total

Kindly suggest the solution for the same.

Regards,

Amit

[Former Member]

I think the error text says the reason for the error -

>No Profile used. sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

You need so set the profile parameters correctly.

Regards

Pankaj