Index _PK causing issues in TCs
Indexes being created with _PK, causing issues with Table Conversions, anyone faced this issue before
We were able to identify Indexes, causing issue running TC's using the below query
************************************************
select DISTINCT INDEX_NAME from SYS.ALL_IND_COLUMNS where TABLE_NAME in ( SELECT DISTINCT TABLE_NAME FROM SYS.ALL_IND_COLUMNS WHERE INDEX_NAME like '%_PK' AND INDEX_OWNER = 'CRPDTA') and INDEX_OWNER='CRPDTA';
************************************************
Normally these Indexes are not supposed to be there, as Indexes usually created within JDE have a numeric, creation eg. INDEX_0 or INDEX_1 and so forth.. for sample " F0022_0 "
not " F0022_PK "
We were then able to drop the Indexes using the below commands