Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question SQL server integrated security for runtime logs

More
06 Jan 2020 17:33 #1 by cbouin
SQL server integrated security for runtime logs was created by cbouin
Hello,

I'm trying to connect the runtime to a microsoft sql server, using integrated security (windows service is running with a dedicated AD account).
I works fine with an sql account.

I found this topic: https://stambia.org/forum/general-questions/183-connect-to-sql-server-database-using-windows-authentication-ad-authentication-in-stambia

I made these changes on the runtime:
  • updated engineparameter.xml
    • changed jdbc connection string
    • removed sql login
    • removed sql password
  • copied sqljdbc_auth.dll
  • copied sqljdbc42.jar
  • restarted windows

I can't make it work.

The designer cannot connect, and here is the message found in "com.indy.engine.42000.log":
06/01/2020 16:42:35,831 INFO  - Runtime version: s17.6.8_20191008
06/01/2020 16:42:35,831 INFO  - Java version: 1.8.0_231 vendor: Oracle Corporation home: D:\Stambia\Java\jdk1.8.0_231\jre
06/01/2020 16:42:35,831 INFO  - 0   : Engine Server : main : starting engine
06/01/2020 16:42:35,878 INFO  - 0   : EngineServerI=>startH2InternalBase() : starting internal Database !
06/01/2020 16:42:36,391 INFO  - Internal Database is started: APPETLRE701:42100
06/01/2020 16:42:36,391 INFO  - 0   : EngineServerI=>startH2InternalBase() : TCP server running on tcp://10.150.4.125:42100 (others can connect)
06/01/2020 16:42:36,530 INFO  - Internal Database Web Server is started: http://APPETLRE701:42101
06/01/2020 16:42:36,530 INFO  - 0   : EngineServerI=>startH2InternalBase() : Web server running on http://10.150.4.125:42101 (others can connect)
06/01/2020 16:42:36,530 INFO  - 0   : EngineServerI=>startH2InternalBase() : Internal Database started!
06/01/2020 16:42:36,530 INFO  - 0   : EngineServerI=>prepareSystemDatabase() : preparing internal Database !
06/01/2020 16:42:36,530 INFO  - 0   : EngineServerI=>prepareSystemDatabase() : Internal Database prepared!
06/01/2020 16:42:36,530 INFO  - 0   : EngineServerI() : Starting report engine...
06/01/2020 16:42:36,546 DEBUG - 0   : ReportEngineServer : ReportLogEngineI --> fillLstLogManager()           : Gettings logs Manager...
06/01/2020 16:42:36,546 DEBUG - 2   : ReportEngineServer : ReportLogManagerI()                                : Report Log Class : com.indy.engine.userLog.RdbmsUserLog
06/01/2020 16:42:36,609 ERROR - Error during Log initialization
com.indy.engine.common.exceptions.EngineExceptionI: Problems getting the log parameters
	at com.indy.engine.userLog.RdbmsUserLog.setParameters(SourceFile:1939)
	at com.indy.engine.userLog.RdbmsUserLog.initLog(SourceFile:1472)
	at com.indy.engine.userLog.a.c.a(SourceFile:71)
	at com.indy.engine.userLog.a.a.b(SourceFile:205)
	at com.indy.engine.h.c(SourceFile:132)
	at com.indy.engine.EngineStartI.main(SourceFile:335)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:53)
	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:36)
Caused by: com.indy.engine.common.exceptions.EngineExceptionI: com.indy.engine.common.exceptions.EngineExceptionI: UserLogI->getProperty, Missing parameter : userLogRdbmsUser
	at com.indy.engine.userLog.n.getProperty(SourceFile:269)
	at com.indy.engine.userLog.RdbmsUserLog.setParameters(SourceFile:1902)
	... 11 more
Caused by: com.indy.engine.common.exceptions.EngineExceptionI: UserLogI->getProperty, Missing parameter : userLogRdbmsUser
	at com.indy.engine.userLog.n.getProperty(SourceFile:260)
	... 12 more

Here is the engineParameters logs section:
			<log userLogName="logDatabase" autoUpdate="true" userLogClass="com.indy.engine.userLog.RdbmsUserLog">
				<parameter name="userLogRdbmsDriver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
				<parameter name="userLogRdbmsUrl" value="jdbc:sqlserver://stambiatestserver:2544;integratedSecurity=true;"/>
				<parameter name="userLogRdbmsVarcharType" value="varchar"/>
				<parameter name="userLogRdbmsVarcharMaxSize" value="1000"/>
				<parameter name="userLogRdbmsNumericType" value="numeric"/>
				<parameter name="userLogRdbmsClobType" value="text"/>
				<parameter name="userLogRdbmsBlobType" value="image"/>
				<parameter name="userLogRdbmsSchemaName" value="StambiaRuntime.dbo"/>
				<parameter name="userLogRdbmsDeleteSyntaxe" value="Delete from"/>
				<parameter name="userLogRdbmsUseSchemaNameForIndexCreation" value="false"/>
				<parameter name="userLogRdbmsCompressedLevel" value="bestCompression"/>
				<parameter name="userLogRdbmsDeliveryFormat" value="compressed"/>
				<parameter name="userLogRdbmsPropertyMaxVarcharSize" value="1000"/>
				<parameter name="userLogRdbmsPropertyMaxClobSize" value="10000"/>
				<parameter name="userLogRdbmsPropertyBinaryFormat" value="compressed"/>
			</log>

Can you please advice?
More
07 Jan 2020 11:28 #2 by Thomas BLETON
Replied by Thomas BLETON on topic SQL server integrated security for runtime logs
Hi,

Can you try to leave the lines for user and password in the file ?
Just leave them with the empty value "".

<parameter name="userLogRdbmsUser" value=""/>
<parameter name="userLogRdbmsPassword" value=""/>

=> is it better ?
More
09 Jan 2020 10:58 #3 by cbouin
Replied by cbouin on topic SQL server integrated security for runtime logs
Hello, it looks better, but still crashes.

