------------------------------------------------------------------------
PRIMeS
May 28, 2020 11:28:43 AM
------------------------------------------------------------------------

Receive Parts
------------------------------------------------------------------------

Error Occurred While Processing Request The web site you are accessing
has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for
debugging purposes.
Error Occurred While Processing Request


  The request has exceeded the allowable time limit Tag: cfoutput

 
The error occurred in
*/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc: line 259*

257 :         <cflog file="myapperrorlog" text="#arguments.exception.message#">
258 :         <cfsavecontent variable="errortext">
*259 : 		<cfoutput>*
260 :         An error occurred:  #session.username# <br>
261 :         http://#cgi.server_name##cgi.script_name#?#cgi.query_string# <br>

------------------------------------------------------------------------
Resources:

  * Check the ColdFusion documentation
    <http://www.adobe.com/go/prod_doc> to verify that you are using the
    correct syntax.
  * Search the Knowledge Base <http://www.adobe.com/go/prod_support/> to
    find a solution to your problem.

Browser   	Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101
Firefox/68.0
Remote Address   	129.57.77.66
Referrer   	https://pansophy.jlab.org/pansophy/PRIMeS/InvReceipt.cfm
Date/Time   	28-May-20 11:30 AM

Stack Trace
at
cfApplication2ecfc684580161$funcONERROR.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:259)


coldfusion.runtime.RequestTimedOutException: The request has exceeded the allowable time limit Tag: cfoutput
	at coldfusion.tagext.io.OutputTag.doStartTag(OutputTag.java:92)
	at cfApplication2ecfc684580161$funcONERROR.runFunction(/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc:259)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
	at coldfusion.runtime.AppEventInvoker.onError(AppEventInvoker.java:524)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:647)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)
	at coldfusion.CfmServlet.service(CfmServlet.java:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:844)

------------------------------------------------------------------------
*Debugging Information*
ColdFusion Server Enterprise 	2018,0,09,318650
Template 	/pansophy/PRIMeS/InvReceipt.cfm
Time Stamp 	28-May-20 11:30 AM
Locale 	English (US)
User Agent 	Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101
Firefox/68.0
Remote IP 	129.57.77.66
Host Name 	129.57.77.66

------------------------------------------------------------------------
*Execution Time*

*Total Time* 	*Avg Time* 	*Count* 	*Template*
127437 ms 	127437 ms 	1
/sgroup/asd/www/pansophy/html/production/P2020/PRIMeS/InvReceipt.cfm
127344 ms 	127344 ms 	1
/sgroup/asd/www/pansophy/html/production/P2020/PRIMeS/CFPrintLabels.cfm
30 ms 	30 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/InventoryActions.cfc
| ReceiveProcess(form = [complex value]) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/InventoryActions.cfc

17 ms 	17 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| fGetLocations(BuildingId = 6) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

11 ms 	11 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| fGetAllPONumbers() ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

10 ms 	10 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| Transaction(TransQty = 1, PartId = 1013, LocationId = 31, SerialNumber
= SN005, Spool_Length = , newStatusCodeId = 2, PartRev = A, CPNId = 18,
TransType = 1, POId = 369) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

6 ms 	6 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| fGetNextPK(myTableName = Inv_Transactions, myPrimaryKeyName =
TransactionID) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

5 ms 	5 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| Inventory(PartId = 1013, Action = newRecord, SerialNumber = SN005,
Spool_Length = , newLocationId = 31, newStatusCodeId = 2, PartRev = A,
CPNId = 18, newInventoryQty = 1, POId = 369) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

4 ms 	4 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| PostToPansophy(PartRev = A, DataTable = adapps.TRAVELER_CM_CAV, IdType
= L2PRD-1, PartName = WIDGET X, SerialNumber = SN005, PartNumber =
WIDGET) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

2 ms 	2 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc |
onRequestStart(/pansophy/PRIMeS/InvReceipt.cfm) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc
2 ms 	2 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/Admin/Checks.cfc
| CanUse(Zone = Inventory, Rule = Manager) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/Admin/Checks.cfc
1 ms 	1 ms 	1
/sgroup/asd/www/pansophy/html/production/P2020/MenuGenerator.cfm
1 ms 	1 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/Menu.cfc |
GetMenu(SelectedMenu = 0) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/Menu.cfc
1 ms 	1 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| fGetNextPK(myTableName = Inv_Inventory, myPrimaryKeyName =
InventoryId) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

