cancel
Showing results for 
Search instead for 
Did you mean: 

Java Engine not connecting to DB

Former Member
0 Kudos

Dears,

From last some days on our ECC5 server which is having ABAP+JAVA stack on SQL server,we are facing one issue that my Java engine is not connecting to Database.

Due to which i am not able to work on my java stack.ABAP stack is working fine.On ABAP side there is no issue.Checked the database schema SAPSIDDB password is it correct.

This happened suddenly.Till evening system was working fine and next day in moring this issue occured means we have not made changes in any configuration or anywhere.

Configtool log says:

###Thread[AWT-EventQueue-0,6,main]##0#0#Warning##Java#SAP_LOGGING_FORMATTER_ERROR##Attempting to change a formatter on active log ! The reset() method must be called first!#1#.
system.log# #1.5#C000ACA8010400010000002801CF243B000455CDD9D74CA8#1220242518265#/System/Configuration/Logging##com.sap.tc.logging.APILogger.FileLog[setFormatter()]#######Thread[AWT-EventQueue-0,6,main]##0#0#Info##Java#TC_LOGGING_CONFIGURATION_IS_CHANGED[C0000A305666000000000000018FB1F70003D67C779CD2B8]##The
for the has been changed from to )!#5#formatter#FileLog#.
system.log#com.sap.tc.logging.ListFormatter#com.sap.tc.logging.ListFormatter# #1.5#C000ACA8010400010000002901CF243B000455CDD9D74CA8#1220242518265#/System/Server##com.sap.engine.core.configuration#######Thread[AWT-EventQueue-0,6,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###Properties for connect through secure store not set. Please check your connect properties. Trying to connect via plain user/password.##1.5#C000ACA8010400010000002A01CF243B000455CDD9D74CA8#1220242518265#/System/Configuration/Logging##com.sap.tc.logging.APILogger.LogController[setResourceBundleName(String resourceBundleName)]#######Thread[AWT-EventQueue-0,6,main]##0#0#Info##Java#TC_LOGGING_CONFIGURATION_IS_CHANGED[C0000A305666000000000000018FB1F70003D67C779CD2B8]##The for the
has been changed from to )!#5#resource bundle name#LogController#/System/Database/sql/jdbc#<null>#com.sap.sql.log.OpenSQLResourceBundle# #1.5#C000ACA8010400010000002B01CF243B000455CDD9D74CA8#1220242518265#/System/Configuration/Logging##com.sap.tc.logging.APILogger.LogController[setResourceBundleName(String resourceBundleName)]#######Thread[AWT-EventQueue-0,6,main]##0#0#Info##Java#TC_LOGGING_CONFIGURATION_IS_CHANGED[C0000A305666000000000000018FB1F70003D67C779CD2B8]##The for the has been changed from to )!#5#resource bundle name#LogController#/System/Database/sql/jdbc#com.sap.sql.log.OpenSQLResourceBundle#com.sap.sql.log.OpenSQLResourceBundle# #1.5#C000ACA8010400010000002C01CF243B000455CDD9D74CA8#1220242518265#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[AWT-EventQueue-0,6,main]##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0015#com.sap.sql.log.OpenSQLResourceBundle#Value "" is not allowed for parameter .#2#url## #1.5#C000ACA8010400010000002D01CF243B000455CDD9D74CA8#1220242518265#/System/Configuration/Logging##com.sap.tc.logging.APILogger.LogController[setResourceBundleName(String resourceBundleName)]#######Thread[AWT-EventQueue-0,6,main]##0#0#Info##Java#TC_LOGGING_CONFIGURATION_IS_CHANGED[C0000A305666000000000000018FB1F70003D67C779CD2B8]##The for the has been changed from to )!#5#resource bundle name#LogController#/System/Database/sql/jdbc#com.sap.sql.log.OpenSQLResourceBundle#com.sap.sql.log.OpenSQLResourceBundle#

ICM log says:

[Thr 3528] Mon Sep 01 09:46:32 2008

[Thr 3528] ICM running on: server2.prospecta.local

[Thr 3528] MtxInit: -2 0 0

[Thr 3528] IcmInit: listening to admin port: 65000

[Thr 3528] DpSysAdmExtCreate: ABAP is active

[Thr 3528] DpSysAdmExtCreate: JAVA is not active

[Thr 3528] DpShMCreate: sizeof(wp_adm) 38168 (1316)

[Thr 3528] DpShMCreate: sizeof(tm_adm) 2780232 (13832)

[Thr 3528] DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

[Thr 3528] DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

[Thr 3528] DpShMCreate: sizeof(comm_adm) 290000 (580)

[Thr 3528] DpShMCreate: sizeof(vmc_adm) 0 (372)

