アップデータ２を適用したら・・・・

現在Flex2勉強中。

当然、ColdFusionはMX7.0.2が必須になります。
flex2gatewayが使えるようになるから。

ところが・・・・

調子に乗って全部のサーバーにアップデータを適用したら、不具合がっ。

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

レポートコンパイルエラー :Error at (155, 20: null   The error occurred in D:\Inetpub\wwwroot\tipnx\cmvweb\CF\printable.cfm: line 99 97 : <cfreportparam name="SMCD" value="#url.SMCD#" /> 98 : <cfreportparam name="printtime" value="#dateformat(now(),'yyyy/mm/dd')#" /> 99 : <cfreportparam name="maxrow" value="#maxalart#" /> 100 : </cfreport> 101 : </html> Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem.   Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Remote Address   10.1.51.160 Referrer   Date/Time   14-12-06 08:40 午後 Stack Trace (click to expand) at cfprintable2ecfm488999781.runPage(D:\Inetpub\wwwroot\tipnx\cmvweb\CF\printable.cfm:99) coldfusion.runtime.report.Report$ReportCompilationException: レポートコンパイルエラー :Error at (155, 20: null at coldfusion.runtime.report.Report.compileXml(Report.java:580) at coldfusion.runtime.report.Report._compileReport(Report.java:181) at coldfusion.runtime.report.Report.compileReport(Report.java:124) at coldfusion.runtime.report.Report.runReport(Report.java:235) at coldfusion.tagext.lang.ReportTag.doEndTag(ReportTag.java:472) at cfprintable2ecfm488999781.runPage(D:\Inetpub\wwwroot\tipnx\cmvweb\CF\printable.cfm:99) 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.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) 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)

何やらレポートビルダーでコンパイルエラー発生。

どうやらHotFixで解決しそうなので、HotFixを適用。
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=kb400074

すると今度はOracleのストアドを呼んでいるところでORA- 発生

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

データベースクエリーを実行する際のエラーです。 ORA-06550: 行1、列19: PLS-00201: 識別子ASMCDを宣言してください。 ORA-06550: 行1、列7: PL/SQL: Statement ignored   The error occurred in D:\Inetpub\wwwroot\tipnx\cmvweb\CF\printable.cfm: line 24 22 : <cfprocparam type="in" cfsqltype="cf_sql_numeric" dbvarname="aPROCDISPID" value="21"> 23 : <cfprocparam type="in" cfsqltype="cf_sql_numeric" dbvarname="aREFERRERID" value="0"> 24 : <cfprocparam type="in" cfsqltype="cf_sql_longvarchar" dbvarname="aDATAVAL" value="#mydirectry.size# Byte Xml"><!---comment---> 25 : </cfstoredproc> 26 : SQL   {call INSERTLOGOP(aSMCD = (param 1) , aPROCDISPID = (param 2) , aREFERRERID = (param 3) , aDATAVAL = (param 4) )} DATASOURCE   tip VENDORERRORCODE   6550 SQLSTATE   65000 Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem.   Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Remote Address   10.1.51.160 Referrer   Date/Time   14-12-06 08:59 午後 Stack Trace (click to expand) at cfprintable2ecfm488999781.runPage(D:\Inetpub\wwwroot\tipnx\cmvweb\CF\printable.cfm:24) at cfprintable2ecfm488999781.runPage(D:\Inetpub\wwwroot\tipnx\cmvweb\CF\printable.cfm:24) java.sql.SQLException: ORA-06550: 行1、列19: PLS-00201: 識別子ASMCDを宣言してください。 ORA-06550: 行1、列7: PL/SQL: Statement ignored at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:87) at coldfusion.sql.Executive.executeCall(Executive.java:611) at coldfusion.sql.Executive.executeCall(Executive.java:542) at coldfusion.sql.Executive.executeCall(Executive.java:502) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:320) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:208) at cfprintable2ecfm488999781.runPage(D:\Inetpub\wwwroot\tipnx\cmvweb\CF\printable.cfm:24) 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.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) 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)

はまる予感・・・・（T_T)