Extreme long time for importing SCA's, activating activities etc.

[Former Member]

Hello all,

I'm having some problem with the setup of NWDI.

It's taking a lot of time to import SCA's to the system (4hours) - even though they are only 42kB each (I did 4 imports at the same time).

Activating activities in the system seems to take a long time too.

I'm not sure what the cause here is, other functionality on the system (E.g. opening NWA) is still working fine during the import.

Has anyone had this problem before? And does someone know how to solve it?

Any help is much appreciated.

Kind regards,

L.

The system is NW CE 7.20 SP3.

In the CMS log (after the check-in) I can see following part took the longest: (however I was going to import the rest of the SCA's later, so some dependencies are not yet imported - but would this cause the NWDI to take 4h ??)

Analyze effect of applied changes to buildspace state... started at 2011-01-31 08:16:30.346 GMT

INVALID DEPENDENCIES: The following dependencies of the DCs in this request are being marked as invalid as they refer to non-existent public parts.

...

Handle Cycles... started at 2011-01-31 08:20:30.331 GMT

No new cycles detected.

Handle Cycles... finished at 2011-01-31 12:00:56.039 GMT and took 220 m 25 s 708 ms

...

REQUEST PROCESSING finished at 2011-01-31 12:01:15.437 GMT and took 224 m 55 s 141 ms

[ErvinSzolke · Accepted solution]

Hi Vandousselaere,

I assume that the import is working, it is just slow, right? Please confirm or deny this.

If you can confirm this, then see some ideas below:

is your system (where NWDI runs) is a unix or windows system?

Perhaps there is an general load issue which is not even related to NWDI. Could you please check the "uptime" and "top" commands to figure this out? On windows you can check the CPU time column of the Task Manager.

This would be useful before we go into details what could be slow regarding NWDI.

Other ideas crosses my mind:

- often we suggest executing UPDATE DATABASE STATISTICS. On MaxDB this should be automatic, but on Oracle you need to execute it manually (you must be <SID>adm to perform this operation: brconnect -u / -f stats -t all (brconnect is located usually under /usr/sap/<SID>/SYS/exe/run))

- See also the notes in this topic which may help or may give some ideas:

#889038 - Collective note: NWDI server component configuration

#737368 - Hardware requirements of Java Development Infrastructure

#754143 - CMS remarks/restrictions

-If these are not helping then I suggest you to trigger again a new import and then monitor the following logs:

- first of all check the transport logs (a.k.a import logs), you can find here:

-usr/sap/JTrans/CMS/log/* Notice, this can be different in your case, check the location of the transport folder under the CMS WebUI (/devinf u2013 Landscape Configurator u2013 Domain Data Tab). This is the same like the "Details..." button in the transport studio when you are importing.

-...\j2ee\cluster\server<n>\log\applications\cms.<n>.log

-...\j2ee\cluster\server<n>\sap.com\tc_dtrenterpriseapp\dtr.<n>.log

-...\j2ee\cluster\server<n>\log\services\tc.CBS.Service\cbs.<n>.log

-...\j2ee\cluster\server<n>\log\defaultTrace.<n>.trc

If you suspect as per the above logs that your problem is related to the DB then you can find information here:

-...\j2ee\cluster\server<n>\log\sysyem\database.<n>.log

I hope this helps!

Best Regards,

Ervin

[Former Member · Accepted solution]

Hi Ervin,

Yes the importis working, just very very slow !

Our system is unix based.

I will ask our system administrator to look into your suggestions.

Will update if I find something.

Thanks a lot for your fast reply !

Kind regards,

LV

[ErvinSzolke]

Hi LV,

I am glad to hear that the problem is resolved!

Best Regards,

Ervin

[ErvinSzolke]

Hi L,

an other interesting question is, which part of the import is slow.

As you know, the import stands of always 3 parts:

- DTR import (integrating the DCs into the DTR workspaces)

- CBS-Make (building the software)

- Deployment (if the build was succesful, deploying changes)

This is what you can also see in the "Details..." button on the "development" tab of the transport studio.

Still, I'd also try first the update DB stats, see instructions for it in my previous answer.

Best Regards,

Ervin

[Former Member]

Hi L.,

I had the same problem as you have now (see my post ). Updating the satistics of the database worked in my case.

Please ask your DBA to help you with this update.

Hope this helps.

Regards,

Alain

[Former Member]

Updating the statistics of the database worked!

Thanks for your help.

LV