[Thr 3528] DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

[Thr 3528] DpShMCreate: SHM_DP_ADM_KEY (addr: 02280040, size: 3220328)

[Thr 3528] DpShMCreate: allocated sys_adm at 02280040

[Thr 3528] DpShMCreate: allocated wp_adm at 02281B58

[Thr 3528] DpShMCreate: allocated tm_adm_list at 0228B070

[Thr 3528] DpShMCreate: allocated tm_adm at 0228B098

[Thr 3528] DpShMCreate: allocated wp_ca_adm at 02531CE0

[Thr 3528] DpShMCreate: allocated appc_ca_adm at 02537AA0

[Thr 3528] DpShMCreate: allocated comm_adm_list at 025399E0

[Thr 3528] DpShMCreate: allocated comm_adm at 025399F8

[Thr 3528] DpShMCreate: allocated vmc_adm_list at 025806C8

[Thr 3528] DpShMCreate: system runs without vmc_adm

[Thr 3528] DpShMCreate: allocated ca_info at 025806F0

[Thr 3528] Mon Sep 01 09:46:33 2008

[Thr 3528] IcmCreateWorkerThreads: created worker thread 0

[Thr 3528] IcmCreateWorkerThreads: created worker thread 1

[Thr 3528] IcmCreateWorkerThreads: created worker thread 2

[Thr 3528] IcmCreateWorkerThreads: created worker thread 3

[Thr 3528] IcmCreateWorkerThreads: created worker thread 4

[Thr 3528] IcmCreateWorkerThreads: created worker thread 5

[Thr 3528] IcmCreateWorkerThreads: created worker thread 6

[Thr 3528] IcmCreateWorkerThreads: created worker thread 7

[Thr 3528] IcmCreateWorkerThreads: created worker thread 8

[Thr 3528] IcmCreateWorkerThreads: created worker thread 9

[Thr 5804] IcmWatchDogThread: watchdog started

[Thr 3476] ISC: created 400 MB disk cache.

[Thr 3476] ISC: created 50 MB memory cache.

[Thr 3476] HttpSubHandlerAdd: Added handler HttpCacheHandler(slot=0, flags=12293) for /:0

[Thr 3476] HttpSubHandlerAdd: Added handler HttpSAPR3Handler(slot=1, flags=4101) for /:0

[Thr 3476] HttpSubHandlerAdd: Added handler HttpJ2EEHandler(slot=2, flags=1077253) for /:0

[Thr 3476] Started service 8000 for protocol HTTP on host "server2.prospecta.local"(on all adapters) (timeout=30)

[Thr 5600] MPI<3>0#3 Peak buffer usage: 1 (@ 64 KB)

[Thr 5084] MPI<5>2#3 Peak buffer usage: 2 (@ 64 KB)

[Thr 3476] Mon Sep 01 09:46:37 2008

[Thr 3476] *** WARNING => IcmNetCheck: NiAddrToHost(10.0.0.1) took 4 seconds [icxxtool.c 852]

*[Thr 3476] *** WARNING => IcmNetCheck: 1 possible network problems detected - please check the network/DNS settings [icxxtool.c 908]*

Please suggest.

Can it be that any of driver file of java get currupted or Is there any network issue.

Shivam

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Plz check the errors in std_bootstratp.error file present in the work dir.

Whatever error is faced by the j2ee while starting it will be logged in the

respective dev_* files and std_server* files.

The default trace is also a good place to look for errors.

Regards,

Abhishek

Former Member
0 Kudos

Hi ,

The following error is present in your post:

instance=default#J2EE_GUEST#0####9d4208103d1911dda55b00145e41f759#Thread[Thread-56,5,SAPEngine_Application_Threadimpl:3]_Group##0#0#Error##Plain###com.sap.jms.server.exception.JMSServerSecurityException:

Cannot create connection. User J2EE_ADMIN is locked.

Plz check the user j2ee_admin on the backend(i am still confused as nothing related to jdbc is thr in the error).Plz once again check the content of latest defaulttrace file.

Regards,

Abhishek

Former Member
0 Kudos

Hi Shyam,

If the j2ee is unable to connect to the db,the following could be the probable

causes:

1)the db is down

2)the jdbc drivers have expired

3)the jdbc user/pwd information specified in the securestore in configtool is incorrect.

Please check the defaulttrace files present in j2ee/cluster/server0/log path.Be sure to check the

latest default trace file(check the timestamp).Post the latest errors here,and will try to help you.

Regards,

Abhishek

Former Member
0 Kudos

Hi Abhishek,

Logs in default trace are:

