"Ouch! We can't load the image." after migration to 6.15.10

[Sébastien NOEL]

I can see the attachment list :

But the link to one leads to error :

I checked on the server..i can see all 7 items . but in subdirectories.

What/where can I continue my investigations ?

Where is the problem ?

It occurs since we migrate from 6.4.1 to 6.15.10 but for some articles.. not all.

PLease help.

[repi]

@Sébastien NOEL 

Is there an error message in the confluence log file?
It can be a problem with the rights of the confluence user or in the filesystem of the attachments.

[Sébastien NOEL]

i am lost between all the log files... Is the "catalina.2020-07-08.log" the good one (in .../confluence/logs/ (same level as webapp, jre, etc) )?

No other log changing at the time I retried to access attach. 

Where can i check the configuration of log file name ?

Thanks

[repi]

You have to check the atlassian-confluence.log.

[Sébastien NOEL]

Thanks.. this log file was in another harddisk. inside i can read something that sounds interesting :

2020-07-08 15:23:20,604 WARN [http-nio-80-exec-2] [atlassian.confluence.pages.DefaultAttachmentManager] getAttachmentData Could not find data for attachment: Attachment: image2019-12-31 10:25:12.png v.1 (177802084) USER1 - com.atlassian.confluence.pages.persistence.dao.filesystem.AttachmentDataFileSystemException: No such file for Attachment: image2019-12-31 10:25:12.png v.1 (177802084) USER1. Were looking at <<<<<<obfusctated by me>>>>Confluence\attachments\ver003\162\156\184156162\65\52\177802065\177802084\1
-- referer: http://wiki-it/pages/viewpageattachments.action?pageId=177802065&preview=/177802065/177802084/image2019-12-31%2010%3A25%3A12.png | url: /download/attachments/177802065/image2019-12-31%2010%3A25%3A12.png | traceId: e38cb8cab769563f | userName: USER2
2020-07-08 15:23:24,601 ERROR [Caesium-1-4] [migration.agent.queue.QueueBroker] error An error occurred when getting the next batch for consumer type: ATTACHMENT_UPLOAD. Message: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
com.atlassian.util.concurrent.LazyReference$InitializationException: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)
at com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)

....

at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275)

...

... 1 more
Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:100)

[Sébastien NOEL]

Then i edit the file : confluence.cfg.xml .. and see :

<property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.OracleDialect</property>...

What is the correct way to change it ? edit the file and restart ? use the admin part of wiki ? ... thanks

[Sébastien NOEL]

I tried to change the value com.atlassian.confluence.impl.hibernate.dialect.OracleDialect to org.hibernate.dialect.Oracle12cDialect as I understand from the same kind of error in discussion https://community.atlassian.com/t5/Confluence-questions/Experience-in-using-Confluence-with-Oracle-19c/qaq-p/1228836

Note also that I note that we were using ojdbc7.jar (driver 12c) I changed it to ojdbc10.jar for Oracle 19c...