May 6, 2019
Coldfusion 2018 error
Comments
(2)
May 6, 2019
Coldfusion 2018 error
Newbie 2 posts
Followers: 0 people
(2)

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

IQ

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:

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
2 Comments
2019-05-07 00:28:39
2019-05-07 00:28:39

This question was somehow repeated 3 times. I replied here only to see others replying to one of them. I will remove my reply here and post it there.

Can other responders seeing this also please keep replies directed at just that one:

https://coldfusion.adobe.com/discussion/2616736/

And I hope the poster, iq1, will delete all but that one to avoid further confusion.

Like
2019-05-06 20:16:05
2019-05-06 20:16:05

Let’s start with having you clarify what has changed–between when it last worked, and now, when it does not.

If you may say you applied a cf2018 update, do check out https://coldfusion.adobe.com/2019/03/problems-applying-cf-update-check-first/.

Also, as for the jdbc driver for oracle, is it the one that Adobe provides with CF, or one you implemented.

Finally, what cf2018 update are you on? 

Like
Add Comment