on 04-02-2007 11:30 AM
I encountered error when I use the TMS Check Transport Tool. Both DB Connect and Offline Call failed during tp Call. Below are the log from the error.
Hope someone can kindly give me some advice here. Thanks.
Rgds,
Aaron
-
This is tp version 340.16.24 (release 640, unicode enabled)
Warning: Parameter DBHOST is no longer used.
Warning: Parameter DBNAME is no longer used.
ERROR: Connect to N01 failed (20070402180622, probably wrong environment).
TRACE-INFO: 1: [dev trc ,00000] Mon Apr 02 18:06:21 2007 179913 0.179913
TRACE-INFO: 2: [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 13 0.179926
TRACE-INFO: 3: [dev trc ,00000] using "D:\usr\sap\N01\SYS\exe\run\dbmssslib.dll" 13 0.179939
TRACE-INFO: 4: [dev trc ,00000] Thread ID:5048 27238 0.207177
TRACE-INFO: 5: [dev trc ,00000] Thank You for using the SLOLEDB-interface 14 0.207191
TRACE-INFO: 6: [dev trc ,00000] Using dynamic link library 'D:\usr\sap\N01\SYS\exe\run\dbmssslib.dll'
TRACE-INFO: 7: 22 0.207213
TRACE-INFO: 8: [dev trc ,00000] dbmssslib.dll patch info 33 0.207246
TRACE-INFO: 9: [dev trc ,00000] patchlevel 0 8 0.207254
TRACE-INFO: 10: [dev trc ,00000] patchno 152 8 0.207262
TRACE-INFO: 11: [dev trc ,00000] patchcomment Connection check on (0,0) (988711) 9 0.207271
TRACE-INFO: 12: [dev trc ,00000] np:(local) connection used on EMI-SAP 95 0.207366
TRACE-INFO: 13: [dev trc ,00000] CopyLocalParameters: dbuser is 'dbo' 11 0.207377
TRACE-INFO: 14: [dev trc ,00000] Provider SQLNCLI could not be initialized. See note #734034 for more information.
TRACE-INFO: 15: 336468 0.543845
TRACE-INFO: 16: [dev trc ,00000] Using provider SQLOLEDB instead. 11 0.543856
TRACE-INFO: 17: [dev trc ,00000] OpenOledbConnection: MARS property was not set. 1474 0.545330
TRACE-INFO: 18: [dev trc ,00000] Mon Apr 02 18:06:22 2007 654933 1.200263
TRACE-INFO: 19: [dev trc ,00000] Provider Release:08.10.1830 10 1.200273
TRACE-INFO: 20: [dev trc ,00000] Provider SQLNCLI could not be initialized. See note #734034 for more information.
TRACE-INFO: 21: 24489 1.224762
TRACE-INFO: 22: [dev trc ,00000] Using provider SQLOLEDB instead. 10 1.224772
TRACE-INFO: 23: [dev trc ,00000] i'm dbo but there exists 1 users <> dbo with tables SVERS ==> connect terminated
TRACE-INFO: 24: 27591 1.252363
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0232
standard output from tp and from tools called by tp:
Joe,
Thanks for your reply.
Notes 734034 implies the following...
"Please NOTE: This is a warning message only. It is meant to remind users to apply the SQL 2005 client libraries."
I have seen this note before and concluded that since I'm on MS SQL 2000 now, so it's not mandatory in my case.
Lastly, I was reluctant to proceed with it because IMHO, I will be introducing new factors into my unsolved problems.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Aaron,
As it's indicated in the trace of the checking TP tools, you need to Install the sql native provider on the application server. In the trae mesasge, it says clearly ou need to consult note 734034 to install the sql native provider on the application server.
Regards,
Joe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Vincent.
I've gone through the notes you listed before. I might have missed something due to my limited knowledge in basis. My initial installation was in SP09 and I've been able to patch uptill SP18. It's only recently that I encounter this problem. It happened during updating the SPAM tool. And currently stuck in the Import phase CHECK_REQUIREMENTS.
Perhaps you can let me know what information you need in order to pin point the problem.
Thanks again for your kind help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the MSSQL env variables settings, i.e DBMS_TYPE, MSSQL_DBNAME,
MSSQL_SCHEMA, SAPLOCALHOST, MSSQL_SERVER
See below SAP Notes
351586 TP: DBSL error 107, DB error 208 with Connect
128126 Database Connect for external tools
28667 Microsoft SQL Server Specific Profile Parameters
98678 SQL Server Connection Issues
Could you also check STMS, system overview, tab transport tool and see here if there are any wrong parameters?
Hope this helps.
Regards,
Vincent
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.