Dear Admin,

There was a new junction box created in Project A and the same designer wished to use the spare terminal for Project B. So what I did is I merge the required terminals (say 3 & 4) back to As-Built database then intentionally claimed terminal 3 & 4 from As-Built to Project B.

Unfortunately in Project B, the terminals were not visible. But the original junction box in Project A somehow shown double for each terminal. I did run checkdb and run the suggested fix statement but no affect to the junction box display terminations. I run sql to check the record from the panel, panel_strip and panel_strip_term tables but I could not see any duplicate terminal (term_num, term_seq) from panel_strip_term. Their eng_proj_id corresponds to Project A where the junction box was originally created.

Any reason why this happen and how to correct it? Please advise.

Hi Ilan,

When I run the sql, there is no record. So what to do now?

I also change slightly the sql to read as panel_name like '%70%JE%772%' and still no record. Any other suggestion ? I also run the sql below. I will email you the excel files for your investigation.