VERIFIED SOLUTION i
X

Error 'user lacks privilege or object not found' while executing a flow containing Query cache stage in Spectrum

Issue

com.g1.dcg.stage.StageException: user lacks privilege or object not found is observed while executing a flow containing query cache in Spectrum.

Cache Query User Permission
Wrapper log shows following entry:

ERROR [DataflowErrorLogger] Exception in SF_Transaction_ItemProcessing_Cache | Query Cache | Inspection mode INFO | jvm 1 | 2018/04/10 09:49:40 | com.g1.dcg.stage.StageException: user lacks privilege or object not found:

Cause

This could be caused due to incorrect formatting of input field in the 'Query Cache' stage.
 

Resolution

UPDATED: July 27, 2018


Syntax to have user a input field in the 'Query cache' stage is ${Input_Fields}. For example to have 'account_no' referred in 'Query cache', ${account_no} is used.


 

Environment Details

Product Feature: Dataflow Design / Implementation

 

Downloads

  • No Downloads