doesnt creating project

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

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

3 answers

0 vote

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jun 14, 2018 in Jira Service Desk

How the Telegram Integration for Jira helps Sergey's team take their support efficiency to the bank

...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...

789 views 5 7
Read article

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