Skip to Content
0
Aug 15, 2016 at 07:15 AM

PI Dual Stack Update: MAIN_NEWBAS/XPRAS_AIMMRG hangs

44 Views

Hello,

we're in update to SPS14 on PI 7.3 double stack system.

We tested already on a sandbox - there were no problems in this phase.

I noticed phase MAIN_NEWBAS/XPRAS_AIMMRG ran longer than on sandbox.

Therefore I checked SM50 on instance 00 - no jobs are running.

I checked SM37 on instance 00 - I saw jobs RDDEXECL. I did a status check as adviced in note 1947874. After that both jobs where cancelled.

Nothing else happened, SUM remained in status MAIN_NEWBAS/XPRAS_AIMMRG is running.

So I tried to logon on instance 09 (shadow instance). This did not work - I didn't get a login window. I checked instance via dpmon and can see all DIA workprocesses are full and running (see screenshot).

In instance 00 I can see two dumps with error "DBIF_REPO_SL_ERROR" and "SQL error 60 occurred when accessing program "~L_PROXY_SERVICE================HPC" and "Databse error text: "ORA-00060: deadlock detected while waiting for resource".

File stderr3 in shadow instance work directory gives information:

Thu Aug 11 15:16:14 2016

*** ERROR => WARNING: Concurrent Generation of PH=~XTAB=========================HTC [scprehdr.c 6281]

{root-id=57AC003F7A9A09B0E10080000A70D4CD}_{conn-id=00000000000000000000000000000000}_0

SUM is still in status running, but processes are hanging on shadow instance.

At the moment I don't know what to do now.

Should I restart shadow instance?

Should I restart SUM?

Should I restart Job?

Regards,
Julia

Attachments