CAN'T SAVE PAGE

[Andrii Maliuta · Accepted solution]

Hello Valerio.

Could you please describe the issue - you receive some error when added text to the page in edit mode and clicking SAVE?

As a text, this is added to the page correctly from my side.

Could you please clarify how you add this to the page and how the error is reproduced?

You just add this as text in the page body of 'Paragraph' style? Or do you add this inside of some macro or some specific part of the page that has specific formatting?

Can you please provide the Storage Format of the page, so that it would be more clear what happens? 

[valerio tarenghi]

wherever I enter the text causes timeout when I hit the save key. i have test the macro,simple text ecc.

I have found 2 errors in the log:

############################

1.

############################

sed by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4646)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10203)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3775)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)
at net.java.ao.ForwardingPreparedStatement.executeQuery(ForwardingPreparedStatement.java:40)
at net.java.ao.ParameterMetadataCachingPreparedStatement.executeQuery(ParameterMetadataCachingPreparedStatement.java:10)
at net.java.ao.EntityManager.stream(EntityManager.java:889)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.stream(EntityManagedActiveObjects.java:174)
... 87 more
Caused by: Error : 936, Position : 184, Sql = SELECT "ID","EVENT_ID","FINISH","OUTCOME","REQUEST_ID","REQUEST_METHOD","REQUEST_URL","RESULT_DESCRIPTION","START","WEBHOOK_ID" FROM "AO_A0B856_HIST_INVOCATION" WHERE "WEBHOOK_ID" IN (), OriginalSql = SELECT "ID","EVENT_ID","FINISH","OUTCOME","REQUEST_ID","REQUEST_METHOD","REQUEST_URL","RESULT_DESCRIPTION","START","WEBHOOK_ID" FROM "AO_A0B856_HIST_INVOCATION" WHERE "WEBHOOK_ID" IN (), Error Msg = ORA-00936: missing expression

############################

2.

############################

2020-10-23 00:25:33,218 ERROR [http-nio-8080-exec-4] [common.error.jersey.ThrowableExceptionMapper] toResponse Uncaught exception thrown by REST service: com.atlassian.migration.agent.okhttp.IOHttpException: An IO exception occurred when communicating with a downstream service
-- referer:  | url: /rest/migration/latest/app/stats | traceId: ec61eae28f3ac26a | userName: valerio.tarenghi
com.atlassian.cache.CacheException: com.atlassian.migration.agent.okhttp.IOHttpException: An IO exception occurred when communicating with a downstream service
at com.atlassian.cache.ehcache.DelegatingCache.get(DelegatingCache.java:113)
at com.atlassian.confluence.cache.ehcache.DefaultConfluenceEhCache.get(DefaultConfluenceEhCache.java:41)
at com.atlassian.confluence.cache.ConfluenceMonitoringCache.get(ConfluenceMonitoringCache.java:46)
at com.atlassian.migration.agent.service.impl.MigrationAppAggregatorService.validateAndReloadBlacklist(MigrationAppAggregatorService.java:98)
at com.atlassian.migration.agent.service.app.PluginManager.getActualUserInstalledPlugins(PluginManager.java:30)
at com.atlassian.migration.agent.service.impl.AppAssessmentService.getAppCount(AppAssessmentService.java:149)
at com.atlassian.migration.agent.service.impl.AppAssessmentService.getPluginStats(AppAssessmentService.java:85)
at com.atlassian.migration.agent.rest.AppAssessmentResource.getPluginStats(AppAssessmentResource.java:41)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker.lambda$_dispatch$0(DispatchProviderHelper.java:181)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.lambda$invokeMethodWithInterceptors$0(DispatchProviderHelper.java:81)
at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53)
at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept(ExpandInterceptor.java:42)
at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors(DispatchProviderHelper.java:106)
at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch(DispatchProviderHelper.java:180)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)

[Andrii Maliuta]

@valerio tarenghi 

Thank you for the details.

The issues seem to be more related to the DB configuration for the Confluence and retrieving some ActiveObject entities. Maybe there are some incorrect settings of SQL database connection to Confluence. For the database config you can refer to:

• https://confluence.atlassian.com/doc/database-configuration-159764.html
• https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

There can be also an incorrect setting of collaborative editing DB connection. If it is not a production instance and it will not impact users, you can try to switch off Collaborative Editing (Synchrony) and try to save the page again.

How to control Collaborative Editing  -https://confluence.atlassian.com/doc/administering-collaborative-editing-858772086.html

[Andrii Maliuta]

@valerio tarenghi 

Thank you for the details!

The provided errors seem to be related to Confluence DB configuration. Could you please refer to the following docs and check if you use the correct versions and settings:

• https://confluence.atlassian.com/doc/database-configuration-159764.html
• https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

Also, if it is not a Production Confluence instance and it will not impact users, you can try to switch off Collaborative Editing and try to save the page without it to check if the Synchrony DB is working correctly. The guide about CE - https://confluence.atlassian.com/doc/administering-collaborative-editing-858772086.html