#1.5#00145E41F759004E0000025A000015BC00044FEDA96A6E36#1213782074687#com.sap.engine.services.deploy##com.sap.engine.services.deploy####server2.prospecta_PRO_5851450#Guest#083f0f103d1911ddaba300145e41f759#SAPEngine_System_Thread[impl:5]_68##0#0#Error#1#/System/Audit#Java###Exception #1#com.sap.engine.services.deploy.exceptions.ServerDeploymentException: Application sap.com/com.sapportals.dqe.beans cannot be started. Reason: it has hard reference to resource DQE with type service, which is not active on the server. at com.sap.engine.services.deploy.server.ReferenceResolver.processReferenceToService(ReferenceResolver.java:475) at com.sap.engine.services.deploy.server.ReferenceResolver.processMakeReference(ReferenceResolver.java:396) at com.sap.engine.services.deploy.server.ReferenceResolver.beforeStartingApplication(ReferenceResolver.java:328) at com.sap.engine.services.deploy.server.application.StartTransaction.beginCommon(StartTransaction.java:178) at com.sap.engine.services.deploy.server.application.StartTransaction.beginLocal(StartTransaction.java:152) at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesLocal(ApplicationTransaction.java:356) at com.sap.engine.services.deploy.server.application.ParallelAdapter.runInTheSameThread(ParallelAdapter.java:117) at com.sap.engine.services.deploy.server.application.ParallelAdapter.makeAllPhasesLocalAndWait(ParallelAdapter.java:235) at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationLocalAndWait(DeployServiceImpl.java:4443) at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationsInitially(DeployServiceImpl.java:2568) at com.sap.engine.services.deploy.server.DeployServiceImpl.clusterElementReady(DeployServiceImpl.java:2425) at com.sap.engine.services.deploy.server.ClusterServicesAdapter.containerStarted(ClusterServicesAdapter.java:42) at com.sap.engine.core.service630.container.ContainerEventListenerWrapper.processEvent(ContainerEventListenerWrapper.java:144) at com.sap.engine.core.service630.container.AdminContainerEventListenerWrapper.processEvent(AdminContainerEventListenerWrapper.java:19) at com.sap.engine.core.service630.container.ContainerEventListenerWrapper.run(ContainerEventListenerWrapper.java:102) at com.sap.engine.frame.core.thread.Task.run(Task.java:64) at com.sap.engine.core.thread.impl5.SingleThread.execute(SingleThread.java:79) at com.sap.engine.core.thread.impl5.SingleThread.run(SingleThread.java:150) Caused by: com.sap.engine.frame.ServiceException: <Localization failed: ResourceBundle='com.sap.engine.frame.KernelResourceBundle', ID='Service DQE error. Nested exception is: com.sap.engine.frame.ServiceException: <Localization failed: ResourceBundle='com.sap.engine.frame.KernelResourceBundle', ID='Could not start DQE service, reason: Could not initialize RuntimeStateAdminAPIImpl.', Arguments: []--> : Can't find resource for bundle java.util.PropertyResourceBundle, key Could not start DQE service, reason: Could not initialize RuntimeStateAdminAPIImpl. at com.metamatrix.sap.service.MetaMatrixServiceFrame.start(MetaMatrixServiceFrame.java:174) at com.sap.engine.core.service630.container.ServiceRunner.startApplicationServiceFrame(ServiceRunner.java:214) at com.sap.engine.core.service630.container.ServiceRunner.run(ServiceRunner.java:144) at com.sap.engine.frame.core.thread.Task.run(Task.java:64) at com.sap.engine.core.thread.impl5.SingleThread.execute(SingleThread.java:79) at com.sap.engine.core.thread.impl5.SingleThread.run(SingleThread.java:150) ', Arguments: []> : Can't find resource for bundle java.util.PropertyResourceBundle, key Service DQE error. Nested exception is: com.sap.engine.frame.ServiceException: <Localization failed: ResourceBundle='com.sap.engine.frame.KernelResourceBundle', ID='Could not start DQE service, reason: Could not initialize RuntimeStateAdminAPIImpl.', Arguments: []--> : Can't find resource for bundle java.util.PropertyResourceBundle, key Could not start DQE service, reason: Could not initialize RuntimeStateAdminAPIImpl. at com.metamatrix.sap.service.MetaMatrixServiceFrame.start(MetaMatrixServiceFrame.java:174) at com.sap.engine.core.service630.container.ServiceRunner.startApplicationServiceFrame(ServiceRunner.java:214) at com.sap.engine.core.service630.container.ServiceRunner.run(ServiceRunner.java:144) at com.sap.engine.frame.core.thread.Task.run(Task.java:64) at com.sap.engine.core.thread.impl5.SingleThread.execute(SingleThread.java:79) at com.sap.engine.core.thread.impl5.SingleThread.run(SingleThread.java:150) at com.sap.engine.core.service630.container.MemoryContainer.startServiceRuntime(MemoryContainer.java:389) at com.sap.engine.core.service630.container.ServiceWrapper.start(ServiceWrapper.java:107) at com.sap.engine.services.deploy.server.ReferenceResolver.processReferenceToService(ReferenceResolver.java:468) ... 17 more # #1.5#00145E41F759006400000011000015BC00044FEDA9D59E32#1213782081718#com.sap.engine.services.httpserver##com.sap.engine.services.httpserver#J2EE_GUEST#0####b5a905603d1a11dd9c8000145e41f759#SAPEngine_Application_Thread[impl:3]_5##0#0#Error#1#/System/Server#Plain###User J2EE_GUEST, IP address HTTP request processing failed. HTTP error [401] will be returned. The error is [Cannot authenticate the user.No details available].# #1.5#00145E41F759005100000036000015BC00044FEDA9D5DB42#1213782081734#com.sap.engine.services.httpserver##com.sap.engine.services.httpserver#J2EE_GUEST#0####b5ab76603d1a11dd941000145e41f759#SAPEngine_Application_Thread[impl:3]_25##0#0#Error#1#/System/Server#Plain###User J2EE_GUEST, IP address HTTP request processing failed. HTTP error [401] will be returned. The error is [Cannot authenticate the user.No details available].# #1.5#00145E41F759005500000022000015BC00044FEDA9D62DE5#1213782081750#com.sap.engine.services.httpserver##com.sap.engine.services.httpserver#J2EE_GUEST#0####b5ade7603d1a11ddbf9f00145e41f759#SAPEngine_Application_Thread[impl:3]_1##0#0#Error#1#/System/Server#Plain###User J2EE_GUEST, IP address HTTP request processing failed. HTTP error [401] will be returned. The error is [Cannot authenticate the user.No details available].# #1.5#00145E41F759006C0000000A000015BC00044FEDA9D65B59#1213782081765#com.sap.engine.services.httpserver##com.sap.engine.services.httpserver#J2EE_GUEST#0####b5b031503d1a11ddcdd000145e41f759#SAPEngine_Application_Thread[impl:3]_4##0#0#Error#1#/System/Server#Plain###User J2EE_GUEST, IP address HTTP request processing failed. HTTP error [401] will be returned. The error is [Cannot authenticate the user.No details available].# #1.5#00145E41F759005400000011000015BC00044FEDA9D670CC#1213782081765#com.sap.aii.af.service.cpa.impl.servlet.CacheInvalidation#sap.com/com.sap.aii.af.cpa.app#com.sap.aii.af.service.cpa.impl.servlet.CacheInvalidation.init(ServletConfig)#J2EE_GUEST#0####b5a44a703d1a11ddb1ef00145e41f759#SAPEngine_Application_Thread[impl:3]_3##0#0#Error##Java###The AdatperFramework has not been registered to SLD after retries. Please restart the application com.sap.aii.service.cpa.monitor as soon as the SLD is available.#1#1#

