A few folks having been hitting a problem recently, they 'build a report', try and run it and get:
Error: The report cannot be rendered because of an error, please contact the administrator.
Error Detail: Attribute missing in : 'url'
I have not been able to reproduce this, the iAdvise blog covers the error in an entry in their Hints and Tips
post back in July.
If you take a look at the .xdo file that is generated by the report builder a simple report looks likes this:
<?xml version = '1.0' encoding = 'utf-8'?>
<report xmlns="http://xmlns.oracle.com/oxp/xmlp" version="1.1" defaultDataSourceRef="Oracle BI EE">
<property name="showControls" value="true"/>
<property name="showReportLinks" value="true"/>
<property name="online" value="true"/>
<property name="parameterColumns" value="3"/>
<property name="openLinkInNewWindow" value="true"/>
<property name="autoRun" value="true"/>
<property name="cacheDocument" value="true"/>
<property name="useExcelProcessor" value="false"/>
<dataModel defaultDataSet="New DataSet 1">
<dataSet id="New DataSet 1">
<![CDATA[select EMPLOYEES.FIRST_NAME as FIRST_NAME,
EMPLOYEES.LAST_NAME as LAST_NAME,
EMPLOYEES.EMAIL as EMAIL,
EMPLOYEES.PHONE_NUMBER as PHONE_NUMBER,
EMPLOYEES.HIRE_DATE as HIRE_DATE,
EMPLOYEES.SALARY as SALARY
from HR.EMPLOYEES EMPLOYEES]]>
<templates default="New Template 2">
<template label="New Template 2" type="rtf" url="APXSOBLX.rtf"/>
Now the only reference to a 'url' attribute is in the 'template' element. I can only think that when you upload a template file, then create a template in the builder (we default in the template file) and you hit save without touching the template definition. That at certain times we do not write the template file name into the 'url' attribute and when the report is run it throws the error.
If you hit the problem, try going back into the definition and explicitly picking a template file and then saving.
As I mentioned its all working for me (of course :0) I tried 10.1.3.4 and 10.1.3.3.3 - if any of you can reproduce the problem consistently on a given release let us know.