SOGo | BTS

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004502SOGoWeb Generalpublic2018-07-03 13:482018-10-23 10:15
Reporternuwohg 
Assigned To 
PriorityhighSeverityminorReproducibilityalways
StatusnewResolutionopen 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version4.0.0 
Target VersionFixed in Version 
Summary0004502: Calendar and addressbook export
DescriptionWhen trying to export an calenar or addressbook I get this error message: "the called object returned no result" and nothing is exported.
SOGo version is: sogo_4.0.0.20180703-1_amd64.deb
TagsNo tags attached.
Attached Fileszip file icon usuari.ana.zip [^] (632,213 bytes) 2018-10-05 09:39
txt file icon trace1.txt [^] (13,159 bytes) 2018-10-23 10:14 [Show Content]
txt file icon trace2.txt [^] (14,159 bytes) 2018-10-23 10:15 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
User avatar (0012943)
francis (administrator)
2018-07-09 14:00

Any error in your sogo logs?
(0012945)
nuwohg (reporter)
2018-07-10 03:01

Yes:

Exporting personal addressbook:

sogo.log
########
Jul 10 08:51:21 sogod [1513]: 87.140.100.188 "GET /SOGo/so/p.stirnberg@ruhrmail.de/Contacts/personal/export HTTP/1.0" 500 36/0 0.007 - - 0

nginx access.log
################
87.140.100.188 - - [10/Jul/2018:08:55:02 +0200] "GET /SOGo/so/p.stirnberg@ruhrmail.de/Contacts/personal/export HTTP/1.1" 500 36 "https://ruhrmail.email/SOGo/so/p.stirnberg@ruhrmail.de/Contacts/view" [^] "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/66.0.3359.181 Chrome/66.0.3359.181 Safari/537.36"

nginx error.log
###############
empty
(0013013)
ASolana (reporter)
2018-09-04 06:23

This issue still appears on SOGo 4.0.1:

- sogo.log
Sep 04 12:10:23 sogod [50058]: 10.4.198.78 "GET /SOGo/so/usuari.ana/Contacts/personal/export HTTP/1.1" 500 36/0 0.072 - - 0
(0013014)
nuwohg (reporter)
2018-09-04 06:38

This issue still appears on SOGo 4.0.2
User avatar (0013015)
francis (administrator)
2018-09-05 10:39

No exception? Can one of you try to debug [UIxContactFolderActions exportAction]?
(0013018)
nuwohg (reporter)
2018-09-11 05:18

Sorry, I'm no developer and don't know how to do this. Setting SOGoUIxDebugEnabled to YES does not have any effect in sogo.log.
User avatar (0013021)
francis (administrator)
2018-09-12 09:22

If you feel adventurous:

https://sogo.nu/support/faq/how-do-i-debug-sogo.html [^]
(0013022)
nuwohg (reporter)
2018-09-12 09:25

Well, I tried that and got errors which I couldn't resolve so I didn't got this dbg thing working, sorry.
(0013038)
ASolana (reporter)
2018-09-18 08:22

- I've tried to follow the debug procedure too, but I haven't got any relevant information, perhaps I did something wrong.

My SOGo 4.0.2 server uses a MySQL DB.


- A log example trying to export a calendar, executing sogo with more debug activated:

Sep 18 14:01:12 sogod [35737]: |SOGo| starting method 'GET' on uri '/SOGo/so/usuari.ana/Calendar/personal.ics/export'
Sep 18 14:01:12 sogod [35737]: |SOGo| traverse(acquire): usuari.ana => Calendar => personal.ics => export
Sep 18 14:01:12 sogod [35737]: |SOGo| do traverse name: 'usuari.ana'
Sep 18 14:01:12 sogod [35737]: |SOGo| do traverse name: 'Calendar'
Sep 18 14:01:12 sogod [35737]: |SOGo| do traverse name: 'personal.ics'
2018-09-18 14:01:12.152 sogod[35737] <MySQL4Channel[0x0x55cd51407300] connection=0x0x55cd513af880> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'usuari.ana' AND c_folder_type = 'Appointment';
2018-09-18 14:01:12.152 sogod[35737] <MySQL4Channel[0x0x55cd51407300] connection=0x0x55cd513af880> query has results, entering fetch-mode.
2018-09-18 14:01:12.152 sogod[35737] <MySQL4Channel[0x0x55cd50e9d720] connection=0x0x55cd50e19450> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/C4E2-5ACF3580-5-19960680';
2018-09-18 14:01:12.152 sogod[35737] <MySQL4Channel[0x0x55cd50e9d720] connection=0x0x55cd50e19450> query has results, entering fetch-mode.
2018-09-18 14:01:12.153 sogod[35737] <MySQL4Channel[0x0x55cd51407300] connection=0x0x55cd513af880> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/8BDE-5A8EB800-7-374D1F80';
2018-09-18 14:01:12.153 sogod[35737] <MySQL4Channel[0x0x55cd51407300] connection=0x0x55cd513af880> query has results, entering fetch-mode.
2018-09-18 14:01:12.153 sogod[35737] <MySQL4Channel[0x0x55cd50e9d720] connection=0x0x55cd50e19450> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/8E4F-5A8EB780-2B-1CDE5CE0';
2018-09-18 14:01:12.154 sogod[35737] <MySQL4Channel[0x0x55cd50e9d720] connection=0x0x55cd50e19450> query has results, entering fetch-mode.
Sep 18 14:01:12 sogod [35737]: |SOGo| do traverse name: 'export'
Sep 18 14:01:12 sogod [35737]: |SOGo| set clientObject: <0x55cd515920b0[SOGoAppointmentFolderICS]: name=personal.ics container=0x55cd516fb8a0/Calendar>
Sep 18 14:01:12 sogod [35737]: |SOGo| request took 0.010611 seconds to execute
Sep 18 14:01:12 sogod [35737]: 10.4.x.x, 10.4.x.x "GET /SOGo/so/usuari.ana/Calendar/personal.ics/export HTTP/1.1" 500 36/0 0.012 - - 0
User avatar (0013039)
francis (administrator)
2018-09-18 08:25

