PKP PN plugin fail

Hi

We use ojs3.3.10 and activate pkp pn for one journal but no deposits, on log apear this

[2022-10-04 06:21:53] https://revistas.ucm.es
[2022-10-04 06:21:53] [Notificación] Se ha iniciado la tarea.
[2022-10-04 06:21:53] [Notificación] PLN Depositor executeActions started
[2022-10-04 06:21:53] [Notificación] ##plugins.generic.pln.notifications.processing_for##
[2022-10-04 06:21:53] [Notificación] ##plugins.generic.pln.notifications.getting_servicedocument##

Thanks

Hi!

FYI the last message refers to Getting service document.

Assuming there’s nothing more on your log, then as far as I know, we’ve been experiencing an infrastructure instability this week, which would explain a failure in this step.

Hopefully everything will be normalized soon :slight_smile:

Best,
Jonas

Hi

The process now is pending from 04-10-2022 for all articles, there is a process to force to deposit ?

Thnks

Hi!

I can see 97 journals were registered from your domain, and I can see the terms were accepted. But looks like none of them have sent deposits so far, is there something new on the log?

Best,
Jonas

Hi
Is correct there is 97 but only one at moment is active, the today logs is

[2022-10-17 06:22:14] https://revistas.ucm.es
[2022-10-17 06:22:14] [Notificación] Se ha iniciado la tarea.
[2022-10-17 06:22:14] [Notificación] PLN Depositor executeActions started
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.notifications.processing_for##
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.notifications.getting_servicedocument##
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.depositor.statusupdates##
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.depositor.updatedcontent##
[2022-10-17 06:22:16] [Notificación] ##plugins.generic.pln.depositor.newcontent##
[2022-10-17 06:22:16] [Notificación] ##plugins.generic.pln.depositor.packagingdeposits##
[2022-10-17 06:22:16] [Notificación] ##plugins.generic.pln.depositor.packagingdeposits.processing##
[2022-10-17 06:22:17] [Notificación] ##plugins.generic.pln.depositor.packagingdeposits.processing.packageSucceeded##
Thnks

There should be more messages in the log, basically the last message should be [2022-10-17 06:22:17] [Notice] Task process stopped.).

I guess an error happened while it was processing. Isn’t there anything in the error log?

Best,
Jonas

Hi
There is not any more in the log file, what should be happening ?

thnks

Hi @Enrique_Manuel_Touce,

I meant the error log from your server, where you’ll be able to see unexpected PHP errors.

If you don’t know where it’s located, you can access this link https://revistas.ucm.es/index.php/admin/phpinfo and search for error_log.

Best,
Jonas

Hi

Yes, your are correct there is an error in error_log

[Mon Oct 17 08:22:17.028311 2022] [php7:error] [pid 118252] [client 66.249.76.234:64753] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘export_deposit_error’ in ‘field list’ in /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute()\n#1 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()\n#3 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()\n#4 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\Database\Connection->run()\n#5 /srv/www/htdocs/ojsucm/li in /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

Thnks

Hi!

I’ve already seen this error before (if you want more details, you can search for export_deposit_error in the forum) :slight_smile:

In order to fix it, please run this query against your database:
ALTER TABLE pln_deposits ADD COLUMN export_deposit_error VARCHAR(1000) NULL

Then let me know if it solved you problem.

Best,
Jonas

Hi

Tomorrow i will see log and tell you

Thnks

1 Like

This topic was automatically closed after 42 days. New replies are no longer allowed.