The logs in com.indy.engine.42000.log loops on these entries, then runtime stops:
09/01/2020 10:48:56,944 INFO  - Runtime version: s17.6.8_20191008
09/01/2020 10:48:56,944 INFO  - Java version: 1.8.0_231 vendor: Oracle Corporation home: D:\Stambia\Java\jdk1.8.0_231\jre
09/01/2020 10:48:56,944 INFO  - 0   : Engine Server : main : starting engine
09/01/2020 10:48:56,975 INFO  - 0   : EngineServerI=>startH2InternalBase() : starting internal Database !
09/01/2020 10:48:57,489 INFO  - Internal Database is started: APPETLRE701:42100
09/01/2020 10:48:57,489 INFO  - 0   : EngineServerI=>startH2InternalBase() : TCP server running on tcp://10.150.4.125:42100 (others can connect)
09/01/2020 10:48:57,642 INFO  - Internal Database Web Server is started: http://APPETLRE701:42101
09/01/2020 10:48:57,642 INFO  - 0   : EngineServerI=>startH2InternalBase() : Web server running on http://10.150.4.125:42101 (others can connect)
09/01/2020 10:48:57,642 INFO  - 0   : EngineServerI=>startH2InternalBase() : Internal Database started!
09/01/2020 10:48:57,642 INFO  - 0   : EngineServerI=>prepareSystemDatabase() : preparing internal Database !
09/01/2020 10:48:57,642 INFO  - 0   : EngineServerI=>prepareSystemDatabase() : Internal Database prepared!
09/01/2020 10:48:57,642 INFO  - 0   : EngineServerI() : Starting report engine...
09/01/2020 10:48:57,657 DEBUG - 0   : ReportEngineServer : ReportLogEngineI --> fillLstLogManager()           : Gettings logs Manager...
09/01/2020 10:48:57,657 DEBUG - 2   : ReportEngineServer : ReportLogManagerI()                                : Report Log Class : com.indy.engine.userLog.RdbmsUserLog
09/01/2020 10:48:57,736 DEBUG - 4   : RdbmsUserLogI=>getVersion : Getting log version ...
09/01/2020 10:49:10,579 WARN  - 0   : Init : Global->InitInternalRessources                     : Can't find resource for bundle java.util.PropertyResourceBundle, key VAR_PREFIXE
09/01/2020 10:49:10,579 INFO  - 0   : Init : Global->printParametersToDebugLog                  : 
--> defaultBatchSize :1000
--> defaultFetchSize :1000
--> deliveryExtension :deliv
--> deliveryFolder :
--> javaSecurityPolicy :properties/security.policy
--> memoryLogCacheDelay :30000
--> memoryLogScanDelay :10000
--> rmiPort :42000
--> rmiName :EngineServerAPI
--> rmiHost :APPETLRE701
--> sessionFolder :
--> userLogDefaultName :logDatabase
Debug informations : 400
--> logLevel :400
--> logMode :INFO & DEBUG & ERROR & WARNING

I can find this in com.indy.engine.42000.rdbmsLog.log:
09/01/2020 10:47:55,230 INFO  - connectionMulti(1578563275230) Connecting...
09/01/2020 10:47:55,308 INFO  - free[0] busy[0] droping[0]
09/01/2020 10:48:15,975 INFO  - connectionMulti(1578563295975) Connecting...
09/01/2020 10:48:16,038 INFO  - free[0] busy[0] droping[0]
09/01/2020 10:48:30,317 INFO  - connectionMulti(1578563310317) Connecting...
09/01/2020 10:48:30,379 INFO  - free[0] busy[0] droping[0]
09/01/2020 10:48:44,248 INFO  - connectionMulti(1578563324248) Connecting...
09/01/2020 10:48:44,404 INFO  - free[0] busy[0] droping[0]
09/01/2020 10:48:57,736 INFO  - connectionMulti(1578563337736) Connecting...
09/01/2020 10:48:57,845 INFO  - free[0] busy[0] droping[0]
09/01/2020 10:49:11,492 INFO  - connectionMulti(1578563351492) Connecting...
09/01/2020 10:49:11,585 INFO  - free[0] busy[0] droping[0]

and this in com.indy.engine.service.log.0:
INFO|wrapper|20-01-09 10:49:02|restart process due to default exit code rule
INFO|wrapper|20-01-09 10:49:02|set state RUNNING->RESTART
INFO|wrapper|20-01-09 10:49:02|set state RESTART->RESTART_STOP
INFO|wrapper|20-01-09 10:49:02|stopping process with pid/timeout 3412 45000
INFO|wrapper|20-01-09 10:49:02|Controller State: PROCESS_KILLED -> USER_STOP
INFO|wrapper|20-01-09 10:49:02|stop config name null
INFO|wrapper|20-01-09 10:49:02|externalStop false
INFO|wrapper|20-01-09 10:49:03|process destroyed -1
INFO|wrapper|20-01-09 10:49:03|process exit code: 1
INFO|wrapper|20-01-09 10:49:03|set state RESTART_STOP->RESTART_WAIT
INFO|3412/4|20-01-09 10:49:03|gobler terminated OUTPUT 3412
INFO|3412/4|20-01-09 10:49:03|gobler terminated ERROR 3412
INFO|wrapper|20-01-09 10:49:08|set state RESTART_WAIT->RESTART_START
INFO|wrapper|20-01-09 10:49:08|starting Process
INFO|wrapper|20-01-09 10:49:08|Controller State: USER_STOP -> UNKNOWN
INFO|wrapper|20-01-09 10:49:08|Controller State: UNKNOWN -> WAITING
INFO|wrapper|20-01-09 10:49:08|working dir D:\Stambia\Runtime\external\stambiaService\.\..\..
INFO|wrapper|20-01-09 10:49:08|started process with pid 6116
INFO|wrapper|20-01-09 10:49:08|set state RESTART_START->RUNNING
INFO|6116/5|20-01-09 10:49:09|log4j:WARN No appenders could be found for logger (org.apache.commons.vfs.impl.DefaultFileReplicator).
INFO|6116/5|20-01-09 10:49:09|log4j:WARN Please initialize the log4j system properly.
INFO|6116/5|20-01-09 10:49:09|log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
INFO|6116/5|20-01-09 10:49:10|external stop false
INFO|wrapper|20-01-09 10:49:10|Controller State: WAITING -> ESTABLISHED
INFO|wrapper|20-01-09 10:49:10|Controller State: ESTABLISHED -> LOGGED_ON
INFO|6116/5|20-01-09 10:49:11|09/01/2020 10:49:10,751 - Runtime version: s17.6.8_20191008
INFO|6116/5|20-01-09 10:49:11|09/01/2020 10:49:10,751 - Java version: 1.8.0_231 vendor: Oracle Corporation home: D:\Stambia\Java\jdk1.8.0_231\jre
INFO|6116/5|20-01-09 10:49:11|09/01/2020 10:49:11,340 - Internal Database is started: APPETLRE701:42100
INFO|6116/5|20-01-09 10:49:11|09/01/2020 10:49:11,367 - Internal Database Web Server is started: http://APPETLRE701:42101
INFO|wrapper|20-01-09 10:49:12|Controller State: LOGGED_ON -> WAITING_CLOSED
INFO|wrapper|20-01-09 10:49:12|Controller State: WAITING_CLOSED -> PROCESS_KILLED
INFO|wrapper|20-01-09 10:49:12|too many restarts 
INFO|wrapper|20-01-09 10:49:12|set state RUNNING->STATE_ABORT
INFO|wrapper|20-01-09 10:49:12|set state STATE_ABORT->IDLE
INFO|wrapper|20-01-09 10:49:12|calling onStop
More
10 Jan 2020 14:45 #4 by Thomas BLETON
Replied by Thomas BLETON on topic SQL server integrated security for runtime logs
The files com.indy.engine.42000.log and com.indy.engine.42000.rdbmsLog.log seem to be normal.
The file com.indy.engine.service.log.0 mentions a PROCESS_KILLED. This log is corresponding to the Windows Service output.

