Tier 1 Notifications

Wednesday, March 27, 2013

SiteManager ADHOC reporting

Our SiteManager ADHOC database did not fully refresh overnight.

This has caused our MTS attachment view program to malfunction. It will be inoperable until the database is fully refreshed.

Many of our CMISD reports use the ADHOC database (Our CMISD reports page lists each report’s database). Currently, some of the ADHOC database sourced reports are not functioning and will not retrieve data until the database is fully refreshed.

The database administrators estimate the database may be fully refreshed by 1:00pm this afternoon.

If you need immediate assistance please contact me or one of the CMISD staff and we will assist you by retrieving the data from another source if possible.

Thank you,

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

Be Safe. Drive Smart

Monday, March 18, 2013

EPRS website and SiteManager DSS reporting are available

EPRS website and SiteManager DSS reporting are now available.

The ADHOC database is still offline and will remain so for the remainder of the day.

CMISD website http://crossroads/org/cst/cmisd/sitemgr.asp?m=smgr&p=reports_all identifies the database each report uses. If the ADHOC database is listed as its database source then the report will not be available.

If your need for the information is immediate, please contact one of us here and we’ll try and pull that data from another source.

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

From: Stewart DeWitt
Sent: Monday, March 18, 2013 7:57 AM
To: 'AUD-DDO'; 'shd4971176.smblog@blogger.com'; Dean Aaron; Kevin Setoda; Mike Tyler; Al Bass; Alex Quintanilla; Allen Shelley; Billy Fergerson; Bob Lindley; Carl Preston; Crystal Woodruff; David Norris; Diane Weishuhn; Donnie McNatt; Earl Anderson; Ellie Salgado; Gil Herndon; Gina Williams; Glenn Jaeger; Jeff Sweetland; 'Jim Zwiener-C'; Joyce Bujak; Ken Jones; Mack Ballenger; Marjorie Roberts; Mark Pollard; Marylou Castillo; Miguel Hernandez; Mike Williams; Pat Swindell; Reuben Jackson; Suzy Blaschke; Wil McCarley; Cliff Hallford; Merrie Rogge; Paul Norman; Darrell Caldwell; Kelli Navarrette; Laura Alwan; Mike Fowler; Shannon Argo; Susan Simpson; James Joslin; Rickie Shields; Thomas Young; Donna Roberts; Deb Zamorano; Mark Petrusek; Miguel Arellano; Sylvia Bockholt; Tad Nichols; Tim Wilhelm; Tommy Blackmore; Tracy Cooper; Andrea Murry; Gordon Bland; John Choate; Michael Skiles; Andy Berlan; Chris Cowen; Darlene Goehl; Sheryl Petroski; Zyna Polansky; Richard Walker; Tonya Shaw; Darwin Lankford; Denise Key; Gene Garcia; 'Jackie Taylor'; James Harris; Ronald Hatcher; David Chapa; Deborah Shults; Ed Rodriguez; Laura Benavides; Lester Lindley; Mary Alice Hernandez; Mitzie Gibson; Noe Cabazos; Rudy Landa; Sandy Harris; Ali Habibi; Glenn Eilert; Jay Tarwater; John Jameson; John Obr; Roxana Garcia-Zinsmeyer; Scott Starkjohann; Barbara Shepherd; Brenda Sanchez; Chris Briggs; Debbie Burgess; Rhonda Schmid; Robert Delaney; Terry Bruce; Trena Brand; Ken Barnett; Maria Chavez; Susan Freres; Tomas Saenz; Bruce Matusek; Leticia Cruz; Alan Easterling; Brad Tate; Jackie Broussard; Peggy Cooper; Richard Williammee; Steve Bone; Emmanuel Isonguyo; Josiah Yuen; Loren Rice; Lovey Reynolds; Terri Hybner; Steven Hudson; Doug Y'Barbo; George Wilson; Sam Hankla; Tom Hunter; Vivian Harrison; Jose Saldana; Lilia Gutierrez; Rosa Trevino; Sergio Reyna; 'Becky Jares'; Claudia Kern; Greg Jones; Jana Buck; Michael Dawidczik; Richard Izzo; 'Robert Sarcinella'; 'Roy Collins'; Bryan Raschke; Jack Lambert; Kathy Schlegel; KC Evans; Stephen Smith; Bill Guy; Cynthia Smith; James Hutchison; Leisha Hopkins; Ricky Daniels; Carlos Peralez; Jesus Limon; John Ramirez; Jorge Rendon; Rosendo Garcia; Crystal King; David Henke; Jackie Benavides; John Heye; Lea Jacobson; Lisa Rainosek; Cathey Galbreath; Jane Hughey; Ricky Moore; Mark Frick; Sherri Ralson; Terry Frick; Hilda Whetzel; Thomas Polansky; Kara Kelley; Mark Smith; Paul Wenzel; Sean Baker; Camille Marek; Gary Gould; George Vogt; Glen Dvorak; Jonathan Rogers; Judy Broomas; Kenneth Anthony; Sherry Hutchinson
Cc: Bill Kokas; Bobby Raytchev-C; James Bunner; Raymond Longoria-C; Thane Mitchell; Veronica Davis; Michael Underwood; Stewart DeWitt; Thomas De La Portilla
Subject: EPRS website and SiteManager ADHOC/DSS reporting are offline

