I accidentally deleted an extension. When I tried to recreate it, I received an error that the extension already exists and indeed it again shows up in my extensions list. However, I cannot modify the extension. If I delete it again and try to recreate it, I get the same "cannot insert into sip table" error. Unfortunately, I had an incoming route pointed to this extension and now whenever a call comes in from on that DID, it attempts to ring this missing extension -- unsuccessfully since it doesn't really exist.
I hope that all makes sense and that you can help. The extension in question is 8005991812. Thanks.
Your extension number is too long. Generally extension numbers should be 2 to 4 digits. Delete this extension, create a new one and change your incoming route to point to the new one.
The actual error I receive is a failed INSERT statement ... database is reporting that a duplicate entry exists ... any change the offending record could be deleted/purged?
I have three reasons for believing this problem has nothing to do with the length of the extension.
First, I have successfully used this configuration on other Asterisk installations.
Second, this extension DID work the first time I created. The problem developed when I deleted the extension and tried to recreate it.
Three, the error message specifically indicates the extension already exists in the SIP table, so it stands to reason the extension did not get correctly deleted from the database when I previously removed it.