Set up application properties won't proceed to Next step for configuration

[YOtm]

I use sql server 2016 and follow the documentation for this. Jira Configuration Tool indicates that Connection Successful, but Jira can not proceed to next step. I used Jira for a while with H2 database in same environment and i wanted to use Ms sql instead of H2. I created a database for this, i can ignore old data so i don't need to immigrate from H2 to Ms Sql. 

I created a database and try to connect it to Jira.

[Nic Brough -Adaptavist-]

Could you describe "can not proceed to next step"?  What is the error message or behaviour?

[YOtm]

You can see the screen attached. It keeps this screen for hours without error.

[Nic Brough -Adaptavist-]

That step does take a while, but if it goes over 10 minutes, it's likely to be having a problem.

You'll need to read the application log to find out where it is stuck.

[YOtm]

Here is the atlassian-jira logs when it tries to pass this step. I couldn't understand what the problem is.

2020-12-15 17:12:28,159-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=4, totalCount=4, periodSec=31, flushIntervalMillis=7953, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\comments, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@4fcee835, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\comments lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,160-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] COMMENT : Stopping writer stats.
2020-12-15 17:12:28,170-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=4, totalCount=4, periodSec=19, flushIntervalMillis=4953, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\issues, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@78a555dd, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\issues lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,170-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] ISSUE : Stopping writer stats.
2020-12-15 17:12:28,183-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=4, totalCount=4, periodSec=19, flushIntervalMillis=4911, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\worklogs, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@401295bc, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\worklogs lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,184-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] WORKLOG : Stopping writer stats.
2020-12-15 17:12:28,201-0800 periodic-index-fixer-0 INFO [c.a.jira.index.WriterWithStats] [index-writer-stats] Creating #3 writer stats for: ISSUE
2020-12-15 17:12:28,208-0800 periodic-index-fixer-0 INFO [c.a.jira.index.WriterWithStats] [index-writer-stats] ISSUE : indexing writer stats will be running every: 5min
2020-12-15 17:12:28,216-0800 periodic-index-fixer-0 INFO [c.a.jira.index.WriterWithStats] [index-writer-stats] Creating #4 writer stats for: COMMENT
2020-12-15 17:12:28,217-0800 periodic-index-fixer-0 INFO [c.a.jira.index.WriterWithStats] [index-writer-stats] COMMENT : indexing writer stats will be running every: 5min
2020-12-15 17:12:28,228-0800 periodic-index-fixer-0 INFO [c.a.jira.index.WriterWithStats] [index-writer-stats] Creating #5 writer stats for: WORKLOG
2020-12-15 17:12:28,228-0800 periodic-index-fixer-0 INFO [c.a.jira.index.WriterWithStats] [index-writer-stats] WORKLOG : indexing writer stats will be running every: 5min
2020-12-15 17:12:28,256-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.j.w.action.setup.SetupApplicationProperties] Re-indexing is 100% complete. Current index:
2020-12-15 17:12:28,267-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.j.issue.index.DefaultIndexManager] ReindexAll in foreground: {indexIssues=true, indexChangeHistory=true, indexComments=true, indexWorklogs=true, forceReloadFromDatabase=false}
2020-12-15 17:12:28,271-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.j.issue.index.IndexingStatsManager] [indexing-stats] Resetting stats.
2020-12-15 17:12:28,279-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=4, totalCount=4, periodSec=0, flushIntervalMillis=15, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\comments, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@7b587291, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\comments lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,279-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] COMMENT : Stopping writer stats.
2020-12-15 17:12:28,313-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=2, totalCount=2, periodSec=0, flushIntervalMillis=13, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\comments, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@5a09546d, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\comments lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,319-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=4, totalCount=4, periodSec=0, flushIntervalMillis=29, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\issues, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@5299f3a3, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\issues lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,319-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] ISSUE : Stopping writer stats.
2020-12-15 17:12:28,334-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=2, totalCount=2, periodSec=0, flushIntervalMillis=4, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\issues, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@524766c9, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\issues lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,347-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=2, totalCount=2, periodSec=0, flushIntervalMillis=3, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\changes, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@7cf273f3, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\changes lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,352-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=4, totalCount=4, periodSec=0, flushIntervalMillis=31, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\worklogs, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@6c48fa3c, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\worklogs lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,353-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] WORKLOG : Stopping writer stats.
2020-12-15 17:12:28,367-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.MonitoringIndexWriter] [lucene-stats] flush stats: snapshotCount=2, totalCount=2, periodSec=0, flushIntervalMillis=4, snapshotNoDocs=0, totalNoDocs=0, indexDirectory=C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\worklogs, indexWriterId=com.atlassian.jira.index.MonitoringIndexWriter@715108fd, indexDirectoryId=MMapDirectory@C:\Program Files\Atlassian\Application Data\Jira\caches\indexesV1\worklogs lockFactory=org.apache.lucene.store.NativeFSLockFactory@6d6d24ea
2020-12-15 17:12:28,431-0800 COMMENT-indexQueue:thread-1 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] Creating #6 writer stats for: COMMENT
2020-12-15 17:12:28,433-0800 COMMENT-indexQueue:thread-1 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] COMMENT : indexing writer stats will be running every: 5min
2020-12-15 17:12:28,436-0800 WORKLOG-indexQueue:thread-1 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] Creating #7 writer stats for: WORKLOG
2020-12-15 17:12:28,438-0800 WORKLOG-indexQueue:thread-1 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] WORKLOG : indexing writer stats will be running every: 5min
2020-12-15 17:12:28,440-0800 ISSUE-indexQueue:thread-1 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] Creating #8 writer stats for: ISSUE
2020-12-15 17:12:28,440-0800 ISSUE-indexQueue:thread-1 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.jira.index.WriterWithStats] [index-writer-stats] ISSUE : indexing writer stats will be running every: 5min
2020-12-15 17:12:28,450-0800 http-nio-8080-exec-24 INFO anonymous 1032x9x1 ylnmfv 192.168.1.38 /secure/SetupApplicationProperties.jspa [c.a.j.issue.index.DefaultIndexManager] ReindexAll took: 173 ms in foreground, index size is 12 KB

[Nic Brough -Adaptavist-]

That looks like a healthy log that should have moved on.

If it's still stuck, then there's probably just a timeout.  Try refreshing the web page first, then try a new browser window where you go to the base url for it - the install should pick up where it left off, unless it's actually complete and able to serve the application.