Can one of you create a backup of a problematic account (using sogo-tool) and send it to me by email? Thanks.
(0013074)
gupal (reporter)
2018-10-03 13:11

Having the same issue with 4.0.2.20181001 on Debian 9.
Does anybody know of a workaround for this issue?
(0013075)
nuwohg (reporter)
2018-10-04 02:01

Please give me an e-mail address so that I can send you the file.
(0013079)
ASolana (reporter)
2018-10-05 09:36

The issue appears for all users.
I've uploaded usuari.ana backup (it's a test user).
(0013080)
ASolana (reporter)
2018-10-05 09:39

The issue appears for all users.
I've uploaded usuari.ana.zip backup file (it's a test user).
(0013111)
gupal (reporter)
2018-10-16 06:00

Finally I found a workaround and was able to export my data from SOGo.
1. Access CardDAV and CalDAV with Thunderbird (Lightning & CardBook)
2. Export data from Thunderbird

I did not use all available entry fields, but from what I can tell, it seems like all data was exported correctly, even had no problems with character-encoding during the import in a different CardDAV & CalDAV Server.
(0013112)
nuwohg (reporter)
2018-10-16 06:23

This works also with Apple or Evolution, but it's unfortunately not what my users need. Export should work from webinterface for those who don't use any mail client.
(0013116)
ASolana (reporter)
2018-10-17 12:02

Messages folder exports fails in my server too (Ubuntu 16.04), same error message: "the called object returned no result"
(0013125)
sascha.kasch@sumcumo.com (reporter)
2018-10-23 08:05

Also have that problem on 4.0.3 stable, any progress here? I have another installation on nightly that is not affected, but I am not able to find the source.
User avatar (0013128)
francis (administrator)
2018-10-23 09:15

I need a stack trace as I can't reproduce this problem.
(0013130)
nuwohg (reporter)
2018-10-23 09:24

Same on sogo_4.0.3.20181023-1.

Unfortunately I don't know how to create a stack trace.
User avatar (0013131)
francis (administrator)
2018-10-23 09:45

https://sogo.nu/support/faq/how-do-i-debug-sogo.html [^]
(0013132)
nuwohg (reporter)
2018-10-23 10:13

As I mentioned before, this doesn't work for me and I have not enough skills to get this working.
I tried to guess the right PID and created a stack trace with this call -> gdb -p PID | tee trace.txt

I attach the 2 files which I created, maybe this helps.

- Issue History
Date Modified Username Field Change
2018-07-03 13:48 nuwohg New Issue
2018-07-09 14:00 francis Note Added: 0012943
2018-07-10 03:01 nuwohg Note Added: 0012945
2018-09-04 06:23 ASolana Note Added: 0013013
2018-09-04 06:38 nuwohg Note Added: 0013014
2018-09-05 10:39 francis Note Added: 0013015
2018-09-11 05:18 nuwohg Note Added: 0013018
2018-09-12 09:22 francis Note Added: 0013021
2018-09-12 09:25 nuwohg Note Added: 0013022
2018-09-18 08:22 ASolana Note Added: 0013038
2018-09-18 08:25 francis Note Added: 0013039
2018-10-03 13:11 gupal Note Added: 0013074
2018-10-04 02:01 nuwohg Note Added: 0013075
2018-10-05 09:36 ASolana Note Added: 0013079
2018-10-05 09:39 ASolana File Added: usuari.ana.zip
2018-10-05 09:39 ASolana Note Added: 0013080
2018-10-16 06:00 gupal Note Added: 0013111
2018-10-16 06:23 nuwohg Note Added: 0013112
2018-10-17 12:02 ASolana Note Added: 0013116
2018-10-23 08:05 sascha.kasch@sumcumo.com Note Added: 0013125
2018-10-23 09:15 francis Note Added: 0013128
2018-10-23 09:24 nuwohg Note Added: 0013130
2018-10-23 09:45 francis Note Added: 0013131
2018-10-23 10:13 nuwohg Note Added: 0013132
2018-10-23 10:14 nuwohg File Added: trace1.txt
2018-10-23 10:15 nuwohg File Added: trace2.txt


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker