Error Codes: ACIOA5LN

Barbara Ba

Hi everyone,

maybe someone could help me.

When I am applying a CAST function (converting a number into character) for one column, then I got this Error message :

Assertion failure: pLhs != 0 && pRhs != 0 at line 108 of inc/nq/webtable/promoter.h

  Error DetailsError Codes: ACIOA5LN

Does someone knows why it does not work?

Mallikarjuna Kuppauru-Oracle

Hi @Barbara Ba

We got the same issue from one of the customer but not for 12c its for OAS version.

Bug 32147192 : OAS 5.5: RUNNING DASHBOARD RENDERS ERROR : ASSERTION FAILURE: PLHS != 0 && PRHS != 0

Assertion failure Plhs!=0 && pRhs!=0 at line 108 of inc/nq/webtable/promoter.h

Error code: ACIOA5LN

Cause: We have found that the issue is with the combination of prompt and conditional formatting.

Are you using any conditional formatting /prompts,if yes can you remove the try and check?

Regards

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @Barbara Ba

Good to see your update as its worked. Can you mark its as Answered so that other community members will refer the same.

Regards,

Arjun

Sumanth V -Oracle

@User_534UY - Please share the version of OBIEE/OAS application you are using. I tried in the latest version of OAS and it's working as expected. Please find the screen shot below showing the query I've used. Thanks.

Barbara Ba

Sumanth V -Oracle Thanks for the quick answer!

I am still getting the same error using the query you have used.

I am using OBIEE 12.2.1.4.0 version.

Here is the Query which I am using to Edit Formula:

CASE

WHEN
CAST ("Project"."Duration until MNR Start" AS CHAR) IS NULL THEN 'NS'
ELSE
CAST("Project"."Duration until MNR Start" AS CHAR)

END

Sumanth V -Oracle

Tried using case statement and still validation works fine.

Kindly share the screen shot showing where exactly you get the error to validate once. Thanks.

Barbara Ba

I get an error when I am going to the Results.

By writing a SQL Statement I don't get an error.

Federico Venturin

Hi @User_534UY ,

I would replace the expression as follows:

CASE WHEN IFNULL("Project"."Duration until MNR Start", -999) = -999 THEN 'NS' ELSE CAST("Project"."Duration until MNR Start" as CHAR) END

Please let me know if it helps ;)

Barbara Ba

Hi Federico Venturin,

thank you for your answer.

Unfortunately I get the same error :(

Federico Venturin

Hi @Barbara Ba ,

I had the same error code (but with a different description years ago) and it turned out to be related to NULL values in the physical column.

Does the same expression work if you apply to a column that does not contain any NULL value?

I also suggest you to raise a SR. When .h and .cpp files are referenced in the error description this is usually the best way to get a solution.

Barbara Ba

Hi Federico Venturin,

thank you.

Yes I get the same error when I apply to a column that does not contain any NULL value.

I will try then with SR.

Mallikarjuna Kuppauru-Oracle

Hi @Barbara Ba

As per previous updates, issue not related to your case statement , issue seems to be an rendering issue while processing your report data.

Are you using any presentation variable using decimal format if yes change to number and then try again?

Regards,

Arjun

Barbara Ba

Hi Mallikarjuna Kuppauru-Oracle,

thank you for your response.

No, i am not using any Presentation Variable, only Repository Variable.