cancel
Showing results for 
Search instead for 
Did you mean: 

Issues with Parse

Former Member
0 Kudos

I have a condition with following syntax. When i parse, it say

Parse failed: Exception: DBD, ORA-00933: SQL command not properly ended State: N/A

@Select(Hotel Contact\Hotel Contact Fax Primary Ind Y/N) () = 'Y' and @Select(Hotel Contact\Hotel Contact Fax Type Code) () = 'PFAX'.

There is any mistake in the prompt.

object defination is

Hotel Contact Fax Primary Ind Y/N ---object name with following defination.

"htl_cont_INDVL_fax_alias".PRIM_IND

and

Hotel Contact Fax Type Code--object defination

"htl_cont_INDVL_fax_alias".PHONE_TYP_CD

I have tried option by changing ANSI also. Does not help.

help me please

Accepted Solutions (1)

Accepted Solutions (1)

MariannevL
Advisor
Advisor
0 Kudos

Just a few thoughts to share;

The is there because you don't want to inner an outer join?

If the join is defined as outer you can also use the syntax

(@Select(Hotel Contact\Hotel Contact Fax Primary Ind Y/N) = 'Y' or

@Select(Hotel Contact\Hotel Contact Fax Primary Ind Y/N) IS NULL)

and (@Select(Hotel Contact\Hotel Contact Fax Type Code) = 'PFAX'

or @Select(Hotel Contact\Hotel Contact Fax Type Code) IS NULL)

This will work in ANSI, whereas the will not, that is typical Oracle syntax.

Another thing check that the table is associated with the condition.

if it isn't associated, the full query will only work if you select some other object that is associated with the table,

or the table will not be put in the from clause.

Please not that this condition is not really a restriction,

since you will allow records without a Hotel Contact record associated too.

If you are actually trying to limit the hotel contacts to the primary fax contact.

I would create an alias on this table with a self join, or a derived table.

outer join it and use an object from that table if I wanted the the primary fax contact information.

Hope this helps,

Marianne

Answers (2)

Answers (2)

Former Member
0 Kudos

Make sure there's no space between the column name or object name and the (+).

I saw another developer with this problem where I worked and when he deleted the space right before the it worked.

Former Member
0 Kudos

In fact,

this is universe level prompt

0 Kudos

Are you sure this is a prompt? I miss the @prompt keyword.

Did you try to use this in one of your reports? DO you get an error there?

Regards,

Stratos

Former Member
0 Kudos

I am sorry,

It is a condition defined at universe in the where clause. It does not parse.

I have to use this conditon at webi report.

0 Kudos

Do you get the same error when you add the condition in your WebI report and try to refresh?

I assume that you are using Oracle as data source. Correct?

Regards,

STratos

Former Member
0 Kudos

When i run webi report.

I get error like this:

Database error-ORA 22905 Cannot access rows from Non nested table items. Contact BO admin or data base supler....

Error WIS 10901

I am using oracle database and BOXIR2 Sp5