[Pansophy] [Fwd: RE: NCR Issued: 783 on C100-CAV-INSP-WGD-R6--139]
georged at jlab.org
georged at jlab.org
Wed Oct 5 07:55:08 EDT 2011
Good morning,
I'm getting the "unexpected error" webpage when trying to view a NCR.
Aaron
---------------------------- Original Message ----------------------------
Subject: RE: NCR Issued: 783 on C100-CAV-INSP-WGD-R6--139
From: "Katherine Wilson" <kwilson at jlab.org>
Date: Tue, October 4, 2011 11:09 pm
To: GEORGED at jlab.org
"'Valerie Bookwalter'" <bookwalt at jlab.org>
--------------------------------------------------------------------------
Not sure what’s up, but this is the message I get when I try to access
this NCR:
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
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "WGDSN": invalid
identifier
The error occurred in
/group/asd/www/pansophy/html/production/R2010/pansophy/inventory/ManageInventory.cfc:
line 687
Called from
/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:
line 104
Called from
/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:
line 1
Called from
/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:
line 290
Called from
/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:
line 260
Called from
/group/asd/www/pansophy/html/production/R2010/pansophy/inventory/ManageInventory.cfc:
line 687
Called from
/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:
line 104
Called from
/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:
line 1
Called from
/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:
line 290
Called from
/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:
line 260
685 : PartName
686 : FROM #application.schema#.inv_Parts p
687 : WHERE p.VarType=#SNtype#
688 : </CFQUERY>
689 : </CFCATCH>
_____
VENDORERRORCODE
904
SQLSTATE
42S22
SQL
SELECT PartNumber, PartName FROM adapps.inv_Parts p WHERE p.VarType=WGDSN
DATASOURCE
Facility10G
Resources:
* Check the <http://www.adobe.com/go/prod_doc> ColdFusion documentation
to verify that you are using the correct syntax.
* Search the <http://www.adobe.com/go/prod_support/> Knowledge Base to
find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; WOW64; Trident/4.0;
.NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR
3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2)
Remote Address
129.57.49.214
Referrer
Date/Time
04-Oct-11 11:08 PM
<javascript:;> Stack Trace (click to expand)
at
cfManageInventory2ecfc1834573946$funcPARTSFORPANSOPHY.runFunction(/group/asd/www/pansophy/html/production/R2010/pansophy/inventory/ManageInventory.cfc:687)
at
cfC1002dCAV2dNCR2dR72dP12ecfm1355480249._factor7(/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:104)
at
cfC1002dCAV2dNCR2dR72dP12ecfm1355480249.runPage(/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:1)
at
cfTRAVELER_FORM2ecfm1312434491._factor8(/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:290)
at
cfTRAVELER_FORM2ecfm1312434491.runPage(/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:260)
at
cfManageInventory2ecfc1834573946$funcPARTSFORPANSOPHY.runFunction(/group/asd/www/pansophy/html/production/R2010/pansophy/inventory/ManageInventory.cfc:687)
at
cfC1002dCAV2dNCR2dR72dP12ecfm1355480249._factor7(/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:104)
at
cfC1002dCAV2dNCR2dR72dP12ecfm1355480249.runPage(/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:1)
at
cfTRAVELER_FORM2ecfm1312434491._factor8(/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:290)
at
cfTRAVELER_FORM2ecfm1312434491.runPage(/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:260)
java.sql.SQLSyntaxErrorException: [Macromedia][Oracle JDBC
Driver][Oracle]ORA-00904: "WGDSN": invalid identifier
at
macromedia.jdbc.oraclebase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown
Source)
at macromedia.jdbc.oraclebase.BaseExceptions40.createSQLException(Unknown
Source)
at macromedia.jdbc.oraclebase.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at macromedia.jdbc.oraclebase.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.oraclebase.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.oraclebase.BaseStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.java:1288)
at coldfusion.sql.Executive.executeQuery(Executive.java:1051)
at coldfusion.sql.Executive.executeQuery(Executive.java:982)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533)
at
cfManageInventory2ecfc1834573946$funcPARTSFORPANSOPHY.runFunction(/group/asd/www/pansophy/html/production/R2010/pansophy/inventory/ManageInventory.cfc:687)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301)
at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:375)
at
cfC1002dCAV2dNCR2dR72dP12ecfm1355480249._factor7(/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:104)
at
cfC1002dCAV2dNCR2dR72dP12ecfm1355480249.runPage(/group/asd/www/pansophy/html/travelers2010/cfmfiles/C100/C100-CAV-NCR-R7-P1.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
at
cfTRAVELER_FORM2ecfm1312434491._factor8(/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:290)
at
cfTRAVELER_FORM2ecfm1312434491.runPage(/group/asd/www/pansophy/html/production/R2010/pansophy/projects/insert/TRAVELER_FORM.cfm:260)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53)
at coldfusion.CfmServlet.service(CfmServlet.java:200)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
From: GEORGED at jlab.org [mailto:GEORGED at jlab.org]
Sent: Tuesday, October 04, 2011 11:49 AM
To: ABURRILL at JLAB.ORG; KWILSON at JLAB.ORG
Cc: GEORGED at JLAB.ORG; JOHNSONG at JLAB.ORG; MDICKEY at JLAB.ORG; BOOKWALT at JLAB.ORG
Subject: NCR Issued: 783 on C100-CAV-INSP-WGD-R6--139
You have been listed as an engineer of a Non-Conformance Report - sequence
number 783 for traveler C100-CAV-INSP-WGD-R6--139.
SN:
F063134/04
SNtype:
WGDSN
DRAWING NUM:
CRM1207070-0000
PART DESCRIPTION:
12GEV WAVEGUIDE ASSEMBLY
TRAV_ID:
C100-CAV-INSP-WGD
TRAV_REV:
R6
TRAV_SEQ_NUM:
139
DESCRIBE STAFF:
GEORGED
DESCRIBE DATE:
04-Oct-2011 11:47
DESCRIBE COMMENT:
Scratches on the small flange.
NOTIFICATION COMMENT:
The NCR is at the following URL: 783
<https://pansophy.jlab.org/pansophy/projects/insert/TRAVELER_FORM.cfm?project=CEBAF-Upgrade&area=C100&system=CAV&TRAV_ID=C100-CAV-NCR&TRAV_REVISION=R7&page=1&maxpage=4&TRAV_SEQ_NUM=783&travstat=&serialnum=>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman.jlab.org/pipermail/pansophy/attachments/20111005/7584396b/attachment-0001.html
More information about the Pansophy
mailing list