KEPADA YANG SUDI SINGGAH

Kepada sape2 yg sudi singgah kat blog ni, kalau sudi tinggalkan lah jejak anda di chat box saya semoga saya senang untuk bertandang di blog kalian pula..boleh kita bertukar2 buah fikiran walaupun hakikatnya, blog ini kadang2 tak mendatangkan manfaat buat pembacanya..=)

Wednesday, July 1, 2009

:: M.A.R.A.H ::

Assalamualaikum..


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: "C"."STATUS_APPLICANT": invalid identifier
The error occurred in C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm: line 20
18 : select s.name,s.studentid,ca.semester,ca.code_college,ca.status, h.hc_desc
19 : from hep.college_applicant ca, uitm.student s, hep.hep_code h
20 : where s.studentid = '#session.user.studentid#'
21 : and s.studentid = ca.studentid
22 : and ca.studentid not in ('2007141703','2007141739','2007144763','2007106777','2006119311','2007210004',

SQL select s.name,s.studentid,ca.semester,ca.code_college,ca.status, h.hc_desc from hep.college_applicant ca, uitm.student s, hep.hep_code h where s.studentid = '2007114001' and s.studentid = ca.studentid and ca.studentid not in ('2007141703','2007141739','2007144763','2007106777','2006119311','2007210004', '2007141723','2006119295','2007106597','2007144419','2006148219','2007141739','2007106533','2008293452', '2007106629','2008293462','2007106647','2008523941','2007141721','2006119315','2008560327','2007138063', '2007106831','2008319945','2008791247','2008768143','2007129927','2006146817','2008293458','2008272526', '2006120045','2007138199','2008720605','2008272546','2008226132','2007243006','2008571881','2007132175', '2008226192','2007288624','2007257364','2008291176','2008557587','2006126219','2007141701','2007252548', '2008343881','2008272562','2006120015','2008272582','2008715213','2006146803','2007141697','2006141573', '2006119097','2006146957','2007210032','2006119313','2008229498','2008794177','2007106545','2007106585') and ca.status = 'P' and c.status_applicant='' and ca.status = h.hc_code and ca.semester = (select cur_code from hep.current_config where cur_indicator = 'C')
DATASOURCE conn_oracle_rac
VENDORERRORCODE 904
SQLSTATE 42S22
Resources:

Browser Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11
Remote Address 203.82.79.104
Referrer http://isisweb53.uitm.edu.my/heponlinev2/index_menu_left.cfm
Date/Time 01-Jul-09 11:41 AM
Stack Trace
at cf1_semak_kolej2ecfm217978359.runPage(C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm:20) at cf1_semak_kolej2ecfm217978359.runPage(C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm:20)

java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "C"."STATUS_APPLICANT": invalid identifier

at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:753)
at coldfusion.sql.Executive.executeQuery(Executive.java:675)
at coldfusion.sql.Executive.executeQuery(Executive.java:636)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cf1_semak_kolej2ecfm217978359.runPage(C:\WEBAPPHEP\1_HEP_ONLINE\COLLEGE_APPLICATION\1_semak_kolej.cfm:20)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Hmm..takde pape nak cerita sebenarnya, cuma marah sgt2..Dari kul 8.00pg tadi dok check result kolej..benda ni yg asyik keluar..aku mmg rase marah ni..kenapalah pihak berkuasa UiTM ni buat benda2 merepek cam ni..menyusahkan je aku rase..aaarrrggggghhhh..bengang aku cam ni..

ok..tu je aku nak bg tau..

jumpe lg nanti ek..

(^_^)

1 comment:

Shahida said...

rilex puan.. rilex..