DB export - Executable directory 'undefined' must exist

[Former Member]

Dear all,

I've finished test heterogenous system copy for development and QUA SAP ECC 6.0 systems (HP-UX 11.32 Oracle 11.2.0.3) to RedHat 6.4 Oracle 11.2.0.3, SAP Central ABAP system Non-Unicode.

Now I tried to perform test heterogenous system copy for production SAP ECC 6.0 on HP-UX 11.32 Oracle 11.2.0.3 to RedHat 6.4 on VMware.

For the Export of DB Instance, on the step for Update Database Statistics I had to do the statistics manually because our schema is still SAPR3 but the tool use Schema SAPSR3.

I've manualy prepared the update statistics with :
brconnect -u / -c -o summary -f stats -o SAPR3 -t all -m +I -s P10 -f allsel,collect,method,precision,space,keep -p 4

Then I checked skip update db statistics.

But when I tried to do the DB instance export I got the error on the phase 2 of 4 - Update database statistics:
"FCO-00011 The step stepPreconditions with step key |NW_Export|ind|ind|ind|ind|0|0|NW_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_update|0|stepPreconditions
was executed with status ERROR ( Last error reported by the step: Assertion failed: in NW_ORA_Statistics_Update.stepPreconditions:
Executable directory 'undefined' must exist)."

I used 70SWPM10SP02_1-20009698.sar Software Provisioning Manager 1.0 SP02 for NW 7.0x.

I couldn't find any similar error for SWPM or sapinst on SAP Notes or on the forums.

Can anyone please suggest how to solve this error?

Thank you in advance.

Best regards,
Ruzica

[Former Member]

This message was moderated.

[Former Member]

Can you provide summary screen with options selected during system export?

[stefan_koehler]

Hi Ruzica,

i don't know how to fix the SWPM error, but i just have replaced brconnect with a shell script that returns return code 0 (something like exit 0) in the "old times" where you were not able to deselect the statistic collection step.

After SAPinst (or SWPM) passed the statistic step, i moved the original brconnect back

Regards

Stefan

[Former Member]

Tnx Stefan,

But it's the production system copy and this error appeared only on this system not on DEV i QUA. I've to find the cause of this error message.

BR,

Ruzica

[former_member206552]

Hi Ruzica,

an option is to skip this error seeing that you collected the stats manually

./sapinst SAPINST_SKIP_ERRORSTEP=true

just an extra is  dbs_ora_schema set in the system ?

Best regards

Marius

[Former Member]

Hi Marius,

Yes I set the dbs_ora_schema to SAPR3. This setting helped on the test system. But here in the production doesn't change anything.

The ./sapinst SAPINST_SKIP_ERRORSTEP=true will skip the error step for update statistics, but it will skip and some other error during export if any after phase 2 of 4. Am I right?

Thank you .

BR,

Ruzica

[former_member206552]

Morning Rezica,

It will just skip this step

Please see sap note below regarding stats

