Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Spreadsheet changes not save #32

Closed
spardahk opened this issue Jan 9, 2020 · 9 comments
Closed

Spreadsheet changes not save #32

spardahk opened this issue Jan 9, 2020 · 9 comments

Comments

@spardahk
Copy link

spardahk commented Jan 9, 2020

Hello, I installed Onlyoffice 5.4 and Nextcloud 16.0.5 installed on Ubuntu 18.04.3 using Snap.
After doing some setup, changes done for word and powerpoint are saved but not spreadsheet.

There is this error in the converter out.log after I edit a spreadsheet, but none if I edit word or powerpoint.

[2020-01-09T12:14:40.552] [ERROR] nodeJS - stderr (id=278330130_2252):change_code: Ma.KRd(z,Ea.TP,Ea.$ba,Ea.V4,Ea.t2b,Ea.G7)}AscFonts.hV=!1;c=this.jVa();a.Asc.editor.r3a(c,function(){if(e.FO.wk.YA)for(var a in y)if(vc(y[a])&&vc(y[a].Bg)&&vc(y[a].Bg.controller)){var c=y[a].Bg.m8e();c&&(c.Ua&&AscCommon.Rd.u5(c.Ua),c.xa&&AscCommon.Rd.u5(c.xa),c.ya&&AscCommon.Rd.u5(c.ya));y[a].Bg.Rdf()}Qe.c0b=!0;Qe.G_b=!0;Ma.pcd(null,z,!1);pb.Gt();e.FT=!1;e.jFc=e.V8a();null!=d&&d()})}else null!=d&&d()};Ua.prototype.FIf=function(c,d,e){if(null!=d){this.FT=!0;if(null==c){c=a.Asc.editor.ud.oba;for(var h in c)vc(c[h])&&
change: Uncaught TypeError: Cannot read property 'oba' of null
DoctRenderer:<result><error index="-2" /></result>
@ShockwaveNN ShockwaveNN transferred this issue from ONLYOFFICE/onlyoffice-nextcloud Jan 9, 2020
@ShockwaveNN
Copy link

Hi, is this error happen for any spreadsheet file?

@spardahk
Copy link
Author

Yes, even I add a new blank Spreadsheet in Nextcloud. The changes are not saved.
I found that the output.xlsx in the file cache is the original file, while the final copy is found for for Document and Presentation.
I missed the last line in the error. There is error = -86.

[2020-01-10T09:35:29.731] [ERROR] nodeJS - stdout (id=1184055309_1564):
[2020-01-10T09:35:29.731] [ERROR] nodeJS - stderr (id=1184055309_1564):change_code: Ma.KRd(z,Ea.TP,Ea.$ba,Ea.V4,Ea.t2b,Ea.G7)}AscFonts.hV=!1;c=this.jVa();a.Asc.editor.r3a(c,function(){if(e.FO.wk.YA)for(var a in y)if(vc(y[a])&&vc(y[a].Bg)&&vc(y[a].Bg.controller)){var c=y[a].Bg.m8e();c&&(c.Ua&&AscCommon.Rd.u5(c.Ua),c.xa&&AscCommon.Rd.u5(c.xa),c.ya&&AscCommon.Rd.u5(c.ya));y[a].Bg.Rdf()}Qe.c0b=!0;Qe.G_b=!0;Ma.pcd(null,z,!1);pb.Gt();e.FT=!1;e.jFc=e.V8a();null!=d&&d()})}else null!=d&&d()};Ua.prototype.FIf=function(c,d,e){if(null!=d){this.FT=!0;if(null==c){c=a.Asc.editor.ud.oba;for(var h in c)vc(c[h])&&
change: Uncaught TypeError: Cannot read property 'oba' of null
DoctRenderer:<result><error index="-2" /></result>

[2020-01-10T09:35:29.731] [ERROR] nodeJS - ExitCode (code=86;signal=null;error:-86;id=1184055309_1564)

Besides, I tried setting production.json to DEBUG. No additional details are shown.

{
        "appenders": {
                "default": {
                        "type": "console",
                        "layout": {
                                "type": "pattern",
                                "pattern": "[%d] [%p] %c - %.10000m"
                        }
                }
        },
        "categories": {
                "default": { "appenders": [ "default" ], "level": "DEBUG" }
        }
}

@ShockwaveNN
Copy link

Am I right that DocumentServer instlled via snap?
Could you try to install documentserver via Docker and see if problem exists?

@spardahk
Copy link
Author

I tried installing it in docker, and spreadsheet can be saved now.
Bot sure if there is any problem with the snap image?

@ShockwaveNN
Copy link

@spardahk Seems so, I move issue to snap repo

@ShockwaveNN ShockwaveNN transferred this issue from ONLYOFFICE/DocumentServer Jan 19, 2020
@akoyaxd
Copy link

akoyaxd commented Feb 13, 2020 •
edited

Hey, I have the exact same issue!

I tested:
latest/stable | 5.4.0 | 23 October 2019
latest/edge | 5.4.2 | 17 January 2020

Direct install: There wasn't any problem with saving spreadsheets there.

I think is is quite critical, since there is no sign of a Problem, until you close you Document and realize that all your changes are lost.

@CacheMinimal
Copy link

I have the same issue on Ubuntu 18.04 LTS server running 5.4.0 stable snap. The only possibly related log entries I can find are:

Feb  7 19:07:49 woody kernel: [873308.685265] audit: type=1400 audit(1581102469.677:466): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:07:49 woody kernel: [873308.685272] audit: type=1400 audit(1581102469.677:467): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:07:49 woody kernel: [873308.685743] audit: type=1400 audit(1581102469.677:468): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:07:49 woody kernel: [873308.685750] audit: type=1400 audit(1581102469.677:469): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.430827] audit: type=1400 audit(1581102509.424:470): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.430832] audit: type=1400 audit(1581102509.424:471): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.431292] audit: type=1400 audit(1581102509.424:472): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.431296] audit: type=1400 audit(1581102509.424:473): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851171] audit: type=1400 audit(1581102915.833:474): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851185] audit: type=1400 audit(1581102915.833:475): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851551] audit: type=1400 audit(1581102915.833:476): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851573] audit: type=1400 audit(1581102915.833:477): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0

