doesnt creating project

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

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

3 answers

0 votes

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.

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
 

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.

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

"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?

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?

Suggest an answer

Log in or Sign up to answer
Community showcase
Asked Thursday in Jira Service Desk

Looking for teams who switched from email to Jira Service Desk

The Jira Service Desk marketing team is working on a guide to help new Atlassian customers switch from email to JSD and we'd love to hear from you! Please share: - What made you realize that i...

185 views 1 5
View question

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you