Test call of transport control program (tp) ended with return code 0200 Message no. TK094

[afifnuzia_alasadi]

I Want to ask, How to fix when cannot release Transport Request?

I have read in other thread, but i dont have any idea to fix it. Please help me to fix it. Because my team basis always restart client when i ask how to fix when error cannot release transport request.

Error Log

This is tp version 380.18.94 (release 741, unicode enabled) ERROR: Connect to DEV failed (20181016144456, invalid protocol or service shutdown during distributed query e executor: communication problem). TRACE-INFO: 1: [ dev trc,00000] Tue Oct 16 14:44:55 2018 0.021551 TRACE-INFO: 2: [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/DEV/DVEBMGS01/exe/dbhdbslib.so"), 144a830 TRACE-INFO: 3: 0.021557 TRACE-INFO: 4: [ dev trc,00000] } DbSlHDBControl(rc=0) 0.021656 TRACE-INFO: 5: [ dev trc,00000] { DbSlHDBControl(con_hdl=-1,command=39,arg_p=(nil)) 0.021664 TRACE-INFO: 6: [ dev trc,00000] } DbSlHDBControl(rc=0) 0.021670 TRACE-INFO: 7: [ dev trc,00000] { DbSlHDBControl(con_hdl=-1,command=10,arg_p=7ffff80c6cc0) 0.021677 TRACE-INFO: 8: [ dev trc,00000] } DbSlHDBControl(rc=0) 0.021683 TRACE-INFO: 9: [ dev trc,00000] { DbSlHDBControl(con_hdl=-1,command=10,arg_p=1055400) 0.021703 TRACE-INFO: 10: [ dev trc,00000] } DbSlHDBControl(rc=0) 0.021709 TRACE-INFO: 11: [ dev trc,00000] { DbSlHDBConnect(con_info_p=(nil)) 0.021736 TRACE-INFO: 12: [ dev trc,00000] DBHDBSLIB : version 741.10, patch 0.052 (Make PL 0.100) 0.021749 TRACE-INFO: 13: [ dev trc,00000] HDB shared library (dbhdbslib) patchlevels (last 10) 0.021755 TRACE-INFO: 14: [ dev trc,00000] (0.052) UPSERT emulation fails with rc=13 (DBSL_ERR_STMTID) (note 20 0.021763 TRACE-INFO: 15: [ dev trc,00000] (0.051) Exception in copy_output_values fixed (note 2064029) 0.021770 TRACE-INFO: 16: [ dev trc,00000] (0.050) Trace EPP buffer (note 2059748) 0.021781 TRACE-INFO: 17: [ dev trc,00000] (0.050) More trace in copy_output_values (note 1897636) 0.021790 TRACE-INFO: 18: [ dev trc,00000] (0.043) R3szchk with partitioned tables (note 2040561) 0.021799 TRACE-INFO: 19: [ dev trc,00000] (0.031) New DBCON syntax for HANA (note 1983389) 0.021807 TRACE-INFO: 20: [ dev trc,00000] (0.028) Bulk insert stop on duplicate, dbsl returncode corrected (no TRACE-INFO: 21: 0.021815 TRACE-INFO: 22: [ dev trc,00000] (0.027) Set DBAREQ class (note 1991383) 0.021823 TRACE-INFO: 23: [ dev trc,00000] (0.022) Get database version via dbsl call (note 1976918) 0.021831 TRACE-INFO: 24: [ dev trc,00000] (0.020) FDA: Core Dump in SELECT ... FOR ALL ENTRIES for tables with TRACE-INFO: 25: 0.021843 TRACE-INFO: 26: [ dev trc,00000] 0.021847 TRACE-INFO: 27: [ dev trc,00000] -> init() 0.021855 TRACE-INFO: 28: [ dev trc,00000] STATEMENT_CACHE_SIZE = 1000 0.021887 TRACE-INFO: 29: [ dev trc,00000] -> init() 0.022562 TRACE-INFO: 30: [ dev trc,00000] -> loadClientRuntime() 0.022569 TRACE-INFO: 31: [ dev trc,00000] Loading SQLDBC client runtime ... 0.022580 TRACE-INFO: 32: [ dev trc,00000] SQLDBC Module : /usr/sap/DEV/DVEBMGS01/exe/hdbclient/libSQLDBCHDB.so 0.028155 TRACE-INFO: 33: [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 1.00.74.00 Build 0390550-1510 0.028185 TRACE-INFO: 34: [ dev trc,00000] SQLDBC client runtime is 1.00.74.00.0390550 0.028201 TRACE-INFO: 35: [ dev trc,00000] -> getNewConnection() 0.028210 TRACE-INFO: 36: [ dev trc,00000] <- getNewConnection(con_hdl=0) 0.028259 TRACE-INFO: 37: [ dev trc,00000] -> checkEnvironment(con_hdl=0) 0.028275 TRACE-INFO: 38: [ dev trc,00000] -> connect(con_info_p=(nil)) 0.028289 TRACE-INFO: 39: [ dev trc,00000] Try to connect via secure store (DEFAULT) on connection 0 ... 0.028326 TRACE-INFO: 40: [ dev trc,00000] -> check_db_params(con_hdl=0) 0.495560 TRACE-INFO: 41: [ dev trc,00000] Attach to HDB : 1.00.74.00.390550 (NewDB100_REL) 0.497499 TRACE-INFO: 42: [ dev trc,00000] Database release is HDB 1.00.74.00.390550 0.497543 TRACE-INFO: 43: [ dev trc,00000] INFO : Database 'H01/00' instance is running on 'pwisap03' 0.498689 TRACE-INFO: 44: [ dev trc,00000] Tue Oct 16 14:44:56 2018 1.458758 TRACE-INFO: 45: [dbsdbsql.cpp,00000] *** ERROR => execute(), rc=1, rcSQL=3587 1.458768 TRACE-INFO: 46: [dbhdbsql.cpp,00000] *** ERROR => Get session info failed : rc=3587 1.458783 TRACE-INFO: 47: [ dev trc,00000] SQLCODE : 3587 1.458797 TRACE-INFO: 48: [ dev trc,00000] SQLERRTEXT : invalid protocol or service shutdown during distributed q [2613] executor: communica\ TRACE-INFO: 49: 1.458808 TRACE-INFO: 50: [ dev trc,00000] tion problem 1.458817 TRACE-INFO: 51: [ dev trc,00000] SQL COMMAND: SELECT TOP 1 USER_NAME, CONNECTION_ID FROM M_CONNECTIONS TRACE-INFO: 52: 1.458826 TRACE-INFO: 53: [ dev trc,00000] -> SetSdbDbslCA(errcode=3587) 1.458837 TRACE-INFO: 54: [ dev trc,00000] -> SetSdbDbslCA(errcode=3587) 1.458861 TRACE-INFO: 55: [ dev trc,00000] -> disconnect(con_hdl=0) 1.458870 TRACE-INFO: 56: [ dev trc,00000] Disconnecting from connection 0 ... 1.458882 TRACE-INFO: 57: [ dev trc,00000] Now I'm disconnected from HDB 1.459163 TRACE-INFO: 58: [ dev trc,00000] -> freeConnection(con_hdl=0) 1.459172 TRACE-INFO: 59: [ dev trc,00000] close all opened locators of connection 0 1.459182 TRACE-INFO: 60: [ dev trc,00000] } DbSlHDBConnect(rc=99) 1.459208 TRACE-INFO: 61: [ dblink ,00000] ***LOG BY2=>sql error 3587 performing CON 1.459252 TRACE-INFO: 62: [ dblink ,00000] ***LOG BY0=>invalid protocol or service shutdown during distributed qu executor: communication problem TRACE-INFO: 63: 1.459264 tp returncode summary: TOOLS: Highest return code of single steps was: 0 ERRORS: Highest tp internal error was: 0232 tp finished with return code: 232 meaning: connect failed standard output from tp and from tools called by tp: