...
[17:40:55 CDT(-0500)] <pspaude> Having issues with the DB. Am getting SQL errors and it is not saving information properly on newly entered students.
[17:46:10 CDT(-0500)] <pspaude> Student Intake is failing around primary caregiver information as well. Fails with SQL not truncated
[17:46:35 CDT(-0500)] <dmccallum54> a monitor?
[17:47:06 CDT(-0500)] <pspaude> Yeah monitoring the SQL database. Didn't know if you left one on. I don't think it matters, just weird stuff is happening.
[17:48:52 CDT(-0500)] <pspaude> And I'm not always able to duplicate. One student I entered the databse dropped his username and so then everything else I did I would get JSON errors for username. But, the one I entered after that it was ok?
[17:49:14 CDT(-0500)] <dmccallum54> definitely no New Relic monitoring. there's some standard monitoring you get with amazon RDS, but i think jason is the only one with access to that
[17:49:54 CDT(-0500)] <dmccallum54> you should be able to connect directly to the db if you want… mgmt console might be on the wins app server.
[17:50:06 CDT(-0500)] <pspaude> Another student I entered it wasn't auto-picking up his information in the other tools and again failing.
[17:50:36 CDT(-0500)] <pspaude> Ah, ok. I might do that. It seems to be getting better with the newly added students here. Weird.
[17:50:57 CDT(-0500)] <dmccallum54> or maybe you've already done this… but could RDP into the app server and tail the logs there
[17:51:05 CDT(-0500)] <dmccallum54> just to see if it's blowing traces
[17:53:12 CDT(-0500)] <pspaude> I was going to do that but it didn't repeat on two newer added students (newer being 1-2 minutes). I've got three students I think it will repeat on and I can go back in. I think it would blow traces as it was putting stuff in the console. The JSON actually looked good, just SQL is blowing up on something missing or an input field, but I went all through the intake and it hasn't repeated.
[17:53:49 CDT(-0500)] <dmccallum54> k
[17:58:46 CDT(-0500)] <pspaude> Alright got it again. UUID field... remoting now.