doesnt creating project

[Алексей]

при создании проекта возникает не известная ошибка.

Что можно сделать

[Алексей]

Hi!

I can't create new project.

Error "Hmm ... I can not create the project because of an unknown error. Try to refresh the page and try again." 

how to attach an archive from the log?

[Nadine Racine]

"When creating a project, an unknown error occurs.
What can be done"

Hey Alekseji

It would be helpful if you could write in English. What does the log file say the problem is?

[Nic Brough -Adaptavist-]

You'll need to read the logs to find out the detail of what is going wrong.

Have a look in <jira home>/logs - start with atlassian-jira.log, and read it for the time at which you got the error.

[Алексей]

errors: Thu Oct 26 13:30:03 KRAT 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

[Nic Brough -Adaptavist-]

That's a warning rather than an error.  It should really be fixed, but it's not the cause of your problem.

What other errors are you getting at the time the UI failed to create the project?

[Алексей]

what file to watch?

[Алексей]

  017-10-25 20:51:33,391 http-nio-8080-exec-14 ERROR anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE dbo2.workflowschemeentity (ID NUMERIC NOT NULL, SCHEME NUMERIC, WORKFLOW NVARCHAR(255), issuetype NVARCHAR(255), CONSTRAINT PK_workflowschemeentity PRIMARY KEY (ID))
Error was: com.microsoft.sqlserver.jdbc.SQLServerException: The specified schema name "dbo2" either does not exist or you do not have permission to use it.
2017-10-25 20:51:33,391 http-nio-8080-exec-14 WARN anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] Entity "WorkflowStatuses" has no table in the database
2017-10-25 20:51:33,392 http-nio-8080-exec-14 ERROR anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] Could not create table "dbo2.jiraworkflowstatuses"
2017-10-25 20:51:33,392 http-nio-8080-exec-14 ERROR anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE dbo2.jiraworkflowstatuses (ID NUMERIC NOT NULL, status NVARCHAR(255), parentname NVARCHAR(255), CONSTRAINT PK_jiraworkflowstatuses PRIMARY KEY (ID))
Error was: com.microsoft.sqlserver.jdbc.SQLServerException: The specified schema name "dbo2" either does not exist or you do not have permission to use it.
2017-10-25 20:51:33,392 http-nio-8080-exec-14 WARN anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] Entity "Worklog" has no table in the database
2017-10-25 20:51:33,394 http-nio-8080-exec-14 ERROR anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] Could not create table "dbo2.worklog"
2017-10-25 20:51:33,394 http-nio-8080-exec-14 ERROR anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE dbo2.worklog (ID NUMERIC NOT NULL, issueid NUMERIC, AUTHOR NVARCHAR(255), grouplevel NVARCHAR(255), rolelevel NUMERIC, worklogbody NTEXT, CREATED DATETIME, UPDATEAUTHOR NVARCHAR(255), UPDATED DATETIME, STARTDATE DATETIME, timeworked NUMERIC, CONSTRAINT PK_worklog PRIMARY KEY (ID))
Error was: com.microsoft.sqlserver.jdbc.SQLServerException: The specified schema name "dbo2" either does not exist or you do not have permission to use it.
2017-10-25 20:51:33,413 http-nio-8080-exec-14 INFO anonymous 1251x46x1 rygz1q 22.178.159.35 /secure/SetupDatabase.jspa [c.a.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.
2017-10-25 20:51:33,514 http-nio-8080-exec-14 ERROR [o.a.c.c.C.[.[localhost].[/].[action]] Servlet.service() for servlet [action] in context with path [] threw exception [com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM dbo2.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (Invalid object name 'dbo2.propertyentry'.)] with root cause
com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM dbo2.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (Invalid object name 'dbo2.propertyentry'.)
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:95)
at com.atlassian.jira.propertyset.JiraCachingPropertySet.getKeys(JiraCachingPropertySet.java:288)
at com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getKeys(BootstrapOfBizPropertyEntryStore.java:45)
at com.atlassian.jira.propertyset.CachingOfBizPropertySet.getKeys(CachingOfBizPropertySet.java:103)
at com.atlassian.jira.propertyset.CachingOfBizPropertySet.getKeys(CachingOfBizPropertySet.java:78)
at com.opensymphony.module.propertyset.PropertySetCloner.clearDestination(PropertySetCloner.java:75)
at com.opensymphony.module.propertyset.PropertySetCloner.cloneProperties(PropertySetCloner.java:61)
at com.opensymphony.module.propertyset.PropertySetManager.clone(PropertySetManager.java:79)
at com.atlassian.jira.config.properties.MemorySwitchToDatabaseBackedPropertiesManager.switchToDbMode(MemorySwitchToDatabaseBackedPropertiesManager.java:53)
at com.atlassian.jira.config.properties.MemorySwitchToDatabaseBackedPropertiesManager.switchBackingStore(MemorySwitchToDatabaseBackedPropertiesManager.java:69)
at com.atlassian.jira.config.properties.PropertiesManager.onDatabaseConfigured(PropertiesManager.java:49)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:271)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:243)
at com.atlassian.jira.web.action.setup.SetupDatabase.doExecute(SetupDatabase.java:207)
... 1 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
... 7 filtered
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
... 49 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 28 filtered

