Passing parameters causes a corrupt query

[arno_huerlimann56]

If I do open and refresh a web document, it works perfectly.
If I schedule the same document with the same parameters, I get the error "ORA-24373: statement handle not prepared".

jobserver_SVPRBOB01.AdaptiveJobServer_WebIJavaSchedulingService_CHILD0_trace.000001.glf:

"|8E950D31880A4C57B514DEB1807709C10|2025 01 16 10:04:05.424|+0100|Error| |>=|E| |jobserver_SVPRBOB01.AdaptiveJobServer_WebIJavaSchedulingService_CHILD0| 6380| 36|ORBacus:ThreadPerRequest:Dispatcher| |3348|0|4|0|BIlaunchpad.WebApp|SVPRBOB01:3260:21.979:1|CMS.runJobs|localhost:7128:1764.228810:1|.run|SVPRBOB01:6380:36.7:1|CihllA4vqEyXk8RzgwzDRjM367|||||||||com.businessobjects.rebean.wi.toolbox.impl.services.VisualizationConfigurationServiceImpl||input contained no data
|8E950D31880A4C57B514DEB1807709C11|2025 01 16 10:04:07.000|+0100|Error| |>>|E| |jobserver_SVPRBOB01.AdaptiveJobServer_WebIJavaSchedulingService_CHILD0| 6380| 36|ORBacus:ThreadPerRequest:Dispatcher| |3382|0|4|0|BIlaunchpad.WebApp|SVPRBOB01:3260:21.979:1|CMS.runJobs|localhost:7128:1764.228810:1|.run|SVPRBOB01:6380:36.7:1|CihllA4vqEyXk8RzgwzDRjM367|||||||||||Prompt mismatch for instance of Id:"1721500" and name:"3) Leistungserbringermerkmale (=> Daten für Grafik in Excel)". The prompts whose ID are "[(ZSR Nummern 1:,[DP0]), (ZSR Nummern 2:,[DP0]), (ZSR Nummern 3:,[DP0]), (ZSR Nummern 4:,[DP0]), (ZSR Nummern 5:,[DP0]), (ZSR Nummern 6:,[DP0]), (ZSR Nummern 7:,[DP0]), (ZSR Nummern 8:,[DP0]), (ZSR Nummern 9:,[DP0]), (ZSR Nummern 10:,[DP0]), (Leistungserbringerkanton(e):,[DP0]), (ZSR Nummer(n) Leistungsveranlasser:,[DP0]), (Kanton(e) Versicherter:,[DP0]), (Kostenart(en):,[DP0]), (Behandlungsbeginn von:,[DP0]), (Behandlungsbeginn bis:,[DP0]), (Behandlungsende von:,[DP0]), (Behandlungsende bis:,[DP0]), (Rechnungsdatum von:,[DP0]), (Rechnungsdatum bis:,[DP0]), (Abgerechnet von:,[DP0]), (Abgerechnet bis:,[DP0]), (ZSR des zu untersuchenden LERBS,[DP3])]" may have been changed since it can not be found in the list of document prompts.

Please re-create the schedule of the document to take into consideration its latest ID""

Of course i tried to do this, but with the same error


I suspect that the parameters are not being passed correctly and an invalid query is being created.
- If I copy the query from the web document and send it directly to the database, it works perfectly.
- Version: BO 4.3 Support Pack 3 Patch 3

Are there any ideas what I can do? The problem also affects reports that worked at an earlier point in time.

Best regards, Arno