Page 1 of 1
Parallel Interaction
Posted: Thu Jul 28, 2011 1:03 pm
by 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.
Re: Parallel Interaction
Posted: Thu Jul 28, 2011 1:35 pm
by 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.
Re: Parallel Interaction
Posted: Thu Jul 28, 2011 1:45 pm
by jim wood
Thanks. Interesting and as I was suspecting,
Jim.
Re: Parallel Interaction
Posted: Thu Jul 28, 2011 3:05 pm
by 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.
Re: Parallel Interaction
Posted: Thu Jul 28, 2011 3:39 pm
by 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.
Re: Parallel Interaction
Posted: Thu Jul 28, 2011 3:43 pm
by 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"
Re: Parallel Interaction
Posted: Fri Jul 29, 2011 2:08 pm
by 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.
Re: Parallel Interaction
Posted: Fri Jul 29, 2011 3:28 pm
by 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.