Tech Trainings

Oracle BI Publisher Bursting Error – Control xml does not have KEY tag defined

June 15, 2023 by admin

Issue: 
::oracle.xdo.servlet.scheduler.ProcessingException: control file throws SAX parser exception::/u01/APPLTOP/instance/domains/fa.oracleoutsourcing.com/FADomain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/public/xdo_sched/718797/bip.bi_server1/t1/bipCVCPy0ctVm1213478483129404402.tmp::org.xml.sax.SAXException: Error happens when adding control property to map::localName = ROWControl xml does not have KEY tag defined. java.lang.Exception: Control xml does not have KEY tag defined.
Solution : 
Make Sure there is a column name : KEY   in the bursting control file query : 
SELECT  1 KEY,  ---bursting control file should have a column name KEY
       'sample template name'                      template,
       'en-US'                                                  locale,
       'excel'                                                    output_format,
       'EMAIL'                                                  del_channel,
       'output file name'                         output_name,
        'sample@email.com'                    parameter1,
       'no-reply@test.com'                                    parameter3,
       'email subject'   parameter4,
	   'sample email body' PARAMETER5,
		'true'           						PARAMETER6

FROM   DUAL


  

Comments |0|