The EPRS website and SiteManager ADHOC/DSS reporting are offline.

EPRS:

Both internal and external customers are affected. Until the issue is resolved no one will be able to logon to the system.

SiteManager ADHOC/DSS Reporting:

This mainly will affect those users that frequently access the CMISD website and retrieve reports. Most of these reports use one of these two database and will be unavailable. This also affect anyone that runs their database queries using these two databases.

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

From: Jay Edwards
Sent: Monday, March 18, 2013 7:14 AM
To: Jesse Kirk; Lois Johnson; Alex Gutierrez; Hisham Makkouk; James Bunner; Keith Buckley; Steven Williams; Stewart DeWitt; Thane Mitchell; Veronica Davis
Cc: TSD-DBA-ORACLE
Subject: TX-SM-PD2 - Fibre Card failure

Production Applications Affected:

SMGRADHC Reporting, EPRS, DSS, CPS and SMGR/DSS replication

A P1 ticket has been entered with Xerox.

Be Safe. Drive Smart

SiteManager Terminal Server is available

The SiteManager terminal server is back online and available for use.

We are still experiencing issues with the ADHOC and DSS database as mentioned previously.

Thank you,

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

From: Stewart DeWitt
Sent: Monday, March 18, 2013 9:00 AM
Subject: SiteManager Terminal Server - Offline

The SiteManager for terminal server is offline this morning. Users may still connect using the SiteManager non-inspector (local install) version and/or SiteManager Citrix server.

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

Be Safe. Drive Smart

SiteManager Terminal Server - Offline

The SiteManager for terminal server is offline this morning. Users may still connect using the SiteManager non-inspector (local install) version and/or SiteManager Citrix server.

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

Be Safe. Drive Smart

EPRS website and SiteManager ADHOC/DSS reporting are offline

The EPRS website and SiteManager ADHOC/DSS reporting are offline.

EPRS:

Both internal and external customers are affected. Until the issue is resolved no one will be able to logon to the system.

SiteManager ADHOC/DSS Reporting:

Stewart DeWitt

Construction Division

SiteManager Production, ADHOC, DSS and EPRS Databases are back online

SiteManager Production including Citrix and MTS servers, ADHOC, DSS and EPRS Databases are back online.

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

Recall: SiteManager Production, ADHOC, DSS and EPRS Databases are offline

Stewart DeWitt would like to recall the message, "SiteManager Production, ADHOC, DSS and EPRS Databases are offline".

SiteManager Production, ADHOC, DSS and EPRS Databases are offline

SiteManager Production including Citrix and MTS servers, ADHOC, DSS and EPRS Databases are offline. ISD is working with Xerox to restore access. Other systems may also be affected.

Stewart DeWitt

Construction Division

(512) 416-2462

Stewart.DeWitt@txdot.gov

Monday, October 29, 2012

SiteManager ADHOC reporting

This does not affect the SiteManager custom report server (e.g. Contractor’s Estimate Package).

This email is for the attention of those individuals that query the SiteManager database through the ADHOC database.

As you know the data available in the ADHOC database runs one day behind production. During this weekend’s update of SiteManager, the ADHOC database did not have an opportunity to update. So, the data currently in our ADHOC database is from the end of business on Thursday.

The database will resume its normal refresh process this evening and by Tuesday again be one day behind production.

