BATCHJOB RSINDCHK FAILED

[Former Member]

Dear all,

While performing an upgrade from 40B to 4.7 version at JOB_RSINDCHK phase we are getting below mentioned error.

we are on windows 2000 oracle 9i platform.

BATCHJOB RSINDCHK FAILED

RSINDCHK.LOG

1 ETQ201XEntering upgrade-phase "JOB_RSINDCHK" ("20080718084251")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '00', GwService = 'sapgw00'

4 ETQ399 Environment variables:

4 ETQ399 dbs_ora_schema=SAPR3

4 ETQ399 auth_shadow_upgrade=0

4 ETQ260 Starting batchjob "RSINDCHK"

4 ETQ010 Date & Time: 20080718084251

4 ETQ260 Starting batchjob "RSINDCHK"

4 ETQ230 Starting RFC Login to: System = "PRD", GwHost = "cysol", GwService = "sapgw00"

4 ETQ359 RFC Login to: System="PRD", Nr="00", GwHost="cysol", GwService="sapgw00"

4 ETQ232 RFC Login succeeded

4 ETQ233 Calling function module "SUBST_START_BATCHJOB" by RFC

4 ETQ234 Call of function module "SUBST_START_BATCHJOB" by RFC succeeded

4 ETQ233 Calling function module "SUBST_CHECK_BATCHJOB" by RFC

4 ETQ010 Date & Time: 20080718084311

4 ETQ234 Call of function module "SUBST_CHECK_BATCHJOB" by RFC succeeded

4 ETQ239 Logging off from SAP system

2EETQ241 Errors found in logfiles - accumulated in file "RSINDCHK.ELG"

1EETQ203 Upgrade phase "JOB_RSINDCHK" aborted with errors ("20080718084315")

I have searched lot of notes but unable to find exact solution to this. Please help me at earliest

Best Regards,

RR

[Former Member]

Hi,

Check with *.ZIP script.

Finally apply for this....

Regards,

Srini Nookala

[Former Member]

Sorry Srini, but i am going to site https://websmp210.sap-ag.de/swcenter-3pmain and search for zip* but unable to find script you mentioned , appreciate if you could post the script righ here ... so that i can copy and run it on my server.

I would really appreciate your help.

[Former Member]

srini,

I found the note thank anyways...

[Former Member]

Thanks to Srini once again my upgrade processing further now.

points rewarded.

[Former Member]

Hi,

The upgrade is hanging within one of the following phases (prior to NetWeaver 7.0:

PARCONV_UPG.

SHADOW_IMPORT_UPG2

XPRAS_UPG

JOB_RSINDCHK

1 The Problem described in this note is unique to systems running on an oracle database.

2 The activity in this note can be applied prior to the upgrade in order to prevent the situation from happening, or while the upgrade is running if the problem occurs.

3 You can see on OS level that an oracle shadow process is consuming a lot of CPU. (On Windows platforms the oracle.exe process).

4 Please perform the following check:

1. logon to R3 and goto transaction sm50 (on the server you are running the upgrade on)

2. Find out what process ID the upgrade process is running on

3. goto st04 -> detail analysis menu -> oracle sessions

4. search for the process id of the upgrade process

5. If you see this session having the status 'ACTIVE' and the select statement being a select on VIEW 'user_ind_columns' or 'dba_ind_columns' please implement the solution mentioned below

6. The problem in most of the cases seen was a result of having statistics on the oracle data dictionary (note 558746 was implemented).

Logon to the 3rdparty maintenance softwarecenter in sapnet http://service.sap.com/swcenter-3pmain, and download the file dba_ind_columns_sap.zip. Execute the sql script.

Regards,

Srini Nookala

[Former Member]

Srini ,

In case of performance issue i have already taken reatsrt of SAP and Oracle database ...but still problem continues now i will work on solution mentioned by you

[Former Member]

srini,

In my ST04 --detail analysis

SID ORA PID Client System Client PID Status Event User SQL statement

1 1044 cysol Shadow ACTIVE pmon timer

2 1056 cysol Shadow ACTIVE rdbms ipc message

3 1068 cysol Shadow ACTIVE rdbms ipc message

4 1072 cysol Shadow ACTIVE rdbms ipc message

5 1076 cysol Shadow ACTIVE smon timer select from ts$ where ts#=:1#

6 1080 cysol Shadow ACTIVE rdbms ipc message select from obj$ o where o.obj#=:1#

7 1084 cysol Shadow ACTIVE rdbms ipc message

8 1088 cysol Shadow ACTIVE rdbms ipc message

above sessions are active.

Could you please let me know where is the path on OSS for downloading dba_ind_columns_sap.zip script

Also could you please explain from note 558746 what eactly i need to execute.

Appreciate your cooperation

[Former Member]

should i run script mentioned in first part of the note