Skip to Content

Please help with SAP Hana installation

Dear Experts,

I'm attempting to perform my first Hana installation.
I've installed the database (SPS12) without any problems.
Now I'm installing NetWeaver 7.4 over that Hana DB.
It shows the following since 2 hours:

Import Monitor jobs: running 1, waiting 27, completed 1, failed 0, total 29.

There is only one R3load running, causing about 25%-35% CPU load.
But nothing seems to be happening. The last logs in the installation directory
are exactly 2 hours old. This should have been loooong time done.
Also, I am not getting it why there is jobnum=16 configured and I have
only a single R3load process running ? i was googling a lot, but no
explanation, just that there is a problem with LOB loading in parallel, but
no suggestion on how to enable multiple R3load processes...

How do I check if something is happening ? And what shall I do now ?

Many thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Jun 27, 2017 at 05:54 AM

    Dear Symon,

    check what job is stuck, I mean which package is being processed by that one R3load job.
    You can also upload import_monitor.log here and we can check this file, then drill down further.
    Perhaps this KBA will help, too: 2146357 - How to analyze Migration Monitor issues in SWPM

    Hendrik

    Add comment
    10|10000 characters needed characters exceeded

    • I'll wait for the files first, no speculation :)
      Did you or your DB admin check on DB level what's going on? If it's only one job that hangs, maybe more detail we find looking there...<- I seem to drift into some movie related accent here *g

  • Jun 26, 2017 at 09:08 PM

    I have replaced R3load with the latest version and I have resumed it, but nothing more seems to happening, so I think it got stuck again :-(

    PLEASE HELP ME :-)

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 07:53 AM

    Hi

    As suggested by Hendrik, please share the log files. (sapinst_dev.log and import_monitor.log) you can find these files in installer directory.

    Also, please go through below link if that helps

    https://wiki.scn.sap.com/wiki/display/SL/Troubleshooting+Installation+and+System+Copy+Issues

    Regards

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 09:55 AM

    import-monitorlog.txtsapinst-devlog.txt

    Hello and many thanks for your replies.

    I had quite a hard time uploading the logs, due to the stupid limitations here.
    You can find 2 of 3 logs attached here. The 3rd one is 5 MB, and the silly
    attachment system here rejected a .zip.txt file as invalid file type, so I had to
    upload it somewhere else and I'm providing a download link here.
    Though I won't be surprised, if it then says - invalid link type :-D

    https://mega.nz/#!E9kzHbTB!W3VeWU1OwvXktk-PuOqov-YMvXX6O6mIxwQTl8EItlU

    Many thanks for having a look at my issue!

    P. S.: In one of the logs, you can see, that it wasn't updated between 22:52h
    and 0:45 - the time at which I interrupted everything as I decided that it makes
    no sense to keep waiting for nothing - almost 2 hours.
    MSSQL Server for instance, was making the whole Import ABAP phase in less
    than 30 minutes on a much weaker hardware!

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 10:47 AM

    sapssexclog.txt

    Pfff, OK, this feels a little embarrassing for me now... I could have thought of checking this log file as well... :-/
    The thing is, that it hadn't been updated for sure. What you will see in the file, or at least most of it, must
    have been flushed into the file after I have cancelled the entire operation. Otherwise I was constantly doing
    ls -lart on the import directory and no file was updated for 2 hours...

    Anyway, any advice on what this error is and how it could be fixed ? Many thanks in advance!

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 11:26 AM

    Hi

    It seems to me a network issue.

    Could you please check sap note https://apps.support.sap.com/sap/support/knowledge/preview/en/2308459

    and below thread https://archive.sap.com/discussions/thread/3858418

    Regards

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 12:53 PM

    Hello Hendrik,

    what you are saying is just partially true. I was checking the SAPSSEXC.log further.
    It looks that it had been working fine, tables were created and objects imported. Till
    I made the mistake to decide, that it's doing nothing and I interrupted it.
    What you are saying then, is true - it was giving an error and I have checked the log
    so I fixed it by using the following command:

    R3load -merge_only SAPSSEXC.TSK

    Then the import continued, but if I read the log correctly, it was then throwing the
    10108 error - no idea why !!

    However, what is initially suspicious here and nobody commends on it - why did I
    have only a single R3load process, when I had set jobnum=16 ? Why isn't it doing
    a parallel import ?

    Many thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 10:21 AM

    SAPSSEXC seems to be the faulty one. Can you please share SAPSSEXC.LOG (hope this works without hassle...)

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 11:37 AM

    Symon,

    thanks so much for the speedy replies and uploads.
    The SAPSSEXC.LOG shows an interruption of the import at June 26th, 20:00 local time.
    At 22:43 it was attempted to restart the import but the necessary parameter for R3load
    were not used thus the attempt failed. Same is valid for all subsequent tries to finish
    import of this package.
    Head over to KBA 1970577 and follow the steps in the Resolution section.

    Let me know if that worked *thumbsup

    Hendrik

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Symon,

      what's the status now?

      For the R3load job question, how many jobs were specified? If it was 16 as you wrote in
      your initial post, it starts gradually and every 30 seconds (by default), migmon checks
      the status anew and creates a new R3load job if necessary.

      If REPOSRC is now the last package, SAPVIEW is the last one waiting but its import
      will only start when all other packages were successfully completed. Thus, there will
      also only be 1 active R3load job importing SAPVIEW.

      Hendrik