You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@airavata.apache.org by Eroma Abeysinghe <er...@gmail.com> on 2017/01/17 19:22:49 UTC

Re: Error in job submitting from localserver

Hi Zhong,

Please check your storage resource preference settings. Once the setting is
done in PGA you need to add the storage resource ID in the pga_config.php
in PGA as well.

More info
1. Have you registered a storage resource in your local PGA? please follow
setting up steps in http://airavata.readthedocs.io/en/latest/
Gateway-Configurations/#StoreResource
2. Once registered in Gateway Profile UI you need to add the preferences
fro the created storage resource. Adding storage preference means adding

   - Login username
   - SSH login name to the storage
   resource
   - ​
   File System Root Location
   - actual location where users data files (inputs and outputs will reside
   - Resource Specific Credential Store Token
   - Token of the public key used for ssh communication

3. Then you need to login to the storage resource server and add the public
key of the assigned ssh token. So airavata can communicate with storage
resource.

You could follow the steps in http://airavata.readthedocs.io/en/latest/
Gateway-Configurations/#StoreResource as well.
If any more info needed please come on board
https://www.hipchat.com/gMDHyN1KM

Hope this helps

Thanks,
Eroma


On Tue, Jan 17, 2017 at 1:34 PM, Zhong Wang <zw...@cornell.edu> wrote:

> Hello Everyone,
>
>
>
> I have installed PGA on my local Linux. The local PGA sends the requests
> to the Airavata server(gw77.iu.xsede.org). Everything is ok, but when I
> submit one job to the Airavata server, the server will throw the exception.
> I copied the error message from the web page:
>
>
>
> org.apache.airavata.registry.cpi.AppCatalogException: javax.persistence.NoResultException:
> Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0"
> selected no result, but expected unique result. at
> org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.
> getStorageResource(StorageResourceImpl.java:125) at
> org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:123)
> at org.apache.airavata.gfac.impl.GFacWorker.(GFacWorker.java:75) at
> org.apache.airavata.gfac.server.GfacServerHandler.submitProcess(GfacServerHandler.java:161)
> at org.apache.airavata.gfac.server.GfacServerHandler$
> ProcessLaunchMessageHandler.onMessage(GfacServerHandler.java:274) at
> org.apache.airavata.messaging.core.impl.RabbitMQProcessLaunchConsumer$
> 2.handleDelivery(RabbitMQProcessLaunchConsumer.java:187) at
> com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144)
> at com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745) Caused by: javax.persistence.NoResultException:
> Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0"
> selected no result, but expected unique result. at org.apache.openjpa.
> persistence.QueryImpl.getSingleResult(QueryImpl.java:332) at
> org.apache.airavata.registry.core.app.catalog.resources.
> StorageResourceResource.get(StorageResourceResource.java:111) at
> org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.
> getStorageResource(StorageResourceImpl.java:121) ... 10 more
>
>
>
> Anyone have ideas about this error?
>
>
>
> Thank you very much,
>
>
> Zhong Wang
>
>
>



-- 
Thank You,
Best Regards,
Eroma

RE: Error in job submitting from localserver

Posted by Zhong Wang <zw...@cornell.edu>.
Marcus,
Thank you very much, I will.

Zhong Wang


From: Christie, Marcus Aaron [mailto:machrist@iu.edu]
Sent: Wednesday, January 18, 2017 8:23 AM
To: users@airavata.apache.org
Subject: Re: Error in job submitting from localserver

Zhong,

I talked with Eroma yesterday and I think we’ve come up with a solution for you. We’re planning on setting up a dev server you can use to test with. We can discuss more at the meeting today.

Thanks,

Marcus

On Jan 17, 2017, at 3:08 PM, Zhong Wang <zw...@cornell.edu>> wrote:

Hello Eroma,

Thank you for your information. I will try to do it.

I have another question, my local PGA does not have global IP,  it can be accessed via VPN by the lab outside. So it is impossible to communicate with the Airavata Server if the Airavata send the request from the outside. Is my understanding correct?

Thanks,

Zhong Wang


From: Eroma Abeysinghe [mailto:eroma.abeysinghe@gmail.com]
Sent: Tuesday, January 17, 2017 2:23 PM
To: users@airavata.apache.org<ma...@airavata.apache.org>
Subject: Re: Error in job submitting from localserver

Hi Zhong,

Please check your storage resource preference settings. Once the setting is done in PGA you need to add the storage resource ID in the pga_config.php in PGA as well.

