SSM 10.1 - Model designer error : Cannot get exclusive access to Model

[former_member288392]

Hello ,

I am using Model designer to create Models in PAS . All my Model connections are working fine.

when i try to build PAS Model after defining Defining Dimensions & Measures ,  Model designer fails with following error message

"Cannot get exclusive access to Model".

On checking PAS, the model is available but Measures  & dimensions are not created in the Model.

Model connections that get created automatically are created fine ( *_SC & *_MM) as well.

Tried Killing all connections to the newly created Model / CBADMIN User  from PAS) , Restarted SM Listener / JPIP sessions.

Any suggestions to resolve the issue would be very helpful.

We are SSM 10.1 SP8 . Windows server /Sybase DB.

Thanks in advance.

Best Regards,

Sridhar Sundaram

[Former Member · Accepted solution]

You may have tried this already, but if I were you, I would check the following:

1. Logon to PAS (SSM Application Server) as admin user "no password"

     In the IDQL type the following: SUP KILL CONN TO <MODEL NAME>, then exit PAS.

2.Check that the procs have been copied correctly. you need to copy the contents of the ASE files to the root directory (up 1 level) to the procs directory and overwrite existing files

3.Does the CBDEFAULT model connection in SSM admin work? If so, build the cube using cubebuilder and if this still fails, attach the log/trace file and I will have a look for you.

Les.

[former_member288392 · Accepted solution]

Hello Les,

Thanks for the inputs.

All the steps have been done already.

SSM_CB_EA and CBDEFAULT test connection works fine.

Attaching , log file for Model creation.

Please have look at your end and let me know , if you figure out something.

Thanks & Regards,
Sridhar Sundaram

[former_member288392 · Accepted solution]

LSS>

LSS> set control LINKID SSM_CB_EA

LSS>

LSS> .... capture cube id in a control var to simplify queries on other tables

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> SELECT CONVERT(VARCHAR, ID) AS CID FROM CPMS_CB_CUBES WHERE NAME = 'TESTSRIDHAR'

LSLink> lss create code = 'set control CUBEID ' + CID

LSLink> output proc setcubeid;PIPADMINDEFAULT over

LSLink> peek create nohead nonumb

set control CUBEID 115600130744543                                                                               

LSLink> output off

LSLink>

LSLink> end

LSS>

LSS> job setcubeid;PIPADMINDEFAULT

LSS> set control CUBEID 115600130744543

LSS>

LSS> .... start by getting FY start month and setting calendar

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> SELECT FY_START_MONTH FROM CPMS_CB_CUBES WHERE NAME = 'TESTSRIDHAR'

LSLink> lss create code = 'set fiscal calendar ' + FY_START_MONTH

LSLink> output proc setfiscal;PIPADMINDEFAULT over

LSLink> peek create nohead nonumb

set fiscal calendar July                                                                                                                                                                                    

LSLink> output off

LSLink>

LSLink> end

LSS>

LSS> job setfiscal;PIPADMINDEFAULT

LSS> set fiscal calendar July

LSS>

LSS> .... build all the dimensions

LSS> job 'cb_adddims.pro'

LSS> .... cb_adddims.pro

LSS>

LSS> ..... procedure called to add and also update dimensions

LSS>

LSS>

LSS> .... temp table has info for dims in this model that is used by cb_onedim.pro

LSS> access lslink

LSLink> connect SSM_CB_EA

LSLink>

LSLink> .... should have been dropped at end of last build but doing here just in case

LSLink> DROP TABLE CPMS_CBTMP1

LSLink>

LSLink> begin

> SELECT ID, NAME, NUM_LEVELS, LEVEL0 AS INP,

> COALESCE(',' + LEVEL1, ' ') AS OUT1,

> COALESCE(',' + LEVEL2, ' ') AS OUT2,

> COALESCE(',' + LEVEL3, ' ') AS OUT3,

> COALESCE(',' + LEVEL4, ' ') AS OUT4,

> ' ' AS RESULT

> INTO CPMS_CBTMP1

> FROM CPMS_CB_DIMS

> WHERE  CPMS_CB_CUBES_ID = 115600130744543

> AND RESULT = 1

> UNION

> SELECT ID, NAME, NUM_LEVELS, LEVEL0 AS INP,

> COALESCE(',' + LEVEL1, ' ') AS OUT1,

> COALESCE(',' + LEVEL2, ' ') AS OUT2,

> COALESCE(',' + LEVEL3, ' ') AS OUT3,

> COALESCE(',' + LEVEL4, ' ') AS OUT4,

> 'NORESULT' AS RESULT

> FROM CPMS_CB_DIMS

> WHERE  CPMS_CB_CUBES_ID = 115600130744543

> AND RESULT = 0

> end

LSLink>

LSLink> UPDATE CPMS_CBTMP1 SET OUT1 = NULL WHERE OUT1 = ','

LSLink>

[former_member220935 · Accepted solution]

Hi Sridhar,

Did you have a chance to check the modified timestamp of the above trace file to confirm that it was generated last time when you received the error "Cannot get exclusive access..." in cubebuilder?

Usually on a stand-alone NW java system with single server node, the error "Cannot get exclusive access" occurs before the trace is generated. Do you use a load-balancing NW Java system or a NW Java system with multiple server nodes?

Regards,

Alicia

[former_member220935 · Accepted solution]

Hi Sridhar,

If you are running a load-balancing or a multiple server node NW Java system, then please try to only keep one active server node and shut down all the other nodes and try "load pas model" in cube builder again.

Regards,

Alicia

[former_member288392 · Accepted solution]

Hi Alicia,

Thanks for the reply.

We are using a single node server neither we use load balancing.

The cubebuiler trace file reflects the time stamp and is in sync with the time we click Build PAS Model.This  means "cannot get exclusive access" is occurring after/during the process where trace file is generated.

Thanks ,

Sridhar

[former_member220935 · Accepted solution]

Hi Sridhar,

There should be more information if the cubebuilder is completed executed. Please check if the pro file cb_adddims.pro located in /<PAS installation>/InternetPub/procs folder was accidently changed or not. Please compare its content with the file located in the /Sybase_procs folder.

Regards,

Alicia

[former_member288392 · Accepted solution]

Hi Alicia,

One more thing , I found is when i run a SQL query

like "SELECT NAME FROM SAPSR3DB.CPMS_CBTMP1" fro, PAS SQL window ,

PAS ADMIN stops working.

Any inputs as to why this happens would be very helpful.

Regards,

Sridhar