Parallel Interaction

[jim wood]

Guys,

I have a problem, Even though I have parallel interaction enabled when I load data via a chore the service locks. As naybody worked with this and found some work arounds for this?

Also the same chore updates security. We have around 7000 groups and it takes some time to work and while this is happening users can't access the service at all. Has anybody foud a way of working around locking while security is updating?

I've got a funny feeling my last question will draw a blank. I'm going to work on optimising the processes that I have built to try eek out every little bit of performance that I can to speed things up,

Jim.

[ajain86]

Is the security update the first item in the chore, if so it will create a server lock when the process starts to when the entire chore finishes.

[jim wood]

Thanks. Interesting and as I was suspecting,

Jim.

[David Usherwood]

Once you've got rid of the security updates, have a look to see what cube dependencies are being triggered by your load. From my light testing, when a dependency is added a lock is applied.

[jim wood]

So a fcat load can still trigger a lock based on dependancies? Why they occur? Are they based on rules within the cube?

Cheers,

Jim.

[jim wood]

Based on the log it looks like it is adding the dependancies after the chore has finished. What impact will this have?

Code: Select all

660   [4]   INFO   2011-07-28 15:13:48.212   TM1.Chore   Chore fact data load executed by user IBIE-TM1\9999999
660   [4]   INFO   2011-07-28 15:13:48.212   TM1.Process   Process ibie_data_load_fact_ibie_gross_closed_pipeline_ytd executed by chore fact data load
660   [4]   ERROR   2011-07-28 15:14:13.727   TM1.Process   Process "ibie_data_load_fact_ibie_gross_closed_pipeline_ytd":  finished executing with errors. Error file: <TM1ProcessError_20110728151413_ibie_data_load_fact_ibie_gross_closed_pipeline_ytd.log>
660   [4]   INFO   2011-07-28 15:14:13.727   TM1.Process   Process ibie_data_load_fact_ibie_gross_open_pipeline executed by chore fact data load
660   [4]   ERROR   2011-07-28 15:17:41.723   TM1.Process   Process "ibie_data_load_fact_ibie_gross_open_pipeline":  finished executing with errors. Error file: <TM1ProcessError_20110728151741_ibie_data_load_fact_ibie_gross_open_pipeline.log>
660   [4]   INFO   2011-07-28 15:17:41.723   TM1.Process   Process ibie_data_load_fact_ibie_ts_measures executed by chore fact data load
660   [4]   ERROR   2011-07-28 15:21:25.453   TM1.Process   Process "ibie_data_load_fact_ibie_ts_measures":  finished executing with errors. Error file: <TM1ProcessError_20110728152121_ibie_data_load_fact_ibie_ts_measures.log>
660   [4]   INFO   2011-07-28 15:21:25.469   TM1.Process   Process ibie_data_load_fact_ibie_revenue executed by chore fact data load
660   [4]   ERROR   2011-07-28 15:22:50.312   TM1.Process   Process "ibie_data_load_fact_ibie_revenue":  finished executing with errors. Error file: <TM1ProcessError_20110728152247_ibie_data_load_fact_ibie_revenue.log>
660   [4]   INFO   2011-07-28 15:22:50.312   TM1.Process   Process ibie_data_load_fact_ibie_risk_mitigation_revenue executed by chore fact data load
660   [4]   ERROR   2011-07-28 15:25:30.777   TM1.Process   Process "ibie_data_load_fact_ibie_risk_mitigation_revenue":  finished executing with errors. Error file: <TM1ProcessError_20110728152530_ibie_data_load_fact_ibie_risk_mitigation_revenue.log>
660   [4]   INFO   2011-07-28 15:25:30.777   TM1.Process   Process ibie_data_load_fact_ibie_ref_revenue executed by chore fact data load
660   [4]   ERROR   2011-07-28 15:26:53.615   TM1.Process   Process "ibie_data_load_fact_ibie_ref_revenue":  finished executing with errors. Error file: <TM1ProcessError_20110728152652_ibie_data_load_fact_ibie_ref_revenue.log>
660   [4]   INFO   2011-07-28 15:26:53.615   TM1.Process   Process ibie_data_load_fact_ibie_client_properties executed by chore fact data load
660   [4]   ERROR   2011-07-28 15:27:03.974   TM1.Process   Process "ibie_data_load_fact_ibie_client_properties":  finished executing with errors. Error file: <TM1ProcessError_20110728152703_ibie_data_load_fact_ibie_client_properties.log>
660   [4]   INFO   2011-07-28 15:27:03.974   TM1.Chore   Chore fact data load finished executing
660   [4]   INFO   2011-07-28 15:32:19.599   TM1.Process   Process "ibie_dimension_break_consolidation_ibie_client" executed by user "IBIE-TM1\9999999"
660   [4]   ERROR   2011-07-28 15:33:07.410   TM1.Process   Process "ibie_dimension_break_consolidation_ibie_client":  finished executing with errors. Error file: <TM1ProcessError_20110728153249_ibie_dimension_break_consolidation_ibie_client.log>
3636   [2a]   INFO   2011-07-28 15:36:25.873   TM1.Comm.SSL   SSL read error. SSL Error: 5
756   [51]   INFO   2011-07-28 15:37:33.028   TM1.Cube.Dependency   Adding cube dependency: cube "ibie_workflow_status" depends on cube "ibie_client_product_group"
756   [51]   INFO   2011-07-28 15:37:33.122   TM1.Cube.Dependency   Adding cube dependency: cube "}ElementAttributes_ibie_client" depends on cube "ibie_workflow_status"
756   [51]   INFO   2011-07-28 15:37:33.497   TM1.Cube.Dependency   Adding cube dependency: cube "}ElementAttributes_ibie_client" depends on cube "ibie_role_mapping"
756   [51]   INFO   2011-07-28 15:37:34.856   TM1.Cube.Dependency   Adding cube dependency: cube "}ElementAttributes_ibie_client" depends on cube "}ElementAttributes_ibie_users"
292   [54]   INFO   2011-07-28 15:40:46.056   TM1.Cube.Dependency   Adding cube dependency: cube "ibie" depends on cube "ibie_client_lockdown"
292   [54]   INFO   2011-07-28 15:40:46.056   TM1.Cube.Dependency   Adding cube dependency: cube "ibie" depends on cube "ibie_product_param"
292   [54]   INFO   2011-07-28 15:40:46.056   TM1.Cube.Dependency   Adding cube dependency: cube "ibie_time_param" depends on cube "ibie_client_lockdown"
292   [54]   INFO   2011-07-28 15:40:46.056   TM1.Cube.Dependency   Adding cube dependency: cube "ibie" depends on cube "ibie_time_param"
292   [54]   INFO   2011-07-28 15:40:46.056   TM1.Cube.Dependency   Adding cube dependency: cube "ibie" depends on cube "ibie_calculation_param"

[ajain86]

when you ran the chore without the security update, was system still locked for the entire chore?

If so, you can also manually create cube dependencies which not create the locks.

[jim wood]

The fact load didn't cause any locking but I wasn't sure if the cube dependancy set after it finished would,

Jim.