One of our Attributes is Missing!

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">
<title>Test</title>
<properties>
<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"/>
</properties>
<dataModel defaultDataSet="New DataSet 1">
<dataSet id="New DataSet 1">
<sql dataSourceRef="demo">
<![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]]>
</sql>
</dataSet>
</dataModel>
<valueSets/>
<parameters/>
<templates default="New Template 2">
<template label="New Template 2" type="rtf" url="APXSOBLX.rtf"/>
</templates>
<burst enabled="false"/>
</report>
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.
Comments:

Could you elaborate a bit more? This might be late but I tried your suggestion and I still get the same error. Thanks. ><

Posted by Scott Martin on July 07, 2010 at 12:24 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today