[Алексей]

 aused by: org.codehaus.jackson.JsonParseException: Unexpected character ('П' (code 1055 / 0x41f)): was expecting comma to separate OBJECT entries
at [Source: java.io.StringReader@24961bd1; line: 11, column: 373]
at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:1433)
at org.codehaus.jackson.impl.JsonParserMinimalBase._reportError(JsonParserMinimalBase.java:521)
at org.codehaus.jackson.impl.JsonParserMinimalBase._reportUnexpectedChar(JsonParserMinimalBase.java:442)
at org.codehaus.jackson.impl.ReaderBasedParser.nextToken(ReaderBasedParser.java:406)
at org.codehaus.jackson.map.deser.BeanDeserializer.deserialize(BeanDeserializer.java:580)
at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:217)
at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:194)
at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:30)
at org.codehaus.jackson.map.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:299)
at org.codehaus.jackson.map.deser.SettableBeanProperty$MethodProperty.deserializeAndSet(SettableBeanProperty.java:414)
at org.codehaus.jackson.map.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:697)
at org.codehaus.jackson.map.deser.BeanDeserializer.deserialize(BeanDeserializer.java:580)
at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:217)
at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:194)
at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:30)
at org.codehaus.jackson.map.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:299)
at org.codehaus.jackson.map.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:905)
at org.codehaus.jackson.map.deser.BeanDeserializer.deserializeFromObjectUsingNonDefault(BeanDeserializer.java:739)
at org.codehaus.jackson.map.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:683)
at org.codehaus.jackson.map.deser.BeanDeserializer.deserialize(BeanDeserializer.java:580)
at org.codehaus.jackson.map.ObjectMapper._readMapAndClose(ObjectMapper.java:2732)
at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:1863)
at com.atlassian.jira.plugins.importer.sample.SampleDataImporterImpl.parseSampleData(SampleDataImporterImpl.java:64)
... 335 more
2017-10-26 16:16:06,541 http-nio-8080-exec-21 DEBUG admin 975x37x1 qmxovb 22.178.159.35 /rest/project-templates/1.0/templates [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] getService bundle [com.atlassian.servicedesk.servicedesk-notifications-plugin]
2017-10-26 16:16:06,918 http-nio-8080-exec-21 DEBUG admin 975x37x1 qmxovb 22.178.159.35 /rest/project-templates/1.0/templates [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] getService bundle [com.atlassian.servicedesk.plugins.automation.servicedesk-automation-plugin]
2017-10-26 16:16:08,221 http-nio-8080-exec-21 ERROR admin 975x37x1 qmxovb 22.178.159.35 /rest/project-templates/1.0/templates [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: An error occurred while notifying that a project was created
java.lang.RuntimeException: An error occurred while notifying that a project was created
at com.atlassian.jira.bc.project.DefaultProjectService.notifyHandlersOfProjectCreated(DefaultProjectService.java:397)
at com.atlassian.jira.bc.project.DefaultProjectService.createProjectInternal(DefaultProjectService.java:379)
at com.atlassian.jira.bc.project.DefaultProjectService.createProject(DefaultProjectService.java:349)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
... 1 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at com.sun.proxy.$Proxy509.createProject(Unknown Source)
... 3 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136)
at com.sun.proxy.$Proxy509.createProject(Unknown Source)
at com.atlassian.jira.projecttemplates.service.ProjectTemplateServiceImpl.applyProjectTemplate(ProjectTemplateServiceImpl.java:173)
at com.atlassian.jira.projecttemplates.rest.ProjectTemplatesResource.createProjectFromFormRequest(ProjectTemplatesResource.java:170)
... 3 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
... 12 filtered
at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:154)
... 1 filtered
at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68)
... 32 filtered
at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)
... 13 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 53 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 16 filtered
at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)
... 19 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
... 5 filtered
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.lambda$invokeFilterChain$0(CustomerContextSettingFilter.java:181)
at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.rteInvoke(ReentrantThreadLocalBasedCodeContext.java:137)
at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.runOutOfContext(ReentrantThreadLocalBasedCodeContext.java:90)
at com.atlassian.servicedesk.internal.utils.context.CustomerContextServiceImpl.runOutOfCustomerContext(CustomerContextServiceImpl.java:65)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.outOfCustomerContext(CustomerContextSettingFilter.java:174)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:130)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:121)
... 4 filtered
at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)
... 8 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 4 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
... 26 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 23 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2017-10-26 16:16:42,053 Modification Check:thread-1 INFO [c.a.jira.startup.JiraStartupLogger]

___ Modifications ___________________________

Modified Files : jira-application.properties
Removed Files : None
 

[Nic Brough -Adaptavist-]

Ok, that's very clear - your database is not configured correctly, and Jira cannot write to it.  Even if corrected, the data might be damaged.

You will need to fix this database error and retry. 

[Алексей]

 how to set up the database correctly?

[Алексей]

[Алексей]

 I set up the database according to the instructions https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html. re-created the base. when creating a project, the same error occurs.

[Nic Brough -Adaptavist-]

The error message says you have the permissions for the database user incorrect.  (Or that you're pointing at the wrong database)

[Алексей]

the user has full rights