Server Error

[tr...@agilebts.com]

Hi

I am trying to update a Google spreadsheet with a batch request. I have 107 variables that I need to input into this spreadsheet. The Update Cells with a multiple batch request connector that I am using can only update 89 cells at a time before an error occurs. I created a new connector with the same parameters as the first and changed the content to only update cells 90-107. When I launch the process, the first 89 cells are updated, but second connector causes the error, "We're sorry, a server error occurred. Please wait a bit and try reloading your spreadsheet."

I've tried different variations of trying to update these last 17 cells, but keep getting the same error. Any help or suggestions would be appreciated.

[Sabine El Rassy]

Hello,

If you try to update the last 17 cells in a process apart does it work? If yes it means you need to wait few seconds between your first connector that update the 89 cells and the second one. 

Please do keep us posted.

Regards,

Sabine EL RASSY

PreSales Consultant

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

Mobile   : +33 (0) 6 22 10 64 61

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/65257ef1-bd6f-4d7d-a08b-83c163dc80d8%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

[tr...@agilebts.com]

I made a new process and tried to change the variables of the last 17 cells back to 1-17. (row90-->row, col90-->col, content90--->content1). I am using the same connector and the same code.

<entry>
<batch:id>$"{pos_id}"</batch:id>
<title type="text"></title>
<batch:operation type="update"/>
<id>https://spreadsheets.google.com/feeds/cells/${spreadsheet_id}/${worksheet_id}/private/full/R${row}C${col}</id>
<link rel="edit" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/cells/${spreadsheet_id}/${worksheet_id}/private/full/R${row}C${col}/version"/>
<gs:cell row="${row}" col="${col}" inputValue="${content1}"/>
</entry>

Now I am getting the error, "Invalid query parameter value for grid-id", with the id of the error being $"{pos_id}".

[Sabine El Rassy]

Hello,

I can see you have written <batch:id>$"{pos_id}"</batch:id>.

Can you try this code instead  <batch:id>"${pos_id}"</batch:id>

Regards,

Sabine EL RASSY

PreSales Consultant

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

Mobile   : +33 (0) 6 22 10 64 61

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/87d0d641-2875-43cd-8b64-028c5457c367%40runmyprocess.com.

[tr...@agilebts.com]

Yes when I use "${pos_id}" I receive an error saying that pos_id is undefined. I tried to put a value for pos_id into the inputs, but the same error came up, however pos_id was nowhere in the computed parameters. Is there a reason why pos_id is not registering in the process?

[Sabine El Rassy]

The correct syntax is "${pos_id}". So now you can see what the real problem is. 

Is your pos_id calculated within the process?

Regards