Ritu Mehta asked 1 year ago
Title : We are generating detail year to year GL report using pin_ledger_report utility. Receiving pin_err_no_mem in dm_oracle.pinlog (shmsize and bigzise)

Question :

We are generating detail year to year GL report using pin_ledger_report utility. Receiving pin_err_no_mem in dm_oracle.pinlog (shmsize and bigzise). What could be the reason?

1 Answers
Umesh SharmaUmesh Sharma Staff answered 1 year ago

This error PIN_ERR_NO_MEM occurs when the buffer that handles the output of pin_ledger_report doesn’t have enough space to handle the records.

This error can be resolved by increasing the parameters shmsize and bigsize in the pin.conf of dm_oracle. The value for dm_shmsize must be a multiple of 1024.

The value of dm_bigsize must be a multiple of 8192. The maximum allowed value of dm_shmsize in the DM’s pin.conf file is 274877905920 bytes (256 GB) and that of bigsize is 192GB.

The shmmax parameter of the system’s kernel should always be greater than the shmsize mentioned in dm_oracle pin.conf

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.