Customer Support Language
 
HomeKnowledge BaseCampaign CSiQuery for finding duplicate postings in CampaignCSi
Information
Article ID177
Created On10/13/2009
Modified10/13/2009
Share With Others
Query for finding duplicate postings in CampaignCSi
If an invalid BDE driver file is installed on the users machine while batches are posted, entries are duplicated in the PR_JOURNAL table.  The following query is helpful to locate these duplicate postings:

select b.batch, b.cnt, j.cnt
from
(select batch,count(*) as cnt from batch_detail group by batch) b,
(select batch,count(*) as cnt from pr_journal group by batch) j
where to_char(b.batch)=j.batch
and b.cnt <> j.cnt


See CSI4x - duplicate batch entries caused by SQLORA8.DLL for more information on this issue and how to resolve it.