The data action couldn't run because of a problem with the data action trigger error in SAC

[eodiase1]

Hello Everyone,

I have created advanced script & running it from data action, getting the following error. Please help if anything wrong in code/configuration.
"The data action couldn't run because of a problem with the data action trigger. Please check its configuration."

Below is the script:

CONFIG.TIME_HIERARCHY = FISCALYEAR

CONFIG.GENERATE_UNBOOKED_DATA = OFF

MEMBERSET [d/Measures] = ("AmountTC", "AmountLC")

MEMBERSET [d/Date] = BASEMEMBER([d/Date], %DateInput%)

MEMBERSET [d/DATASOURCE] = "DS_PP_ACTUAL_R" 

MEMBERSET [d/COSTCENTER] = BASEMEMBER([d/COSTCENTER], %CostCenterInput%)

MEMBERSET [d/ENTITY] = "1110"

MEMBERSET [d/ACCOUNT] = "65200005"

IF [d/WBS] != "#" THEN

DATA([d/COSTCENTER] = [d/WBS].[p/RESP_CC]) = RESULTLOOKUP()

ENDIF

No records were generated if I run in trace mode.

Thanks.

[William_Yu]

Any error message in data action monitor?

[zsuarez1]

Start small. Too many configurations going on. 

Remove Configuration at the top (ie. CONFIG). Run it for default members/hierarchies/etc. Fix the default date to run 1 month/day/lowest granularity at a time. Same with cost center, select one cost center. Not sure what cost center hierarchy you are running on because it makes a difference.  The default hierarchy will be used unless specified otherwise. 

Try to write 1 or 100 or 1000 to the cost center dimension whose work breakdown structure (wbs) attribute responsibility cost center actually exists.  After that, you can focus on the source value to pull and write to the destination.  

Hint: I have never run an open RESULTLOOKUP() on a go-live project.