SAP ECC Installation struck at Import ABAP

[abk07]

Hi All,

I am currently installing SAP ECC 6.0 EHP 7 on Suse Linux 11 SP3. The database is SAP HANA Rev 82.

The installation is hung at import ABAP and log files are also not being updated at the OS level. Currently SAPSSEXC is being imported.

Please find the attached logs for reference. Kindly help.

PS: Rename the attachment logs.zip.txt to logs.zip.

Regards,

Abhishek

logs.zip.txt.zip

[abk07 · Accepted solution]

Hi All,

Sorry for the late response, was busy handling escalation calls and planning a backup plan Anyways the update was happening very slowly. It took about 38 hours to complete the DB import!! In the mean time tested the network and I/O, but everything seemed fine. Still not sure what was/is the problem.

Had to manually monitor the progress something like this for the tables which were getting updated.

select count(*) from INDTEXT

Have even upgraded the system without any issues. Thank you very much for your help guys, really appreciate it

Closing this thread.

Regards,

Abhishek

[abk07]

Hi All,

A bit worried now. I am getting the following error message in the index server log, can someone guide me why this is happening?

[39386]{-1}[30/-1] 2015-04-30 01:24:05.738807 e SERVER_TRACE     TRexApiAdmin.cpp(01508) : TRexApiAdmin::mergeDeltaIndexLocal, Index Id: SAP<SID>:REPOSRC (169505), main memory merge not supported on tables containing disk lobs!

[39386]{-1}[30/-1] 2015-04-30 01:24:05.738868 e Mergedog         Mergedog.cpp(01155) : Automerge failed: {IndexName: REPOSRC, Trigger: 7, ReclaimDelta: false, DeltaMerge: true, MemoryMerge: true, OptimizeCompression: false, MainSize: 3056}, error: error during merge of delta index occurred(2450)

Regards,

Abhishek

[Former Member]

Hello Abhishek,

Please upload the import log file and the indexserver trace file.

Can you also tell me if there are any files with the name *.oom.trc in your trace directory ?

I think you hit a OOM situation but need to see the traces/logs to confirm.

Kind Regards,

Amerjit

[abk07]

I see few issues in the index server trace, not sure whether it is related to the installation or not.

index server trace.txt.zip

[Former Member]

Hi Abhishek,

Missed your reply earlier on. Did you make any progress ?

Amerjit

[abk07]

Hi Amerjit,

Yes, it is updating the tables at the DB level gradually, finally something to cheer about. I could see the count increasing.

Monitoring using the below command

select count(*) from INDTEXT

Regards,

Abhishek

[Former Member]

Hi Abhishek,

Just so that you get a feel for things, also look in the thread tab, you'll see what's going on.

I'd guess that your slowdown (hiccup) was down to merge operations.

INDTEXT will be about ~1 mill entries.

If you're happy to do so, close out the thread as resolved.

Cheers,

Amerjit

[abk07]

Hi Amerjit,

I find the below things under threads tab of my HANA studio.

I am not knowledgeable about SAP HANA. 

Regards,

Abhishek

[abk07]

Processing REPOSRC table took a lot of time, it had about 4 million records

[Former Member]

Hello Abhishek,

Check your running threads in the HANA studio and also check the trace files on the HANA side.

Are all your HANA still services running ?

KR,

Amerjit

[abk07]

Hi Amerjit,

All the services are running fine.

Also no problem with the Database Ram which is currently 256 GB.

Regards,

Abhishek

[Former Member]

Active threads ?

Merge operations ?

Do you see the R3load connection in the studio ?

[former_member185239]

Hi Abhishek,

You have to use the latest patch of R3load for the kernel release.

Download the latest patch and retry the sapinst by stopping and starting it.

Issue generally occur with the Cluster tables but you can give a try by updating the R3load patches.

With Regards

Ashutosh Chaturvedi

[Reagan]

Install HANA studio and connect to the database using the SYSTEM user and check if the space usage is increasing.

[abk07]

Hi Reagan,

I executed the following query in SQL console and got the output

select count(*) from INDTEXT

Output

COUNT(*)

300,003

But log files in the OS level aren't getting updated.

Regards,

Abhishek

[former_member185954]

Hello Abhishek,

Do you find any R3trans/R3load  processes running at OS level ?

Regards,

Siddhesh

[abk07]

Hi Siddhesh,

Yes I can see the process -

/usr/sap/<SID>/SYS/exe/uc/linuxx86_64/R3load -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -c 100000 -loadprocedure dbsl -rowstorelist /install/tmp/sapinst_instdir/BS2013SR2/ERP607SR2/HDB/INSTALL/DISTRIBUTED/ABAP/DB/rowstorelist.txt -decluster