Question Re: ITAB_DUPLICATE_KEY dump in the PSA tree or search in Technology Q&A

ITAB_DUPLICATE_KEY dump in the PSA tree or search

Former Member — Wed, 09 Nov 2005 05:46:22 GMT

Hi,

I am getting the above mentioned error in my BW system. On further investigation I found out in table RSISOSMAP, there are 2 entries for a Data source each for a different source system. But the Transfer structure is the same for both the source system, this is where the problem is.

E.g.

SE16 for RSISOSMAP:

OLTPSOURCE LOGSYS TRANSTRU

________________________________________________

ZBW_R3_SEC12 ANA430 ZBW_R3_SEC12_GB

ZBW_R3_SEC12 F6A430 ZBW_R3_SEC12_GB

If you see the TransStru (ZBW_R3_SEC12_GB) is same for different system. I think there must be some pleace where the last charcter '_GB' is set for each system.. (configuration)

I checked the OSS: 366181, but its does not mention how to solve the problem.

Regards,

Kaustubh

Re: ITAB_DUPLICATE_KEY dump in the PSA tree or search

Former Member — Wed, 09 Nov 2005 06:59:33 GMT

Hi,

I'd try the following.

- Delete duplicated entries from RSISOSMAP table.

- Regenerate DSs

- Replicate DSs in BW

- Assign DS-IS

etc.

Best regards,

Eugene

Re: ITAB_DUPLICATE_KEY dump in the PSA tree or search

Former Member — Wed, 09 Nov 2005 08:54:41 GMT

On Investigation I found out the table : RSBASIDOC

stores all the related data for Prefix..

Can some1 tell me which T code is used to update this table?

Re: ITAB_DUPLICATE_KEY dump in the PSA tree or search

Former Member — Mon, 23 Jan 2006 11:33:27 GMT

Hi Kaustubh,

It is telling that there are different transfer rules for the same transfer structure,

So u have to delete duplicates

Run RS_FIND_ISOSMAP_DUPREC (CHECH IF IT IS FM OR ST PROG),so that it lists all duplicates.

Go to rsisosmap and delete duplicates.

Regards

Raman.

Re: ITAB_DUPLICATE_KEY dump in the PSA tree or search

Former Member — Fri, 28 Apr 2006 19:25:49 GMT

Once you have generated a list of duplicates with RS_FIND_ISOMAP_DUPREC, how do you actually delete them in RSISOSMAP?

Thanks,

Dave

Re: ITAB_DUPLICATE_KEY dump in the PSA tree or search

Former Member — Mon, 08 May 2006 13:29:15 GMT

Dave,

Go to Trx SE16 with Table RSISOSMAP. Filter the InfoSources you have with duplicates and delete the one that is wrong.

PM.