| Scope | | railo | | Struct | | release-date | | Date Time | {ts '2009-04-29 00:00:00'} |
| | version | | | versionName | | | state | | | versionNameExplanation | | string | http://en.wikipedia.org/wiki/Barry_(dog) |
|
| | java | | Struct | | version | | | totalMemory | | | maxMemory | | | freeMemory | | | vendor | | string | Sun Microsystems Inc. |
|
| | 49fad7ecf04102c2808eb425c14cf93f | | Struct | | DEBUGENTRIES | | Array | | 1 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 07:53:44'} |
| | IPADDRESS | | | CALLEDURL | | | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362265 | 1 | 32 | 32 | 32 | 32 | 0 | 0 | 32 | C:\Program Files\Railo\webapps\ROOT\index.cfm | | 2362266 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | name | time | sql | src | count | datasource |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | |
|
|
| | 2 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 08:14:27'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schTransactUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362675 | 1 | 1781 | 1781 | 1781 | 1781 | 0 | 0 | 1781 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 2362665 | 1 | 16 | 16 | 16 | 16 | 0 | 0 | 16 | C:\webRoot\Silverpop\schTransactUndeliverables.cfm | | 2362681 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2362673 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2362669 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2362674 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2362668 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (17317170, '/download/Master Suppression List - Undeliverables - Jan 29 2012 08-14-27 AM.CSV', 'tr')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2362665 | 1 | | 2362668 | 2 | | 2362669 | 3 | | 2362673 | 3 | | 2362669 | 4 | | 2362674 | 3 | | 2362675 | 2 | | 2362681 | 1 |
|
|
|
| | 3 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 08:14:27'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schChUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362663 | 1 | 1797 | 1797 | 1797 | 1797 | 0 | 0 | 1797 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 2362658 | 1 | 16 | 16 | 16 | 16 | 0 | 0 | 16 | C:\webRoot\Silverpop\schChUndeliverables.cfm | | 2362682 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2362661 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2362660 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2362662 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2362659 | 1 | 0 | 0 | 0 | 0 | 0 | 16 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 16 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (17317171, '/download/Master Suppression List - Undeliverables - Jan 29 2012 08-14-27 AM.CSV', 'ch')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2362658 | 1 | | 2362659 | 2 | | 2362660 | 3 | | 2362661 | 3 | | 2362660 | 4 | | 2362662 | 3 | | 2362663 | 2 | | 2362682 | 1 |
|
|
|
| | 4 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 08:15:43'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schProcessUndeliverableBatches.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362672 | 1 | 76969 | 76969 | 76969 | 76969 | 0 | 0 | 76969 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processUndeliverableBatches | | 2362664 | 1 | 62 | 62 | 62 | 62 | 0 | 0 | 62 | C:\webRoot\Silverpop\schProcessUndeliverableBatches.cfm | | 2362733 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2362670 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2362667 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2362671 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2362666 | 1 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 51 | | cached | No | | result | | name | time | sql | src | count | datasource | | qBatches | 0 |
SELECT batch_id,
list_id,
file_path,
list_type
FROM members_stale_flg_batches
WHERE status = 0
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 12 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 15 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 15 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 17316879
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 17316880
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2362664 | 1 | | 2362666 | 2 | | 2362667 | 3 | | 2362670 | 3 | | 2362667 | 4 | | 2362671 | 3 | | 2362672 | 2 | | 2362733 | 1 |
|
|
|
| | 5 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 08:16:46'} |
| | IPADDRESS | | | CALLEDURL | | | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362754 | 1 | 15 | 15 | 15 | 15 | 0 | 0 | 15 | C:\Program Files\Railo\webapps\ROOT\index.cfm | | 2362755 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | name | time | sql | src | count | datasource |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | |
|
|
| | 6 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 07:14:32'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schChUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2361603 | 1 | 2125 | 2125 | 2125 | 2125 | 0 | 0 | 2125 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 2361605 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2361601 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2361598 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\schChUndeliverables.cfm | | 2361600 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2361602 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2361599 | 1 | 0 | 0 | 0 | 0 | 0 | 15 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 15 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (17316720, '/download/Master Suppression List - Undeliverables - Jan 29 2012 07-14-31 AM.CSV', 'ch')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2361598 | 1 | | 2361599 | 2 | | 2361600 | 3 | | 2361601 | 3 | | 2361600 | 4 | | 2361602 | 3 | | 2361603 | 2 | | 2361605 | 1 |
|
|
|
| | 7 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 07:15:39'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schProcessUndeliverableBatches.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2361597 | 1 | 69219 | 69219 | 69219 | 69219 | 0 | 0 | 69219 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processUndeliverableBatches | | 2361592 | 1 | 78 | 78 | 78 | 78 | 0 | 0 | 78 | C:\webRoot\Silverpop\schProcessUndeliverableBatches.cfm | | 2361621 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2361595 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2361594 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2361596 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2361593 | 1 | 0 | 0 | 0 | 0 | 0 | 47 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 51 | | cached | No | | result | | name | time | sql | src | count | datasource | | qBatches | 16 |
SELECT batch_id,
list_id,
file_path,
list_type
FROM members_stale_flg_batches
WHERE status = 0
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 12 | hmcclub | | qUserId | 15 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 16 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 17316511
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 17316510
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2361592 | 1 | | 2361593 | 2 | | 2361594 | 3 | | 2361595 | 3 | | 2361594 | 4 | | 2361596 | 3 | | 2361597 | 2 | | 2361621 | 1 |
|
|
|
| | 8 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 07:37:47'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schChUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362009 | 1 | 2063 | 2063 | 2063 | 2063 | 0 | 0 | 2063 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 2362004 | 1 | 15 | 15 | 15 | 15 | 0 | 0 | 15 | C:\webRoot\Silverpop\schChUndeliverables.cfm | | 2362022 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2362007 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2362006 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2362008 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2362005 | 1 | 0 | 0 | 0 | 0 | 0 | 16 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 16 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (17316879, '/download/Master Suppression List - Undeliverables - Jan 29 2012 07-37-47 AM.CSV', 'ch')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2362004 | 1 | | 2362005 | 2 | | 2362006 | 3 | | 2362007 | 3 | | 2362006 | 4 | | 2362008 | 3 | | 2362009 | 2 | | 2362022 | 1 |
|
|
|
| | 9 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 07:37:47'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schTransactUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362016 | 1 | 2094 | 2094 | 2094 | 2094 | 0 | 0 | 2094 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 2362023 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2362014 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2362011 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\schTransactUndeliverables.cfm | | 2362013 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2362015 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2362012 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (17316880, '/download/Master Suppression List - Undeliverables - Jan 29 2012 07-37-47 AM.CSV', 'tr')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2362011 | 1 | | 2362012 | 2 | | 2362013 | 3 | | 2362014 | 3 | | 2362013 | 4 | | 2362015 | 3 | | 2362016 | 2 | | 2362023 | 1 |
|
|
|
| | 10 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2012-01-29 07:38:18'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schProcessUndeliverableBatches.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 7 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 2362021 | 1 | 32766 | 32766 | 32766 | 32766 | 0 | 0 | 32766 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processUndeliverableBatches | | 2362010 | 1 | 47 | 47 | 47 | 47 | 0 | 0 | 47 | C:\webRoot\Silverpop\schProcessUndeliverableBatches.cfm | | 2362034 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 2362019 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc | | 2362018 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc | | 2362020 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Mosaic.cfc$init | | 2362017 | 1 | 0 | 0 | 0 | 0 | 0 | 46 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 51 | | cached | No | | result | | name | time | sql | src | count | datasource | | qBatches | 16 |
SELECT batch_id,
list_id,
file_path,
list_type
FROM members_stale_flg_batches
WHERE status = 0
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 12 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 15 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 15 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 17316721
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 17316720
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 8 | | cached | No | | result | | id | level | | 2362010 | 1 | | 2362017 | 2 | | 2362018 | 3 | | 2362019 | 3 | | 2362018 | 4 | | 2362020 | 3 | | 2362021 | 2 | | 2362034 | 1 |
|
|
|
|
| | DEBUGENTRYCOUNT | |
| | os | | Struct | | version | | | name | | | buildnumber | | | arch | | | additionalinformation | |
| | coldfusion | | Struct | | appserver | | | serialnumber | | | rootdir | | | productname | | | productlevel | | | productcontextcount | | | installkit | | | productversion | | | expiration | | Date Time | {ts '2011-11-07 12:37:58'} |
| | supportedlocales | | string | japanese (japan),spanish (peru),english,ja_JP_JP,spanish (panama),serbian (bosnia and herzegovina),macedonian,spanish (guatemala),arabic (united arab emirates),norwegian (norway),albanian (albania),bulgarian,arabic (iraq),arabic (yemen),hungarian,portuguese (portugal),greek (cyprus),arabic (qatar),macedonian (macedonia),swedish,german (switzerland),english (united states),finnish (finland),icelandic,czech,english (malta),slovenian (slovenia),slovak (slovakia),italian,turkish (turkey),chinese,thai,arabic (saudi arabia),norwegian,english (united kingdom),serbian (serbia and montenegro),lithuanian,romanian,english (new zealand),no_NO_NY,lithuanian (lithuania),spanish (nicaragua),dutch,irish (ireland),french (belgium),spanish (spain),arabic (lebanon),korean,french (canada),estonian (estonia),arabic (kuwait),spanish (united states),spanish (mexico),arabic (sudan),indonesian (indonesia),russian,latvian,spanish (uruguay),latvian (latvia),hebrew,portuguese (brazil),arabic (syria),croatian,estonian,spanish (dominican republic),french (switzerland),hindi (india),spanish (venezuela),arabic (bahrain),english (philippines),arabic (tunisia),finnish,german (austria),spanish,dutch (netherlands),spanish (ecuador),chinese (taiwan),arabic (jordan),belarusian,icelandic (iceland),spanish (colombia),spanish (costa rica),spanish (chile),arabic (egypt),english (south africa),thai (thailand),greek (greece),italian (italy),catalan,hungarian (hungary),french,english (ireland),ukrainian (ukraine),polish (poland),french (luxembourg),dutch (belgium),english (india),catalan (spain),arabic (morocco),spanish (bolivia),english (australia),serbian,chinese (singapore),portuguese,ukrainian,spanish (el salvador),russian (russia),korean (south korea),vietnamese,arabic (algeria),vietnamese (vietnam),albanian,arabic (libya),arabic,chinese (china),belarusian (belarus),chinese (hong kong),japanese,hebrew (israel),bulgarian (bulgaria),indonesian,maltese (malta),spanish (paraguay),slovenian,french (france),czech (czech republic),italian (switzerland),romanian (romania),spanish (puerto rico),english (canada),german (germany),irish,german (luxembourg),german,spanish (argentina),slovak,malay (malaysia),croatian (croatia),english (singapore),danish,maltese,polish,arabic (oman),turkish,th_TH_TH,greek,malay,swedish (sweden),danish (denmark),spanish (honduras) |
|
| | separator | |
|