Workprocesses used by SM_EFWK or SOLMAN_BTC in Commit Status for a long time

[Former Member]

Hi,

lately, our SSM (7.1 SP11) system has been extremely slow. The problem is all DIA WP are occupied because every WP used by SM_EFWK or SOLMAN_BTC stay in Commit Status for a very long time.

I've checked several notes but with no success:

1851551 - Solution Manager not reachable/accessible because all dialog work processes are used by SM_EFWK

2253162 - Long running processes for user SM_EXTERN_WS report SAPLSYDB and action Commit in Solution Manager

2209954 - Deadlock in soft cancel

Settings for the EFWK are correct and set according to note 1851551.

We just upgraded the kernel to the latest version (7.22 PL127), but the problem continues...

Is there any note I could be missing?

Do you have an opinion and/or suggestion on how to fix this?

thanks

Antonio

[Former Member · Accepted solution]

Hi Antonio,

kindly check SAP note 1847293 - Message "DIA WP Resource Cap Exceeded" or message "DIA WP Resource Failure" in job log of job EFWK RESOURCE MANAGER.

We had similar issue on our solution manager as well. For us it helped to decrease Resources cap for RFC resources.  But please decrease it carefully and always double check with job log

EFWK RESOURCE MANAGER.

Hope it will help you.

Monika.

[Former Member · Accepted solution]

thanks for the tip... that's a very useful note.

Been trying some new values, but the situation hasn't improved yet

I'll have to keep looking for solutions.

thanks anyway!

[patelyogesh]

Hello,

Can you pleae let me know what jobs are running in system by this users taking long time or keep running?

-Yogesh

[Former Member]

one example... a screenshot of SM50:

[patelyogesh]

Hello,

Can you please check SAP note below

2253162 - Long running processes for user SM_EXTERN_WS report SAPLSYDB and action Commit in Solutio...

Thanks

Yogesh

[Former Member]

thanks for the tip...

but I already looked at that note.

We had SAP KERNEL 7.22 EXT 64-BIT UC PL13 and upgraded to PL127, but the problem continued...

[patelyogesh]

Is there any dead locks in system?

-Yogesh

[Former Member]

some are being reported, yes...

[manish_singh13]

Hi Antonio,

Do you see any relevant entries in SM21 or ST22 for these users when work process are stuck with COMMIT status.

Please update your OS & DB version also.

Thanks,

Manish

[Former Member]

Hi,

I see a lot of these entries:

> CREATE/ALTER partition function failed as only a maximum of

> 1000 partitions can be created.

Database error 7719 at OPC

with user SM_EFWK

and these:

BP_STEPLIST_EDITOR: Invalid step values (step 1 ) found. Reason:

> You are not authorized to schedule user SM_EFWK

BP_JOB_EDITOR: Job CCMS_CPH_RAW_DATA_UPDATE is invalid. Reason:

> Step 1 contains illegal values

with user SM_EXTERN_WS

Updating the OS and DB version is not an option right now, I'm afraid

thanks

Antonio

[patelyogesh]

Lets try restarting SAP instam including OS and DB

-Yogesh

[Former Member]

hey...

did it several times already. Didn't worked...

thanks

[patelyogesh]

Did you removed deadlocks and try again?

-Yogesh

[manish_singh13]

Hi Antonio,

What I meant earlier by update your OS & DB is please update this message about your current OS and DB version.

For your Database Error 7719, please check below SAP Note if your database is SQL Server:

1688108 - MSSQL: SQL Error 7719 despite support of more than 1000 partitions

Thanks,

Manish

[Former Member]

Yes.. that's done

[Former Member]

thanks for the tip.....

OS: Windows Server 2008 R2

DB: SQL Server 2008 R2

let me check that note and get back to you...

thanks