More info
1. Have you registered a storage resource in your local PGA? please follow setting up steps in http://airavata.readthedocs.io/en/latest/Gateway-Configurations/#StoreResource
2. Once registered in Gateway Profile UI you need to add the preferences fro the created storage resource. Adding storage preference means adding
•         Login username
- SSH login name to the storage
resource
•         ​
File System Root Location
- actual location where users data files (inputs and outputs will reside
•         Resource Specific Credential Store Token
- Token of the public key used for ssh communication
3. Then you need to login to the storage resource server and add the public key of the assigned ssh token. So airavata can communicate with storage resource.

You could follow the steps in http://airavata.readthedocs.io/en/latest/Gateway-Configurations/#StoreResource as well.
If any more info needed please come on board https://www.hipchat.com/gMDHyN1KM

Hope this helps

Thanks,
Eroma


On Tue, Jan 17, 2017 at 1:34 PM, Zhong Wang <zw...@cornell.edu>> wrote:
Hello Everyone,

I have installed PGA on my local Linux. The local PGA sends the requests to the Airavata server(gw77.iu.xsede.org<http://gw77.iu.xsede.org/>). Everything is ok, but when I submit one job to the Airavata server, the server will throw the exception. I copied the error message from the web page:


org.apache.airavata.registry.cpi.AppCatalogException: javax.persistence.NoResultException: Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0" selected no result, but expected unique result. at org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:125) at org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:123) at org.apache.airavata.gfac.impl.GFacWorker.(GFacWorker.java:75) at org.apache.airavata.gfac.server.GfacServerHandler.submitProcess(GfacServerHandler.java:161) at org.apache.airavata.gfac.server.GfacServerHandler$ProcessLaunchMessageHandler.onMessage(GfacServerHandler.java:274) at org.apache.airavata.messaging.core.impl.RabbitMQProcessLaunchConsumer$2.handleDelivery(RabbitMQProcessLaunchConsumer.java:187) at com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144) at com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: javax.persistence.NoResultException: Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0" selected no result, but expected unique result. at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:332) at org.apache.airavata.registry.core.app.catalog.resources.StorageResourceResource.get(StorageResourceResource.java:111) at org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:121) ... 10 more


Anyone have ideas about this error?

Thank you very much,

Zhong Wang




--
Thank You,
Best Regards,
Eroma


Re: Error in job submitting from localserver

Posted by "Christie, Marcus Aaron" <ma...@iu.edu>.
Zhong,

I talked with Eroma yesterday and I think we’ve come up with a solution for you. We’re planning on setting up a dev server you can use to test with. We can discuss more at the meeting today.

Thanks,

Marcus

On Jan 17, 2017, at 3:08 PM, Zhong Wang <zw...@cornell.edu>> wrote:

Hello Eroma,

Thank you for your information. I will try to do it.

I have another question, my local PGA does not have global IP,  it can be accessed via VPN by the lab outside. So it is impossible to communicate with the Airavata Server if the Airavata send the request from the outside. Is my understanding correct?

Thanks,

Zhong Wang


From: Eroma Abeysinghe [mailto:eroma.abeysinghe@gmail.com]
Sent: Tuesday, January 17, 2017 2:23 PM
To: users@airavata.apache.org<ma...@airavata.apache.org>
Subject: Re: Error in job submitting from localserver

Hi Zhong,

Please check your storage resource preference settings. Once the setting is done in PGA you need to add the storage resource ID in the pga_config.php in PGA as well.

More info
1. Have you registered a storage resource in your local PGA? please follow setting up steps in http://airavata.readthedocs.io/en/latest/Gateway-Configurations/#StoreResource
2. Once registered in Gateway Profile UI you need to add the preferences fro the created storage resource. Adding storage preference means adding
•         Login username
- SSH login name to the storage
resource
•         ​
File System Root Location
- actual location where users data files (inputs and outputs will reside
•         Resource Specific Credential Store Token
- Token of the public key used for ssh communication
3. Then you need to login to the storage resource server and add the public key of the assigned ssh token. So airavata can communicate with storage resource.

You could follow the steps in http://airavata.readthedocs.io/en/latest/Gateway-Configurations/#StoreResource as well.
If any more info needed please come on board https://www.hipchat.com/gMDHyN1KM

Hope this helps

Thanks,
Eroma


On Tue, Jan 17, 2017 at 1:34 PM, Zhong Wang <zw...@cornell.edu>> wrote:
Hello Everyone,

I have installed PGA on my local Linux. The local PGA sends the requests to the Airavata server(gw77.iu.xsede.org<http://gw77.iu.xsede.org/>). Everything is ok, but when I submit one job to the Airavata server, the server will throw the exception. I copied the error message from the web page:


org.apache.airavata.registry.cpi.AppCatalogException: javax.persistence.NoResultException: Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0" selected no result, but expected unique result. at org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:125) at org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:123) at org.apache.airavata.gfac.impl.GFacWorker.(GFacWorker.java:75) at org.apache.airavata.gfac.server.GfacServerHandler.submitProcess(GfacServerHandler.java:161) at org.apache.airavata.gfac.server.GfacServerHandler$ProcessLaunchMessageHandler.onMessage(GfacServerHandler.java:274) at org.apache.airavata.messaging.core.impl.RabbitMQProcessLaunchConsumer$2.handleDelivery(RabbitMQProcessLaunchConsumer.java:187) at com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144) at com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: javax.persistence.NoResultException: Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0" selected no result, but expected unique result. at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:332) at org.apache.airavata.registry.core.app.catalog.resources.StorageResourceResource.get(StorageResourceResource.java:111) at org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:121) ... 10 more


