May 6, 2019

Coldfusion 2018 error

IQ1 Follow

(0)

Comments

(2)

May 6, 2019

Coldfusion 2018 error

IQ1 Follow

(0)

(2)

Summary

ColdFusion 2018 error

Hello,

We are using coldfusion 2018 on a windows 2016 server. We are getting an error as shown below, please advice how to fix this ?

I have already checked and recompiled the database packages and all looks good with this.

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/MultiSectionReports.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/eOPS/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

ColdFusion