topic Re: ADR6 TABLE_Internal Error in Application Development and Automation Discussions

ADR6 TABLE_Internal Error

Former Member — Fri, 21 May 2010 21:50:55 GMT

Dear experts,

I deleted email id on some of the address ids in ADR6 table as I have multiple address number for the same person number that is linked to my BP profile. Unfortunately I lock my user id and password and I requested security to unlock my id. Now the security is getting below error message. Please advise how I can resolve this.

"Internal error - Insert in sorted tabl ZADRU with 3000.....320181NT001 AD_DEFAULT"

Thanks,

Sri

Re: ADR6 TABLE_Internal Error

Former Member — Wed, 09 Jun 2010 19:12:10 GMT

Slect (double click) the record you want to edit in ADR6 <> /h enter and enter

Duouble click on code and on right side double click on edit icon and type EDIT <> debugger <> continue <> OR F8

Re: ADR6 TABLE_Internal Error

Former Member — Wed, 09 Jun 2010 19:33:26 GMT

> I deleted email id on some of the address ids in ADR6 table...

So "**** in, **** out" works the other way around as well for referential DB models heh...

Have you considered that there might be more than 2 tables used by appications which depend on them and this is just the beginning of a big mess?

Cheers,

Julius

Re: ADR6 TABLE_Internal Error

Former Member — Fri, 09 Jul 2010 15:47:09 GMT

nup

closing this as we found a work around

Re: ADR6 TABLE_Internal Error

Former Member — Tue, 29 Apr 2014 15:23:17 GMT

what you have done as workaround?

Re: ADR6 TABLE_Internal Error

Former Member — Tue, 23 Jun 2015 11:56:58 GMT

I have the same problem. For me the solution was to update the table ADCP and set the field FLAGCOMM6 to space, like this:


Update ADCP Set FLAGCOMM6 = ' ' Where ADDRNUMBER = <fs_data>-addrnumber.

The flag FLAGCOMM6 indicates that an email address is maintained.

I hope this can help other.