A bip query is running very long time — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

A bip query is running very long time

in Reporting and Analytics for HCM 7 comments

Below query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was working fine but all of a sudden it has stopped working.

When tried running the whole query lower environment, the full query is running fine smoothly. Any suggestion how to approach with this issue? Not sure why it is not behaving consistent.:

SELECT

CORE_TIME_PRTN.TC_TM_REC_GRP_ID,
CORE_TIME_PRTN.TC_A_TS_APPROVED_TIMESTAMP,
TIME_ATRB_PRTN_2.ATTRIBUTE_VARCHAR_VALUE VAL2,
TIME_ATRB_PRTN_3.ATTRIBUTE_VARCHAR_VALUE VAL3,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!