-
1. Re: Unable to open the ODBC.INI data sources root
ChrisJenkins-Oracle Aug 13, 2018 4:14 PM (in response to Dmitrii Dunaev)Hi,
Firstly, can you confirm that you are indeed running TimesTen on Windows (your post suggests that you are but I just want to be sure).
Could this be a permissions issue? Do you have any specific permission set for that registry key path in the registry and if so does the user that the TimesTen service is running as have permission to read that key and all of its subordinates? Did you encounter any issues when you installed TimesTen? Is the user that the TimesTen service is configured to run as a member of the Administrators group?
Thanks,
Chris
-
2. Re: Unable to open the ODBC.INI data sources root
Dmitrii Dunaev Aug 14, 2018 7:14 AM (in response to ChrisJenkins-Oracle)Hello Chris.
I run TimesTen 11.2.2 (64 bit) on Windows 7 SP1 64-bit. I do not have any specific permissions set for the registry path. I installed it under my own user, which has administrator priviliges on this machine. The registry path has all permissions set for my user as a user and as an administrator. I did not encounter any issues during the installation process. I did not even know there were any issues until I tried to connect remotely to the timesten. Only then I reliazed that the server process was not running. Then I tried to start it and got message saying that the server is being restarted. And it actually was, that's my log files kept growing, because it could never restart it.
Thank you in advance.
-
3. Re: Unable to open the ODBC.INI data sources root
ChrisJenkins-Oracle Aug 14, 2018 1:36 PM (in response to Dmitrii Dunaev)Hi Dmitrii,
This is not an issue that I have encountered before so I don't have an immediate solution to suggest.
Can you please provide:
1. The exact TimesTen version (the output of the ttVersion command would be perfect).
2. A small section of the TimesTen log file that shows examples of the errors reported when the server tries to start.
Thanks,
Chris
-
4. Re: Unable to open the ODBC.INI data sources root
Dmitrii Dunaev Aug 14, 2018 2:08 PM (in response to ChrisJenkins-Oracle)Hello Chris.
Thank you very much for helping me with this.
Here is the ouput from ttVersion
C:\Windows\system32>ttVersion
TimesTen Release 11.2.2.8.0 (64 bit NT) (tt1122_64:53396) 2015-01-20T23:15:04Z
Instance admin: d_dunaev
Instance home directory: C:\TimesTen\TT1122~1\
Group owner: OFFICE\Domain Users
Daemon home directory: C:\TimesTen\TT1122~1\srv\info
PL/SQL enabled.
Here is a snippet from ttmesg.log
09:59:54.24 Err : SRV: 5936: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.24 Info: : 2128: maind got #4.4, hello: pid=5512 type=subdaemon payload=%81%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=AB%0f%00
09:59:54.24 Info: : 2128: Got hello from pid 5512, type subdaemon
09:59:54.24 Info: : 2128: mark process up: index 1000001, port 49793, pid 5512
09:59:54.24 Info: : 2128: marking subdaemon #1000001 (pid 5512) idle
09:59:54.24 Info: : 2128: maind: done with request #4.4
09:59:54.25 Info: : 2128: maind 1: socket closed, calling recovery (last cmd was 1)
09:59:54.25 Info: : 2128: Starting daRecovery for 5936
09:59:54.25 Info: : 2128: Finished daRecovery for pid 5936.
09:59:54.25 Info: : 2128: maind 3: socket closed, calling recovery (last cmd was 3)
09:59:54.25 Info: : 2128: Starting daRecovery for 5936
09:59:54.25 Info: : 2128: 5936 ------------------: TimesTen Server exited
09:59:54.25 Info: : 2128: Mark process (pid 5936, idx 1000004) down
09:59:54.25 Info: : 2128: Mark process #1000004 as down (0)
09:59:54.25 Info: : 2128: Spawning 'c:\timesten\tt1122~1\bin\ttcserver1122.exe'
09:59:54.25 Info: : 5512: subd: connectToDaemon(sub) port 49793 id 1000001
09:59:54.25 Info: : 2128: Spawned new process (ttcserver1122.exe), idx 1000005, handle 0x210=528
09:59:54.25 Info: : 2128: Finished daRecovery for pid 5936.
09:59:54.25 Info: : 216: Process running as user система
09:59:54.25 Info: : 5512: subd: watching for main daemon termination
09:59:54.25 Info: : 2128: maind got #6.5, hello: pid=216 type=deadman payload=%87%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=BB%0f%00
09:59:54.25 Info: : 2128: Got hello from pid 216, type deadman
09:59:54.25 Info: : 2128: 216 ------------------: Subprocess deadman registering
09:59:54.25 Info: : 2128: maind: done with request #6.5
09:59:54.25 Info: : 3932: Process running as user система
09:59:54.25 Info: : 2128: maind got #7.6, hello: pid=3932 type=deadman payload=%89%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=CB%0f%00
09:59:54.25 Info: : 2128: Got hello from pid 3932, type deadman
09:59:54.25 Info: : 2128: 3932 ------------------: Subprocess deadman registering
09:59:54.25 Info: : 2128: maind: done with request #7.6
09:59:54.25 Info: : 3932: subd: watching for main daemon termination
09:59:54.25 Info: : 2128: maind got #8.7, hello: pid=3932 type=subdaemon payload=%89%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=CB%0f%00
09:59:54.25 Info: : 2128: Got hello from pid 3932, type subdaemon
09:59:54.25 Info: : 2128: mark process up: index 1000003, port 49801, pid 3932
09:59:54.25 Info: : 2128: marking subdaemon #1000003 (pid 3932) idle
09:59:54.26 Info: : 216: subd: watching for main daemon termination
09:59:54.26 Info: : 3932: subd: connectToDaemon(sub) port 49801 id 1000003
09:59:54.26 Info: : 2128: maind: done with request #8.7
09:59:54.26 Info: : 2128: maind got #9.8, hello: pid=216 type=subdaemon payload=%87%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=BB%0f%00
09:59:54.26 Info: : 2128: Got hello from pid 216, type subdaemon
09:59:54.26 Info: : 2128: mark process up: index 1000002, port 49799, pid 216
09:59:54.26 Info: : 2128: marking subdaemon #1000002 (pid 216) idle
09:59:54.26 Info: : 2128: maind: done with request #9.8
09:59:54.26 Info: : 216: subd: connectToDaemon(sub) port 49799 id 1000002
09:59:54.26 Info: : 2128: maind got #10.9, hello: pid=5364 type=deadman payload=%8d%c2%00%00 serverport=%95%d0%00%00 ident=EB%0f%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64
09:59:54.26 Info: : 2128: Got hello from pid 5364, type deadman
09:59:54.26 Info: : 2128: 5364 ------------------: Subprocess deadman registering
09:59:54.26 Info: : 2128: maind: done with request #10.9
09:59:54.26 Info: : 2128: maind got #11.10, hello: pid=5364 type=ttconnect payload=%8d%c2%00%00 serverport=%95%d0%00%00 ident=EB%0f%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64
09:59:54.26 Info: : 2128: Got hello from pid 5364, type ttconnect
09:59:54.26 Info: : 2128: mark process up: index 1000005, port 49805, pid 5364
09:59:54.26 Info: : 2128: maind: done with request #11.10
09:59:54.26 Err : SRV: 5364: EventID=7| Unable to open the ODBC.INI data sources root
Here is a snippet from tterrors.log
09:59:54.21 Warn: : 2128: TimesTen Daemon Release 11.2.2.8.0.tt1122_64 started on 2018-08-14.
09:59:54.24 Err : SRV: 5936: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.26 Err : SRV: 5364: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.26 Err : SRV: 4476: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.27 Err : SRV: 6140: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.30 Err : SRV: 4852: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.31 Err : SRV: 1040: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.32 Err : SRV: 2464: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.33 Err : SRV: 2412: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.34 Err : SRV: 5256: EventID=7| Unable to open the ODBC.INI data sources root
09:59:54.35 Err : SRV: 2140: EventID=7| Unable to open the ODBC.INI data sources root
-
5. Re: Unable to open the ODBC.INI data sources root
ChrisJenkins-Oracle Aug 14, 2018 5:36 PM (in response to Dmitrii Dunaev)This may be a silly question, but can you confirm that the registry contains the key HKLM/Software/ODBC/ODBC.INI
Thanks,
Chris
-
6. Re: Unable to open the ODBC.INI data sources root
ChrisJenkins-Oracle Aug 14, 2018 5:45 PM (in response to ChrisJenkins-Oracle)Also, can you please confirm what user the TimesTen Data Manager and Server services are configured to run as?
Thanks, Chris
-
7. Re: Unable to open the ODBC.INI data sources root
ChrisJenkins-Oracle Aug 14, 2018 6:04 PM (in response to ChrisJenkins-Oracle)I'd also like to get the output file produced by the ttCapture utility run from a command prompt with the TimesTen environment set. This output will be too large to easily post here; are you willing to provide an email address so that I can contact you directly?
Thanks, Chris
-
8. Re: Unable to open the ODBC.INI data sources root
Dmitrii Dunaev Aug 15, 2018 5:08 AM (in response to ChrisJenkins-Oracle)Hi Chris.
Sure, please send me an e-mail to "It's my last name (DUNAEV) followed by my initials DN followed by @gmail.com". I will repply back with the files attached.
Thank you in advance.
-
9. Re: Unable to open the ODBC.INI data sources root
ChrisJenkins-Oracle Aug 15, 2018 6:44 AM (in response to Dmitrii Dunaev)Thanks. I just sent you an e-mail.
Chris