Monthly Archives: June 2012

Dong Shin 06.13.2012

issues at the site

using sub projects to limit what users can see
copy project generates error – some cascading error, but can’t duplicate it on mine.
users having problems viewing projects assigned to – fixed

getting error when logged out and try to log back in… and the login screen locks up

Error logggin in!
[FaultEvent fault=[RPC Fault faultString=”[MessagingError message=’Destination ‘PPMUserService’ either does not exist or the destination has no channels defined (and the application does not define any default channels.)’]” faultCode=”InvokeFailed” faultDetail=”Couldn’t establish a connection to ‘PPMUserService'”] messageId=”C6D2C3B1-E087-9059-0A89-E669D5CDC239″ type=”fault” bubbles=false cancelable=true eventPhase=2]

fixed projects not showing for users in PPM

SELECT projects.*, projects.uid as ID, projects.project_number as ‘Project ID’, projects.title as ‘Project Name’, begin_year as ‘Start FY’, end_year as ‘End FY’, begin_year as startYear, IF(ISNULL(lock_id), if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), IF (lock_id=’dongshin’, if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), ‘LOCKED’)) as Status, (end_year – begin_year) as duration, CONCAT(o.first_name, ‘ ‘, o.last_name) AS ‘Project Mgr’, CONCAT(a.first_name, ‘ ‘, a.last_name) AS ‘Portfolio Admin’, CONCAT(o.first_name, ‘ ‘, o.last_name) AS projMgrName, CONCAT(b.first_name, ‘ ‘, b.last_name) AS ‘Project Admin’, CONCAT(c.first_name, ‘ ‘, c.last_name) AS ‘Portfolio Mgr’, services, o.unclass_phone as projMgrPhone, o.unclass_phone_ext as projMgrPhoneExt, o.JWICS_email as projMgrJWICSemail, o.SIPR_email as projSIPRemail, o.unclass_email as projUnClassEmail, CONCAT(c.first_name, ‘ ‘, c.last_name) AS projSupervisorName, c.unclass_phone as projSupervisorPhone, c.unclass_phone_ext as projSupervisorPhoneExt, c.JWICS_email as projSupervisorJWICSemail, c.SIPR_email as projSupervisorSIPRemail, c.unclass_email as projSupervisorUnClassEmail, projects.total_budget as ‘Total Budget’, sub.project_id as parent_project_id, sub.sub_project_id FROM projects
LEFT JOIN _project_sub_projects as sub ON uid = sub_project_id
LEFT JOIN users AS o ON projects.proj_mgr_login = o.login
LEFT JOIN users AS a ON portfolio_mgr_login = a.login
LEFT JOIN users AS b ON proj_admin_login = b.login
LEFT JOIN users AS c ON portfolio_admin_login = c.login
WHERE (projects.proj_mgr_login = ‘dongshin’ OR projects.portfolio_mgr_login = ‘dongshin’ OR projects.proj_admin_login = ‘dongshin’ OR projects.portfolio_admin_login = ‘dongshin’)
OR (projects.uid in (SELECT project_id FROM _projects_portfolio_mgrs WHERE login = ‘dongshin’))
OR (projects.uid in (SELECT project_id FROM _projects_portfolio_admins WHERE login = ‘dongshin’))
OR (projects.uid in (SELECT project_id FROM _projects_service_finance_pocs WHERE login = ‘dongshin’))
OR (projects.uid in (SELECT project_id FROM _projects_service_project_mgrs WHERE login = ‘dongshin’))

fixed View Comments button not enabling after adding comments

Phil 6.13.12

8:00 – 5:00 FP

In prep for getting the mouse, I’m going add hand navigation to the demo.
Done. I added a “move model” choice in the Gl_ShaderWindo base class that sets a float[3] of the current desired(?) model XYZ. It’s up to the inheriting class to do something with it. In this case, I moved the hand origin in XZ space and left the position of the rotating cubes alone.
Checked in.
More modelling training

Tom 6.12.2012

Start: 10:00

For whatever reason I had a very hard time figuring out which connector was a hard drive power connector. It is molex 8981.
The footprint for this connector is not under molex but instead under Thomas Betts in pad to pad which is part of the reason I was confused.
Decided to use a single connector per component. This will make routing the traces more straight foward and may fix the problem I had when I tried before, without adding additional trace layers.

