SNAP_NO_NEW_ENTRY dump in production.

[Former Member]

Hi,

We are  using ECC6.5 ,In production server when snap table gets 1000 entries we are getting SNAP_NO_NEW_ENTRY dump... we are maintaining spool table very low as 3000 entries only.still we are getting  dump, please suggest what could be the reason.

Regards,

Harish.

[Former Member · Accepted solution]

Hello Ankam,

It could happen due to transaction log full even though you might have defined parameter value as 3000.

Please check.

Regards

Anand

[Former Member · Accepted solution]

Hi Anand,

What could be the solution.

Regards,

Harish.

[divyanshu_srivastava3]

Have you scheduled the housekeeping job for this ?

Regards,

[Former Member]

Hi Srivastava,

Yes , we have scheduled housekeeping jobs.

[Sriram2009]

Hi Ankam

Could you share the full dump details?

BR

SS

[divyanshu_srivastava3]

Backup and truncate the SNAP table or Goto ST22 and rorganize the table ;ST22->Go to->Reorganize

Schedule the house keeping job selecting with correct variant.

Also, check if there are no issues in the database, for eg, log waits or deadlock or anything other issue in alert logs and SM21.

Regards,

[Former Member]

Hi,

Thank u Divyanshu and Anand

[Former Member]

Hi,

Happy to help.

Close this thread if your query has been clarified.

Regards

Anand

[divyanshu_srivastava3]

Welcome brother

Cheers,