#1.5#00145E41F759006B000000EB000015BC00044FEDA9E66758#1213782082812#com.sap.jms#sap.com/irj#com.sap.jms.server.sessioncontainer.InboundBus instance=default#J2EE_GUEST#0####9d4208103d1911dda55b00145e41f759#Thread[Thread-56,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error##Plain###com.sap.jms.server.exception.JMSServerSecurityException: Cannot create connection. User J2EE_ADMIN is locked.

at com.sap.jms.server.service.impl.SecurityServiceImpl.checkAuthentication(SecurityServiceImpl.java:451)

at com.sap.jms.server.sessioncontainer.handler.ConnectionHandler.onCreateRequest(ConnectionHandler.java:120)

at com.sap.jms.server.sessioncontainer.handler.ConnectionHandler.process(ConnectionHandler.java:69)

at com.sap.jms.server.sessioncontainer.InboundBus.process(InboundBus.java:143)

at com.sap.jms.server.sessioncontainer.InboundBus.enqueue(InboundBus.java:116)

at com.sap.jms.server.sessioncontainer.SessionContainer.receiveFromDispatcher(SessionContainer.java:63)

at com.sap.jms.server.routingcontainer.RoutingContainer.receiveFromDispatcher(RoutingContainer.java:447)

at com.sap.jms.server.JMSServerContainer.createConnection(JMSServerContainer.java:481)

at com.sap.jms.server.ServerClientAdapter.sendAndWait(ServerClientAdapter.java:87)

at com.sap.jms.client.connection.ConnectionFactory.sendConnectionCreateRequest(ConnectionFactory.java:412)

at com.sap.jms.client.connection.ConnectionFactory.createConnection(ConnectionFactory.java:356)

