ORA-24373 Invalied Length error while REFRESHING METRIC

other Performance Management
1

We have BOXI R2 on Windows. We have MHF1. I have a very straight and simple universe with only one table (and it’s NOT a derived table or a view).

I have 2 measure objects with the where clause for creating metrics. I have copied the where clause and also made sure that the syntax is fine.
Anyways here is the where clause if someone would like to take a look.

(ASHAH.TAGG.AGGDATE between @Prompt('BEGIN_DATE','D',,mono,free) AND
@Prompt('END_DATE','D',,mono,free))

I imported the universe and created a metric, until then everything worked fine. But when I try to refresh my metric I get this error

.
Please look at the attached screenshot.

I even checked the CI_PROBE table and the table does not have any details on this metric refresh. I don’t think the query is even going to the database. I tried creating my own calendar instead of using the default BO daily calendear and that does not work either.

I looked at all the metric related posts on the forum, but could not find any that has the same issue as I do. I will appreciate your reply.

Thank you.
Untitled2.gif

bits06 :us: (BOB member since 2006-04-21)

2

i have the same error while refresh the metric in Dashboard manager. for me the error is

Error: Cannot create query on fact tables for probe
Sum of Despatch : ORA-00936: missing expression

if some one comes across this error send reply

Thanks in Advance

karuppiah :india: (BOB member since 2007-04-10)

3

i have the same error while refresh the metric in Dashboard manager. for me the error is

Error: Cannot create query on fact tables for probe
Sum of Despatch : ORA-00936: missing expression

if some one comes across this error send reply

Thanks in Advance

karuppiah :india: (BOB member since 2007-04-10)

4

Hi,

I am facing the similar issue. Did you find any solution? If yes, Could you please post it over here?

And the error for me is : 0RA-24373 invalid length specified.

Thank you,
Regards,

GowthamSen :india: (BOB member since 2006-08-31)

5

The length specified for the statement is either 0 or too large.

Action: Specify a valid length for the statement.

you try to prepare or execute an empty string, or a
statement longer then oracle can parse.

if it is a date function try to use to_date function

Please check below links as well
http://www.boguru.com/ora-24373-business-objects-cause/

krishnak :india: (BOB member since 2008-06-27)

6

Thank you Kris.

The queries are running fine in Oracle withoug any changes.

Now I saw that, the error is coming for the metrics which were working previously.

I verified the two posts. Both are related to Scheduling. So the solutions provided are not helped in this scenario.

Any other ideas?

GowthamSen :india: (BOB member since 2006-08-31)

7

Check ci_probe for the affected metrics. It’s likely that the executable_sql is blank, which is what’s causing the error you see.

If this is the case, turn on all tracing, then re-import the universe in AF. Check the logs for errors.

Joe

joepeters :us: (BOB member since 2002-08-29)

8

Hi Joe,

Could you please let me know, how to check ci_probe?

GowthamSen :india: (BOB member since 2006-08-31)

9

PM is the most half-baked enterprise application I’ve ever used, since an in-depth knowledge of the inner workings of the application stack is a prerequisite to debugging even simple problems like this.

That said, ci_probe is one of the PM repository tables. You can query it directly with SQL, or use one of the pre-built Metrics universes.

Within that table, probe_name and probe_code can be used to find the metric in question. Once you identify the row, check the executable_sql column. This is supposed to hold the actual SQL that is used to refresh the metric.

joepeters :us: (BOB member since 2002-08-29)

10

Hi Joe,

I verified it. You are correct. The metrics are not holding the SQL. Its showing as blank.

I tried to Update the universe in metrics. But its not effecting.

Is there anything which I am missing here?

GowthamSen :india: (BOB member since 2006-08-31)

11

You’ll need to turn on tracing and then import the universe again. Then check the logs.

joepeters :us: (BOB member since 2002-08-29)

12

Hi,

I found the problem.
When I set the Owner name in Metrics Parameters as “Administrator”, the metrics are refreshing.

I guess its the problem with priveleges.

Thanks a lot joe for your help.

GowthamSen :india: (BOB member since 2006-08-31)