Problems for Milestone 4

[marpierc]

I'm getting the following errors below. The job is running on Karst successfully.

2016-04-20 12:59:03.397 INFO 25599 --- [bio-8443-exec-3] org.airavata.teamzenith.ssh.SshUtil : qsub /N/u/marpierc/Karst/workspace/PBS_Script_1461171540875.pbs: Executed successfully !!! 2016-04-20 12:59:03.398 INFO 25599 --- [bio-8443-exec-3] o.a.teamzenith.drivers.JobManagement : Command Executed with response : 1422527.m2

2016-04-20 12:59:03.398 INFO 25599 --- [bio-8443-exec-3] o.a.teamzenith.webmethods.SubmitJob : Job ID is :1422527 2016-04-20 12:59:03.398 INFO 25599 --- [bio-8443-exec-3] o.a.teamzenith.webmethods.SubmitJob : LE USERNAME ISmarpierc Hibernate: select userdata0_.UserId as col_00 from TZ_USERDATA userdata0 where userdata0_.UserName=? 2016-04-20 12:59:03.421 ERROR 25599 --- [bio-8443-exec-3] o.s.boot.context.web.ErrorPageFilter : Forwarding to error page from request [/upload] due to exception [No entity found for query; nested exception is javax.persistence.NoResultException: No entity found for query]

org.springframework.dao.EmptyResultDataAccessException: No entity found for query; nested exception is javax.persistence.NoResultException: No entity found for query

[a2l007]

Hello Marlon, Could you please confirm that the queries provided in DDL.txt has been executed in your database?

[marpierc]

How would you like for me to do this?

From: ajinkya-dhamnaskar notifications@github.com<mailto:notifications@github.com> Reply-To: airavata-courses/TeamZenith reply@reply.github.com<mailto:reply@reply.github.com> Date: Wednesday, April 20, 2016 at 7:51 PM To: airavata-courses/TeamZenith TeamZenith@noreply.github.com<mailto:TeamZenith@noreply.github.com> Cc: marpierc marpierc@iu.edu<mailto:marpierc@iu.edu>, Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [airavata-courses/TeamZenith] Problems for Milestone 4 (#46)

Hello Marlon, Could you please confirm that the queries provided in DDL.txt has been executed in your database?

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHubhttps://github.com/airavata-courses/TeamZenith/issues/46#issuecomment-212655470

[a2l007]

Connect to mysql using the following command: mysql -u root -p followed by the password. Then execute: use zenith; followed by: select * from TZ_USER_DATA; Could you please provide the output of the above SELECT query? This can help us verify.

[marpierc]

mysql> use zenith;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from TZ_USER_DATA;

+--------+-----------------+-----------------+

| UserId | UserName | Email |

+--------+-----------------+-----------------+

| 1 | marpierc@iu.edu | marpierc@iu.edu |

+--------+-----------------+-----------------+

1 row in set (0.00 sec)

mysql>

From: ajinkya-dhamnaskar notifications@github.com<mailto:notifications@github.com> Reply-To: airavata-courses/TeamZenith reply@reply.github.com<mailto:reply@reply.github.com> Date: Wednesday, April 20, 2016 at 9:00 PM To: airavata-courses/TeamZenith TeamZenith@noreply.github.com<mailto:TeamZenith@noreply.github.com> Cc: marpierc marpierc@iu.edu<mailto:marpierc@iu.edu>, Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [airavata-courses/TeamZenith] Problems for Milestone 4 (#46)

select * from TZ_USER_DATA;

[a2l007]

The issue is with the username in TZ_USER_DATA. Our application expects the username column to be the username which is used to login to Karst/BigRed2. That is, the value without the @iu.edu domain. In this case, the value should be marpierc Sorry that we hadn't added that to the instructions. This has been added now. In order to rectify this issue, please execute the following update query on your database and then run the job:

UPDATE TZ_USER_DATA SET username='marpierc' WHERE UserId=1;

[marpierc]

OK, I will try it. I will just create a new user.

From: ajinkya-dhamnaskar notifications@github.com<mailto:notifications@github.com> Reply-To: airavata-courses/TeamZenith reply@reply.github.com<mailto:reply@reply.github.com> Date: Thursday, April 21, 2016 at 1:09 PM To: airavata-courses/TeamZenith TeamZenith@noreply.github.com<mailto:TeamZenith@noreply.github.com> Cc: marpierc marpierc@iu.edu<mailto:marpierc@iu.edu>, Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [airavata-courses/TeamZenith] Problems for Milestone 4 (#46)

The issue is with the username in TZ_USER_DATA. Our application expects the username column to be the username which is used to login to Karst/BigRed2. That is, the value without the @iu.edu domain. In this case, the value should be marpierc Sorry that we hadn't added that to the instructions. This has been added now. In order to rectify this issue, please execute the following update query on your database and then run the job:

UPDATE TZ_USER_DATA SET username='marpierc' WHERE UserId=1;

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHubhttps://github.com/airavata-courses/TeamZenith/issues/46#issuecomment-213020803

[marpierc]

Hi Atul, this is a bug. The account creation form doesn’t ask for a user name, so you must be using the email.

From: ajinkya-dhamnaskar notifications@github.com<mailto:notifications@github.com> Reply-To: airavata-courses/TeamZenith reply@reply.github.com<mailto:reply@reply.github.com> Date: Thursday, April 21, 2016 at 1:09 PM To: airavata-courses/TeamZenith TeamZenith@noreply.github.com<mailto:TeamZenith@noreply.github.com> Cc: marpierc marpierc@iu.edu<mailto:marpierc@iu.edu>, Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [airavata-courses/TeamZenith] Problems for Milestone 4 (#46)

The issue is with the username in TZ_USER_DATA. Our application expects the username column to be the username which is used to login to Karst/BigRed2. That is, the value without the @iu.edu domain. In this case, the value should be marpierc Sorry that we hadn't added that to the instructions. This has been added now. In order to rectify this issue, please execute the following update query on your database and then run the job:

UPDATE TZ_USER_DATA SET username='marpierc' WHERE UserId=1;

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHubhttps://github.com/airavata-courses/TeamZenith/issues/46#issuecomment-213020803

[marpierc]

I did change the username field directly in the DB, which seems to fix some of the problems. But you need to fix this issue in your submission.

[a2l007]

We have fixed this issue in the latest commit. Could you please review?