Page 1 of 1

Missing object access after copy from Prod to Dev

Posted: Tue Jan 08, 2019 7:55 pm
by Rtel
Hi there,

I have system A that have:
1) TM1 native login in Prod
2) Cognos authentication method in Dev

(I have access to Prod and Dev both as a user not admin)

Once system A is copied (by network engineer) from prod to Dev (keeping original Tm1.cfg file in Dev) and when I log back in to the System A, there is no objects available (no cubes, dim, Process etc)

Surprisingly there is another system B in dev. No changes were made to it and I lost access to all the objects in System B as well.

Any suggestions as what are we missing.

Thanks

Rtel.

Re: Missing object access after copy from Prod to Dev

Posted: Wed Jan 09, 2019 11:59 am
by Steve Rowe
Sounds to me like the cfg is pointing to an empty folder so it has created the initial starting objects.

Best guess is that your network engineer has not correctly copied the files to the correct location.

Re: Missing object access after copy from Prod to Dev

Posted: Wed Jan 09, 2019 2:44 pm
by Rtel
HI Steve, thanks for your response.

I checked and the folder path is correct pointing to all data files. Also i am not able to create any new cubes since that option is disabled.

I am thinking I may have to change Cognos LDAP authentication on Dev to Native TM1 and add users appropriately and change back to Cognos LDAP login.

Any thoughts ?

Thanks

Rtel

Re: Missing object access after copy from Prod to Dev

Posted: Wed Jan 09, 2019 3:24 pm
by tomok
Rtel wrote: Tue Jan 08, 2019 7:55 pm I have system A that have:
1) TM1 native login in Prod
2) Cognos authentication method in Dev
Given these facts, I don't see how you can expect to copy from Prod to Dev and have it work UNLESS you specifically EXCLUDE the }Clients dimension and the }ClientGroups cube because the clients in a native TM1 system are not going to be the same as clients created in CAM.

Re: Missing object access after copy from Prod to Dev

Posted: Wed Jan 09, 2019 4:36 pm
by Rtel
Hi Tomok, thanks for the reply.

In such case, if we delete }Client dimension and }ClientGroups cube from existing data directory and restart the server , will these 2 objects be recreated ? or what should be the approach.

Thanks

Rtel

Re: Missing object access after copy from Prod to Dev

Posted: Wed Jan 09, 2019 6:45 pm
by tomok
I didn't say DELETE them. I said EXCLUDE them from the copy so that those two objects on dev will not be touched during the copy down. You can't copy prod client to dev because you're using native TM1 for one and CAM for the other. Leave the CAM users alone and it should work fine, although you may need to make some group assignments changes for those CAM users if you've added groups in prod that didn't previously exist in dev.

Re: Missing object access after copy from Prod to Dev

Posted: Thu Jan 10, 2019 7:24 pm
by Rtel
Hi, I tried copying the files as suggested but server is not starting at all. I reversed the files and server still can not start

I am puzzled.

Any suggestion ?

Thanks

Re: Missing object access after copy from Prod to Dev

Posted: Thu Jan 10, 2019 9:00 pm
by lotsaram
I think it might be quite helpful if you have a play around with 1 or 2 local installations on an environment you control (like your own laptop with the sample databases). Then you can get a handle on how the file system objects relate to what you see in server explorer and likewise understand what control objects are a pre-requisite and get automatically created and which don't, and then finally which files need to be copied from one data directory to another to successfully create objects in TM1.

Only after you have this understanding will you be in a position to be able to prepare packages on a server in order to perform migrations.

Re: Missing object access after copy from Prod to Dev

Posted: Fri Feb 08, 2019 4:31 pm
by Rtel
Hello all, after some experiments I found the answer'

Issue 2 different kind of authentication method on 2 diff environments

Solution
1) Copying files from Prod (with TM1 native login) to Dev --Keep TM1.cfg from Dev
2) Change original Config file on Dev to set up TM1 native login (IntegratedSecurityMode=1 ) Comment out ServerCAMURI and
ClientCAMURI
3) Start the server and login with Native TM1 Admin credentials
4) Open client security and check the boxes to grant the ADMIN access for LDAP Cognos user
5) Shut down server ...change config file to LDAP authentication
6) The LDAP user now have access to all the objects ..and he/she can add more user in LDAP

Thanks

Rtel