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.
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.
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 pageThis 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.