Author Archives: pgfeldman

Phil 4.24.13

8:00 – 4:00 – SR

  • backups
  • Installed new version of FA
  • table_dash_templates
    • name
    • xml_layout_template
    • xml_variables – gives something to iterate over
  • Nearly done. Finish tomorrow, though I have to build test classes.
  • New version of FA to bring in.

Phil 4.23.13

8:00 – 5:00 SR

  • Backups
  • Meeting with Chris at 2:00?
  • Decided that rather than do updateVizTable and mess with the canonical cars database, I’d start by creating databases and then modifying them. Looks like I might be able to use NOW() for the timestamp column?
  • Creating the appropriate table. Did you know that MySQL doesn’t have a way to determine if a table exists? Here’s how I’m doing it: 
    	public boolean tableExists(String tableName){
		try {
			DatabaseMetaData metadata = dBconnection.getMetaData();
			ResultSet resultSet = metadata.getTables(null, null, tableName, null);
			if(resultSet.next())
				return true;
		} catch (SQLException e) {
			return false;
		}
		return false;
	}
  • So to add a table, you have to create the table with a UID and timestamp, add a line table_data, get the id for that line, then place that id and the roleId into the table_data_role.
  • And here is a script generated test table in VISIBILITY: scriptGenerated

Phil 4.22.13

8:00 – 4:00 SR

  • Backups and some security updates.
  • After my thrill-packed afternoon of setting up my IDE so that I could do some work, it’s back to my regular IDE. Ah well, it’s good to keep everything up to date at home.
  • Downloading and installing the new Cygwin. No, I lied. The download stops about 33% in. Grr.
  • I had an interesting web.xml problem for the last few days that was bothering me:Description Resource Path Location Type 
     The content of element type "web-app" must match 
"(icon?,display-name?,description?,distributable?,context-param*,filter*,
filter-mapping*,listener*,servlet*,servlet-mapping*,session-config?,mime-mapping*,
welcome-file-list?,error-page*,taglib*,resource-env-ref*,
resource-ref*,security-constraint*,login-config?,security-role*,env-entry*,
ejb-ref*,ejb-local-ref*)". web.xml 
/VisibilityScriptingServer/src/main/webapp/WEB-INF line 5 XML Problem
  • What this means is that some of the elements are out of order. If you match the order of the elements in the xml file to the list in the error message, that completely fixes it. In my case, I had the <servlet> and the <servlet-mapping> tags associated, since that helps readability. But no, we don’t get to do that. Moving all the <servlet-mapping> tags to just before the <welcome-file-list> element did the trick. Yay!
  • Finished getUserId() and getRoleId(). Starting on updateVizTable()

Phil 4.19.13

7:30 – 3:30 SR

  • Went home yesterday to find my phone and internet knocked out. Oddly, after a Verizon reset the cable came back. Why that works and the other two don’t I have no idea. Service is scheduled between 1:00 – 5:00 so it’s either work from home or leave.
  • Backups
  • More work on changing the visibility_dev2 db on the fly.
  • Need to contact Jeremy (Shawn?) about a charge number.
  • Downloading everything so that I can work from home without an internet connection
    • Project files (zipped and workspace)
    • new xampp
    • sql db (VSS and VD2)
    • notes
    • Juno
  • Got home and put the old FIOS battery back in and bounced the system. I now have TV and internet. And literally, as I was typing this, the connection dropped out. Correlation without causation. And it’s back now….
    • Ticket: mddq03c37es
    • 12:32 – restored
    • 1:27 – down (could not find host)
    • 1:29 – restored.
    • 2:34 – down
    • 2:36 – up
    • 4:09 – down for two minutes
  • Building environment. Unzipping is really slow. And the workspace I copied over isn’t working, so I have to get my stuff from subversion, which means installing that…
  • But everything is running. And it’s 3:10. I got started around noon. Pity we can’t bill Verizon for this.

Phil 4.18.13

7:30 – 3:30 SR

  • Deployed test version of FA and new versions of PPM, PA and VSS.
  • The “Total” bug in PPM is half fixed.
  • Long discussion about FA. Our job is to determine how to work the FYear column (hopefully) into the existing database.

Phil 4.17.13

