[Zoo-discuss] Update of database tables

[Fenoy Gerald]

Dear Rakesh,
sorry for late reply.

My answer inline below.

> Le 29 juin 2016 à 16:59, rakesh prithiviraj <rakeshuk at outlook.com> a écrit :
> 
> Hi,
> 
> For an asynchronous WPS execute request, I observe that the status of the job under column "fstate" in "services" table does not show "running" when the service is still running. Instead it is blank. but after the job is successfully completed, the status changes to "succeeded".  As soon as i submit the WPS execute request, a new entry is created in the table but with no value for "fstate". 
> 
> Is this configuration issue?

This is not a configuration issue. The fstate column should now contains « Running » when the service has been started.

> 
> Also I would like to know when the "files" table is updated. My async WPS job produces files and in the getResult I could see valid reference URL to the file but the "files" table in the database is always empty. 
> 
>  <wps:Output id="out1">
>     <wps:Reference href="http://192.168.3.86/ftep-output/f7177d10-3e06-11e6-bca9-005056011a8d/outDir/concatenated-files.txt" mimeType="application/text" encoding="UTF-8"/>
>   </wps:Output>
> 

The files tables is not used. Initially, the idea was to store a list of files created during the service run. Nevertheless, as the full response of the Execute request is store in the responses tables, it means it will already contain the list of created files. So there is no need to store the same information twice in two different tables. Obviously, it would make the retrieval of the created files easier as you don’t have to first parse the execute reponse (which vary depending on the version of the standard used) then replace again the tmpUrl by tmpPath. Still, it is not that hard to handle. Nevertheless, I think it may be a good idea to activate the capability to store the files created by both the ZOO-Kernel and the services in this table.

Please let me know what do you think about this. If you think it may help, then I can update the source code to insert both files created by the ZOO-Kernel and the ones created by the service.

I hope to hear back from you.

Best regards,


Gérald Fenoy
http://wiki.osgeo.org/wiki/User:Djay