SAP Knowledge Base Article - Preview

1866658 - EPM-PCM PCM 10 Application hangs with console wizard import to Oracle

Symptom

Using PCM console, create a new model, using a new load id and after preparing everything in PPLOAD* tables, Data loader hangs with activitydrivervalues and see the database session hanging for a long time, no data records changes in table that seems to be inserting. 


Read more...

Environment

PCM 10.0 SP4 patch 2 with Oracle 11G.

Verified these settings were used:
- Data Warehouse
- Database Character Set: - "AL32UTF8 – Unicode UTF-8 Universal character set".
- National Character Set: - "AL16UTF16 – Unicode UTF-16 Universal character set".
- Dedicated Server Mode
- Verify that the tablespace creation script (OracleCreateObjects.SQL) was run only modifying the path and passwords.
Should there be any questions on the settings, there is a series of notes that cover all of this See 1546214.

Tuned the database with these two articles:
1537840 - Suggested Oracle Database Settings and Tuning Options for PCM.
1531674 - PCM : Oracle Data Loader performance tuning for large imports that take longer than expected.

Product

SAP Profitability and Cost Management 10.0

Keywords

jmhiv, epm-pcm, PCM, profit, profitability and cost management, EPM; EPM-PCM; Profit; SAP PCM; SBOP PCM; jmhiv2016e; SAP BusinessObjects Profitability and Cost Management; , KBA , EPM-PCM , Profitability and Cost Management, EPO, PP, AA, Metify , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.