Convert Microsoft Excel Spreadsheet to PDF in Java issue using Aspose.Cells REST API

Aspose.Cells Cloud Product Family
,
1

Hi Aspose’s Support,

I have converted Excel to Pdf as following sample :
Convert Excel Workbook to Different File Formats
with following steps :

  • Step 1 : Upload excel file to Aspose’s server (ex : excel.xlsx)
  • Step 2 : Convert excel file into result PDF (ex : result.pdf)
    ( String strURI = “http://api.aspose.com/v1.1/cells/excel.xlsx/saveAs?newfilename=result.pdf”; )
  • Step 3 : Download result PDF file (using GET method)

I have been noticed that the converting pdf progress fail in Step 2 from our customers
(from 15-Feb-2016 23:40 GMT+07 to 16-Feb-2016 06:52 GMT+07), about 270 cases.

I have just tested it again (at 09:15) and the progress of converting pdf okie. Please tell me what’s wrong with it.

Thanks,
Chien

2

Hi Chien,


Thank you for contacting Aspose support.

I have checked the scenario (from step 1 to 3) on my side and I have found the service is working fine at the moment. I have also requested the concerned member of the team to check the service logs in order to find out the probable reason for service disruption during the mentioned time slot. We will shortly get back to you with more updates in this regard.
3

Hi Chien,

Database was updated and some database related changes were pushed during that period. Most probably that can be the reason for your conversion failures however we are further investigating it to check if something else caused these conversion failures.

Best Regards,

4

Hello,

This issue is happening again now.
Please check and resolve it asap.

Thanks,
Tuan

5

Hi all,

We have still received the same errors from 16-Feb-2016 19:25 GMT+07 to 17-Feb-2016 07:05 GMT+07, about 1100 cases in 12 hours. I have tested it again at 09:24 today and it’s OK now. Did these errors relate to database issues ?

Thanks,
Chien

6

Hi Chien,


The service is working fine at the moment, moreover, we are investigating the problem cause during the mentioned time period and we will share shortly get back with updates in this regards.
7

Hi Chien,

Our platform team is investigating it on priority and we will share our findings as soon as our investigation is complete. Sorry for the inconvenience.

Best Regards,

8

Hi Muhammad,

Do you have any updates on this ?
Has this issue been addressed and fixed ?

Thanks,
Tuan

9

Hi Tuan,

We did not find any suspicious entry in our logs to show if there was any problem in the service. Some database changes were deployed during the periods mentioned in your post. Those changes were the possible cause of interruption at your end. We have also deployed a fix to stop this issue from happening in future.

Please let us know if you noticed this issue again. Sorry for the inconvenience.

Best Regards,

10

Hi Muhammad,

This was still happening from 02/22/2016 14:00 - 24:00 GMT-0.
We really need a permanent fix for this issue.

Thanks

11

Hi Tuan,

Can you please confirm if the files fail during that period and same files convert after that period?

Best Regards,

12

Hi Muhammad,

Yes, the files failed in multiple cases in time range about 10 hours.
All of our errors in that time related to Step 2 as following :

Step 1 : Upload excel file to Aspose’s server (ex : excel.xlsx)
Step 2 : Convert excel file into result PDF (ex : result.pdf)
( String strURI = “http://api.aspose.com/v1.1/cells/excel.xlsx/saveAs?newfilename=result.pdf ”; )
Step 3 : Download result PDF file (using GET method)

Note that, if the Step 2 is OK, we will have the file result.pdf at the same folder with file excel.xlsx .
But we can’t find the file result.pdf after finishing Step 2 . We have checked the existing of file result.pdf as following :

Check if file or folder exists
Here is my Java code for checking existed file result.pdf (after Step 2 ) :

/**
* File Aspose exists or not
* @param fileName
*/
public static boolean isExistFileAspose(String fileName) {

try {
String strFilePath = Product.getBaseProductUri() + “/storage/exist/” + fileName;
String signedFilePath = com.saaspose.common.Utils.Sign(strFilePath);
InputStream checkExist = getInputStream4ReadData(signedFilePath);

// {“FileExist”:{“IsExist”:true,“IsFolder”:false},“Code”:200,“Status”:“OK”}
String strCheckExists = com.saaspose.common.Utils.StreamToString(checkExist);
System.out.println("strCheckExist : " + strCheckExists);

JSONObject jsonData = new JSONObject(strCheckExists);
// String code = jsonData.getString(“Code”);
// String status = jsonData.getString(“Status”);
String isExist = jsonData.getJSONObject(“FileExist”).getString(“IsExist”);
if (“true”.equals(isExist)) {
return true;
}

} catch (Exception e) {
log.warning("Exception : " + Utils.exceptionToStringShort(e));
}

return false;
}

Here is my error time ranges log when requesting convert pdf to Aspose’s server
(use the timezone GMT +07) :

16/Feb : 00:00 → 10:00, 18:00 → 23:58
17/Feb : 00:00 → 07:00, 20:15 → 23:59
18/Feb : 00:00 → 07:47, 20:42 → 23:59
19/Feb : 00:00 → 09:22, 19:15 → 23:59
20/Feb : 00:00 → 08:15, 20:55 → 23:59
21/Feb : 00:00 → 05:25
22/Feb : 08:56 → 09:00, 21:02 → 23:59
23/Feb : 00:00 → 08:48

It seemed the errors occur in the mornings and the nights (with the same rules)

Thanks,
Chien

13

Hi Chien,

Will it be possible for you to share one or two documents which were failed and no PDFs were generated against them?

Best Regards,

14

Hi Muhammad,

Here are some cases of our errors (timezone GMT+07)

Excel link download : http://api.aspose.com/v1.1/storage/file/3808-Palisades-Ave-02-22-2016-Office_Managers_Report-Jose-Pacheco_2028779.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=%2FO394A9Y1MHsIv7BhvWjcwQ7NOc

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/3808-Palisades-Ave-02-22-2016-Office_Managers_Report-Jose-Pacheco_2028779.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=ZMHQ3kzLKlRloTYP4LinDWc11yo

Time process : 22-Feb-2016 21:02:38 GMT+07

=============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/The-Village-Apts-02-22-2016-Bedbug_Inspection-AJ-Mack-Larry-Hardin_9410783.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=1hUhL4H9EBZFBE%2FlSdQWfjGyYP4

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/The-Village-Apts-02-22-2016-Bedbug_Inspection-AJ-Mack-Larry-Hardin_9410783.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=RM%2B7etRMiX5QMd7xa2NL2B9lRGE

Time process : 22-Feb-2016 21:17:40 GMT+07

==============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/Rowan-Towers-02-19-2016-Sanitation_Report-Leroy-Baker-demikia-smith_0631752.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=yb6cWnq0uK8W1R%2FWVueXKsu9n%2BY

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/Rowan-Towers-02-19-2016-Sanitation_Report-Leroy-Baker-demikia-smith_0631752.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=KCH2CT0I3xMkb8G58FLOKS7WoA8

Time process : 22-Feb-2016 21:39:16 GMT+07

===============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/52-Bright-Street-02-22-2016-Office_Managers_Report-Jose-Pacheco_5148391.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=%2FaVQ88Io1edDBZeeI%2BWR4KaCRxo

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/52-Bright-Street-02-22-2016-Office_Managers_Report-Jose-Pacheco_5148391.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=f%2BYYxx3ejLsUt78MnzT58fnSTrc

Time process : 22-Feb-2016 22:27:11 GMT+07

===============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/Green-Street-Apartments-02-22-2016-Office_Managers_Report-Richard-Thomas_1187189.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=Dpa2wOq2c61lIYJ71WBR%2FuodmbY

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/Green-Street-Apartments-02-22-2016-Office_Managers_Report-Richard-Thomas_1187189.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=PuhZyznD4bH7BBGiv3v3aH9tjBE

Time process : 22-Feb-2016 23:38:35 GMT+07

===============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/Bradley-Court-NHA-2-14-02-22-2016-Office_Managers_Report-Wes-Newton_8814913.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=JR6qpwKEAzKF0R5J%2Bw7I05tts%2Fk

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/Bradley-Court-NHA-2-14-02-22-2016-Office_Managers_Report-Wes-Newton_8814913.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=eCtSwyjwfAJ7lS%2BRFKk5XdErdFo

Time process : 22-Feb-2016 23:58:13 GMT+07

Thanks,
Chien

15

Hi Chien,


Thank you for sharing the samples. We have logged an investigative ticket with Id SAASCELLS-157 to look further into this matter. Please spare us little time for analysis. In meanwhile, we will keep you posted with updates in this regard.
16

Just wanted to let you know the issue is reoccurring now so please fix it asap.

17

Hi again,


We have intimated the concerned member of the product team to schedule the analysis and share the findings at earliest possible. Please spare us some time for thorough investigation. As soon as we get any updates, we will share here for your reference.
18

Hi all,

I have tested it again with some above spreadsheets and I’ve got the response error in Step 2 as following :

Result of strResponseSave PDF :
Error in calculating Cell[[0]Office Managers Report!AN1]
=> The converting pdf fail.
(Checking time : 24-Feb-2016 16:50 GMT +07)

===============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/52-Bright-Street-02-22-2016-Office_Managers_Report-Jose-Pacheco_5148391.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=%2FaVQ88Io1edDBZeeI%2BWR4KaCRxo

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/52-Bright-Street-02-22-2016-Office_Managers_Report-Jose-Pacheco_5148391.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=f%2BYYxx3ejLsUt78MnzT58fnSTrc

Time process : 22-Feb-2016 22:27:11 GMT+07

===============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/Green-Street-Apartments-02-22-2016-Office_Managers_Report-Richard-Thomas_1187189.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=Dpa2wOq2c61lIYJ71WBR%2FuodmbY

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/Green-Street-Apartments-02-22-2016-Office_Managers_Report-Richard-Thomas_1187189.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=PuhZyznD4bH7BBGiv3v3aH9tjBE

Time process : 22-Feb-2016 23:38:35 GMT+07

===============================================================
Excel link download : http://api.aspose.com/v1.1/storage/file/Bradley-Court-NHA-2-14-02-22-2016-Office_Managers_Report-Wes-Newton_8814913.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=JR6qpwKEAzKF0R5J%2Bw7I05tts%2Fk

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/Bradley-Court-NHA-2-14-02-22-2016-Office_Managers_Report-Wes-Newton_8814913.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=eCtSwyjwfAJ7lS%2BRFKk5XdErdFo

Time process : 22-Feb-2016 23:58:13 GMT+07

Thanks,
Chien

19

Hi Chien,


I have just tested the conversion process for mentioned spreadsheets however, I am not able to observe the said error on my end. I have requested the concerned member of the product team to investigate the scenario to find out why you have experienced this error during the mentioned time. In meanwhile, could you please recheck the scenario using any of the spreadsheets shared here?

My PdfSaveOptions XML looks as follow.

<PdfSaveOptions>
<– Pdf property –>
<CalculateFormula>True</CalculateFormula>
<CheckFontCompatibility>False</CheckFontCompatibility>
<Compliance>None</Compliance>
<OnePagePerSheet>True</OnePagePerSheet>
<desiredPPI>90</desiredPPI>
<jpegQuality>70</jpegQuality>
<SaveFormat>Pdf</SaveFormat>
</PdfSaveOptions>
20

Hi Babar,

I have just tested with my spreadsheet again and I’ve got the same error as yesterday.

Error in calculating Cell[[0]Office Managers Report!AN1]

Excel File name :
CHIEN-02-15-2016-11-02-13-GMT07-00-Field-Text_3170928.xltx >>
FileSize : 340863 bytes <=> 0.3250723 MB

Excel link download : http://api.aspose.com/v1.1/storage/file/CHIEN-02-15-2016-11-02-13-GMT07-00-Field-Text_3170928.xltx?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=sxLElD5nmrrZu22NFbrzXcjcgCk

Expected PDF link download : http://api.aspose.com/v1.1/storage/file/CHIEN-02-15-2016-11-02-13-GMT07-00-Field-Text_3170928.pdf?appSID=febd886e-b9dc-4514-9deb-73f48f81dc71&signature=vyv1K42E85q%2BAFTM7tKGLqOn%2BDU

Time process : 25-Feb-2016 10:15:07 GMT+07

Here is my PDF Save Options :

PDFSave options :

true
true
false
None
400
95
false
Pdf

These are some detail of code’s logs :

uploadURI : http://api.aspose.com/v1.1/storage/file/CHIEN-02-15-2016-11-02-13-GMT07-00-Field-Text_6379367.xltx
strURIPdf (raw URL) : http://api.aspose.com/v1.1/cells/CHIEN-02-15-2016-11-02-13-GMT07-00-Field-Text_6379367.xltx/saveAs?newfilename=CHIEN-02-15-2016-11-02-13-GMT07-00-Field-Text_6379367.pdf&isAutoFitRows=true
strResponseSave PDF : Error in calculating Cell[[0]Office Managers Report!AN1]
strCheckExist : {“FileExist”:{“IsExist”:false,“IsFolder”:false},“Code”:200,“Status”:“OK”}

Thanks,
Chien