[ instantDocLogID : 6518884 ]
[ In CheckDocumentExistsWithOrder ]
[ Attempting to match recording information to a document with this order... ]
[ Document Year: 2008 ]
[ Instrument Number: 4365 ]
[ Book/Page: / ]

qryAllDocuments - query
RESULTSET
qryAllDocuments - query
  DOCUMENTBOOK DOCUMENTDATE DOCUMENTNUMBER DOCUMENTPAGE DOCYEAR ID IMAGEID OCRID
1 [empty string] 2020-05-20 00:00:00.0 921 [empty string] 2020 153033040 50147863 0
2 [empty string] 2019-08-02 00:00:00.0 3933 [empty string] 2019 152991319 49787766 0
3 [empty string] 2019-08-02 00:00:00.0 3932 [empty string] 2019 152991318 49787716 0
CACHED false
EXECUTIONTIME 5
SQL SELECT d.[id], d.documentNumber, d.documentBook, d.documentPage, d.imageID, d.documentDate, year(d.documentDate) AS docYear, ISNULL(x.ocrID, 0) AS ocrID FROM documents d WITH (NOLOCK) LEFT OUTER JOIN images..xref x WITH (NOLOCK) ON d.imageID = x.imageID WHERE d.orderPKID = ? AND ISNULL(d.imageID, 0) != 0 AND d.active = 1
SQLPARAMETERS
qryAllDocuments - array
1 14966714
Documents with same date - query
RESULTSET
Documents with same date - query
  DOCUMENTBOOK DOCUMENTDATE DOCUMENTNUMBER DOCUMENTPAGE DOCYEAR ID IMAGEID OCRID
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM qryDocuments WHERE CAST(documentDate AS DATE) = ?
SQLPARAMETERS
Documents with same date - array
1 2008-01-01
Documents with same year - query
RESULTSET
Documents with same year - query
  DOCUMENTBOOK DOCUMENTDATE DOCUMENTNUMBER DOCUMENTPAGE DOCYEAR ID IMAGEID OCRID
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM qryDocuments WHERE CAST(docYear AS VARCHAR) = ?
SQLPARAMETERS
Documents with same year - array
1 2008
[ Attempting to match the instrument number... ]
[ Unable to match to a document with the order! ]
[ In CheckIfDocumentExistsWithOrder ]
[ Attempting to match recording information to a document with this order with imageID is null or imageID is 0... ]
Documents with same date - query
RESULTSET
Documents with same date - query
  DOCUMENTBOOK DOCUMENTDATE DOCUMENTNUMBER DOCUMENTPAGE DOCYEAR ID IMAGEID
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM qryDocuments WHERE CAST(documentDate AS DATE) = ?
SQLPARAMETERS
Documents with same date - array
1 2008-01-01
Documents with same year - query
RESULTSET
Documents with same year - query
  DOCUMENTBOOK DOCUMENTDATE DOCUMENTNUMBER DOCUMENTPAGE DOCYEAR ID IMAGEID
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM qryDocuments WHERE CAST(docYear AS VARCHAR) = ?
SQLPARAMETERS
Documents with same year - array
1 2008
Attempting to match the instrument number...
OrderPkId:O
DocNumber:N
DocYear:Y
GIID:G
Book:B
Page:P
HyperLinked PDF:KH
doc Type:T
Doc Date:D
Request String:R
MAP:MAP
PdfHyperlinkLinkID:LL
Type:type
DocID:DocID
Misc:M
Username:U
Password:U
State:S
County:C
Company ID:CID
Ws RequestLogID:IID
ImageID:ImgID
MAP Type:MAP
MAP Apn:Apn
Subdivision:Subdiv
Legal:Legal
ShortLegal:ShortLegal
Tract:Tract
Section:Section
Township:Township
Range:Range
Block:Block
Lot:Lot
CustomerFileNo:CustomerFileNo
MapSubType:MapSubType
Ws RequestLogID:wsrlid
[ Calling new_ImageRequest.cfm ]
[ New ImageRequestV2: OrderPKID 14966714 - {ts '2024-05-19 00:21:37'} ]
[ Calling instantDocLogUpdater(6518884, 1, 14966714)... ...done!
[ isDefined("isSearchQ") : NO ]
url - struct
356535D488474EC8B843BB4383BE4D9E [empty string]
DEBUG false
IMAGEPROVIDERID 0
ORDERPKID 14966714
UNITTEST 0
UNITTESTING 0
displayOnly true
instantDocLogID 6518884
docID = 0
bInstantDoc = YES
imgReqRunTask =
qryDoc - query
RESULTSET
qryDoc - query
  DATAPROVIDERID GIID IMAGEID IMAGEPROVIDERID MISC ORDERPKID
CACHED false
EXECUTIONTIME 0
SQL SELECT orderPKID, imageProviderID, misc, GIID, ISNULL(imageID, 0) AS imageID, dataProviderID FROM documents WITH (NOLOCK) WHERE [id] = ? AND active = 1
SQLPARAMETERS
qryDoc - array
1 0
[ bInstantDoc : YES ]
[ docID : 0 ]
[ sOrder["id"] : 14966714 ]
imageProviderStruct - struct [Filtered - 5 of 23 keys hidden]
ACTIVE 1
CLIENTKEY [empty string]
COMPANYCODE 00036
COMPANYID 240
DATAPROVIDERID 35379
DEPTCODE 00067
DISPLAYNAME PropertyInsight (36-67)
ISOVERRIDEONLY 0
MISC [empty string]
PROVIDER propertyInsight
SOUNDEX 50
SOURCEDATAPROVIDERID 0
SYSTEMTYPE TitlePoint Image
TESTACCOUNT 0
TITLEOFFICER [empty string]
TYPE 2
URL https://www.titlepoint.com/TitlePointServices/TpsImage.asmx
concurrentDataProviders
imageProviderStruct - struct [empty]
[ Get Image for Doc From Chain ]
struct
PCOUNTY Clark
PDATE 01.01.2008
PDOCNUMBER 4365
PDOCYEAR 2008
PSTATE NV
[ We couldn't match our doc to a doc in the documents table, so let's just build qryAosngImageFiles out of the data passed in :
]
SELECT 'Clark' AS county, 'CL' AS countyAbv, '32' AS state_fips, '003' AS County_Fips, 47145 AS dataProviderID, '' AS DocumentBook, 'CL' AS DocumentCounty, '01.01.2008' AS DocumentDate, '01' AS DocumentDay, '01' AS DocumentMonth, '4365' AS DocumentNumber, '' AS DocumentPage, 'NV' AS DocumentState, '2008' AS DocumentYear, '' AS GIID, 0 AS id, 14966714 AS orderPKID, 'INSTANT DOC' AS ImageFiles, '03025475' AS OrderId, 'Chain' AS SourceType, '' AS DocumentType, '' AS RequestString, '' AS misc, '' AS derivedFromId, '35379' AS ImageProviderID, 0 AS ImageRequestIsComplete, 0 AS imageID [ Retrieving image via Instant doc ]
qryAosngImageFiles 2 - query
RESULTSET
qryAosngImageFiles 2 - query [Filtered - 0 of 27 columns hidden]
  COUNTY COUNTYABV COUNTY_FIPS DATAPROVIDERID DERIVEDFROMID DOCUMENTBOOK DOCUMENTCOUNTY DOCUMENTDATE DOCUMENTDAY DOCUMENTMONTH DOCUMENTNUMBER DOCUMENTPAGE DOCUMENTSTATE DOCUMENTTYPE DOCUMENTYEAR GIID ID IMAGEFILES IMAGEID IMAGEPROVIDERID IMAGEREQUESTISCOMPLETE MISC ORDERID ORDERPKID REQUESTSTRING SOURCETYPE STATE_FIPS
1 Clark CL 003 47145 [empty string] [empty string] CL 01.01.2008 01 01 4365 [empty string] NV [empty string] 2008 0 0 INSTANT DOC 0 35379 0 [empty string] 03025475 14966714 [empty string] Chain 32
CACHED false
EXECUTIONTIME 0
SQL SELECT ? AS county, ? AS countyAbv, ? AS state_fips, ? AS County_Fips, ? AS dataProviderID, ? AS DocumentBook, ? AS DocumentCounty, ? AS DocumentDate, ? AS DocumentDay, ? AS DocumentMonth, ? AS DocumentNumber, ? AS DocumentPage, ? AS DocumentState, ? AS DocumentYear, ? AS GIID, 0 AS id, ? AS orderPKID, 'INSTANT DOC' AS ImageFiles, ? AS OrderId, ? AS SourceType, '' AS DocumentType, ? AS RequestString, '' AS misc, '' AS derivedFromId, ? AS ImageProviderID, 0 AS ImageRequestIsComplete, 0 AS imageID
SQLPARAMETERS
qryAosngImageFiles 2 - array
1 Clark
2 CL
3 32
4 003
5 47145
6 [empty string]
7 CL
8 01.01.2008
9 01
10 01
11 4365
12 [empty string]
13 NV
14 2008
15 0
16 14966714
17 03025475
18 Chain
19 [empty string]
20 35379
in ip.Abstractor.cfm
ImagesDB Image Data (before logic) - struct
DocumentBook [empty string]
DocumentDate 01.01.2008
DocumentFIPS 32003
DocumentNumber 4365
DocumentPage [empty string]
DocumentType [empty string]
ImageProvider Abstractor
Images DB result - query
  FILENAME IMAGEID TABLENAME
out of ip.Abstractor.cfm
[ imageID : 0 ]
processManual: 0
in ip.Manual.cfm
ImagesDB Image Data (before logic) - struct
DocumentBook [empty string]
DocumentDate 01.01.2008
DocumentFIPS 32003
DocumentNumber 4365
DocumentPage [empty string]
DocumentType [empty string]
ImageProvider Manual Upload
Images Db result - query
  FILENAME IMAGEID TABLENAME
out of ip.Manual.cfm
[ imageID : 0 ]
1 : qryAosngImageFiles - query
CACHED false
EXECUTIONTIME 0
SQL SELECT ? AS county, ? AS countyAbv, ? AS state_fips, ? AS County_Fips, ? AS dataProviderID, ? AS DocumentBook, ? AS DocumentCounty, ? AS DocumentDate, ? AS DocumentDay, ? AS DocumentMonth, ? AS DocumentNumber, ? AS DocumentPage, ? AS DocumentState, ? AS DocumentYear, ? AS GIID, 0 AS id, ? AS orderPKID, 'INSTANT DOC' AS ImageFiles, ? AS OrderId, ? AS SourceType, '' AS DocumentType, ? AS RequestString, '' AS misc, '' AS derivedFromId, ? AS ImageProviderID, 0 AS ImageRequestIsComplete, 0 AS imageID
SQLPARAMETERS
1 : qryAosngImageFiles - array
1 Clark
2 CL
3 32
4 003
5 47145
6 [empty string]
7 CL
8 01.01.2008
9 01
10 01
11 4365
12 [empty string]
13 NV
14 2008
15 0
16 14966714
17 03025475
18 Chain
19 [empty string]
20 35379
[ qryAosngImageFiles.recordCount : 1 ]
[ imageID : 0 ]
[ in imgRequestDataProviderSelector() ]
local.allImageProviderStruct - struct
1
local.allImageProviderStruct - array
1 35379
2 47146
local.qryImgRequestLogAll - query
  BIGID DATAPROVIDERID DATEADDED DATEFINISHED IMAGEID IMGREQUESTLOGID MULTI OCRID ORDERPKID QUERYSTRING
local.usedDataProviderIDs :
[ dataProviderID : 35379 ]
imageProviderStruct - struct [Filtered - 4 of 23 keys hidden]
ACTIVE 1
CLIENTKEY [empty string]
COMPANYCODE 00036
COMPANYID 240
DATAPROVIDERID 35379
DEPTCODE 00067
DISPLAYNAME PropertyInsight (36-67)
HTTPUSERNAME [empty string]
ISOVERRIDEONLY 0
MISC [empty string]
PROVIDER propertyInsight
SOUNDEX 50
SOURCEDATAPROVIDERID 0
SYSTEMTYPE TitlePoint Image
TESTACCOUNT 0
TITLEOFFICER [empty string]
TYPE 2
URL https://www.titlepoint.com/TitlePointServices/TpsImage.asmx
concurrentDataProviders
imageProviderStruct - struct [empty]
[ isImageProviderDown : false ]
[ in imgRequestAddTask() ]
[ In sysWatchAddOrderTask() ]
local.qryRedirect - query
  SERVERNAME TASKNAME
[ Called edge/includes/getdocument/instantDocTop2.cfm?356535D488474EC8B843BB4383BE4D9E=&displayOnly=true&ORDERPKID=14966714&DEBUG=false&UNITTEST=0&IMAGEPROVIDERID=0&UNITTESTING=0&imgRequestLogID=50917380&instantDocLogID=6518884 via local.ws.SubmitJob() ]
[ Returning JobID 411651738 from sysWatchAddOrderTask() ]
[ Aborting task ]