SMP 2.3.5 MBO many rows

[Former Member]

Hi all,

i have a project with a cache group with 20000 rows,

in this cache group there is only one MBO with scheduled policy.

Till SMP 2.3 SP04 there was any problem, I can deploy and cache refresh the MBO successfully; the we decide to support https on iOS8 and move to SMP 2.3 sp05.

From this moment cache group with many rows (10000 to 20000) hangs SMP server (CPU on CDB goes to 100%) , MBO with few rows (100 to 5000) load all and refresh without problem, the backend is an Oracle Database.

I try even to create a new project with only one MBO of 30000 rows to test the issue and the result is the same, server blocked.

Even installing PL01 patch the problem has not been resolved, have you encountered this problem?

Best Regards

[patton_li]

Hi Massimo Perego,

I'm from SMP 2.x developing team, according to the issue your met, can you provide more info about it?

1. What the backend type? SAP? or JDBC?

2. May I know what means "server blocked"? the server never response? or the CPU is high but it still response?

3. Is it a single node or a cluster dataTier?

4. Is this MBO a commingled MBO (parent-child) or a single MBO?

5. What's the server info? memory size?

--

Thanks and regards.

Patton Li.

[Former Member]

Hi Patton Li,

1. the backend is an Oracle Database

2. when cache refresh starts, cpu goes to 100% the SMP server and SCC are no more responsive, then SMP services needs to be restarted.

3. we try in a single node (dev environment) but also in cluster (quality environment)

4. Single MBO

5.  I ask to Server Admin info about RAM and server info and I forward them as soon as I'm able to.

Thanks and Regards

Massimo

[patton_li]

Hi Massimo,

Please help to pack the server logs under "MobilePlatform\Servers\UnwiredServer\logs" and send to me. I have to dig into it.

And let we know the Oracle JDBC driver version and his Oracle version.

--

Thanks and regards.

Patton.

[Former Member]

Ok thank you,

I'll try to give you all informations you need in a couple of hours.

Massimo

[Former Member]

Hi,

I have required information:

-Window Server 64 bit, 12GB RAM.

-backend oracle 11g  enterprise edition 11.2.0.3

-JDBC Driver used ojdbc14.jar

If you sent me your email I can sent you the zipped log file.

Thank you

[patton_li]

Hi Massimo,

You can send the info to my mail patton.li@sap.com.

But please CC to our SMP sustaining protocol manager: william.lai@sap.com and li-xiong.feng@sap.com.

--

Thanks and regards.

Patton.