I am trying to create a credit memo in my store but I keep getting this error

Cannot save the credit memo

I have checked the exception.log and can see the following:

Integrity constraint violation: 1062 Duplicate entry '100003910' for key 'UNQ_SALES_FLAT_CREDITMEMO_INCREMENT_ID

I wanted to ask if I should change the value in the database to the next increment or is there a better way to solve this problem?

I'd be greatful for any advice...

I am trying to create a credit memo in my store but I keep getting this error

Cannot save the credit memo

I have checked the exception.log and can see the following:

Integrity constraint violation: 1062 Duplicate entry '100003910' for key 'UNQ_SALES_FLAT_CREDITMEMO_INCREMENT_ID

I wanted to ask if I should change the value in the database to the next increment or is there a better way to solve this problem?

I'd be greatful for any advice...