End: 6:00

1:00-4:00(OVERHEAD IT): Phil’s laptop has been having an intermittent problem where it randomly freezes. I also noticed that it was pretty slow.

I first checked the heat sinks as the laptop is kinda old and intermittent problems can be caused by overheating due to dust.
The heat sinks turned out to be cleaner than expected. Its kinda funny how my computer has a dust filter and somehow had way more dust in it.
When I started it back up I noticed the hard drive was running at full speed constantly and seemed to be the bottleneck in the performance. The main issue seemed to be that windows updates were behind but it was still odd that this would take so many resources when it was only downloading the updates.
I did some various other things like checking for malware, cleaning/defraging the registry, and a few other general maintenance procedures.
Once the updates and other maintenance was done, the computer seemed to run much better than initially. There is something strange where the programs that start with windows are using about 3 times as many handles as my computer which also runs vista. This may be causing some of the excess hard drive use but I am not sure.
As the problem was intermittent its hard to say if it was fixed but it does seem faster, so we’ll see. If it happens again either windows needs to be reinstalled or the hard drive should be replaced. I definitely recommend backing up all that isn’t already, as hard drive crashes do cause computers to lock up, and might be a sign its going soon.

Mike 6.12.2012

Server backups
Got another request on how to hide select budget centers from finance POCs while letting them see others, unfortunately the system was not designed that way so the only answer still seems to be sub-projects
Sent an email out the other 3 users having issues:

One responded that it was working now and he can also help someone else he works with
no response yet from the 3rd

Tested copying a project to create a sub-project, got a database error
Need to add some kind of banner or block to prevent users from getting on the test server since the URLs are so similar
More work on the charting package:

All the series specific configs are done
Just need a drag and drop interface for managing sets and z-order or series

Phil 6.12.12

8:00 – 4:00 FP

Was able to successfully print out the mouse yesterday. It printed “solid” in that it had structure on the inside to allow the piece not to collapse. I also wound up printing it at about 1/3 scale so that it only took an hour to print as opposed to six. Still, I’m pretty happy with the result. Below is the Blender version on the left and the MakerBot printout on the right:
Set up an account with Shapeways so that I can print out a more substantial model. And so that I don’t have to sit around for six hours waiting for something to print. Along the way, I learned why my mouse model was solid. You need to generate inner and outer walls and connect them. The printer doesn’t know how to handle printing two sides of a two-dimensional plane. This is controlled in Blender by detecting ‘Non-Manifold’ surfaces. If you find them, that means that the normals in that area are behaving oddly, and need to be fixed. Maya had a ‘clean up option, but blender doesn’t. Still working on how to completely fix a surface, though I do have it to the point what it looks pretty reasonable. We’ll see if Shapeways accepts it.
It was accepted, but came out as the wrong size. Trying to scale it now. Well, that seemed to work.
It’s now in the printing queue, and should be here by the 22nd!
Found the problem with the shape. There were edges *inside* the original shape that I rotated that were confusing the calculation of the normals. Next, time – delete those before rotating.
Made a fixed version and uploaded it to Shapeways.
Filled out AMPERE paperwork.
Make some dice. Done!

Mike 6.11.12

Scanned and deployed the latest version of the PPM documentation
Server backups
There was an issue with users assigned as ‘Service Finance POC (site)’ not being able to see projects in PA. Changing them to ‘Project Managers (site)’ resolved the issue
Drafted a simple retro-active requirements list. Jessica and Bill are going to revise them and hopefully we can come to a list to agree on.
added security banners to ppm and pa, loaded from config file
More work on the charting stuff:

the chart itself is done, it can read in an xml config and write one out.
The basic chart config options are done
Adding/removing series are all done
The only series where you can choose specific options (color, shape, etc.) is LineSeries
Need to finish specific config options for other series
Need to create a drag/drop tree for configuring series sets (stacked columns, areas, etc.) Also allows the user to pick z order of the series

Dong Shin 06.11.2012

fixed ProjectManagement panel messing up projects grid when filter is applied; AdvancedDataGrid requires IHierarchicalCollectionView
investing Comments now showing up properly – working properly, need to check at the site.
looking at adding status/progress bar to panels

