TSA Accounts with no search engine users but active campaigns may not sync

The problem is with accountID 323 Actuate Java. The account has no
searchengineUsers assigned to it:

mysql> select count from searchEngineUsers where accountID in (select
id from accounts where description = 'Actuate Java');
----------

count

----------

----------
1 row in set (0.02 sec)

There are campaigns assigned though

select count from searchEngineAccounts where accountID in (select id
from accounts where description = 'Actuate Java');
----------

count

----------

----------
1 row in set (0.05 sec)

When a sync is run, with the seuserid or accountid (even by itself), we
appear to be doing a sync based on a mapping that looks for a list of
seuserids then maps those back to a tsaccount. Even in the case of just
an accountid, what appears to be happening is we go from account to
campaign to seuser, then look up the account that that seuser belongs to
and sync that rather than what is passed in. Output below shows the
switch from account 323 to account 319

$DIR/seupdate.sh --groups --listings --distribution 3 --accountid 323 -d3

2009-07-22 07:32:46.731 (3) [main]: Debug Level set to 3
2009-07-22 07:32:46.745 (3) [main]: DatabasePool with a limit of 80 created
2009-07-22 07:32:47.060 (3) [main]: getSEUserIDs distID=3,
seUserID=null, accounts=(323) returned 859
2009-07-22 07:32:47.062 (3) [main]: =============== Starting Search
Engine Updater ================
2009-07-22 07:32:47.063 (3) [main]:
----------------ReportDownloadSearchEngineUserWorker starting
2009-07-22 07:32:47.307 (3) [main]: No licensing config file found,
assuming TSA production environment
2009-07-22 07:32:47.438 (3) [main]: Created shared sesystem connection rw
2009-07-22 07:32:48.373 (3) [P0T0]: DatabasePool with a limit of 80 created
2009-07-22 07:32:48.406 (3) [P0T0]: – Bulk downloads supported.
2009-07-22 07:32:48.464 (3) [P0T0]: – Begining search engine sync for
se user: (859) "Actuate Java"
2009-07-22 07:32:48.464 (3) [P0T0]: Google Sync – starting for seUser:
859 AcctID: 319
2009-07-22 07:32:48.472 (3) [P0T0]: validating report job...
2009-07-22 07:32:50.454 (3) [P0T0]: ...success
2009-07-22 07:32:51.412 (3) [P0T0]: Scheduled report. Report Job ID =
940997986
2009-07-22 07:33:08.714 (3) [P0T0]: Connected to URL
"https://adwords.google.com/api/adwords/ReportDownload?t=AAAAADgWfWIAAAEiouFGkgEAAAAAUR-M1lLgRdXAAR2tD7d
dRY3vZ0Pocbm_"
2009-07-22 07:33:11.287 (3) [P0T0]: validating report job...
2009-07-22 07:33:11.642 (3) [P0T0]: ...success
2009-07-22 07:33:12.070 (3) [P0T0]: Scheduled report. Report Job ID =
940998436
2009-07-22 07:33:45.260 (3) [P0T0]: Connected to URL
"https://adwords.google.com/api/adwords/ReportDownload?t=AAAAADgWfyQAAAEiouHVZwEAAAACNcpMjv_1lqMYl8n7Dga
LrqT74MjBPVwY"
2009-07-22 07:33:46.638 (3) [P0T0]: Downloaded to
/var/local/tsa/google_sync_files/tsa-creative-structure-report-319-859-2009-07-22
07:32:48.gz
2009-07-22 07:33:57.520 (3) [P0T0]: Writing temp infile...
2009-07-22 07:33:59.667 (3) [P0T0]: Writing temp infile...
2009-07-22 07:33:59.669 (3) [P0T0]: Columns already defined
2009-07-22 07:34:00.002 (3) [P0T0]: Loading data infile into temp table...
2009-07-22 07:34:00.973 (3) [P0T0]: Change Detected: SEUserID: 859 -
AcctID: 319 - Found seAccounts for 1st sync:
13781,13794,13802,13808,13811,13814,14457,
14459,14461,14462,14464,14466,14492,15787,
2009-07-22 07:34:00.974 (3) [P0T0]: number seaccounts for 1st sync: 14

It still could mean I am not seeing something obvious here, but it looks
like we are not handling the case where an seuser is not assigned to a
tsa account but campaigns are?

This is preventing a sync of two campaigns in production for Actuate
Java.