My Oracle Support Banner

E-PORTAL: Loading OBIEE Reports Throws Error "First operand of . is NULL, so cannot access member Len. (180,236) FUNCLIB_PTOBIEE.FUNCLIB.FieldFormula Name:PingOBIEE PCPC:13288 Statement:185 Called from:LOAD_REPORT.Activate Statement" in PT 8.56 OBIEE 12C (Doc ID 2587837.1)

Last updated on DECEMBER 03, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

Unable to load OBIEE reports in Peoplesoft


ERROR
-----------------------

First operand of . is NULL, so cannot access member Len. (180,236) FUNCLIB_PTOBIEE.FUNCLIB.FieldFormula Name:PingOBIEE PCPC:13288 Statement:185
Called from:LOAD_REPORT.Activate Statement:163

The first operand of the dot operator is the NULL value, indicating the lack of any object value. As a consequence, the given method or property cannot be used.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Setup OBIEE 12C (Tested on OBIEE 12.2.1.3) with Peoplesoft, Create the same user as exist in OBIEE, and Assigned Impersonate permission to the user in OBIEE.

2. Navigate to Peopletools > Portal > OBIEE Setup > OBIEE Server Setup. Configure the OBIEE servers. Update the configuration.Properties File with OBIEEServers=http://URL:PORT/analytics

3. Navigate to Peopletools > Portal > OBIEE Setup > Load Report Definitions

4. Error generated as "First operand of . is NULL, so cannot access member Len. (180,236)"

Tried capturing the OBIEE Server Session value and it was returning NULL. Attached Error Screenshot for reference

NOTE: There was no issue with 11g version of OBIEE

Changes

NA

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.