Is there anything else above the first line that you copied ?
INFO|wrapper|20-01-09 10:49:02|restart process due to default exit code rule
More
10 Jan 2020 15:51 #5 by cbouin
Replied by cbouin on topic SQL server integrated security for runtime logs
In addition, here i sthe output of the startengine when ran from command line:
D:\Stambia\Runtime>cmd /c startengine.bat

D:\Stambia\Runtime>echo off
10/01/2020 15:23:41,064 - Runtime version: s17.6.8_20191008
10/01/2020 15:23:41,064 - Java version: 1.8.0_231 vendor: Oracle Corporation home: D:\Stambia\Java\jdk1.8.0_231\jre
10/01/2020 15:23:41,862 - Internal Database is started: APPETLRE701:42100
10/01/2020 15:23:41,939 - Internal Database Web Server is started: http://APPETLRE701:42101
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0000000070ccf713, pid=2296, tid=0x00000000000006c4
#
# JRE version: Java(TM) SE Runtime Environment (8.0_231-b11) (build 1.8.0_231-b11)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.231-b11 mixed mode windows-amd64 compressed oops)
# Problematic frame:
# V  [jvm.dll+0x13f713]
#
# Core dump written. Default location: D:\Stambia\Runtime\hs_err_pid2296.mdmp
#
# An error report file with more information is saved as:
# D:\Stambia\Runtime\hs_err_pid2296.log
#
# If you would like to submit a bug report, please visit:
#   http://bugreport.java.com/bugreport/crash.jsp
#

And a dump is generated, with this associated log file :
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0000000070ccf713, pid=84, tid=0x0000000000001940
#
# JRE version: Java(TM) SE Runtime Environment (8.0_231-b11) (build 1.8.0_231-b11)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.231-b11 mixed mode windows-amd64 compressed oops)
# Problematic frame:
# V  [jvm.dll+0x13f713]
#
# Core dump written. Default location: D:\Stambia\Runtime\hs_err_pid84.mdmp
#
# If you would like to submit a bug report, please visit:
#   http://bugreport.java.com/bugreport/crash.jsp
#

---------------  T H R E A D  ---------------

Current thread (0x00000000024fe000):  JavaThread "RuntimeMainThread" [_thread_in_vm, id=6464, stack(0x0000000000ac0000,0x0000000000b00000)]

siginfo: ExceptionCode=0xc0000005, reading address 0x0000000386eb14e8

Registers:
RAX=0x0000000000000000, RBX=0x00000000024fe000, RCX=0x0000000000000003, RDX=0x0000000386eb1480
RSP=0x0000000000afe3e0, RBP=0x0000000000afe530, RSI=0x00000000024fe1f8, RDI=0x00000000024fe000
R8 =0xffff8006d656d720, R9 =0x00007ff929a9290f, R10=0x000000000000002f, R11=0x000000000000002f
R12=0x0000000000000000, R13=0x0000000000000000, R14=0x0000000000afe778, R15=0x0000000000afe748
RIP=0x0000000070ccf713, EFLAGS=0x0000000000010202

Top of Stack: (sp=0x0000000000afe3e0)
0x0000000000afe3e0:   00007ff929a928e0 00000000024fe000
0x0000000000afe3f0:   0000000000afe530 0000000000000000
0x0000000000afe400:   00000000024fe000 0000000000000000
0x0000000000afe410:   0000000000000000 0000000000000000
0x0000000000afe420:   000000001299cf50 00007ff929a83017
0x0000000000afe430:   00000000024fe1f8 0000000000afe530
0x0000000000afe440:   00000000024fe000 00000000026d1aa0
0x0000000000afe450:   0000000000000000 00000000026d1b97
0x0000000000afe460:   00000000026d1ea0 0000000000000000
0x0000000000afe470:   0000000000000000 0000000000000000
0x0000000000afe480:   00000000026d1aa0 0000000002010000
0x0000000000afe490:   0000000000000000 0000000000000000
0x0000000000afe4a0:   0000000000000000 0000000000000000
0x0000000000afe4b0:   0000000000000000 0000000000000000
0x0000000000afe4c0:   0000000000000000 0000000000afe760
0x0000000000afe4d0:   0000000000afe780 0000000000afe748 

Instructions: (pc=0x0000000070ccf713)
0x0000000070ccf6f3:   00 00 48 8b 17 74 15 8b 52 08 8b 0d 65 b1 66 00
0x0000000070ccf703:   48 d3 e2 48 03 15 53 b1 66 00 eb 04 48 8b 52 08
0x0000000070ccf713:   48 8b 52 68 48 8b ce e8 71 85 0d 00 48 83 7c 24
0x0000000070ccf723:   28 00 48 8b f0 74 0a 48 8d 4c 24 20 e8 7c f7 13 


Register to memory mapping:

RAX=0x0000000000000000 is an unknown value
RBX=0x00000000024fe000 is a thread
RCX=0x0000000000000003 is an unknown value
RDX=0x0000000386eb1480 is an unknown value
RSP=0x0000000000afe3e0 is pointing into the stack for thread: 0x00000000024fe000
RBP=0x0000000000afe530 is pointing into the stack for thread: 0x00000000024fe000
RSI=0x00000000024fe1f8 is an unknown value
RDI=0x00000000024fe000 is a thread
R8 =0xffff8006d656d720 is an unknown value
R9 =0x00007ff929a9290f is an unknown value
R10=0x000000000000002f is an unknown value
R11=0x000000000000002f is an unknown value
R12=0x0000000000000000 is an unknown value
R13=0x0000000000000000 is an unknown value
R14=0x0000000000afe778 is pointing into the stack for thread: 0x00000000024fe000
R15=0x0000000000afe748 is pointing into the stack for thread: 0x00000000024fe000


