Portal
Language
 
Home>Knowledge Base>Root>Campaign CSi>Query for finding duplicate postings in CampaignCSi
User Login
Username
Password
 
 Login
Information
Article ID177
Created On10/13/2009
Modified10/13/2009

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.