Skip to Main Content
Forums

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Show Data throws "Object reference not set to an instance of an object."

TomekJun 29 2022

Just installed the VS Code and Oracle extensions. Created connection and I'm able to use Oracle Explorer to see the objects. I can also open the content of function, procedures, packages, etc. However, when I select a table and try to us the "Show Data..." I'm getting the "Object reference not set to an instance of an object." error.

BTW, I'm connecting to local instance of Oracle 19c using Basic connection type.

Comments

Uttam.Singh

Hey Ebin,

Yes Ago function works from Answers too. You need to ensure you have the Hierarchy Tree pulled in to answers to do this calculation and reference the "level" with right level of field.

In the example below the level would be "Time"."Time"."Year".

pastedImage_0.png

cesar.advincula.o

It depends on your business model, can you check the query behind

Ebin Cherian

Hi,

If I create a measure in the RPD for the formula COUNT(DISTINCT "Transaction Details"."Document Number") and use that column in the analysis, AGO works fine. But when I try to do count distinct in answers, it is not working and just displays the same value as shown in the above screenshot.

Uttam.Singh

Hey Ebin,

This seems to be a defect in 12c. I faced the same issue and Oracle Provided a workaround to fix this.

You can add one of the below in the Advance Tab --> Prefix

SET VARIABLE OBIS_REDUNDANT_DISTINCT_OPTIMIZATION = 'DISABLED' ;

OR

SET VARIABLE OBIS_REDUNDANT_DISTINCT_OPTIMIZATION = 'LEAF_ONLY'

pastedImage_0.png

Ebin Cherian

Hi,

My issue is not related to distinct. It is with using formula in AGO in report. I face the same issue even if I just use count instead of count distinct.

Just want to confirm if there is any restriction on measure that it should be defined in the RPD ?

Thanks

Ebin

Uttam.Singh

Check this SR 3-16820476571 I created for the Ago issue.

Bug 26642083 was reported in 12c version. I dont think you need to do anything specific in the RPD for Ago function to work.

1 person found this helpful
1 - 6

Post Details

Added on Jun 29 2022
#oracle-developer-tools-for-vs-code
4 comments
1,313 views
1 mention