I have a similiar issue but my engine log reports 1 line as per:

<?xml version="1.0" encoding="UTF-8"?><debugLog></debugLog>

So not very helpful just yet.

This is my sql that runs fine in sqlplus and works fine when I don't use 'host' as the member_target_type and I get the failed to load xml error. Using 'host' target type works just find in sqlplus.

Code:

SELECT member_target_name, exadata_host, availability_status,

  SUM(NVL(duration, 0)) "Days"

FROM

  (

    SELECT a.member_target_name,

    a.member_target_type exadata_host,

    b.availability_status,

    round((SYSDATE - b.start_timestamp),10) duration

  FROM sysman.mgmt$target_flat_members a,

    sysman.mgmt$availability_current b

  WHERE a.member_target_name   =b.target_name

  AND a.member_target_type   ='host'

  AND a.aggregate_target_name IN (:para_exa_machine)

  union all

  SELECT a.member_target_name,

    a.member_target_type exadata_host,

    b.availability_status,

    round((NVL(b.end_timestamp, SYSDATE) - case when b.start_timestamp < :para_start_date

then to_date(:para_start_date)  <----------------------------- used to have an issue here until I added the to_date but now just won't work for 'host' target

else b.start_timestamp end),10) duration

  FROM sysman.mgmt$target_flat_members a,

    sysman.mgmt$availability_history b

  WHERE a.member_target_name=b.target_name

  AND a.member_target_type='host'

  AND a.aggregate_target_name in (:para_exa_machine)

  AND b.end_timestamp           > :para_start_date

  )

GROUP BY member_target_name, exadata_host, availability_status

This error appears in both Chrome and IE. I haven't tried in Firefox but the customer SOE browser is Chrome.

'Clear Object Cache' in BIP and that will solve the issue.

Here the steps.

1. Login to xmlpserver by using weblogic user.

2. Click on the Administration link

3. Manage BI Publisher

4. Manage Cache

5. Click on the 'Clear Object Cache'

Thanks,

Prasad Renati