at com.sap.jms.client.connection.ConnectionFactory.createConnection(ConnectionFactory.java:257)

at com.sap.jms.client.connection.QueueConnectionFactory.createQueueConnection(QueueConnectionFactory.java:70)

at com.sap.ip.collaboration.core.api.rtmf.core.RTMFMessaging$JMSPolling.startRunning(RTMFMessaging.java:1128)

at com.sap.ip.collaboration.core.api.rtmf.core.RTMFMessaging$JMSPolling.run(RTMFMessaging.java:1069)

at java.lang.Thread.run(Thread.java:534)

Shivam

Former Member
0 Kudos

Hi,

Please check with your network administrator,whther he has make some change in the host or in the DNS.

and also try to login to the configtool,let me know what it is saying.

Thanks,

Satyabrat

Former Member
0 Kudos

Hi Satyabrat,

Thanks for your reply.

Checked with my network administrator ,No Change has been made in network setting.

Config tool is showing error message:

"Error occured while working with configuration(Scanning)"

"Msg-Error while connecting to DB"

Also restarted server several times but no improvement.

Please suggest.

Shivam

Former Member
0 Kudos

Hi,

Just I need to confirm what is the R3trans -d says in your ABAP stack.

Thanks,

Satyabrat

Former Member
0 Kudos

Hi,

Out of R3trans -d is:

This is R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 -


db call info -


2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

Shivam

Former Member
0 Kudos

Hi,

Some question to clear my doubt

Have u ran the R3trans -d from the userID SIDadm?

Did you have done any Database related activities,or changed the any of sap users properties present in operating system level?

Thanks,

Satyabrat

Former Member
0 Kudos

Hi,

Yes executed command by R3trans -d.

Not performed any database activity or have not made any change in any user configuration,

Output of trans.log:

4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 01.09.2008 - 15:03:32

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Sep 01 15:03:34 2008 5374 0.005374

4 ETW000 [dev trc ,00000] db_con_init called 64 0.005438

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 63 0.005501

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 53 0.005554

4 ETW000 [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 14481 0.020035

4 ETW000 [dev trc ,00000] using "D:\usr\sap\PRO\SYS\exe\run\dbmssslib.dll"

4 ETW000 64 0.020099

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 87 0.020186

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll

4 ETW000 48 0.020234

4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "640.00", patchlevel (0.43)

4 ETW000 3895 0.024129

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll

4 ETW000 12927 0.037056

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll

4 ETW000 54 0.037110

4 ETW000 [dev trc ,00000] New connection 0 created 13410 0.050520

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 56 0.050576

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 33 0.050609

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 45 0.050654

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 52 0.050706

4 ETW000 [dev trc ,00000] Thank You for using the SLOLEDB-interface 9515 0.060221

4 ETW000 [dev trc ,00000] Using dynamic link library 'D:\usr\sap\PRO\SYS\exe\run\dbmssslib.dll'

4 ETW000 104 0.060325

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 100 0.060425

4 ETW000 [dev trc ,00000] patchlevel 0 27 0.060452

4 ETW000 [dev trc ,00000] patchno 43 27 0.060479

4 ETW000 [dev trc ,00000] patchcomment View with literal containing (0x60) (786638)

4 ETW000 44 0.060523

4 ETW000 [dev trc ,00000] np:(local) connection used on SERVER2 90 0.060613

4 ETW000 [dev trc ,00000] Mon Sep 01 15:03:35 2008 192170 0.252783

4 ETW000 [dev trc ,00000] Failed to initialize provider SQLNCLI. See note #734034 for more information.

4 ETW000 68 0.252851

4 ETW000 [dev trc ,00000] Using provider SQLOLEDB instead. 27 0.252878

4 ETW000 [dev trc ,00000] OpenOledbConnection: Failed to set MARS property.

4 ETW000 216 0.253094

4 ETW000 [dev trc ,00000] Provider Release:08.50.1022 21250 0.274344

4 ETW000 [dev trc ,00000] Failed to initialize provider SQLNCLI. See note #734034 for more information.

4 ETW000 27874 0.302218

4 ETW000 [dev trc ,00000] Using provider SQLOLEDB instead. 30 0.302248

4 ETW000 [dev trc ,00000] OpenOledbConnection: Failed to set MARS property.

4 ETW000 189 0.302437

4 ETW000 [dev trc ,00000] Cache sizes: header 68 bytes, 100 names (157600 bytes), 100 dynamic statements (567200 bytes), total 724868 bytes

4 ETW000 3597 0.306034

4 ETW000 [dev trc ,00000] Initializing private procedure name cache. 31 0.306065

4 ETW000 [dev trc ,00000] procedure cache created/attached 35 0.306100

4 ETW000 [dev trc ,00000] Connected to db server : [SERVER2] server_used : [np:(local)], dbname: PRO, dbuser: SAPPRODB

4 ETW000 48 0.306148

4 ETW000 [dev trc ,00000] pn_id:SERVER2_PROSAPPRODB 26 0.306174

4 ETW000 [dev trc ,00000] Not using MARS (on sql 8.0) 30 0.306204

4 ETW000 [dev trc ,00000] Connection 0 opened 33 0.306237

4 ETW000 [dev trc ,00000] The IRow interface is supported by this OLEDB provider

4 ETW000 11058 0.317295

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 22757 0.340052

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 100 0.340152

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000001150335]

