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.
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';
INSERT INTO OPTIONREGISTRY VALUES('XBlob', 'm_blob', 'BLOBSIZE', '75000000');
commit;
exit
Restart the PPR Server
To verify, connect to the Oracle database and enter the following command:
SELECT MAX(M_LNGTPSIZE76V0) FROM E5_DATABASE.XDOBLOBC318V0;