Tom 6.8.2012

Start 10:00

Spread out everything a little more so that the connectors won’t be under the pcb boards
Fixed the labels
Moved the sensor circuits so that they are closer to the analog inputs on the arduino

End: 6:00

Phil 6.11.12

7:30 – 6:30 FP

Rode my legs off this weekend. There are mornings that it’s really good to be at work
Working on the mouse. Created an stl file, which is generally covered here: http://wiki.makerbot.com/how-to-print
Though for final ergonomics, it might make sense to model a mouse in clay and then scan it. These guys are local: http://www.dirdim.com/pdfs/DDI_Product_Service_Catalog.pdf
Made a penguin
Meeting at the PAD lab to learn how to use the MakerBot Replicator

Mike 6.8.2012

Server backups
Final prep for meeting
30 minute demo to colonel
1 hour tutorial session with PMs
Additional requirements, test plan, etc. discussion with Tangie, Bill, Jessica, and Lenni
A few of the immediate things to add:

Default security banners
A new project summary table with budget, appropriations, and available balance all by year
Need to check on why no comments are working

Phil 6.8.12

8:30 – 12:30 ESSO

Moved the lab yesterday, so no notes.
Customer meeting:

Add a read-only admin user? I.e. one that can see everything, but can’t make changes
Need capability to print out/copy to clipboard the financial remediation. It sounds like these get included in reports
Comments aren’t being shown.
Make sure that most recent comments are on the top of the list, with date/time info
Unfunded Requests (UFRs) need to be downloadable. This can be done at two levels

Add a link that points to a generic UFR Excel Spreadsheet
Build a partially filled out UFR spreadsheet for the user to save.

Service Fincance POC name does not fill from dropdown selection. The field remains blank after the selection
Add banners like for VISIBILITY
Add regex for portion marking in all freeform text areas. Throw a fit if the portions are not marked.
Project Manager screen seems to load really slow sometimes. We might want to add something tat lets us see what it’s hanging on, but more importantly, add some loading animation so that the user doesn’t think the browser is hung.

12:30 – 5:30 FP

More Blender.
Got a meeting set up on Monday at 3:00 to learn how to use the MakerBot. Going to try to bring a file to attempt to print.
Pretty picture:

Mike 6.7.2012

Server backups at site
Status meeting with Jim G from TASC, Dave W. and others. Highlights of the meeting

We need some kind of requirements (future and retroactive). First we are checking around for an old statement of work then will go from there
Vet all new requirements through Dave W. and this weekly meeting before proceeding on them
Figure out who is working on the test plan

Finished up the presentation for tomorrow
Jessica R. is still having some issues deleting users, this time is was a foreign key problem with the user_alerts table
Lenni M. was having trouble changing his password, seems to have something to do with changing your password and trying to log in without refreshing the page (this should be possible)
The modify funding request screen needs an overhaul, it is VERY difficult to search, Tangie would also like the document_number column added
There’s an issue with searching on the project management list then scrolling
There are some instances of portfolio managers being updated on a project then not showing up in the project management list
Fixed the password changing issue, the login screen was getting stuck in a state between the normal state and the change password state

Dong Shin 06.07.2012

added MySQL database connection clean up routines to PPM server
mvn tomcat:redeploy generates 403 error on Tomcat 7. Maven’s Tomcat 7 requires different configuration… http://stackoverflow.com/questions/3714080/tomcat-7-maven-plugin

in tomcat-users.xml, add

<role rolename=”manager-gui”/>
<role rolename=”manager-script”/>
<user password=”admin” roles=”manager-gui, manager-script” username=”admin”/>

in pom.xml, add
- <plugin>
  <groupId>org.codehaus.mojo</groupId>
  <artifactId>tomcat-maven-plugin</artifactId>
  <version>1.0-beta-1</version>
  <configuration>
  <url>http://127.0.0.1:8080/manager/text</url>
  <server>localTomcat</server>
  <path>/${project.build.finalName}</path>
  </configuration>
  </plugin>

added the new config to PPM server’s pom.xml, now mvn tomcat:redeploy works.

Tom 6.6.2012