Some of the SiteManager Excel reports found on our CMISD website use this database. Our CMISD website references the database each report is using. Look here { http://crossroads/org/cst/cmisd/sitemgr.asp?m=smgr&p=reports_all } under the “Database” column if you have any doubt.

Thank you,

Stewart DeWitt

Friday, October 26, 2012

SiteManager Update Tonight Friday Oct 26th

We are proceeding with this weekend’s distribution of SiteManager 3.8 tx2.010. Tonight Friday, October 26, 2012 SiteManager version 3.8a tx 2.010 will be made available for install through LANDesk. The upgrade process will begin at 6 PM tonight and will proceed through Saturday and Sunday (all times central). SiteManager (Citrix, MTS and client) and SiteManager reporting will be unavailable for this duration. SiteManager is scheduled to be available again Monday, October 29th at 6 AM or sooner. A pdf copy of this notice is available here.

We were unable to resolve the technical issues with the automated update process that was original scheduled with this release. So, we are scheduling it for a later release and continuing without it. SiteManager 3.8a tx 2.010 will only contain the change order modifications listed below.

Please make every attempt to keep all SiteManager PC's powered on during this period.

It is mandatory that standalone users check in all work in prior to 6:00 PM Friday, October 26, 2012. Laptop and tablet devices using SiteManager standalone must be powered on and on the TxDOT network. Devices using Citrix and/or Terminal Server SiteManager require no updating and can remain offline.

Remember – When users open SiteManager for the first time (presumably on Monday) the user id field on the logon screen will be blank. SiteManager user ids are case sensitive and 99% of these ids are all upper case characters.

The primary purpose of this 3.8a tx2.010 upgrade is to:

Conform to the May 30, 2012 Phil Wilson memo, “Franchise Model – Contract Change Orders” Link.

This release contains two significant changes.

· Change order approval levels will be determined manually. No longer will SiteManager assign the appropriate approval levels. Under the franchise model, District discretion will be used to manually select approval levels. Approval levels will be assigned in a process that is identical to the formally available override option*. See link for new change order approval process.

Minimum requirements :

1. A minimum of one Area Engineer or District Engineer must be included with each change order approval.

2. A minimum of two different users must approve each change order.

ü The change order header window override option has been removed (see figure 1a & b).

ü Federal Funding and Oversite indicators have been added to the change order header window (see figure 1a). The Federal funding indicator is only representative of the controlling CSJ.

*The override option has been removed as there are no longer any calculated approval levels to override.

Friday, October 19, 2012

Canceled - Pending SiteManager Update Friday Oct 19th

Due to technical issues, this weekend’s distribution of the latest SiteManager release has been canceled.

SiteManager will be available this weekend except during the scheduled database maintenance period between 11:00 pm tonight and 1:00 am Saturday, October 20^th.

We have tentatively rescheduled the release for next Friday, October 26^th.

Stewart DeWitt

512.416.2462

~Friday, October 12, 2012~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

On Friday, October 19, 2012 the SiteManager technical team is schedule to release the next version of SiteManager. The new version (3.8a tx 2.010) will be made available for install through LANDesk. The upgrade process will begin at 6 PM on Friday and will proceed through Saturday and Sunday (all times central). SiteManager (Citrix, MTS and client) and SiteManager reporting will be unavailable for this duration. SiteManager is scheduled to be available again Monday, October 22th at 6 AM or sooner. A pdf copy of this notice is available here.

Please make every attempt to keep all SiteManager PC's powered on during this period.

It is mandatory that standalone users check in all work in prior to 6:00 PM Friday, October 19, 2012.

Remember – When users open SiteManager for the first time the user id field on the logon screen will be blank. SiteManager user ids are case sensitive and 99% of these ids are all upper case characters.

The primary purpose of this 3.8a tx2.010 upgrade is to:

Conform to the May 30, 2012 Phil Wilson memo, “Franchise Model – Contract Change Orders” Link.

This release contains two significant changes.

Change order approval levels will be determined manually. No longer will SiteManager assign the appropriate approval levels. Under the franchise model, District discretion will be used to manually select approval levels. Approval levels will be assigned in a process that is identical to the formally available override option*. See link for new change order approval process.

Minimum requirements :

1. A minimum of one Area Engineer or District Engineer must be included with each change order approval.

2. A minimum of two different users must approve each change order.

ü The change order header window override option has been removed (see figure 1a & b).

ü Federal Funding and Oversite indicators have been added to the change order header window (see figure 1a). The Federal funding indicator is only representative of the controlling CSJ.

Automatic updates! SiteManager can now determine if the SiteManager client is current and update the installation if it is not**. A new application (SM Loader) is now included with each SiteManager installation. When a user starts SiteManager the app will read the local installation and compare it to the latest available version (see figure 2a). If the install is not current the app will install the latest version (see figure 2c). It is our hope that this new feature will allow us to bring you SiteManager enhancements quicker and with greater frequency.

*The override option has been removed as there are no longer any calculated approval levels to override.

**This option is not available when in Standalone mode.