4 ETW000 45 0.340197

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.

4 ETW000 64 0.340261

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000001150335]

4 ETW000 44 0.340305

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT VERSION AS c FROM SVERS ]

4 ETW000 60 0.340365

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum: 112300

4 ETW000 47 0.340412

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on open 31 0.340443

4 ETW000 [dev trc ,00000] DbSlRead - <##Y3SERVER2SAPPRODB00000042640000000001150335>

4 ETW000 44 0.340487

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on fetch 27 0.340514

4 ETW000 [dev trc ,00000] DbSlRead - <##Y3SERVER2SAPPRODB00000042640000000001150335>

4 ETW000 44 0.340558

4 ETW000 [dblink ,01281] ***LOG BZA=>table SVERS does not exist on database [dblink#1 @ 1281]

4 ETW000 25087 0.365645

4 ETW000 [dev trc ,00000] Failed to initialize provider SQLNCLI. See note #734034 for more information.

4 ETW000 19414 0.385059

4 ETW000 [dev trc ,00000] Using provider SQLOLEDB instead. 40 0.385099

4 ETW000 [dev trc ,00000] OpenOledbConnection: Failed to set MARS property.

4 ETW000 238 0.385337

4 ETW000 [dev trc ,00000] DbSlBegRead[2]: ##Y3SERVER2SAPPRODB00000042640000000002150335

4 ETW000 5461 0.390798

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 941 0.391739

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 94 0.391833

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000002150335]

4 ETW000 69 0.391902

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 80 0.391982

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000002150335]

4 ETW000 57 0.392039

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT COMPCNT AS c FROM "DDNTT" ]

4 ETW000 76 0.392115

4 ETW000 [dev trc ,00000] Conn_i:2 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 222016

4 ETW000 66 0.392181

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED 59 0.392240

4 ETW000 [dev trc ,00000] DbSlBegRead[2]: ##Y3SERVER2SAPPRODB00000042640000000003150335

4 ETW000 126 0.392366

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 917 0.393283

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 81 0.393364

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000003150335]

4 ETW000 66 0.393430

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 82 0.393512

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000003150335]

4 ETW000 64 0.393576

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT VERSION AS c FROM "DDNTT" ]

4 ETW000 86 0.393662

4 ETW000 [dev trc ,00000] Conn_i:2 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 222014

4 ETW000 68 0.393730

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED 182 0.393912

4 ETW000 [dev trc ,00000] DbSlBegRead[2]: ##Y3SERVER2SAPPRODB00000042640000000004150335

4 ETW000 113 0.394025

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 961 0.394986

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 94 0.395080

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000004150335]

4 ETW000 67 0.395147

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 86 0.395233

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000004150335]

4 ETW000 66 0.395299

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT DBASE AS c FROM "DDNTT" ]

4 ETW000 84 0.395383

4 ETW000 [dev trc ,00000] Conn_i:2 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 222014

4 ETW000 68 0.395451

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED

4 ETW000 89 0.395540

4 ETW000 [dbntab ,01274] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#7 @ 12744]

4 ETW000 87 0.395627

4 ETW000 [dev trc ,00000] NTAB: standalone processing 99 0.395726