8:00 – SR

  • Backups
  • There is a Viztool review set for tomorrow from 7:30 – 9:00. Need to check with Dong about having a deploy. The Version Checker in FlexUtils45 had to be updated to pass namespaces down to the SingletonDataDictionary. Though I’m not sure that I’ve checked that in yet.
  • Is it not possible to open an unfunded project? John Anderson’s GCC project will not open in PA or in the PPM project management screen. However, when the Project->Enter Monthly Status is clicked and the same project is selected in the folowing dialog and opened, it’s possible to access. Lenny just checked, and the project is unfunded. I know that we had some additional info and locks in a previous version. But there is nothing now (March 8 2013 at 6:07 AM).
  • Fixed some bugs in VersionTracker.
  • Started working on what the visibility_dev2 data functions should be:
  • VssNewMethods

Phil 4.16.13

8:00 – 4:00 SR

  • Backups
  • Lenny found a possible math problem with PPM, where sub project allocations are not summing correctly
  • Showed Lenny how to delete incorrect project info using the DB utils
  • Working on getting VSSTestbed up and running.
    • Adding a Web project to a server is easy, though you do have to start (possibly refresh) the server to get the files deployed to the server instance
    • The only place that it seems that you can add projects to be deployed is in the Deployment Assembly dialog in the Properties. Add any jar files or projects here. Note that if you ass a project, that the system builds a jar file for you here and deploys that to the WEB-INF/lib directory. There do not have to be any classes.
    • VSSTestbedConfig

4.15.13

8:00 – 10:00, 2:00 – 4:00 SR

  • Backups,
  • Financial
  • Starting to look at the date rollover script issue.
  • Getting VisibilityScripting to run on the Eclipse server – Looks like I have to create a new Dynamic Web project and can’t retrofit that into VSS. I think this is starting to look like a tomorrow thing…

Phil 4.12.13

8:00 – 3:30 SR

  • Tried out FA and version tracker. VT is not creating tables, but we don’t know why. Need to add some tracking.
  • Found out that the backup of visibility_scripting.sql was corrupted because the packet size was too small. Wound up using the –max_allowed_packet=512M argument as shown here.

Phil 4.11.13

8:00 – 3:00 SR

  • Backups
  • There seems to be a problem with PA: “February in VizTool is showing ‘overdue’ If everyone input their data for Feb shouldn’t it be March that’s overdue?” – Heidi. Lenny also had the same problem. I’ll bring a printout of the entire email.
  • Make AS3 version tracker
  • Start on script(?) to convert months for slide show. I’m guessing python. But since we’re adding server side code this time anyway, we might want to add a way for the scripting system to insert a ‘visibility_dev2″ table to bypass the ingestor. This means managing roles, users and ingest(?) tables.

Phil 4.10.13

8:00 – 4:00 – SR

  • Sleepy – went to see Marc Broussard last night. Got to sleep after midnight and up at 5:45. Ow.
  • Backups.
  • Start moving VersionChecker to a component. Done. Added it to FGMFlexUtils45
  • Next, let’s add this to EdgeUtils.
  • Dong has incorporated VersionChecker into PA, and we have a disk full of installs for tomorrow.

Phil 4.9.13

7:30 – 4:30 SR

  • Imported new FA
  • VizTool Review (More notes in Req’s & Bugs & Stuff)
  • And now I can’t put my bike in the basement hallway. Gonna try the gym, which I thought would cause complaints. People don’t seem to like bicycles here.
  • Got the logic working on the test and updates. Now I just need to package and make versions for 3.x and 4.5+

Phil 4.8.13

8:00 – 4:30 SR

  • Someone stole my last few teabags! Trader Joe’s today…
  • Backups – done
  • Prep for review tomorrow
    • Get demo-able version of VersionTracker
    • Status report
    • Burn Dong’s system for deployment on integration server
  • Spent the entire morning trying to get the DbObjectTestbed server running in Eclipse. It was working just fine when I turned off the machines for the weekend.
    • Committed my code changes and reloaded the project – nothing
    • Did notice that the properties might be corrupted. I could not edit some of the properties tabs.
    • Added JavaUtils as a project that DbObjectTestbed depended on. That forced a rebuild, which placed the .class files I needed in the Tomcat directory.
    • Rebuilt and deployed the VersionTrackerTest Flex project, and after a hiccup (I’m assuming the server was still coming up), everything is now working. Well, sort of. I have to stop the server, rebuild the Java code then restart the server for the classes to get updated in the webapps directory.
  • Working on getting a very finicky Date.parse() to work properly so that the milliseconds since the code was compiled to assemble properly.

Phil 4.5.13

8:00 – 4:00 SR

Phil 4.4.13

7:30 – 3:00 SR

  • Thought there was a meeting today, but nope.
  • Deployed the new vis2.swf, which seems to be working fine.
  • Approved Chris so that he can see the SSP. Funny.
  • Looks like these are the guys -http://www.vsi-corp.com/