Error during archive

I have not been able to get a clean run of the archive process with no parameters. Of the 12 sites we are monitoring, only one gets an error. It is by far our busiest site with 8 - 9 thousand visits a day. It seems to be that the other sites are only looking at the last 2 periods for days, weeks, months and years. For site id 5, our busiest, it runs the last 2 days and then it is currently trying to run the last 150 weeks, which throws an error. That number has been incrementing each day. I can include the output from running just site id 5 if necessary.

Here is the output:
INFO [2020-05-08 15:53:43] 5724 START
INFO [2020-05-08 15:53:43] 5724 Starting Matomo reports archiving…
INFO [2020-05-08 15:53:44] 5724 Will pre-process for website id = 5, period = day, date = last2
INFO [2020-05-08 15:53:44] 5724 - pre-processing all visits
INFO [2020-05-08 15:54:54] 5724 Archived website id = 5, period = day, 0 segments, 10542 visits in last 2 days, 2319 visits
today, Time elapsed: 70.905s
INFO [2020-05-08 15:55:01] 5724 Will pre-process for website id = 5, period = week, date = last150
INFO [2020-05-08 15:55:01] 5724 - pre-processing all visits
/php/php.exe : ERROR [2020-05-08 15:56:29] 5724 Got invalid response from API request:
?module=API&method=API.get&idSite=5&period=week&date=last150&format=php&trigger=archivephp. Response was ’
At C:\Users\matomo_admin\Documents\Matomo archive V4.ps1:1 char:1

  • /php/php.exe C:\inetpub\wwwroot\webmetrics.mygeosource.com\console co …
  •   + CategoryInfo          : NotSpecified: (ERROR [2020-05-...l1-strict.dtd">:String) [], RemoteException
      + FullyQualifiedErrorId : NativeCommandError
    
    
500 - Internal server error.

Server Error

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

' INFO [2020-05-08 15:56:29] 5724 Archived website id = 5, period = week, 0 segments, 0 visits in last 150 weeks, 0 visits thi s week, Time elapsed: 94.118s INFO [2020-05-08 15:56:29] 5724 Archived website id = 5, 2 API requests, Time elapsed: 165.146s [1/1 done] INFO [2020-05-08 15:56:29] 5724 Done archiving! INFO [2020-05-08 15:56:29] 5724 --------------------------- INFO [2020-05-08 15:56:29] 5724 SUMMARY INFO [2020-05-08 15:56:29] 5724 Total visits for today across archived websites: 2319 INFO [2020-05-08 15:56:29] 5724 Archived today's reports for 1 websites INFO [2020-05-08 15:56:29] 5724 Archived week/month/year for 1 websites INFO [2020-05-08 15:56:29] 5724 Skipped 11 websites INFO [2020-05-08 15:56:29] 5724 - 0 skipped because no new visit since the last script execution INFO [2020-05-08 15:56:29] 5724 - 0 skipped because existing daily reports are less than 900 seconds old INFO [2020-05-08 15:56:29] 5724 - 0 skipped because existing week/month/year periods reports are less than 3600 seconds old INFO [2020-05-08 15:56:29] 5724 Total API requests: 2 INFO [2020-05-08 15:56:29] 5724 done: 1/1 100%, 2319 vtoday, 1 wtoday, 1 wperiods, 2 req, 165147 ms, 1 errors. INFO [2020-05-08 15:56:29] 5724 Time elapsed: 165.147s INFO [2020-05-08 15:56:29] 5724 --------------------------- INFO [2020-05-08 15:56:29] 5724 SCHEDULED TASKS INFO [2020-05-08 15:56:29] 5724 Starting Scheduled tasks... INFO [2020-05-08 15:56:29] 5724 done INFO [2020-05-08 15:56:29] 5724 --------------------------- INFO [2020-05-08 15:56:29] 5724 --------------------------- INFO [2020-05-08 15:56:29] 5724 SUMMARY OF ERRORS INFO [2020-05-08 15:56:29] 5724 Error: Got invalid response from API request: ?module=API&method=API.get&idSite=5&period=wee k&date=last150&format=php&trigger=archivephp. Response was ' 500 - Internal server error.

Server Error

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

' ERROR [2020-05-08 15:56:29] 5724 1 total errors during this script execution, please investigate and try and fix these errors. ERROR [2020-05-08 15:56:29] 5724 Uncaught exception: C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\CronArchive.php(606): 1 total errors during this script execution, please investigate and try and fix these errors. 1 total errors during this script execution, please investigate and try and fix these errors. #0 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\CronArchive.php(599): Piwik\CronArchive->logFatalError('1 total errors ...') #1 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\CronArchive.php(331): Piwik\CronArchive->end() #2 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\Access.php(635): Piwik\CronArchive->Piwik\{closure}() #3 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\CronArchive.php(335): Piwik\Access::doAsSuperUser(Object(Closure)) #4 C:\inetpub\wwwroot\webmetrics.mygeosource.com\plugins\CoreConsole\Commands\CoreArchiver.php(27): Piwik\CronArchive->main() #5 C:\inetpub\wwwroot\webmetrics.mygeosource.com\vendor\symfony\console\Symfony\Component\Console\Command\Command.php(257): Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #6 C:\inetpub\wwwroot\webmetrics.mygeosource.com\vendor\symfony\console\Symfony\Component\Console\Application.php(874): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #7 C:\inetpub\wwwroot\webmetrics.mygeosource.com\vendor\symfony\console\Symfony\Component\Console\Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\Plugins\CoreConsole\Commands\CoreArchiver), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #8 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #9 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\Console.php(140): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #10 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\Access.php(644): Piwik\Console->Piwik\{closure}() #11 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\Console.php(141): Piwik\Access::doAsSuperUser(Object(Closure)) #12 C:\inetpub\wwwroot\webmetrics.mygeosource.com\core\Console.php(93): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 C:\inetpub\wwwroot\webmetrics.mygeosource.com\vendor\symfony\console\Symfony\Component\Console\Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 C:\inetpub\wwwroot\webmetrics.mygeosource.com\console(32): Symfony\Component\Console\Application->run() #15 {main}

[Exception]
1 total errors during this script execution, please investigate and try and fix these errors.

core:archive [–url="…"] [–force-all-websites] [–force-all-periods[="…"]] [–force-timeout-for-periods[="…"]]
[–skip-idsites[="…"]] [–skip-all-segments] [–force-idsites[="…"]] [–skip-segments-today] [–force-periods[="…"]]
[–force-date-last-n="…"] [–force-date-range[="…"]] [–force-idsegments="…"]
[–concurrent-requests-per-website[="…"]] [–concurrent-archivers[="…"]] [–disable-scheduled-tasks]
[–accept-invalid-ssl-certificate] [–php-cli-options[="…"]]

PS C:\Windows\system32>

Hi,

Can you please check the php error log to see if there are more information about what exactly the error is?

It took me a while to get the php error logging to work and then verified. Unfortunately, no erros are being recorded in the PHP error log. I do see some erros when I was working on the DB server and I have error reporting set for E_ALL.