Stack: [0x0000000000ac0000,0x0000000000b00000],  sp=0x0000000000afe3e0,  free space=248k
Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
V  [jvm.dll+0x13f713]
C  [sqljdbc_auth.dll+0x3017]
C  0x0000000002688bc7

Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)
j  com.microsoft.sqlserver.jdbc.AuthenticationJNI.SNISecGenClientContext([B[I[BI[B[I[ZLjava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/logging/Logger;)I+0
j  com.microsoft.sqlserver.jdbc.AuthenticationJNI.GenerateClientContext([BI[B[I[Z)I+24
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.SSPIData([B[B[I[ZLcom/microsoft/sqlserver/jdbc/AuthenticationJNI;)V+13
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Lcom/microsoft/sqlserver/jdbc/SQLServerConnection$LogonCommand;Lcom/microsoft/sqlserver/jdbc/AuthenticationJNI;)V+155
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Lcom/microsoft/sqlserver/jdbc/SQLServerConnection$LogonCommand;)V+20
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Lcom/microsoft/sqlserver/jdbc/SQLServerConnection;Lcom/microsoft/sqlserver/jdbc/SQLServerConnection$LogonCommand;)V+2
j  com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute()Z+5
j  com.microsoft.sqlserver.jdbc.TDSCommand.execute(Lcom/microsoft/sqlserver/jdbc/TDSWriter;Lcom/microsoft/sqlserver/jdbc/TDSReader;)Z+30
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Lcom/microsoft/sqlserver/jdbc/TDSCommand;)Z+45
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Lcom/microsoft/sqlserver/jdbc/ServerPortPlaceHolder;II)V+284
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.login(Ljava/lang/String;Ljava/lang/String;ILjava/lang/String;Lcom/microsoft/sqlserver/jdbc/FailoverInfo;IJ)V+399
j  com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Ljava/util/Properties;Lcom/microsoft/sqlserver/jdbc/SQLServerPooledConnection;)Ljava/sql/Connection;+1929
j  com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;+45
j  com.indy.runtime.jdbc.JdbcDataSource.connectWithStandardJdbc(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+150
j  com.indy.runtime.jdbc.JdbcDataSource.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;+13
j  com.indy.runtime.jdbc.JdbcDataSource.getConnection()Ljava/sql/Connection;+9
j  com.indy.engine.userLog.b.b.d()Z+202
j  com.indy.engine.userLog.b.b.b()Z+36
j  com.indy.engine.userLog.b.a.a(Z)Ljava/sql/Connection;+138
j  com.indy.engine.userLog.RdbmsUserLog.getConnection(ZZ)Ljava/sql/Connection;+9
j  com.indy.engine.userLog.e.a()Ljava/lang/String;+57
j  com.indy.engine.userLog.RdbmsUserLog.connect()Z+8
j  com.indy.engine.userLog.a.c.c()V+4
j  com.indy.engine.userLog.a.a.b()I+108
j  com.indy.engine.h.c()V+29
j  com.indy.engine.EngineStartI.main([Ljava/lang/String;)V+645
v  ~StubRoutines::call_stub

---------------  P R O C E S S  ---------------

Java Threads: ( => current thread )
  0x0000000014695000 JavaThread "ConnectionCleaner" [_thread_blocked, id=3752, stack(0x0000000015b40000,0x0000000015b80000)]
  0x00000000146a9800 JavaThread "H2 Console Server (http://10.150.4.125:42101)" [_thread_in_native, id=3756, stack(0x0000000015a80000,0x0000000015ac0000)]
  0x00000000146ad000 JavaThread "H2 TCP Server (tcp://10.150.4.125:42100)" [_thread_in_native, id=1120, stack(0x0000000015940000,0x0000000015980000)]
  0x0000000012aba800 JavaThread "Service Thread" daemon [_thread_blocked, id=5116, stack(0x0000000012f20000,0x0000000012f60000)]
  0x0000000012ab5000 JavaThread "C1 CompilerThread1" daemon [_thread_blocked, id=5176, stack(0x0000000012e20000,0x0000000012f20000)]
  0x0000000012a5b800 JavaThread "C2 CompilerThread0" daemon [_thread_blocked, id=4012, stack(0x0000000012d20000,0x0000000012e20000)]
  0x0000000012a59800 JavaThread "Attach Listener" daemon [_thread_blocked, id=1108, stack(0x0000000012ce0000,0x0000000012d20000)]
  0x0000000012a58800 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=6716, stack(0x0000000002500000,0x0000000002540000)]
  0x00000000129cc000 JavaThread "Finalizer" daemon [_thread_blocked, id=1964, stack(0x0000000002490000,0x00000000024d0000)]
  0x00000000129c2800 JavaThread "Reference Handler" daemon [_thread_blocked, id=4768, stack(0x0000000002450000,0x0000000002490000)]
=>0x00000000024fe000 JavaThread "RuntimeMainThread" [_thread_in_vm, id=6464, stack(0x0000000000ac0000,0x0000000000b00000)]

Other Threads:
  0x000000001299c000 VMThread [stack: 0x0000000012af0000,0x0000000012bf0000] [id=4516]
  0x0000000012ad0800 WatcherThread [stack: 0x0000000012f60000,0x0000000013060000] [id=5784]

VM state:synchronizing (normal execution)

VM Mutex/Monitor currently owned by a thread:  ([mutex/lock_event])
[0x00000000024fd1d0] Threads_lock - owner thread: 0x000000001299c000

heap address: 0x0000000080000000, size: 2048 MB, Compressed Oops mode: 32-bit
Narrow klass base: 0x0000000000000000, Narrow klass shift: 3
Compressed class space size: 1073741824 Address: 0x0000000100000000

Heap:
 def new generation   total 314560K, used 123063K [0x0000000080000000, 0x0000000095550000, 0x00000000aaaa0000)
  eden space 279616K,  44% used [0x0000000080000000, 0x000000008782df90, 0x0000000091110000)
  from space 34944K,   0% used [0x0000000091110000, 0x0000000091110000, 0x0000000093330000)
  to   space 34944K,   0% used [0x0000000093330000, 0x0000000093330000, 0x0000000095550000)
 tenured generation   total 699072K, used 0K [0x00000000aaaa0000, 0x00000000d5550000, 0x0000000100000000)
   the space 699072K,   0% used [0x00000000aaaa0000, 0x00000000aaaa0000, 0x00000000aaaa0200, 0x00000000d5550000)
 Metaspace       used 18365K, capacity 18590K, committed 18944K, reserved 1067008K
  class space    used 2112K, capacity 2198K, committed 2304K, reserved 1048576K

Card table byte_map: [0x0000000011a30000,0x0000000011e40000] byte_map_base: 0x0000000011630000

Polling page: 0x0000000000b00000

CodeCache: size=245760Kb used=6046Kb max_used=6056Kb free=239713Kb
 bounds [0x0000000002670000, 0x0000000002c60000, 0x0000000011670000]
 total_blobs=2141 nmethods=1694 adapters=359
 compilation: enabled

Compilation events (10 events):
Event: 2.784 Thread 0x0000000012ab5000 1694       3       com.sun.crypto.provider.AESCrypt::mul4 (181 bytes)
Event: 2.784 Thread 0x0000000012ab5000 nmethod 1694 0x0000000002c58c90 code [0x0000000002c58e40, 0x0000000002c593f0]
Event: 2.784 Thread 0x0000000012a5b800 1689       4       sun.security.provider.MD5::FF (33 bytes)
Event: 2.784 Thread 0x0000000012a5b800 nmethod 1689 0x0000000002c58a90 code [0x0000000002c58bc0, 0x0000000002c58c38]
Event: 2.784 Thread 0x0000000012a5b800 1690       4       sun.security.provider.MD5::GG (33 bytes)
Event: 2.784 Thread 0x0000000012a5b800 nmethod 1690 0x0000000002c58890 code [0x0000000002c589c0, 0x0000000002c58a38]
Event: 2.784 Thread 0x0000000012a5b800 1691       4       sun.security.provider.MD5::HH (29 bytes)
Event: 2.785 Thread 0x0000000012a5b800 nmethod 1691 0x0000000002c58690 code [0x0000000002c587c0, 0x0000000002c58838]
Event: 2.785 Thread 0x0000000012a5b800 1692       4       sun.security.provider.MD5::II (31 bytes)
Event: 2.785 Thread 0x0000000012a5b800 nmethod 1692 0x0000000002c58490 code [0x0000000002c585c0, 0x0000000002c58638]

GC Heap History (0 events):
No events

Deoptimization events (10 events):
Event: 2.061 Thread 0x00000000024fe000 Uncommon trap: reason=unstable_if action=reinterpret pc=0x0000000002b12824 method=java.util.regex.Pattern$BmpCharProperty.match(Ljava/util/regex/Matcher;ILjava/lang/CharSequence;)Z @ 5
Event: 2.142 Thread 0x00000000024fe000 Uncommon trap: reason=unstable_if action=reinterpret pc=0x0000000002838dc8 method=java.io.WinNTFileSystem.normalize(Ljava/lang/String;)Ljava/lang/String; @ 128
Event: 2.674 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x000000000296127c method=java.util.regex.Pattern$Slice.match(Ljava/util/regex/Matcher;ILjava/lang/CharSequence;)Z @ 75
Event: 2.714 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000002c4761c method=sun.security.util.math.intpoly.IntegerPolynomial$MutableElement.setSum(Lsun/security/util/math/IntegerModuloP;)Lsun/security/util/math/intpoly/IntegerPolynomial$MutableE
Event: 2.714 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000002c4761c method=sun.security.util.math.intpoly.IntegerPolynomial$MutableElement.setSum(Lsun/security/util/math/IntegerModuloP;)Lsun/security/util/math/intpoly/IntegerPolynomial$MutableE
Event: 2.714 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000002c4761c method=sun.security.util.math.intpoly.IntegerPolynomial$MutableElement.setSum(Lsun/security/util/math/IntegerModuloP;)Lsun/security/util/math/intpoly/IntegerPolynomial$MutableE
Event: 2.714 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000002c4761c method=sun.security.util.math.intpoly.IntegerPolynomial$MutableElement.setSum(Lsun/security/util/math/IntegerModuloP;)Lsun/security/util/math/intpoly/IntegerPolynomial$MutableE
Event: 2.752 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x000000000296127c method=java.util.regex.Pattern$Slice.match(Ljava/util/regex/Matcher;ILjava/lang/CharSequence;)Z @ 75
Event: 2.752 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x000000000296127c method=java.util.regex.Pattern$Slice.match(Ljava/util/regex/Matcher;ILjava/lang/CharSequence;)Z @ 75
Event: 2.752 Thread 0x00000000024fe000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x000000000296127c method=java.util.regex.Pattern$Slice.match(Ljava/util/regex/Matcher;ILjava/lang/CharSequence;)Z @ 75

Classes redefined (0 events):
No events

Internal exceptions (10 events):
Event: 0.725 Thread 0x00000000024fe000 Exception <a 'java/lang/ClassNotFoundException': org/apache/log4j/PatternLayoutCustomizer> (0x0000000081bdc1d0) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\classfile\systemDictionary.cpp, line 210]
Event: 0.848 Thread 0x00000000024fe000 Exception <a 'java/lang/ClassNotFoundException': com/sun/org/glassfish/hk2/osgiresourcelocator/ServiceLoader> (0x0000000081e323c0) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\classfile\systemDictionary.cpp
Event: 0.853 Thread 0x00000000024fe000 Exception <a 'java/lang/NullPointerException'> (0x0000000081e42808) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\linkResolver.cpp, line 1287]
Event: 0.892 Thread 0x00000000024fe000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x0000000081eec870) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
Event: 0.893 Thread 0x00000000024fe000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x0000000081eee550) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
Event: 0.898 Thread 0x00000000024fe000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x0000000081f0dee8) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
Event: 0.906 Thread 0x00000000024fe000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException'> (0x0000000081f39b80) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\runtime\sharedRuntime.cpp, line 605]
Event: 1.075 Thread 0x00000000024fe000 Exception <a 'java/lang/NoSuchFieldError': method resolution failed> (0x00000000822e9b00) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\prims\methodHandles.cpp, line 1167]
Event: 1.078 Thread 0x00000000024fe000 Exception <a 'java/lang/NoSuchFieldError': method resolution failed> (0x00000000822f6df0) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\prims\methodHandles.cpp, line 1167]
Event: 1.543 Thread 0x00000000024fe000 Implicit null exception at 0x00000000027af656 to 0x00000000027af9e9

Events (10 events):
Event: 2.785 loading class sun/security/ssl/CipherBox$1
Event: 2.785 loading class sun/security/ssl/CipherBox$1 done
Event: 2.785 loading class java/lang/StrictMath
Event: 2.786 loading class java/lang/StrictMath done
Event: 2.786 loading class sun/security/ssl/HandshakerHelper
Event: 2.786 loading class sun/security/ssl/HandshakerHelper done
Event: 2.786 loading class com/microsoft/sqlserver/jdbc/AuthenticationJNI
Event: 2.786 loading class com/microsoft/sqlserver/jdbc/AuthenticationJNI done
Event: 2.787 loading class java/lang/ClassLoaderHelper
Event: 2.788 loading class java/lang/ClassLoaderHelper done


Dynamic libraries:
0x00007ff600cb0000 - 0x00007ff600ce7000 	D:\Stambia\Java\jdk1.8.0_231\bin\java.exe
0x00007ff93d050000 - 0x00007ff93d220000 	C:\Windows\SYSTEM32\ntdll.dll
0x00007ff93aa20000 - 0x00007ff93aacc000 	C:\Windows\System32\KERNEL32.DLL
0x00007ff939f80000 - 0x00007ff93a19d000 	C:\Windows\System32\KERNELBASE.dll
0x00007ff93ac10000 - 0x00007ff93acb2000 	C:\Windows\System32\ADVAPI32.dll
0x00007ff93acc0000 - 0x00007ff93ad5e000 	C:\Windows\System32\msvcrt.dll
0x00007ff93ceb0000 - 0x00007ff93cf09000 	C:\Windows\System32\sechost.dll
0x00007ff93cd80000 - 0x00007ff93cea1000 	C:\Windows\System32\RPCRT4.dll
0x00007ff93c790000 - 0x00007ff93c8f5000 	C:\Windows\System32\USER32.dll
0x00007ff93a560000 - 0x00007ff93a57e000 	C:\Windows\System32\win32u.dll
0x00007ff93cf10000 - 0x00007ff93cf44000 	C:\Windows\System32\GDI32.dll
0x00007ff939c20000 - 0x00007ff939da1000 	C:\Windows\System32\gdi32full.dll
0x00007ff928190000 - 0x00007ff92840a000 	C:\Windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.14393.3053_none_7de042968342015d\COMCTL32.dll
0x00007ff93a610000 - 0x00007ff93a8d5000 	C:\Windows\System32\combase.dll
0x00007ff93a3b0000 - 0x00007ff93a4a4000 	C:\Windows\System32\ucrtbase.dll
0x00007ff93a1a0000 - 0x00007ff93a20a000 	C:\Windows\System32\bcryptPrimitives.dll
0x00007ff93a5e0000 - 0x00007ff93a60e000 	C:\Windows\System32\IMM32.DLL
0x0000000071440000 - 0x0000000071512000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\msvcr100.dll
0x0000000070b90000 - 0x0000000071436000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\server\jvm.dll
0x00007ff93c770000 - 0x00007ff93c778000 	C:\Windows\System32\PSAPI.DLL
0x00007ff92f7f0000 - 0x00007ff92f7f9000 	C:\Windows\SYSTEM32\WSOCK32.dll
0x00007ff93c700000 - 0x00007ff93c76a000 	C:\Windows\System32\WS2_32.dll
0x00007ff937a20000 - 0x00007ff937a43000 	C:\Windows\SYSTEM32\WINMM.dll
0x00007ff92fc90000 - 0x00007ff92fc9a000 	C:\Windows\SYSTEM32\VERSION.dll
0x00007ff9379f0000 - 0x00007ff937a1b000 	C:\Windows\SYSTEM32\WINMMBASE.dll
0x00007ff93a2b0000 - 0x00007ff93a2f2000 	C:\Windows\System32\cfgmgr32.dll
0x00007ff931250000 - 0x00007ff93125f000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\verify.dll
0x00007ff929b40000 - 0x00007ff929b69000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\java.dll
0x00007ff929b20000 - 0x00007ff929b36000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\zip.dll
0x00007ff93b1f0000 - 0x00007ff93c6f5000 	C:\Windows\System32\SHELL32.dll
0x00007ff939540000 - 0x00007ff939c1a000 	C:\Windows\System32\windows.storage.dll
0x00007ff9394d0000 - 0x00007ff93951c000 	C:\Windows\System32\powrprof.dll
0x00007ff93b190000 - 0x00007ff93b1e2000 	C:\Windows\System32\shlwapi.dll
0x00007ff939520000 - 0x00007ff93952f000 	C:\Windows\System32\kernel.appcore.dll
0x00007ff93a4b0000 - 0x00007ff93a559000 	C:\Windows\System32\shcore.dll
0x00007ff9394b0000 - 0x00007ff9394c4000 	C:\Windows\System32\profapi.dll
0x00007ff929b00000 - 0x00007ff929b1a000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\net.dll
0x00007ff938d70000 - 0x00007ff938dcc000 	C:\Windows\system32\mswsock.dll
0x00007ff932080000 - 0x00007ff932096000 	C:\Windows\system32\napinsp.dll
0x00007ff938af0000 - 0x00007ff938b92000 	C:\Windows\SYSTEM32\DNSAPI.dll
0x00007ff93c780000 - 0x00007ff93c788000 	C:\Windows\System32\NSI.dll
0x00007ff938ab0000 - 0x00007ff938ae8000 	C:\Windows\SYSTEM32\IPHLPAPI.DLL
0x00007ff932180000 - 0x00007ff93218e000 	C:\Windows\System32\winrnr.dll
0x00007ff933c00000 - 0x00007ff933c18000 	C:\Windows\system32\NLAapi.dll
0x00007ff933c20000 - 0x00007ff933c2a000 	C:\Windows\System32\rasadhlp.dll
0x00007ff936760000 - 0x00007ff9367ca000 	C:\Windows\System32\fwpuclnt.dll
0x00007ff939400000 - 0x00007ff93942b000 	C:\Windows\SYSTEM32\bcrypt.dll
0x00007ff92d530000 - 0x00007ff92d53d000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\management.dll
0x00007ff929ae0000 - 0x00007ff929af2000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\nio.dll
0x00007ff929ab0000 - 0x00007ff929ad4000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\sunec.dll
0x00007ff9363f0000 - 0x00007ff936406000 	C:\Windows\SYSTEM32\dhcpcsvc6.DLL
0x00007ff9363d0000 - 0x00007ff9363ea000 	C:\Windows\SYSTEM32\dhcpcsvc.DLL
0x00007ff938f20000 - 0x00007ff938f37000 	C:\Windows\SYSTEM32\CRYPTSP.dll
0x00007ff938940000 - 0x00007ff938973000 	C:\Windows\system32\rsaenh.dll
0x00007ff938bf0000 - 0x00007ff938c0f000 	C:\Windows\SYSTEM32\USERENV.dll
0x00007ff938f40000 - 0x00007ff938f4b000 	C:\Windows\SYSTEM32\CRYPTBASE.dll
0x00007ff92c480000 - 0x00007ff92c48b000 	D:\Stambia\Java\jdk1.8.0_231\jre\bin\sunmscapi.dll
0x00007ff939db0000 - 0x00007ff939f79000 	C:\Windows\System32\CRYPT32.dll
0x00007ff939530000 - 0x00007ff939540000 	C:\Windows\System32\MSASN1.dll
0x00007ff929a80000 - 0x00007ff929aa2000 	D:\Stambia\Java\jdk1.8.0_231\bin\sqljdbc_auth.dll
0x00007ff934a90000 - 0x00007ff934a9c000 	C:\Windows\system32\secur32.dll
0x00007ff939120000 - 0x00007ff93914c000 	C:\Windows\SYSTEM32\SSPICLI.DLL
0x00007ff938e20000 - 0x00007ff938f11000 	C:\Windows\system32\kerberos.DLL
0x00007ff93a210000 - 0x00007ff93a2ac000 	C:\Windows\System32\msvcp_win.dll
0x00007ff938d00000 - 0x00007ff938d67000 	C:\Windows\system32\msv1_0.DLL
0x00007ff938cf0000 - 0x00007ff938cfc000 	C:\Windows\SYSTEM32\NtlmShared.dll
0x00007ff938dd0000 - 0x00007ff938de4000 	C:\Windows\SYSTEM32\cryptdll.dll
0x00007ff92d240000 - 0x00007ff92d269000 	C:\Windows\system32\ntdsapi.dll
0x00007ff92e630000 - 0x00007ff92e7c2000 	C:\Windows\system32\DBGHELP.DLL
0x00007ff92e4d0000 - 0x00007ff92e4f9000 	C:\Windows\SYSTEM32\dbgcore.DLL

VM Arguments:
jvm_args: -XX:-HeapDumpOnOutOfMemoryError -Dstambia.client.configuration=properties\client.xml -Xms1024m -Xmx2048m -Xss256k -Djava.system.class.loader=com.indy.engine.StambiaSystemClassLoader -Dstambia.classpath.v1.root=lib\**\*.jar;lib\**\*.zip;lib\**\*.dll;exclude::lib\scripting\cachedir;exclude::lib\scripting\Lib;exclude::lib\scripting\jython.jar -Dorg.quartz.properties=properties\engineScheduler.properties -Djava.security.policy=properties\security.policy 
java_command: com.indy.engine.EngineStartI -conf properties\engineParameters.xml
java_class_path (initial): =.;lib\comdcom;lib\scripting\Lib\.;properties\.;lib\indyEngineLauncher.jar;lib\scripting\jython.jar
Launcher Type: SUN_STANDARD

Environment Variables:
PATH=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\PowerShell\6\;D:\Stambia\Runtime\lib\dll;C:\Program Files\dotnet\;C:\Users\BOUINCH\AppData\Local\Microsoft\WindowsApps
USERNAME=BOUINCH
OS=Windows_NT
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 63 Stepping 2, GenuineIntel



---------------  S Y S T E M  ---------------

OS: Windows 10.0 , 64 bit Build 14393 (10.0.14393.2969)

CPU:total 1 (initial active 1) (1 cores per cpu, 1 threads per core) family 6 model 63 stepping 2, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, sse4.1, sse4.2, popcnt, avx, avx2, aes, clmul, erms, lzcnt, tsc, tscinvbit, bmi1, bmi2

Memory: 4k page, physical 4193712k(733348k free), swap 4914608k(2154772k free)

vm_info: Java HotSpot(TM) 64-Bit Server VM (25.231-b11) for windows-amd64 JRE (1.8.0_231-b11), built on Oct  5 2019 03:11:30 by "java_re" with MS VC++ 10.0 (VS2010)

time: Fri Jan 10 15:12:31 2020
timezone: Romance Standard Time
elapsed time: 5 seconds (0d 0h 0m 5s)
More
10 Jan 2020 15:58 #6 by cbouin
Replied by cbouin on topic SQL server integrated security for runtime logs
Here is the service log file before the first restart try:
INFO|wrapper|20-01-10 15:24:18|Win service: before service init
INFO|wrapper|20-01-10 15:24:18|set state IDLE->STARTING
INFO|wrapper|20-01-10 15:24:18|starting Process
INFO|wrapper|20-01-10 15:24:18|+ ServiceMain callback
INFO|wrapper|20-01-10 15:24:18|Controller State: UNKNOWN -> WAITING
INFO|wrapper|20-01-10 15:24:18|reporting status 0
INFO|wrapper|20-01-10 15:24:18|reporting status 0
INFO|wrapper|20-01-10 15:24:18|onstart
INFO|wrapper|20-01-10 15:24:19|working dir D:\Stambia\Runtime\external\stambiaService\.\..\..
INFO|wrapper|20-01-10 15:24:19|started process with pid 4764
INFO|wrapper|20-01-10 15:24:19|set state STARTING->RUNNING
INFO|4764/0|20-01-10 15:24:20|log4j:WARN No appenders could be found for logger (org.apache.commons.vfs.impl.DefaultFileReplicator).
INFO|4764/0|20-01-10 15:24:20|log4j:WARN Please initialize the log4j system properly.
INFO|4764/0|20-01-10 15:24:20|log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
INFO|4764/0|20-01-10 15:24:21|external stop false
INFO|4764/0|20-01-10 15:24:21|Controller State: WAITING -> ESTABLISHED
INFO|4764/0|20-01-10 15:24:21|Controller State: ESTABLISHED -> LOGGED_ON
INFO|4764/0|20-01-10 15:24:22|10/01/2020 15:24:21,833 - Runtime version: s17.6.8_20191008
INFO|4764/0|20-01-10 15:24:22|10/01/2020 15:24:21,833 - Java version: 1.8.0_231 vendor: Oracle Corporation home: D:\Stambia\Java\jdk1.8.0_231\jre
INFO|4764/0|20-01-10 15:24:22|10/01/2020 15:24:22,432 - Internal Database is started: APPETLRE701:42100
INFO|4764/0|20-01-10 15:24:22|10/01/2020 15:24:22,575 - Internal Database Web Server is started: http://APPETLRE701:42101
INFO|4764/0|20-01-10 15:24:23|10/01/2020 15:24:23,638 - RMI server is started: rmi://APPETLRE701:42000
INFO|4764/0|20-01-10 15:24:24|10/01/2020 15:24:24,277 - Scheduler is started
INFO|4764/0|20-01-10 15:24:25|10/01/2020 15:24:25,307 - SOAP Endpoint: http://APPETLRE701:42200/wsi/DeliverableService?WSDL
INFO|4764/0|20-01-10 15:24:25|10/01/2020 15:24:25,307 - SOAP Legacy "Non WSI-Compliant" Endpoint: http://APPETLRE701:42200/StambiaDeliveryService?WSDL
INFO|4764/0|20-01-10 15:24:25|10/01/2020 15:24:25,307 - HTTP Rest v3 - Endpoint: http://APPETLRE701:42200/rest/StambiaDeliveryService/3/default/<path>
INFO|4764/0|20-01-10 15:24:25|10/01/2020 15:24:25,307 - HTTP Rest v3 - UI: http://APPETLRE701:42200/rest/StambiaDeliveryService/3/default?swagger-ui
INFO|4764/0|20-01-10 15:24:25|10/01/2020 15:24:25,307 - HTTP Rest v3 - Definition: http://APPETLRE701:42200/rest/StambiaDeliveryService/3/default?swagger2.json
INFO|4764/0|20-01-10 15:24:25|10/01/2020 15:24:25,307 - HTTP Rest v2 - Endpoint: http://APPETLRE701:42200/rest/StambiaDeliveryService/2/<deliveryName>
INFO|4764/0|20-01-10 15:24:25|10/01/2020 15:24:25,308 - HTTP Rest v1 - Endpoint: http://APPETLRE701:42200/rest/StambiaDeliveryService/1/<deliveryName>
INFO|wrapper|20-01-10 15:49:52|received service control 1
INFO|wrapper|20-01-10 15:49:52|reporting status 1
INFO|wrapper|20-01-10 15:49:52|Win service stop - timeout: 30000
INFO|wrapper|20-01-10 15:49:52|Win service wrapper.control -> stopping application
INFO|wrapper|20-01-10 15:49:52|set state RUNNING->STATE_USER_STOP
INFO|wrapper|20-01-10 15:49:52|stopping process with pid/timeout 4764 45000
INFO|4764/0|20-01-10 15:49:52|Controller State: LOGGED_ON -> WAITING_CLOSED
INFO|4764/0|20-01-10 15:49:52|wrapper manager received stop command
INFO|4764/0|20-01-10 15:49:52|Controller State: WAITING_CLOSED -> USER_STOP
INFO|wrapper|20-01-10 15:49:52|stop config name null
INFO|wrapper|20-01-10 15:49:52|externalStop false
INFO|4764/0|20-01-10 15:49:52|Controller State: USER_STOP -> PROCESS_KILLED
INFO|4764/0|20-01-10 15:49:53|gobler terminated ERROR 4764
INFO|wrapper|20-01-10 15:49:53|process destroyed -1
INFO|wrapper|20-01-10 15:49:53|process exit code: 0
INFO|wrapper|20-01-10 15:49:53|set state STATE_USER_STOP->IDLE
INFO|wrapper|20-01-10 15:49:53|set state IDLE->STATE_SHUTDOWN
INFO|wrapper|20-01-10 15:49:53|reporting status 1
INFO|wrapper|20-01-10 15:49:53|Win service terminated
INFO|wrapper|20-01-10 15:49:53|Win service: terminated correctly
INFO|wrapper|20-01-10 15:54:20|Win service: before service init
INFO|wrapper|20-01-10 15:54:20|+ ServiceMain callback
INFO|wrapper|20-01-10 15:54:20|reporting status 0
INFO|wrapper|20-01-10 15:54:20|reporting status 0
INFO|wrapper|20-01-10 15:54:20|onstart
INFO|wrapper|20-01-10 15:54:20|set state IDLE->STARTING
INFO|wrapper|20-01-10 15:54:20|starting Process
INFO|wrapper|20-01-10 15:54:21|Controller State: UNKNOWN -> WAITING
INFO|wrapper|20-01-10 15:54:21|working dir D:\Stambia\Runtime\external\stambiaService\.\..\..
INFO|wrapper|20-01-10 15:54:21|started process with pid 228
INFO|wrapper|20-01-10 15:54:21|set state STARTING->RUNNING
INFO|228/0|20-01-10 15:54:22|log4j:WARN No appenders could be found for logger (org.apache.commons.vfs.impl.DefaultFileReplicator).
INFO|228/0|20-01-10 15:54:22|log4j:WARN Please initialize the log4j system properly.
INFO|228/0|20-01-10 15:54:22|log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
INFO|228/0|20-01-10 15:54:22|external stop false
INFO|228/0|20-01-10 15:54:23|Controller State: WAITING -> ESTABLISHED
INFO|228/0|20-01-10 15:54:23|Controller State: ESTABLISHED -> LOGGED_ON
INFO|228/0|20-01-10 15:54:23|10/01/2020 15:54:23,610 - Runtime version: s17.6.8_20191008
INFO|228/0|20-01-10 15:54:24|10/01/2020 15:54:23,610 - Java version: 1.8.0_231 vendor: Oracle Corporation home: D:\Stambia\Java\jdk1.8.0_231\jre
INFO|228/0|20-01-10 15:54:24|10/01/2020 15:54:24,234 - Internal Database is started: APPETLRE701:42100
INFO|228/0|20-01-10 15:54:24|10/01/2020 15:54:24,396 - Internal Database Web Server is started: http://APPETLRE701:42101
INFO|228/0|20-01-10 15:54:27|Controller State: LOGGED_ON -> WAITING_CLOSED
INFO|228/0|20-01-10 15:54:27|Controller State: WAITING_CLOSED -> PROCESS_KILLED
INFO|wrapper|20-01-10 15:54:27|restart process due to default exit code rule
More
13 Jan 2020 17:45 #7 by Thomas BLETON
Replied by Thomas BLETON on topic SQL server integrated security for runtime logs
I see that the Java VM is in 64 bits.
Did you make sure to get the sqljdbc_auth.dll file from the "x64" folder of the Ms Sql jdbc driver distribution ?
Are you able to setup a connection from another java-based Query tool (dbeaver, squirrel...) using the same integratedSecurity connection mode ?

Note : we can plan a remote session meeting if you feel this is necessary.
More
13 Jan 2020 21:01 - 14 Jan 2020 10:46 #8 by cbouin
Replied by cbouin on topic SQL server integrated security for runtime logs
Hello,

Wasn't that, even if this mistake gives exactly the same dump log.

The last try I could do this afternoon was successful.
I found another sqljdbc4-2.jar file in runtime/lib folder, which obviously didn't match the sqljdbc42.jar delivered with the sqljdbc_auth.dll ^_^

Tomorrow I'll try to remove as many jar and dll as possible, to be able to tell which ones are really needed. I think the jar I copied to the other folders were not taken into account.

Thanks for your help!

Edit: The sqljdbc42.jar used by my designer and local runtime wasn't the same (same name, but different file size). I replaced with the one from my qual/prod environment, and placed the sqljdbc_auth.dll next to Stambia.exe -> everything works fine, I can use integratedSecurity in metadata connection strings
Last edit: 14 Jan 2020 10:46 by cbouin.
More
14 Jan 2020 10:53 - 15 Jan 2020 16:00 #9 by cbouin
Replied by cbouin on topic SQL server integrated security for runtime logs
Hello,

I removed all sqljdbcxx.jar files from my server, except the one in Runtime\lib\jdbc
I removed all sqljdbc_auth.dll from my server, except the one in Runtime (next to the startengine.bat file)
Everything works fine!

What would you recommend for sqljdbc_auth.dll?
- do exactly what I did, it's the best way to make it work and to maintain it!
- place the dll into a system folder?
- place the dll elsewhere and change a config file?
- another method?

When our scheduler tries to run a startdelivery, it uses the scheduler service account to access the log, instead of the runtime service account.
What is the expected behaviour? Is it possible to use the runtime service account to access the log database?

Thanks.
Last edit: 15 Jan 2020 16:00 by cbouin.