Skip to Content
0
Former Member
Jun 07, 2010 at 11:08 AM

Executing a stored procedure using custom BPC task

101 Views

Hi,

I have written a script logic. its is validated and saved to create the LGX file. When i test this logic from logic debugger, it is working fine. but, when i create a data manager package with Logic task, it is failing (runs infinitely). I have included the modifyscript variable to enable run time assignment. In the advanced tab of the data manager package in modify mode, i have specified the the following settings.

PROMPT(SELECTINPUT,%SELECTION%,,"Select the members to INSERT","ACCOUNT,CATEGORY,ENTITY")

TASK(lt,LogicMode,1)

TASK(lt,LogicFile,SP_TEST_BPC.LGX)

TASK(lt,RUNMODE,1)

'TASK(lt,Selection,%SELECTION%)

TASK(lt,FORMULASCRIPT,"*RUN_STORED_PROCEDURE=SP_TESTBPC('%ACCOUNT_SET%', '%CATEGORY_SET%','%ENTITY_SET%')")

.LGX contains

*RUN_STORED_PROCEDURE=SP_TESTBPC('%ACCOUNT_SET%','%CATEGORY_SET%','%ENTITY_SET%')

i used TASK(lt,LogicFile,SP_TEST_BPC.LGF) also and tried, this also fails.(runs infinitely)

Need help on this issue

Regards,

Vivek S