BusinessObjects Board

BO Auditor- Oracle activity unvierse

other Auditor
#1

Hi all,

I am trying to create a report using the objects given in the acitivity universe and i get the syntax error.Exception: DBD, ORA-00936: missing expression
State: N/A

can any one help me with this.

below is the sql
SELECT
WA_SESSION.SESSION_ID
FROM
( select
CONVERT(DETAIL.Detail_Text, CHAR) as SESSION_ID,
EVENT.User_Name as SESN_USER,
SERVER.Server_Name as SESN_HOST,
SERVER.Server_FullName as SESN_SERVER,
EVENT.Start_Timestamp as SESN_TIME,
min(EVENT.Start_Timestamp) as SESN_START,
max(EVENT.Start_Timestamp) as SESN_END,
TIME_TO_SEC(TIMEDIFF(MAX(EVENT.Start_Timestamp) , MIN(EVENT.Start_Timestamp))) as SESN_DURATION_SEC

from
AUDIT_DETAIL as DETAIL,
AUDIT_EVENT as EVENT,
SERVER_PROCESS as SERVER

where
(DETAIL.Server_CUID = EVENT.Server_CUID) and
(DETAIL.Event_ID = EVENT.Event_ID) and
DETAIL.Detail_Type_ID = 45 and SERVER.Server_CUID = EVENT.Server_CUID and SERVER.Application_Type_ID = 7

group by
CONVERT(DETAIL.Detail_Text, CHAR), EVENT.User_Name, SERVER.Server_Name, SERVER.Server_FullName) WA_SESSION

our audit database is set up in oracle and version we are using is BOXI 3

Thanks
Rekha

rekha (BOB member since 2008-06-08)

How can I use the Activity univers with Oracle data base?
#2

What version of Oracle are you using, I believe the CONVERT function has only been available from version 10G and above…?

Mak 1 :uk: (BOB member since 2005-01-06)

#3

I got the same error/issue after moving to BOE XI 3.1

Opened a SAP ticket, they gave me an Oracle 10G related universe and connection in a biar file, also gave me biar file with related audit folders, packages, reports = Crystal and WebI reports.

I’d upload a file, but it’s over the limit, so email me at
ben_atmore@mentor.com and I’ll pass it along…

ben
readme.txt (0.0 KB)

batmore (BOB member since 2005-05-16)

#4

I also run into this same issue, Missing Expression. I have narrowed it down to the CONVERT function… but we are on 10g. Our oracle environment still doesn’t like it.

CSGDrew :us: (BOB member since 2008-02-12)