i see the note is in reworking you can use this link to view it (http://www.stechno.net/sap-notes.html?view=sapnote&id=1249365)

Note 1249365 - Inst. SAP NetWeaver based on Kernel 7.11 - Unix Oracle

------------------------<D023322, 01/DEC/08>------------------------SAP NetWeaver Composition Environment 7.11:

Update Management Service error during the Oracle-specific post-installation phase.

Symptom:

• Error in sapinst_dev.log:

             ERROR <date>                                                     FCO-00011  The step createOracleStatisticsJava with step key CE_UpdateManagementService ind ind ind ind 0 0 NW_Postdeploy ind ind ind ind 5 0 NW_Postdeploy_ORA ind ind ind ind 1 0 createOracleStatisticsJava was executed with status ERROR . 

• Error in brconnect.log:

           BR0813I Schema owner found in database O81: SAPO81DB%BR0824E Owner 'SAPSR3DB' not found in database or not SAP owner BR0182E Checking parameter/option 'stats_owner/-o' failed 

Solution 1:

1. Start the brconnect call manuall as orasid user:

              brconnect -u / -c -o summary -f stats -o SAP<SCHEMAID>DB -t all -p 4 -f nocasc 

2. Skip the last sapinst error step with SAPINST_SKIP_ERRORSTEP=true

Solution 2:

1. In keydb.xml search for table name="t_NWDB_ind" and write the entry:

              <fld name="javaSchema"> 

       <strval><![CDATA[SAP<YourSchemaId>DB]]>
       </strval>
    </fld>

1. 2. Restart sapinst with the option continue old installation.

Best Regards

Marius

[Former Member]

Thank you Marius.

I'll try this on the weekend .

BR,

Ruzica

[former_member206552]

Good Luck

[Former Member]

Hello,

I tried the ./sapinst SAPINST_SKIP_ERRORSTEP=true , it skiped the step for update statistics , but next error appeared for Prepare to Export ABAP:

CJS-00030  Assertion failed: in NW_ABAP_Prepare_Export.stepPreconditions: Executable directory 'undefined' must exist

What should be the problem? There is no exact info in the error message - directory 'undifiened'.

It looks like there is no some privilage but where ?

Thank you in advance.

BR,
Ruzica

[former_member188883]

Hi Ruzica,

Could you check whether following environment variable is set for sidamd user or not

LIBPATH =<path of executable directory.

Hope this helps.

Regards,

Deepak Kori

[former_member206552]

Hi Ruzica,

can you maybe upload the sapinst_dev.log ?

but looking just at the error I think that it's complaining that the directoy does note exist that you choose to export to. If it does exist give the folder 777 permissions

Best Regards

Marius

[Former Member]

Hello Deepak,

Yes I have this for sidadm

SHLIB_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/11x_64/instantclient

Tnx,

BR,

Ruzica

[Former Member]

Hello Marius,

This is not the problem. SAPINST already created the ABAP folder in /EXPORT directory.

I checked the control.xml for this executable directory, it seems it is the /sapmnt/SID/exe, but I've central system and the /sapmnt is on the same host.

Thanks.

BR,

Ruzica

[former_member206552]

Hi Ruzica,

are you using virtual names ?

Note 962955 - Use of virtual TCP/IP host names

http://help.sap.com/saphelp_nwpi71/helpdata/en/45/61997b34542a4de10000000a11466f/content.htm

if so you need to run 'sapinst SAPINST_USE_HOSTNAME=dbhostname'

Best Regards

Marius

[Former Member]

Hi Marius,

No I'm not using virtual names.

But I'm suspecting in someting:

In our DNS server I've record for the production system "sapprod" but this is different from the host name in /etc/hosts:

x.x.x.x      prod1      prod1.telco.mk

On the screen for the installer : SAP System  Database

For DB host I had to set the dns name  "sapprod" beacuse the host name of the server shows the error: "This computer host name is "prod1" but a reverse lookup returned 'sapprod'. This will lead to problems latter on whne starting the Web Application Server. SOLUTION: Insert a line into the hsot file ' x.x.x.x prod1' into the host file '/etc/hosts' and continue with the installation"

I did this but nothing changed and I had to use the record "sapprodd".

Can this make the problems?

BR,

RUzica

[former_member206552]

Hi Ruzica,

After you changed the entries in the /etc/hosts file did you restart the sapinst from  the beggining or just closed and continued, reason why im asking i did a install aqbout 2 weeks ago where i also had the error with the reverse lookup so i changed the etc/hosts file and start sapinst again with SAPINST_USE_HOSTNAME=DBNAME and the problem did not appear this round

Best Regards

Marius

[Former Member]

Hi Marius,

I've tried without the /etc/resolve.conf file, just /etc/host.

Now when trying sapinst with Run a new option, no error in the part for DB host, but in the phase 2 of 3 in Export preparation again the error message. The hostname and reverse dns name was not causing the error “Assertion failed: in NW_ORA_Statistics_Update.stepPreconditions: Executable directory 'undefined' must exist”

Thanks in advance.

BR,

Ruzica

[former_member206552]

Hi Ruzica,

can you upload the log file ?

Best Regards

Marius

[Former Member]

The log is bigger then 1MB. How to attached?

BR,

Ruzica

[former_member206552]

Hi Ruzica,

you can zip it.

or you can paste the last 100 entries here

[Former Member]

Hello,

Please look at sapinst.log

/tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP#tail -100 sapinst.log

INFO 2013-07-02 00:29:11.883
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:29:11.943
Execute step dialogUpdateOracleStatistics of component |NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_stat_update|0

INFO 2013-07-02 00:29:37.603
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:29:38.223
Execute step cleanInifile of component |NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_stat_update|0

INFO 2013-07-02 00:29:38.532
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:29:38.722
Execute step dialogPreconditions of component |NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Post|ind|ind|ind|ind|actionPost|0

INFO 2013-07-02 00:29:39.52
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:29:43.42
Creating file /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP/summary.html.

INFO 2013-07-02 00:29:55.602
Execute step adaptInstanceProfiles of component |NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_GetSidFromProfiles|ind|ind|ind|ind|getSid|0|NW_getFQDN|ind|ind|ind|ind|fqdn|0

INFO 2013-07-02 00:29:55.792
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:30:00.532
Execute step createExportTopSubdirs of component |NW_Prepare_Export|ind|ind|ind|ind|0|0

INFO 2013-07-02 00:30:01.252
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:30:01.652
Execute step createExportTopLabelIndexFile of component |NW_Prepare_Export|ind|ind|ind|ind|0|0

INFO 2013-07-02 00:30:01.772
Removed file /IMPORT/LABELIDX.ASC.

INFO 2013-07-02 00:30:01.782
Creating file /IMPORT/LABELIDX.ASC.

INFO 2013-07-02 00:30:01.812
Authorizations set for /IMPORT/LABELIDX.ASC.

INFO 2013-07-02 00:30:01.812
Authorizations set for /IMPORT/LABELIDX.ASC.

INFO 2013-07-02 00:30:01.942
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:30:02.762
Execute step stepPreconditions of component |NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_stat_update|0

ERROR 2013-07-02 00:30:08.172
CJS-00030  Assertion failed: in NW_ORA_Statistics_Update.stepPreconditions: Executable directory 'undefined' must exist

ERROR 2013-07-02 00:30:08.182
MUT-03025  Caught ESAPinstException in module call: .

ERROR 2013-07-02 00:30:08.682
FCO-00011  The step stepPreconditions with step key |NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_stat_update|0|stepPreconditions was executed with status ERROR ( Last error reported by the step: Assertion failed: in NW_ORA_Statistics_Update.stepPreconditions: Executable directory 'undefined' must exist).

INFO 2013-07-02 00:30:09.242
Creating file /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP/__instana_tmp.xml.

INFO 2013-07-02 00:32:28.501
An error occured and the user decided to retry the current step: "|NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_stat_update|0|stepPreconditions".

INFO 2013-07-02 00:32:28.521
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

ERROR 2013-07-02 00:32:37.531
CJS-00030  Assertion failed: in NW_ORA_Statistics_Update.stepPreconditions: Executable directory 'undefined' must exist

ERROR 2013-07-02 00:32:37.541
MUT-03025  Caught ESAPinstException in module call: .

ERROR 2013-07-02 00:32:38.241
FCO-00011  The step stepPreconditions with step key |NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_stat_update|0|stepPreconditions was executed with status ERROR ( Last error reported by the step: Assertion failed: in NW_ORA_Statistics_Update.stepPreconditions: Executable directory 'undefined' must exist).

INFO 2013-07-02 00:32:38.691
Creating file /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP/__instana_tmp.xml.

INFO 2013-07-02 00:34:21.190
An error occured and the user decided to stop.\n Current step "|NW_Prepare_Export|ind|ind|ind|ind|0|0|NW_Prepare_Export_Pre|ind|ind|ind|ind|actionPre|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|ora_stat_update|0|stepPreconditions".

INFO 2013-07-02 00:34:32.360
Working directory changed to /tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/PREEXP.

INFO 2013-07-02 00:34:32.450
Creating file /tmp/sapinst_instdir/.lastInstallationLocation.

INFO 2013-07-02 00:34:34.470
Cancelled task 1.

[former_member206552]

Hi Ruzica,

You have me stuck, maybe we can start by checking some vatiables, reason for this is that it complains about the executable directory.

just to double check you are running the sapinst as root ?

can you make sure that in PATH variable for the adm/ora user the /sapmnt/SID/exe is defined.

you can add it to .cshrc if they are not here.

env | grep PATH

there should be /sapmnt/SID/exe or /usr/sap/SID/SYS/exe/run

if not you can manuall add it to the .cshrc by adding the following line

for csh

setenv PATH /usr/sap/SID/SYS/exe/run:$PATH

or for ksh

export PATH=/usr/sap/SID/SYS/exe/run:$PATH

after that can you double check the file permissions on the directory

/IMPORT/ (777)

also start the sapinst with the skip part to bypass the orastats.

Best Regards

Marius

[Former Member]

Hello Marius,

Yes sapinst started with root.

For sidadm:

SHLIB_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/11x_64/instantclient

and also PATH variable have the /usr/sap/SID/SYS/exe/run

For orasid:

SHLIB_PATH=/oracle/SID/112_64/lib:/usr/sap/SID/SYS/exe/run

and also PATH variable have the /usr/sap/SID/SYS/exe/run

What you mean to start sapinst with skip part to bypass orastats? I use the radio button skip update statistics in sapinst.

Thank you.

BR,

Ruzica

[former_member206552]

Hi Ruzica,

ok that is fine then if you used the buttong to skip the stats, but i see i the log that it also complains about the stats,

please start the sapinst with the option

./sapinst SAPINST_USE_HOSTNAME=dbname SAPINST_SKIP_ERRORSTEP=true

and see if the error appears alter on again, if it does i will have to suggest to log an oss because im out of ideas

Best Regards

Marius

[Former Member]

Hi Marius,

Thank you.

I used the SAPINST_SKIP_ERRORSTEP=true and for the next step Prepare to Export ABAP:

CJS-00030  Assertion failed: in NW_ABAP_Prepare_Export.stepPreconditions: Executable directory 'undefined' must exist

BR,

Ruzica

[former_member206552]

Hi Ruzica,

sorry i'm out of ideas, i would suggest to log an oss call,

I would as a test if you have time skip it again and see if it goes through just as a test.

Best Regards

Marius