When using Process Engineer with an Oracle database, the database administrator must increase the size of the ErgoItem, as the size defined by the default installation is not sufficient for storing DELMIA V5 data.
The following steps describe how to increase the default size and verify the change.
Connect to the database instance
Connect to the Oracle database instance named 'databaseora' to update the Option registry value for V5 detailing data.
|2.||Increase the size of the ErgoItem
Enter the following SQL commands to increase the maximum size of the ErgoItem to 75MB (this size may be adjusted):
DELETE FROM OPTIONREGISTRY WHERE CLASSNAME= 'XBlob' AND MEMBERNAME='m_blob' AND OPTIONNAME='BLOBSIZE';
Restart the PPR Server
|4.||Verify the change
To verify, connect to the Oracle database and enter the following command:
SELECT MAX(M_LNGTPSIZE76V0) FROM E5_DATABASE.XDOBLOBC318V0;