a database. For each entry in the log file, the script must make two very
simple select query calls to one data source, and then insert all of the
data into a second data source. The first couple of log files were parsed
just fine ... they averaged about 500 entries. The file I am working with
now is much longer and the script is bailing out every time somewhere around
entry number 725 ( +/- 50 ). Each time, it quits on a different record, so
there is not one record that is causing the issue, but it always quits in
the same general area.
The CF error message is stating that 'The Request has exceeded the allowable
time limit Tag: CFQUERY'. The query is a very simple select query ....
SELECT OBJECTID
FROM PTUSERS
WHERE NAME = <cfqueryparam cfsqltype="cf_sql_varchar" maxlength="255"
value="#auditEntry.name#">
This query has already run 700+ times (once for each log entry), but
somewhere in the low 700s, it quits.
Any suggestions as to what might be going on?
Thanks
-- Jeff
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
