Page 1 of 1
Very newbie question: Cannot get architect functionality
Posted: Wed Jul 24, 2013 6:41 pm
by shosty
Hi everyone,
I recently began learning TM1 10.1 through some self-study of the Great Outdoors samples. Everyone worked very well for a few weeks, until one day after a reboot of my laptop, the Great Outdoors server suddenly stopped appearing in Architect. I checked the configuration settings, and the Great Outdoors server, TM1 admin server, and Local Configuration are all started. I am not the most experienced computer user, so I don't really know how to troubleshoot any further beyond making sure all services are started in the Control Panel. Could this be an issue with the ports?
Best,
Re: Very newbie question: Cannot get architect functionality
Posted: Wed Jul 24, 2013 9:42 pm
by shosty
If someone could just post a few suggestions for things to try.... I've exhausted the options that I know of and Google has not been an enormous help.
Re: Very newbie question: Cannot get architect functionality
Posted: Wed Jul 24, 2013 9:53 pm
by Alan Kirk
shosty wrote:
I recently began learning TM1 10.1 through some self-study of the Great Outdoors samples. Everyone worked very well for a few weeks, until one day after a reboot of my laptop, the Great Outdoors server suddenly stopped appearing in Architect. I checked the configuration settings, and the Great Outdoors server, TM1 admin server, and Local Configuration are all started. I am not the most experienced computer user, so I don't really know how to troubleshoot any further beyond making sure all services are started in the Control Panel. Could this be an issue with the ports?
If all of that information is correct (bearing in mind that we can't see your server and don't know what your tm1p.ini file looks like), there is no obvious reason for the problem. It does beg the question of whether you are getting ANY servers showing in Architect, though, and if so whether the port numbers of those servers (in the tm1s.cfg file of the server) is the same as that of the Great Outdoors sample server.
Re: Very newbie question: Cannot get architect functionality
Posted: Wed Jul 24, 2013 10:01 pm
by shosty
Alan Kirk wrote:
If all of that information is correct (bearing in mind that we can't see your server and don't know what your tm1p.ini file looks like), there is no obvious reason for the problem. It does beg the question of whether you are getting ANY servers showing in Architect, though, and if so whether the port numbers of those servers (in the tm1s.cfg file of the server) is the same as that of the Great Outdoors sample server.
No servers are showing up in Architect, but keep in mind that I have
only been working with the Great Outdoor planning samples so far. I'm not sure how it could be a port conflict if I never manually changed anything. Quite literally: it was working, I went home from work, and the next day it did not work. I have just been working in a local environment with the planning samples, no connection to the outside whatsoever. Is there any other information I can check or provide that might help me narrow down my troubleshooting options? I am genuinely sorry that I can't give greater detail!
Re: Very newbie question: Cannot get architect functionality
Posted: Wed Jul 24, 2013 10:36 pm
by shosty
Perhaps this is significant: While the Local Configuration and the GO Server are both started, I can't stop them or restart them...
Re: Very newbie question: Cannot get architect functionality
Posted: Wed Jul 24, 2013 10:58 pm
by Alan Kirk
shosty wrote:Perhaps this is significant: While the Local Configuration and the GO Server are both started, I can't stop them or restart them...
By "Local configuration" I presume that you mean a Local server.
If:
(a) You have your Local Server Data directory (in File => Options of Server Explorer) pointing to the GO server's data directory; and
(b) You have Connect To Local Server on Startup; and
(c) You have a Windows Service (the Go server itself) that is set up to use the same data directory, then
It's entirely possible that you have your Local server and the Go Server service contesting for ownership of the same data files and log files.
Make sure that your data directory option is pointing to a directory OTHER than the Go server's one, and that you are not starting the local server automatically.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 2:05 am
by shosty
Alan Kirk wrote:shosty wrote:Perhaps this is significant: While the Local Configuration and the GO Server are both started, I can't stop them or restart them...
By "Local configuration" I presume that you mean a Local server.
If:
(a) You have your Local Server Data directory (in File => Options of Server Explorer) pointing to the GO server's data directory; and
(b) You have Connect To Local Server on Startup; and
(c) You have a Windows Service (the Go server itself) that is set up to use the same data directory, then
It's entirely possible that you have your Local server and the Go Server service contesting for ownership of the same data files and log files.
Make sure that your data directory option is pointing to a directory OTHER than the Go server's one, and that you are not starting the local server automatically.
Okay. I ensured that Server Explorer wasn't pointing to the GO_New_Stores directory. I pointed it to a different directory (admittedly random; didn't know which one to put. If there is a specific one that I need let me know) instead. It was indeed pointing to the GO_New_Stores files as you predicted. I also unchecked the start local server automatically box. Still cannot stop the TM1 Admin Server or GO server, and still nothing showing up in Architect... :/
Thanks again for your help anyway. If you have anything further to suggest, please let me know. I'm learning a lot!
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 3:42 am
by Alan Kirk
shosty wrote:
Okay. I ensured that Server Explorer wasn't pointing to the GO_New_Stores directory. I pointed it to a different directory (admittedly random; didn't know which one to put. If there is a specific one that I need let me know) instead. It was indeed pointing to the GO_New_Stores files as you predicted. I also unchecked the start local server automatically box. Still cannot stop the TM1 Admin Server
Hang on, you didn't say anything about not being able to stop the Admin Server before; you said that you couldn't stop the "Local configuration" and the Go Server.
When you go to Computer => Manage => Services (which is where you should be doing the stop from), what is the exact error message that you're getting?
When you go to Computer => Manage => Event Viewer => Windows Logs, are there any entries in the various logs about the services?
(In this I'm assuming that you are running on Windows 7 or equivalent; you haven't
specified the operating system version that you're using.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 2:03 pm
by shosty
shosty wrote:
Hang on, you didn't say anything about not being able to stop the Admin Server before; you said that you couldn't stop the "Local configuration" and the Go Server.
When you go to Computer => Manage => Services (which is where you should be doing the stop from), what is the exact error message that you're getting?
When you go to Computer => Manage => Event Viewer => Windows Logs, are there any entries in the various logs about the services?
(In this I'm assuming that you are running on Windows 7 or equivalent; you haven't
specified the operating system version that you're using.
Apologies for not being more clear! Yes, Windows 7.
Error message when I attempt to stop the Admin Server from services: "Error 1061:The service cannot accept control messages at this time." The only thing I can think to do is to kill the service in task manager but I thought it better to ask for advice first.
The only logs I can find that have anything to do with TM1 are under Administrative Events. There are 2-3 Errors every two minutes that my computer has been in use, with an event ID of 0. The source is tm1sdx64.
I'm almost thinking a clean re-install is what I need but I would really prefer not to if at all possible as it will put me behind (won't be able to re-access the files until Monday).
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 2:20 pm
by me2
The Great Outdoors sample TM1 server regularly fails to start after a reboot of my VM - might be the same issue you're experiencing. In my case it seems the transaction logfile somehow gets corrupted.
Try to delete the tm1s.log file (on my VM it's in C:\Program Files\ibm\cognos\tm1_64\webcontent\samples\datasources\cubes\amdtool\greatoutdoors\logfiles) and then start the greatoutdoors server.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 2:34 pm
by shosty
me2 wrote:The Great Outdoors sample TM1 server regularly fails to start after a reboot of my VM - might be the same issue you're experiencing. In my case it seems the transaction logfile somehow gets corrupted.
Try to delete the tm1s.log file (on my VM it's in C:\Program Files\ibm\cognos\tm1_64\webcontent\samples\datasources\cubes\amdtool\greatoutdoors\logfiles) and then start the greatoutdoors server.
Just want to clarify - The Great Outdoors server has no problem starting in the IBM Cognos Configuration window. My problem is that after it is started, it doesn't appear in server explorer, making me unable to access dimension/cubes/TI processes/etc. And, it is unable to be stopped.
In that case, would you still suggest I delete the log file?
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 3:13 pm
by me2
Perhaps not the same issue then - sorry if I put you on the wrong track.
Sometimes a TM1 server appears to start as expected but fails later in the process.
What are the last entries in the tm1server.log message file after start up?
Mine say:
FATAL ... TM1.Transaction TM1TransactionLog::ProcessTransactionLog: Bad transaction log record, line number 1.
FATAL ... TM1.Server Server terminated
You should see "... TM1 Server is ready" if all is OK. In that case it's not the same issue and deleting the transaction log file probably won't help.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 3:23 pm
by shosty
me2 wrote:Perhaps not the same issue then - sorry if I put you on the wrong track.
Sometimes a TM1 server appears to start as expected but fails later in the process.
What are the last entries in the tm1server.log message file after start up?
Mine say:
FATAL ... TM1.Transaction TM1TransactionLog::ProcessTransactionLog: Bad transaction log record, line number 1.
FATAL ... TM1.Server Server terminated
You should see "... TM1 Server is ready" if all is OK. In that case it's not the same issue and deleting the transaction log file probably won't help.
The path you indicated leads to an empty folder named sandbox logs. I've been clicking around since you posted the path originally looking for it but I can't seem to find that file. Everything is started up too.
I feel very, very dumb.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 3:25 pm
by Duncan P
Is the IPAddress specified in the config file? Do you connect to a DHCP server? Did the lease on your IPAddress expire and you get a new one?
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 3:32 pm
by shosty
Duncan P wrote:Is the IPAddress specified in the config file? Do you connect to a DHCP server? Did the lease on your IPAddress expire and you get a new one?
No, nothing with the IP Addresses have changed. Yes to DHCP server. IP Addresses all match.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 3:58 pm
by me2
I feel very, very dumb.
Shosty, I should be the one feeling dumb as I put you on a wild goose chase by not reading you're question properly.
You mentioned GO_New_Stores as well (which is a different server as the greatoutdoors one), its logfiles should be here: C:\Program Files\ibm\cognos\tm1_64\samples\tm1\GO_New_Stores\logfiles
If everything is up and running and the admin host in the Options dialog matches the one in the tm1s.cfg file of the server then you should see it in Architect.
Again my apologies for leading you down the wrong path.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 4:30 pm
by shosty
me2 wrote:I feel very, very dumb.
Shosty, I should be the one feeling dumb as I put you on a wild goose chase by not reading you're question properly.
You mentioned GO_New_Stores as well (which is a different server as the greatoutdoors one), its logfiles should be here: C:\Program Files\ibm\cognos\tm1_64\samples\tm1\GO_New_Stores\logfiles
If everything is up and running and the admin host in the Options dialog matches the one in the tm1s.cfg file of the server then you should see it in Architect.
Again my apologies for leading you down the wrong path.
Definitely going to add you as a "foe" for this. Just kidding. I actually think you're on to something.
Here are the last several logs located in the file:
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Server TM1CubeImpl::LoadFeeders: Loading feeders for cube '}StatsByClient' from saved feeders file.
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Done loading body for cube }StatsByClient
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Loading body for cube }StatsByCube
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Done loading body for cube }StatsByCube
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Loading body for cube }StatsByCubeByClient
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Done loading body for cube }StatsByCubeByClient
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Loading body for cube }StatsForServer
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Done loading body for cube }StatsForServer
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Loading body for cube }tp_application_cubes
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Done loading body for cube }tp_application_cubes
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Loading body for cube }tp_central_application_state
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Done loading body for cube }tp_central_application_state
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Loading body for cube }tp_process_errors
2860 [] INFO 2013-07-18 00:19:26.423 TM1.Cube Done loading body for cube }tp_process_errors
2468 [] INFO 2013-07-18 00:19:26.719 TM1.Comm.SSL Error connecting to remote machine
3240 [] INFO 2013-07-18 00:19:27.109 TM1.Server Starting PseudoElement thread. Thread Id: 3240
3256 [] INFO 2013-07-18 00:19:27.109 TM1.Server Starting spy thread. Thread Id: 3256
2860 [] INFO 2013-07-18 00:19:27.125 TM1.Chore Registering chore: PriceAndCostMeasures Start time: 2013/07/16 18:14:47 Frequency: 07:00:00:00
2860 [] INFO 2013-07-18 00:19:27.125 TM1.Server TM1 Server load time (secs) = 8
2468 [] INFO 2013-07-18 00:19:28.747 TM1.Comm.SSL Error connecting to remote machine
Continued.....
As you can see, near the "end" I was playing around with element attribute cubes, and experimenting with chores, when suddenly an error occurred (although this wasn't apparent to me until the next day; I still had access to the server). The error at the end of the previous sequence continued to occur multiple times per second, every second that my computer is in use, until....
This is the very end of the log file:
......continued
3120 [] INFO 2013-07-24 22:18:46.339 TM1.Comm.SSL Error connecting to remote machine
7736 [] INFO 2013-07-24 22:18:46.560 TM1.Server Closing...
7736 [] INFO 2013-07-24 22:18:46.560 TM1.Server Saving...
7736 [] INFO 2013-07-24 22:18:46.560 TM1.Server The server is coming down...
7736 [] INFO 2013-07-24 22:18:46.561 TM1.Server TM1ServerImpl::Destroy: disconnect clients
7736 [] INFO 2013-07-24 22:18:46.561 TM1.Server TM1ServerImpl::Destroy: Deactive all chores
7736 [] INFO 2013-07-24 22:18:46.561 TM1.Server TM1ServerImpl::Destroy: Save server data
7736 [] INFO 2013-07-24 22:18:46.631 TM1.Server TM1ServerImpl::Destroy: destroy chores
7736 [] INFO 2013-07-24 22:18:46.631 TM1.Server TM1ServerImpl::Destroy: destroy processes
7736 [] INFO 2013-07-24 22:18:46.632 TM1.Server TM1ServerImpl::Destroy: destroy blobs
7736 [] INFO 2013-07-24 22:18:46.632 TM1.Server TM1ServerImpl::Destroy: destroy sets
7736 [] INFO 2013-07-24 22:18:46.632 TM1.Server TM1ServerImpl::Destroy: destroy groups
7736 [] INFO 2013-07-24 22:18:46.632 TM1.Server TM1ServerImpl::Destroy: destroy clients
7736 [] INFO 2013-07-24 22:18:46.632 TM1.Server TM1ServerImpl::Destroy: destroy cubes
7736 [] INFO 2013-07-24 22:18:46.636 TM1.Server TM1ServerImpl::Destroy: destroy dimensions
7736 [] INFO 2013-07-24 22:18:46.638 TM1.Server TM1ServerImpl::Destroy: destroy connections
7736 [] INFO 2013-07-24 22:18:46.638 TM1.Server TM1ServerImpl::Destroy: Destroy unregistered objects
7736 [] INFO 2013-07-24 22:18:46.638 TM1.Server TM1ServerImpl::Destroy: Commit changes
7736 [] INFO 2013-07-24 22:18:46.657 TM1.Server Server shutdown
So yeah! Not looking so good. No clue what this end is all about. I never (knowingly) deleted anything.
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 6:18 pm
by shosty
Does anyone see any issue with a full re-install? Is there anything that could go wrong with a re-install that I could correct first?
Re: Very newbie question: Cannot get architect functionality
Posted: Thu Jul 25, 2013 9:40 pm
by shosty
Re-installed, everything worked fine. What a waste of time! Thanks for all your help everyone. Lesson learned.