4 ETW000 [dev trc ,00000] NTAB: read profile 41 0.395767

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 38 0.395805

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 36 0.395841

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 37 0.395878

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 37 0.395915

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 51 0.395966

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 56 0.396022

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 37 0.396059

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 35 0.396094

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 42 0.396136

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 36 0.396172

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 44. 36 0.396208

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 36. 36 0.396244

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 34 0.396278

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 34 0.396312

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 34 0.396346

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 35 0.396381

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 44. 33 0.396414

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 36. 49 0.396463

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 34 0.396497

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 34 0.396531

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 40 0.396571

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 38 0.396609

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 44. 39 0.396648

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 36. 38 0.396686

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 39 0.396725

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 37 0.396762

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 40 0.396802

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 38 0.396840

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 148. 38 0.396878

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 24. 36 0.396914

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 39 0.396953

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 38 0.396991

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 38 0.397029

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 37 0.397066

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 3369b8, hh_len 44 1284 0.398350

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 1e86528, aa_len 8012 53 0.398403

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 1e88480, ia_len 36000 29 0.398432

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 1e93008, dat_len 512000 28 0.398460

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 33fd50, hh_len 44 27 0.398487

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 1f10010, aa_len 8012 27 0.398514

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 1f11f68, ia_len 9000 27 0.398541

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 1f14298, dat_len 102400 28 0.398569

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 33fd88, hh_len 44 27 0.398596

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 1f2d2a0, aa_len 8012 27 0.398623

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 1f2f1f8, ia_len 9000 27 0.398650

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 2d30048, dat_len 102400 28 0.398678

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 332b18, hh_len 148 27 0.398705

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 2d49050, aa_len 8012 27 0.398732

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 1f31528, ia_len 24000 28 0.398760

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 2d4afa8, dat_len 256000 27 0.398787

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 332b18, ntab_mp_p 332b18, ntab_proc_id 0

4 ETW000 53 0.398840

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 3369b8, ha_list 1e86528, hi_list 1e88480, buffer 1e93008

4 ETW000 87 0.398927

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 33fd50, ha_list 1f10010, hi_list 1f11f68, buffer 1f14298

4 ETW000 47 0.398974

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 33fd88, ha_list 1f2d2a0, hi_list 1f2f1f8, buffer 2d30048

4 ETW000 59 0.399033

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 332b80, ha_list 2d49050, hi_list 1f31528, buffer 2d4afa8

4 ETW000 47 0.399080

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000 29373 0.428453

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000 108 0.428561

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000 97 0.428658

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000 87 0.428745

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000005150335

4 ETW000 495 0.429240

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 1247 0.430487

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 90 0.430577

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000005150335]

4 ETW000 65 0.430642

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 86 0.430728

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000005150335]

4 ETW000 65 0.430793

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 111 0.430904

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 68 0.430972

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 94 0.431066

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000006150335

4 ETW000 146 0.431212

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 1019 0.432231

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 85 0.432316

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000006150335]

4 ETW000 62 0.432378

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 76 0.432454

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000006150335]

4 ETW000 12371 0.444825

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 79 0.444904

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 47 0.444951

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 73 0.445024

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000007150335

4 ETW000 102 0.445126

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 755 0.445881

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 61 0.445942

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000007150335]

4 ETW000 45 0.445987

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 55 0.446042

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000007150335]

4 ETW000 44 0.446086

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 62 0.446148

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.446194

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 64 0.446258

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000008150335

4 ETW000 93 0.446351

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 621 0.446972

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 59 0.447031

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000008150335]

4 ETW000 44 0.447075

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.447129

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000008150335]

4 ETW000 55 0.447184

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 62 0.447246

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.447292

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 63 0.447355

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000009150335

4 ETW000 92 0.447447

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 607 0.448054

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 59 0.448113

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000009150335]

4 ETW000 45 0.448158

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.448212

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000009150335]

4 ETW000 44 0.448256

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 61 0.448317

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.448363

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 63 0.448426

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000010150335

4 ETW000 90 0.448516

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 601 0.449117

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 58 0.449175

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000010150335]

4 ETW000 45 0.449220

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.449274

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000010150335]

4 ETW000 44 0.449318

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 7326 0.456644

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 48 0.456692

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 65 0.456757

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000011150335

4 ETW000 95 0.456852

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 652 0.457504

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 60 0.457564

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000011150335]

4 ETW000 45 0.457609

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.457663

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000011150335]

4 ETW000 45 0.457708

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 61 0.457769

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.457815

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 64 0.457879

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000012150335

4 ETW000 92 0.457971

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 607 0.458578

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 59 0.458637

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000012150335]

4 ETW000 45 0.458682

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 55 0.458737

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000012150335]

4 ETW000 44 0.458781

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 72 0.458853

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.458899

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 63 0.458962

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000013150335

4 ETW000 91 0.459053

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 603 0.459656

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 59 0.459715

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000013150335]

4 ETW000 45 0.459760

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.459814

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000013150335]

4 ETW000 44 0.459858

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 61 0.459919

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.459965

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 63 0.460028

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000014150335

4 ETW000 91 0.460119

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 615 0.460734

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 60 0.460794

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000014150335]

4 ETW000 45 0.460839

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.460893

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000014150335]

4 ETW000 44 0.460937

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 145 0.461082

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 47 0.461129

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 65 0.461194

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000015150335

4 ETW000 93 0.461287

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 627 0.461914

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 60 0.461974

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000015150335]

4 ETW000 45 0.462019

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.462073

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000015150335]

4 ETW000 44 0.462117

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 61 0.462178

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.462224

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 64 0.462288

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000016150335