@CacheMinimal CacheMinimal mentioned this issue Feb 14, 2020
Closed
@akoyaxd
Copy link

akoyaxd commented Feb 15, 2020

I have the same issue on Ubuntu 18.04 LTS server running 5.4.0 stable snap. The only possibly related log entries I can find are:

Feb  7 19:07:49 woody kernel: [873308.685265] audit: type=1400 audit(1581102469.677:466): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:07:49 woody kernel: [873308.685272] audit: type=1400 audit(1581102469.677:467): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:07:49 woody kernel: [873308.685743] audit: type=1400 audit(1581102469.677:468): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:07:49 woody kernel: [873308.685750] audit: type=1400 audit(1581102469.677:469): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32104 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.430827] audit: type=1400 audit(1581102509.424:470): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.430832] audit: type=1400 audit(1581102509.424:471): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.431292] audit: type=1400 audit(1581102509.424:472): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:08:29 woody kernel: [873348.431296] audit: type=1400 audit(1581102509.424:473): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=32232 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851171] audit: type=1400 audit(1581102915.833:474): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851185] audit: type=1400 audit(1581102915.833:475): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851551] audit: type=1400 audit(1581102915.833:476): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Feb  7 19:15:15 woody kernel: [873754.851573] audit: type=1400 audit(1581102915.833:477): apparmor="DENIED" operation="open" profile="snap.onlyoffice-ds.documentserver" name="/snap/core18/1668/lib/x86_64-linux-gnu/libgcc_s.so.1" pid=582 comm="x2t" requested_mask="r" denied_mask="r" fsuid=0 ouid=0

I am having the same log entries. Did you try the edge Version? (5.4.2)
On that Version they disappear. But Spreadcheats still don't get saved.

@CacheMinimal
Copy link

I am having the same log entries. Did you try the edge Version? (5.4.2)
On that Version they disappear. But Spreadcheats still don't get saved.

Afraid I didn't try the edge version as others had previously indicated no improvement. I've defected to the Docker image for now and everything works just beautifully on Ubuntu 18.04 LTS server.

romandemidov added a commit that referenced this issue Jan 19, 2021
@romandemidov
Fix #32 Spreadsheet changes not save
975c462
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@ShockwaveNN @akoyaxd @CacheMinimal @spardahk