May 6, 2019

Coldfusion error on a page

IQ1 Follow

(0)

Comments

(1)

May 6, 2019

Coldfusion error on a page

IQ1 Follow

(0)

(1)

Hello,

I am using ColdFusion 2018. I have successfully tested the application on a test server and everything works fine bujt when I move this to a new Windows 2016 server, I get an error as shown below. Can someone please advice how to fix this error ?

Thanks

Error Executing Database Query.

ORA-00936: missing expression ORA-06512: at “DBO.REPORT_PKG”, line 490 ORA-06512: at “DBO.REPORT_PKG”, line 48 ORA-06512: at “DBO.MULTI_REPORT_PKG”, line 31 ORA-06512: at line 1

The error occurred in C:/inetpub/wwwroot/eOPS/MultiSectionReportsResults.cfm: line 69

67 : 
68 : <cfquery name="PrepareMultiReportData" datasource="#datasource#" username="#Session.UserName#" password="#Session.password#">
69 :     BEGIN dbo.multi_report_pkg.run_multi_report(#Session.multi_rep_id#, '#Session.UserName#', #multi_report_def_id#, TO_DATE('#DateFormat(datefrom, "dd-mm-yyyy")# #TimeFormat(datefrom, "HH:mm:ss")#', 'DD-MM-YYYY HH24:MI:SS'), TO_DATE('#DateFormat(dateto, "dd-mm-yyyy")# #TimeFormat(dateto, "HH:mm:ss")#', 'DD-MM-YYYY HH24:MI:SS'), #period#); END;
70 : </cfquery>
71 :

SQLSTATE	42000
DATASOURCE	eops
VENDORERRORCODE	936
SQL	BEGIN dbo.multi_report_pkg.run_multi_report(12382, ‘fquresh2′, 10, TO_DATE(’06-05-2019 00:00:00’, ‘DD-MM-YYYY HH24:MI:SS’), TO_DATE(’06-05-2019 23:59:00′, ‘DD-MM-YYYY HH24:MI:SS’), 2); END;

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/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko
Remote Address	::1
Referrer	http://localhost/TOPS/Reports.cfm
Date/Time	06-May-19 10:35 AM

Stack Trace

at cfMultiSectionReportsResults2ecfm2027920610.runPage(C:/inetpub/wwwroot/TOPS/MultiSectionReportsResults.cfm:69) at cfMultiSectionReportsResults2ecfm2027920610.runPage(C:/inetpub/wwwroot/TOPS/MultiSectionReportsResults.cfm:69)

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
ORA-06512: at "DBO.REPORT_PKG", line 490
ORA-06512: at "DBO.REPORT_PKG", line 48
ORA-06512: at "DBO.MULTI_REPORT_PKG", line 31

cf2018 updates