4 ETW000 91 0.462379

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 596 0.462975

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 59 0.463034

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000016150335]

4 ETW000 45 0.463079

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.463133

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000016150335]

4 ETW000 44 0.463177

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 72 0.463249

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.463295

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 63 0.463358

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000017150335

4 ETW000 91 0.463449

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 600 0.464049

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 58 0.464107

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000017150335]

4 ETW000 45 0.464152

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.464206

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000017150335]

4 ETW000 44 0.464250

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 61 0.464311

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 47 0.464358

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 62 0.464420

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000018150335

4 ETW000 91 0.464511

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 599 0.465110

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 59 0.465169

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000018150335]

4 ETW000 45 0.465214

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.465268

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000018150335]

4 ETW000 44 0.465312

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 61 0.465373

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 20466 0.485839

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 71 0.485910

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000019150335

4 ETW000 97 0.486007

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 711 0.486718

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 60 0.486778

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000019150335]

4 ETW000 45 0.486823

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.486877

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000019150335]

4 ETW000 45 0.486922

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 62 0.486984

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 46 0.487030

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 65 0.487095

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y3SERVER2SAPPRODB00000042640000000020150335

4 ETW000 93 0.487188

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 614 0.487802

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 58 0.487860

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000020150335]

4 ETW000 45 0.487905

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXF'.

4 ETW000 54 0.487959

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000020150335]

4 ETW000 44 0.488003

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TABNAME AS c, BLOCKNR AS c, FIELDSLG AS c, FIELDS AS c FROM "XXXXF" WHERE TABNAME = ? ORDER BY TABNAME, BLOCKNR ]

4 ETW000 61 0.488064

4 ETW000 [dev trc ,00000] Conn_i:0 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 55031

4 ETW000 56 0.488120

4 ETW000 [dbntab ,01025] ***LOG BZY=>unexpected return code 103 calling DbSlBegRd [dbntab#7 @ 10253]

4 ETW000 65 0.488185

4 ETW000 [dev trc ,00000] ParamStmtExec: line 11888. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 878 0.489063

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 59 0.489122

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000021150335]

4 ETW000 45 0.489167

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 11888]: Error/Message: (err 208, sev 16), Invalid object name 'XXXXT'.

4 ETW000 54 0.489221

4 ETW000 [dev trc ,00000] Procname: [##Y3SERVER2SAPPRODB00000042640000000021150335]

4 ETW000 45 0.489266

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT VERSION AS c, UUID AS c, CRTIMESTMP AS c, ABTIMESTMP AS c, DYTIMESTMP AS c, FLDCNT AS c, TABLENGTH AS c, KEYCNT AS c, KEYLENGTH AS c, CLIENTPOS AS c, TABTYPE AS c, TABFORM AS c, REFNAME AS c, HFLAG AS c, BUFSTATE AS c, BUFPARM AS c, ALIGN AS c, POINTERLG AS c, UNICODELG AS c, COMPCNT AS c, LEAFCNT AS c FROM "XXXXT" WHERE TABNAME = ? ]

4 ETW000 78 0.489344

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum: 112703

4 ETW000 46 0.489390

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on open 29 0.489419

4 ETW000 [dev trc ,00000] DbSlRead - <##Y3SERVER2SAPPRODB00000042640000000021150335>

4 ETW000 45 0.489464

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on fetch 27 0.489491

4 ETW000 [dev trc ,00000] DbSlRead - <##Y3SERVER2SAPPRODB00000042640000000021150335>

4 ETW000 44 0.489535

4 ETW000 [dbntab ,01000] ***LOG BZY=>unexpected return code 103 calling DbSlRead [dbntab#7 @ 10007]

4 ETW000 63 0.489598

2EETW000 sap_dext called with msgnr "2":

2EETW000 -


db call info -


2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)

4 ETW000 2044 0.491642

4 ETW000 [dev trc ,00000] Rollback Work (0) 654 0.492296

4 ETW000 [dev trc ,00000] Rollback: TestConnection(1) successful 412 0.492708

4 ETW000 ROLLBACK (0).

Former Member
0 Kudos

Hi Shivam,

check the environment variable of the user SIDadm.

MSSQL_SCHEMA=<sid>

MSSQL_DBNAME=<SID>

MSSQL_SERVER=<sql_server_name>

DBMS_TYPE=mss

Thanks,

Satyabrat

Edited by: Satyabrat Mohanty on Sep 1, 2008 12:46 PM

Edited by: Satyabrat Mohanty on Sep 1, 2008 12:48 PM

Former Member
0 Kudos

Hi,

All env varaibles are correct.How can i check that whether my jdbc drivsers has expired.

Please suggest.

Shivam