Anyone have ideas about this error?

Thank you very much,

Zhong Wang




--
Thank You,
Best Regards,
Eroma


RE: Error in job submitting from localserver

Posted by Zhong Wang <zw...@cornell.edu>.
Hello Eroma,

Thank you for your information. I will try to do it.

I have another question, my local PGA does not have global IP,  it can be accessed via VPN by the lab outside. So it is impossible to communicate with the Airavata Server if the Airavata send the request from the outside. Is my understanding correct?

Thanks,

Zhong Wang


From: Eroma Abeysinghe [mailto:eroma.abeysinghe@gmail.com]
Sent: Tuesday, January 17, 2017 2:23 PM
To: users@airavata.apache.org
Subject: Re: Error in job submitting from localserver

Hi Zhong,

Please check your storage resource preference settings. Once the setting is done in PGA you need to add the storage resource ID in the pga_config.php in PGA as well.

More info
1. Have you registered a storage resource in your local PGA? please follow setting up steps in http://airavata.readthedocs.io/en/latest/Gateway-Configurations/#StoreResource
2. Once registered in Gateway Profile UI you need to add the preferences fro the created storage resource. Adding storage preference means adding
·         Login username
- SSH login name to the storage
resource
·         ​
File System Root Location
- actual location where users data files (inputs and outputs will reside
·         Resource Specific Credential Store Token
- Token of the public key used for ssh communication
3. Then you need to login to the storage resource server and add the public key of the assigned ssh token. So airavata can communicate with storage resource.

You could follow the steps in http://airavata.readthedocs.io/en/latest/Gateway-Configurations/#StoreResource as well.
If any more info needed please come on board https://www.hipchat.com/gMDHyN1KM

Hope this helps

Thanks,
Eroma


On Tue, Jan 17, 2017 at 1:34 PM, Zhong Wang <zw...@cornell.edu>> wrote:
Hello Everyone,

I have installed PGA on my local Linux. The local PGA sends the requests to the Airavata server(gw77.iu.xsede.org<http://gw77.iu.xsede.org>). Everything is ok, but when I submit one job to the Airavata server, the server will throw the exception. I copied the error message from the web page:


org.apache.airavata.registry.cpi.AppCatalogException: javax.persistence.NoResultException: Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0" selected no result, but expected unique result. at org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:125) at org.apache.airavata.gfac.impl.GFacEngineImpl.populateProcessContext(GFacEngineImpl.java:123) at org.apache.airavata.gfac.impl.GFacWorker.(GFacWorker.java:75) at org.apache.airavata.gfac.server.GfacServerHandler.submitProcess(GfacServerHandler.java:161) at org.apache.airavata.gfac.server.GfacServerHandler$ProcessLaunchMessageHandler.onMessage(GfacServerHandler.java:274) at org.apache.airavata.messaging.core.impl.RabbitMQProcessLaunchConsumer$2.handleDelivery(RabbitMQProcessLaunchConsumer.java:187) at com.rabbitmq.client.impl.ConsumerDispatcher$5.run(ConsumerDispatcher.java:144) at com.rabbitmq.client.impl.ConsumerWorkService$WorkPoolRunnable.run(ConsumerWorkService.java:99) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: javax.persistence.NoResultException: Query "SELECT p FROM StorageResource p WHERE p.storageResourceId =:param0" selected no result, but expected unique result. at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:332) at org.apache.airavata.registry.core.app.catalog.resources.StorageResourceResource.get(StorageResourceResource.java:111) at org.apache.airavata.registry.core.app.catalog.impl.StorageResourceImpl.getStorageResource(StorageResourceImpl.java:121) ... 10 more


Anyone have ideas about this error?

Thank you very much,

Zhong Wang




--
Thank You,
Best Regards,
Eroma