0 ms 	0 ms 	1
/sgroup/asd/www/pansophy/html/production/P2020/Includes/login.cfm
0 ms 	0 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/Admin/Checks.cfc
| CanUse(Zone = Pansophy) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/Admin/Checks.cfc
0 ms 	0 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/Menu.cfc |
GetMenu(SelectedMenu = 6000) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/Menu.cfc
0 ms 	0 ms 	1 	CFC[
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
| instantiateRECV(partSN = SN005, partrev = A, cpName = L2PRD, vendor =
JLAB, partName = WIDGET X, partNum = WIDGET, varType = , poNumber =
TEST-PO) ] from
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc

/127461 ms/	  	/STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN/
/127463 ms/	  	/TOTAL EXECUTION TIME/

red = over 250 ms average execution time

------------------------------------------------------------------------
*Exceptions*

11:30:50.050 - Application Exception - in
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc : line 259

	    The request has exceeded the allowable time limit Tag: cfoutput
	    

------------------------------------------------------------------------
*SQL Queries*

|*qGetMenuTree* (Datasource=ACCESS, Time=0ms, Records=9, Cached Query)
in
/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/Menu.cfc @
11:28:43.043|

			SELECT		Level,
						DisplayName,
						regexp_replace(hlink, '#','',1,0) as hlink,
						Target,
						ItemId,
						ParentRef,
						AccessRights,
						DisplayOrder
			FROM		adapps.Menus
			WHERE		Obs is NULL
			
			AND			Level = 2	
						
			START WITH	ItemId = ?
			CONNECT BY PRIOR ItemId = ParentRef
			
			ORDER siblings BY DisplayOrder, ParentRef
		

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0
|
|*activities* (Datasource=ACCESS, Time=1ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Application.cfc @
11:28:43.043|

				  	insert into adapps.activities (mod_user, mod_date, page, query_string)
					values ('MDICKEY', sysdate, '/pansophy/PRIMeS/InvReceipt.cfm', '')
				  

|*qGetMenuTree* (Datasource=ACCESS, Time=0ms, Records=42, Cached Query)
in
/sgroup/asd/www/pansophy/html/production/P2020/Components/Global/Menu.cfc @
11:28:43.043|

			SELECT		Level,
						DisplayName,
						regexp_replace(hlink, '#','',1,0) as hlink,
						Target,
						ItemId,
						ParentRef,
						AccessRights,
						DisplayOrder
			FROM		adapps.Menus
			WHERE		Obs is NULL
						
			START WITH	ItemId = ?
			CONNECT BY PRIOR ItemId = ParentRef
			
			ORDER siblings BY DisplayOrder, ParentRef
		

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6000
|
|*GetOutsideUsers* (Datasource=ACCESS, Time=0ms, Records=0) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/Admin/Checks.cfc
@ 11:28:43.043|

					SELECT	username, project
					FROM 	adapps.outside_users
					WHERE 	Upper(username)='MDICKEY'
					AND 	project != 'CRYO'
					and 	OBS is NULL
				

|*GetCryoUsers* (Datasource=ACCESS, Time=0ms, Records=0) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/Admin/Checks.cfc
@ 11:28:43.043|

					SELECT	username, project
					FROM 	adapps.outside_users
					WHERE 	Upper(username)='MDICKEY'
					AND 	project='CRYO'
					and 	OBS is NULL
				

|*GetKeys* (Datasource=ACCESS, Time=0ms, Records=1, Cached Query) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/Admin/Checks.cfc
@ 11:28:43.043|

				SELECT	Max(KeyLevel) AS Value 
				FROM 	adapps.KeyView 
				WHERE 	Upper(KeyUserName) IN ('AUTHUSER','MDICKEY') 
				AND 	Upper(ZoneName)='INVENTORY' AND Upper(RuleName) IN ('MANAGER','0') AND Upper(KeyScope) IN ('0') 
				AND 	obs_date is NULL 
				AND 	7350 = 7350 

|*qGetLocations* (Datasource=FACILITY, Time=5ms, Records=409) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
@ 11:28:43.043|

			SELECT 	l.locationid, 
					locationname, 
					b.buildingid, 
					buildingname, 
					s.siteid, 
					sitename
			FROM 	adapps.inv_locations l,
					adapps.inv_buildings b,
					adapps.inv_sites s
			WHERE 	l.buildingid = b.buildingid
			AND 	l.obs IS NULL
			
			AND		b.buildingid=? 
			AND 	b.siteid = s.siteid
			AND 	s.obs IS NULL
			AND 	b.obs IS NULL
			AND 	l.obs IS NULL
			ORDER BY s.sitename, 
					b.buildingname,
					l.locationname
		

|Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6
|
|*qGetPurchaseOrders* (Datasource=FACILITY, Time=4ms, Records=355) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
@ 11:28:43.043|

			SELECT poid, ponumber 
			FROM adapps.inv_purchaseorders
			WHERE obs is NULL
			ORDER BY ponumber desc 
		

|*PartInfo* (Datasource=FACILITY, Time=2ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/InventoryActions.cfc
@ 11:28:43.043|

					SELECT 	PartNumber, 
							PartName,
							InitialStatus,
							StatusName,
							VarType
					FROM	adapps.inv_parts p,
							adapps.inv_Statuscodes sc
					WHERE	PartId=?
					and		statuscodeid = InitialStatus
				

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1013
|
|*LocationInfo* (Datasource=FACILITY, Time=1ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/InventoryActions.cfc
@ 11:28:43.043|

					SELECT 	LocationName
					FROM	adapps.inv_Locations
					WHERE	LocationId = ? 

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 31
|
|*POInfo* (Datasource=FACILITY, Time=1ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/InventoryActions.cfc
@ 11:28:43.043|

					SELECT 	PONumber
					FROM	adapps.inv_PurchaseOrders
					WHERE	POID = ? 

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 369
|
|*ProjectInfo* (Datasource=FACILITY, Time=1ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/InventoryActions.cfc
@ 11:28:43.043|

					SELECT 	CPName as projname
					FROM	adapps.inv_ProjectNames
					WHERE	CPNID = ? 

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18
|
|*CheckSN* (Datasource=FACILITY, Time=1ms, Records=0) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/InventoryActions.cfc
@ 11:28:43.043|

					SELECT 	PartNumber,
							SerialNumber
					FROM	adapps.inv_inventory i,
							adapps.inv_parts p
					WHERE	i.PartId = ?
					AND		i.PartId = p.PartId
					AND		SerialNumber = ? 

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1013
Parameter #2(CF_SQL_VARCHAR) = SN005
|
|*qGetNextRecord* (Datasource=FACILITY, Time=1ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
@ 11:28:43.043|

			SELECT NVL(MAX(InventoryId), 0) + 1 AS NextRecord
       	    FROM adapps.Inv_Inventory 

|*qPutInventory* (Datasource=FACILITY, Time=3ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
@ 11:28:43.043|

 
					INSERT INTO adapps.inv_inventory (
                        inventoryid, 
                        partid, 
                        serialnumber,
                        locationid, 
                        statuscodeid, 
                        inventoryqty
                        ,cpnid ,poid ,PartRev
                        )
					VALUES (
                       	18452, 
                        1013,
						UPPER('SN005'), 31,
						2,
                        1 ,18 ,369 ,UPPER('A')
                        )
				

|*qGetNextRecord* (Datasource=FACILITY, Time=6ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
@ 11:28:43.043|

			SELECT NVL(MAX(TransactionID), 0) + 1 AS NextRecord
       	    FROM adapps.Inv_Transactions 

|*qPutTransaction* (Datasource=FACILITY, Time=2ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
@ 11:28:43.043|

 
			INSERT INTO adapps.inv_transactions(
               	transactionid, 
                mod_date, 
                transtypesid, 
                mod_user, 
                transqty,
                poid, cpnid, 
                partid, 
                serialnumber, StatusCodeId, PartRev,
                locationid
               )
			VALUES (
               	?, 
                sysdate, 
                ?, 
                ?, 
                ?,
                ?, ?, ?, 
                ?, ?, ?, ?
                )
		

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 54965
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_varchar) = MDICKEY
Parameter #4(cf_sql_integer) = 1
Parameter #5(cf_sql_integer) = 369
Parameter #6(cf_sql_integer) = 18
Parameter #7(cf_sql_integer) = 1013
Parameter #8(cf_sql_varchar) = SN005
Parameter #9(cf_sql_integer) = 2
Parameter #10(cf_sql_varchar) = A
Parameter #11(cf_sql_integer) = 31
|
|*qPutToPansophy* (Datasource=TRAVELER, Time=3ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/Components/PRIMeS/ManageInventory.cfc
@ 11:28:43.043|

        		INSERT INTO adapps.TRAVELER_CM_CAV (
                    	ID_NAME, 
                    	ID_TYPE, 
                    	MOD_USER, 
                    	MOD_DATE,
						PART_NUMBER,
						PART_NAME,
						PARTREV
                    	)
           		VALUES (
						'SN005', 
                    	'L2PRD-1', 
                    	'PRIMeS', 
                        sysdate,
						'WIDGET',
						'WIDGET X',
						'A'
                    	)
        	

|*PONum* (Datasource=FACILITY, Time=7ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/PRIMeS/InvReceipt.cfm @
11:28:43.043|

					Select Distinct
							ponumber,
							vendorname
					from	adapps.inv_transactions t,
							adapps.inv_purchaseorders po,
							adapps.inv_vendors v
					where	t.poid = po.poid
					and		v.vendorid = po.vendorid
					and 	t.partid = ?  
						and 	UPPER(t.serialnumber) = ? 

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1013
Parameter #2(cf_sql_varchar) = SN005
|
|*getLabelDetails* (Datasource=FACILITY, Time=11ms, Records=1) in
/sgroup/asd/www/pansophy/html/production/P2020/PRIMeS/InvReceipt.cfm @
11:28:43.043|

					select	distinct
							max(transactionid) as tid, 
							partnumber, 
							partname, 
							i.serialnumber, 
							i.partrev,
							cpname as projname, 
							statusname,
							i.inventoryid as invid,
							vartype,
							pn.cpName
					from 	adapps.inv_inventory i, 
							adapps.inv_transactions t, 
							adapps.inv_parts p, 
							adapps.inv_projectnames pn,
							adapps.inv_statuscodes s
					where 	i.partid = p.partid (+)
					and 	i.cpnid = pn.cpnid (+)
					and 	i.statuscodeid = s.statuscodeid (+)
					and		t.partid = i.partid
					and		t.serialnumber = i.serialnumber
					and 	i.partid = ?
					and 	UPPER(i.serialnumber) = ?
					and 	i.locationid = ?
					group by partnumber, partname, i.serialnumber, i.partrev, cpname, statusname, i.inventoryid, vartype, pn.cpName
				

|Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1013
Parameter #2(cf_sql_varchar) = SN005
Parameter #3(cf_sql_integer) = 31
|

------------------------------------------------------------------------
*Scope Variables*

*Application Variables:*
accessdsn=ACCESS
applicationname=pansophydev
area=pansophy
border=0
calibrationdsn=FACILITY
doauthentication=yes
dsrc=TRAVELER
facilitydsn=FACILITY
keydsn=ACCESS
logbookdsn=FACILITY
pilotdsrc=FACILITY
querycachecode=7350
querycacheminutes=20
schema=adapps
server=pansophy.jlab.org
stx=SAMTRAXS
tblwidth=50%

*CGI Variables:*
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/sgroup/asd/www/pansophy/html/pansophy/PRIMeS/InvReceipt.cfm
CONTENT_LENGTH=1374
CONTENT_TYPE=application/x-www-form-urlencoded
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip, deflate, br
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=CFID=746; CFTOKEN=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695; CFGLOBALS=urltoken%3DCFID%23%3D746%26CFTOKEN%23%3Da701a643779dd791%2D8DB64DF5%2D96E7%2DB2DD%2D649A91718EAB0695%23lastvisit%3D%7Bts%20%272020%2D05%2D28%2011%3A28%3A14%27%7D%23hitcount%3D24625%23timecreated%3D%7Bts%20%272018%2D06%2D05%2007%3A05%3A00%27%7D%23cftoken%3Da701a643779dd791%2D8DB64DF5%2D96E7%2DB2DD%2D649A91718EAB0695%23cfid%3D746%23; CFCLIENT_PANSOPHY=""; __utma=105360600.983676423.1528721825.1579275090.1579799532.42; __utmz=105360600.1570208721.37.3.utmcsr=misportal.jlab.org|utmccn=(referral)|utmcmd=referral|utmcct=/portal/insight/frontPage; _ga=GA1.2.983676423.1528721825; BARCODE_PRINTER_NAME=tl2131z%2Ejlab%2Eorg; _gid=GA1.2.1192582821.1590491041; CFCLIENT_PANSOPHYDEV=""
HTTP_HOST=pansophy.jlab.org
HTTP_REFERER=https://pansophy.jlab.org/pansophy/PRIMeS/InvReceipt.cfm
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101 Firefox/68.0
LOCAL_ADDR=129.57.64.95
PATH_INFO=
PATH_TRANSLATED=/sgroup/asd/www/pansophy/html/pansophy/PRIMeS/InvReceipt.cfm
QUERY_STRING=
REMOTE_ADDR=129.57.77.66
REMOTE_HOST=129.57.77.66
REMOTE_USER=
REQUEST_METHOD=POST
SCRIPT_NAME=/pansophy/PRIMeS/InvReceipt.cfm
SERVER_NAME=pansophy.jlab.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_wsgi/3.4 Python/2.7.5 mod_jk/1.2.41
WEB_SERVER_API=

*Client Variables:*
cfid=746
cftoken=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695
hitcount=24625
lastvisit={ts '2020-05-28 11:28:14'}
timecreated={ts '2018-06-05 07:05:00'}
urltoken=CFID=746&CFTOKEN=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695

*Cookie Variables:*
BARCODE_PRINTER_NAME=tl2131z.jlab.org
CFCLIENT_PANSOPHY=
CFCLIENT_PANSOPHYDEV=
CFGLOBALS=urltoken=CFID#=746&CFTOKEN#=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695#lastvisit={ts '2020-05-28 11:28:14'}#hitcount=24625#timecreated={ts '2018-06-05 07:05:00'}#cftoken=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695#cfid=746#
CFID=746
CFTOKEN=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695
__utma=105360600.983676423.1528721825.1579275090.1579799532.42
__utmz=105360600.1570208721.37.3.utmcsr
_ga=GA1.2.983676423.1528721825
_gid=GA1.2.1192582821.1590491041

*Form Fields:*
ACTION=submit
BUILDID=#form.buildingid#
BUILDINGID=6
CPNAME=L2PRD
CPNID=18
FIELDNAMES=ACTION,NUMOFPARTS,PREVNUMOFPARTS,TOTALNUMBEROFPARTS,NUMBEROFLOCATIONS,POFOUND,PARTSFOUND,SMYSTRUCT,SMYARRAY,BUILDID,BUILDINGID,PONUMB,POID,PONUMBER,OWNER,VENDOR,PROJECT,ORG,CPNID,CPNAME,INITIALSTATUS_1,VARTYPE_1,PARTID_1,QTY_1,LOCATIONID_1,SERIALNUMBER_1,PARTREV_1,SPOOL_LENGTH_1,INITIALSTATUS_2,VARTYPE_2,PARTID_2,QTY_2,LOCATIONID_2,SERIALNUMBER_2,PARTREV_2,SPOOL_LENGTH_2,INITIALSTATUS_3,VARTYPE_3,PARTID_3,QTY_3,LOCATIONID_3,SERIALNUMBER_3,PARTREV_3,SPOOL_LENGTH_3,INITIALSTATUS_4,VARTYPE_4,PARTID_4,QTY_4,LOCATIONID_4,SERIALNUMBER_4,PARTREV_4,SPOOL_LENGTH_4,INITIALSTATUS_5,VARTYPE_5,PARTID_5,QTY_5,LOCATIONID_5,SERIALNUMBER_5,PARTREV_5,SPOOL_LENGTH_5,INITIALSTATUS_6,VARTYPE_6,PARTID_6,QTY_6,LOCATIONID_6,SERIALNUMBER_6,PARTREV_6,SPOOL_LENGTH_6,INITIALSTATUS_7,VARTYPE_7,PARTID_7,QTY_7,LOCATIONID_7,SERIALNUMBER_7,PARTREV_7,SPOOL_LENGTH_7,INITIALSTATUS_8,VARTYPE_8,PARTID_8,QTY_8,LOCATIONID_8,SERIALNUMBER_8,PARTREV_8,SPOOL_LENGTH_8,INITIALSTATUS_9,VARTYPE_9,PARTID_9,QTY_9,LOCATIONID_9,SERIALNUMBER_9,PARTREV_9,SPOOL_LENGTH_9,INITIALSTATUS_10,VARTYPE_10,PARTID_10,QTY_10,LOCATIONID_10,SERIALNUMBER_10,PARTREV_10,SPOOL_LENGTH_10
INITIALSTATUS_1=0
INITIALSTATUS_10=0
INITIALSTATUS_2=0
INITIALSTATUS_3=0
INITIALSTATUS_4=0
INITIALSTATUS_5=0
INITIALSTATUS_6=0
INITIALSTATUS_7=0
INITIALSTATUS_8=0
INITIALSTATUS_9=0
LOCATIONID_1=31
LOCATIONID_10=0
LOCATIONID_2=0
LOCATIONID_3=0
LOCATIONID_4=0
LOCATIONID_5=0
LOCATIONID_6=0
LOCATIONID_7=0
LOCATIONID_8=0
LOCATIONID_9=0
NUMBEROFLOCATIONS=409
NUMOFPARTS=10
ORG=LCLS2
OWNER=
PARTID_1=1013,2,-1
PARTID_10=0
PARTID_2=0
PARTID_3=0
PARTID_4=0
PARTID_5=0
PARTID_6=0
PARTID_7=0
PARTID_8=0
PARTID_9=0
PARTREV_1=A
PARTREV_10=0
PARTREV_2=0
PARTREV_3=0
PARTREV_4=0
PARTREV_5=0
PARTREV_6=0
PARTREV_7=0
PARTREV_8=0
PARTREV_9=0
PARTSFOUND=1
POFOUND=1
POID=369
PONUMB=TEST-PO
PONUMBER=TEST-PO
PREVNUMOFPARTS=0
PROJECT=LCLS2
QTY_1=1
QTY_10=0
QTY_2=0
QTY_3=0
QTY_4=0
QTY_5=0
QTY_6=0
QTY_7=0
QTY_8=0
QTY_9=0
SERIALNUMBER_1=SN005
SERIALNUMBER_10=
SERIALNUMBER_2=
SERIALNUMBER_3=
SERIALNUMBER_4=
SERIALNUMBER_5=
SERIALNUMBER_6=
SERIALNUMBER_7=
SERIALNUMBER_8=
SERIALNUMBER_9=
SMYARRAY=0
SMYSTRUCT=0
SPOOL_LENGTH_1=
SPOOL_LENGTH_10=
SPOOL_LENGTH_2=
SPOOL_LENGTH_3=
SPOOL_LENGTH_4=
SPOOL_LENGTH_5=
SPOOL_LENGTH_6=
SPOOL_LENGTH_7=
SPOOL_LENGTH_8=
SPOOL_LENGTH_9=
TOTALNUMBEROFPARTS=1
VARTYPE_1=
VARTYPE_10=
VARTYPE_2=
VARTYPE_3=
VARTYPE_4=
VARTYPE_5=
VARTYPE_6=
VARTYPE_7=
VARTYPE_8=
VARTYPE_9=
VENDOR=

*Request Parameters:*
samesite_value=

*Server Variables:*
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

*Session Variables:*
area=C75
cfid=746
cftoken=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695
facilitydsn=FACILITY
logintime={ts '2020-05-28 07:14:58'}
menugroup=1000
project=C75
schema=adapps
sessionid=PANSOPHYDEV_746_a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695
system=
urltoken=CFID=746&CFTOKEN=a701a643779dd791-8DB64DF5-96E7-B2DD-649A91718EAB0695
username=MDICKEY

*URL Parameters:*
area=C75
project=C75
system=
title=PRIMeS

/Debug Rendering Time: 7 ms/