ATSPM 4.2 Webconfig File #44
Comments
|
Those values are in the database now and can be configured using the web ui. |
|
It is now in the general settings of the website. If you are following the installation manual it is step 2.1.6 b. |
Excuse me, I have the same question and this answer makes me even more confused. So does it mean that the website could be launched before setting the keys? Since there were no more settings for keys in the web config file, I skipped step 2.1.6 b,c,d and launched the website. However it failed(see the figure below). So could you please explain what I should do to solve this problem in details since I did get any idea from this answer. Thanks very much!
|
|
The website can be launched without the image location set. That value is only used when a chart is run. |
Thank you! So what could be the potential reasons for the error "A network-related or instance-specific error occurred while establishing a connection to SQL Server" when trying to launch the website? |
|
There are lots of potential configuration issues it could be but the first thing I would check is to make sure your database user is set up properly with the correct permissions. After that make sure your database is visible from your web server. This especially important if your database is on a separate machine and potentially behind a firewall. |
|
Hi, I have checked the connectivity to the database using the login information set in the SQL Server Management Studio. It showed that the connection could be built up successfully. Since I set up everything on the same machine, I think it indicates the database is visible from my web server. I also followed everything step by step in the installation manual. So is there any other possible reason for failing to launch the website?
|
|
Does your database user have admin privileges? When running for the first time it creates a lot of things that require admin. Also what version are you installing and is it a new install or an upgrade? |
Excuse me, I do not know if I understand the question database "Does your database user have admin privileges" correctly. My answer would be that I am logging on the computer with an administrative account. I am installing ATSPM version 4.2 which was downloaded from OSADP and it is a new install |
|
I believe there were some files that were fixed after the release on OSADP, but I'm not sure they were incorporated into the OSADP package. Do we know if FHWA updated the release? |
|
For now I am advising people to get the release from GitHub. I emailed OSADP a few times and did not get a response but I have direct control of the GitHub release mechanism. |
|
I haven't tried to install from Github. Do I just download the ATSPM.Executables.zip file and not the Source Code? |
dloweAvenueConsultants
added a commit
that referenced
this issue
Aug 16, 2022
* Create outline for Left Turn Gap Report * Add more data to each approachResult, add more properties to FinalGapAnalysisReportViewModel, clean up final report. * Add additional values, logic to control what fields are viewed * Add spinners to button * Add additional logic for SIgnal Type and CrossProductReview * Update charts, add additional styling for PDF * Change Bootstrap path from absolute to relative * Add % symbol to PedVsFailures chart * Change line colors, refactor stuff * Fix position of tables * Separate AM and PM reports, move most logic from GetFinalGapAnalysisReport into GetApproachResult, general refactor * change true case to GapOutOk, PedCycleOk, and LeftTurnVolumeOk to success * Update chart intervals * Add opposingApproach , peak period time, gap chart height * Add peak description and opposing approach, general refactor * Change report bin size to 15 * Add Get24HourPeriod to FinalGapAnalysisReportParameters, refactor left turn controller * Fix mistake in signal data check report, css changes * Create development4.2.5.yml * removed old tests * Update development4.2.5.yml * Update development4.2.5.yml * Update development4.2.5.yml * Test for github actions * test * Add Left Turn Report to menu, add auth roles restrictions, rename peak period description * Add additional styling, remove opposingApproach function * Update development4.2.5.yml * Update development4.2.5.yml * Bug fixes for Pre check * Add GetSignalType to Signal class * Add table and model for MetricTypesDefaultValues * Add basic outline * Fix FAQ Table * Remove Value from Table Key * Move AddDefaults function to parent class, remove from others * move addDefaults to inside of class instantiations * Add controller and viewmodel for defaults, additional funtions to repo * Add basic outline of view * Adding direction and movement type to return results * Final fixes for direction and movement type on return result. * Adding direction to results * Jurisdiction Fixes * Add views, update view model display names * Remove default value * Add to chart default settings to menu * Add update action to defaults controller * Add display names to model for real this time * Add function to rotate arrow in defaults menu * I guess you're supposed to commit these files * Update menu with authorize action link helper * refactor * Change chart text for Left Turn Gap Analysis * Fix bug in GetMetric.js this should fix the issue of charts throwing an error * Create outline for Left Turn Gap Report * Add more data to each approachResult, add more properties to FinalGapAnalysisReportViewModel, clean up final report. * Add additional values, logic to control what fields are viewed * Add spinners to button * Add additional logic for SIgnal Type and CrossProductReview * Update charts, add additional styling for PDF * Change Bootstrap path from absolute to relative * Add % symbol to PedVsFailures chart * Change line colors, refactor stuff * Fix position of tables * Separate AM and PM reports, move most logic from GetFinalGapAnalysisReport into GetApproachResult, general refactor * change true case to GapOutOk, PedCycleOk, and LeftTurnVolumeOk to success * Update chart intervals * Add opposingApproach , peak period time, gap chart height * Add peak description and opposing approach, general refactor * Change report bin size to 15 * Add Get24HourPeriod to FinalGapAnalysisReportParameters, refactor left turn controller * Fix mistake in signal data check report, css changes * Add Left Turn Report to menu, add auth roles restrictions, rename peak period description * Add additional styling, remove opposingApproach function * Add GetSignalType to Signal class * Add approach and opposing approach descriptions * Refactor FinalGapAnalysisReport * Add extension method for grabbing description from enum, add methods to grab phaseType and signalHeadType, use in LeftTurnGapController * Add project too * Add filter drop down for agency * Move stop spinner function to success/fail * Update graphs from 30 -> 15 minutes * remove unneeded import * Remove duplicate left turn gap menu * small fix * Remove opposingDirection from split fail analysis * Remove redundant jurisdiction menu * Reorder charts in defaults menu, refactor * Adding a new javascript funtion to do the check * Change labels to Jurisdicition. fixed Pin selection function * remove commented out code. * Change chart axis name to "% Cycles w/ Peds" * Fix opposing volume issues * Rename MetricTypesDefaultValues -> MeasuresDefaults * rename charts to measures * remove edits from web.config * number of opposing lanes fix * changed splitfails from int to double * Fix for Gap out percentage * Added card to Y&R Actuations Options * Combined migrations into one. * Fixes for Gap Duration Calculation * Fix for Split fail analysis not selecting permissive phase. * Fixes for Pedestrian Analysis * fix for ped series * Fixes for Split fail aggregation * Change Ped Analysis to use correct field * Remove AuthorizeActionLink Removed the authorize action link until we can look into it further. * fix to group by approach ID, otherwise it would add all the split failures, cycles for the same Phase number * Signal config changes (#22) * Creates new checkboxes and one new textbox in the Signal and Approach configuration; also added a migration (TAPedestrianPhases) * roll back migration * changed PedestrianDetector to a string (instead of a list) * new migration, adds 4 columns to dbo.Approach * Add approach speed box in Admin side and configuration table; moved from detectors to approaches * Approach Speed changes to merge with pedestrian phase changes * Spacing changes on the signal config page (due to new options) * Initial attempt at JS function to change the ped phase box based on the Peds 1:1 box * Set up for calling js query when Peds are 1:1 box is checked or unchecked * Attempt at making the ped phase variable disabled * Toggles between disabled/not disabled and ped phase values based on checkbox pedsare1to1 * makes style uniform within the function * Toggles for all approaches * removed unused test code that was commented out * makes ped phase blank when enabled; adds descriptive comments; disables other fields as well as desired * Add logic to update modified approaches when signal is saved * Changed from using disabled to using readonly. Also updated cshtml file to have the fields disabled upon load (if applicable). * Added logic so new signals have Pedsare1to1 checked by default. * Changes made to make Ped Overlap checkbox readonly when Peds are 1:1 is checked * Changes to use ped phase number if it is different from protected phase number * Changes to use ped detectors Co-authored-by: avetraffic <traffic@avenueconsultants.com> Co-authored-by: Nuzhat Azra <nazra@avenueconsultants.com> Co-authored-by: avetraffic <96312362+avetraffic@users.noreply.github.com> Co-authored-by: mstanley <mstanley@AVELT60> * Area configuration (#21) * Add area table and connect to signals * Add area repository, interface and factory * Add area to seed and dbcontext * Add area controller and basic views * Add area signal map and signal config * Add area table and connect to signals * Add area repository, interface and factory * Add area to seed and dbcontext * Add area controller and basic views * Add area signal map and signal config * Include area * refactor PinFilterCheck * Remove areaId from signal * Fix how generateAddData filters Areas * Add harvest.chosen package and apply to dropdown * Add chosen scripts * Add area drondown for signal * update area and signal controllers * remove bug from SignalsController * Fix csproj Co-authored-by: mstanley <mstanley@AVELT60> Co-authored-by: dlowe <dlowe@avenueconsultants.com> * combine migrations * combine migrations 2 * combine migrations 3 * fix for missing pedphase checkbox * Update About.cshtml * remove spinners on error on check for left turn gap * Add defaults to seed file * Rename places where jurisdiction is referred to as agency * Remove empty migration * General bug fixes * Text change in Lable for LT Gap Analysis chart * Fix pedsAre1to1 + small grammar/syntax fixes * Phase ped aggregation update (#30) * Add new properties to PhasePedAggregation Model, add to db * Add logic to PedPhase and ControllerEventLogs, add values to DataAggregation * Fix Signal Start Bug (#24) * Fixed spelling error * Update scripts * Remove "|" in signals pages * Update Configuration.cs Add PennDOT ATSPM Interface Remove Defaults for Area and Jurisdiction * Updated partners logo + changed 4.2.5 to 4.3 * Update dropdown multiselect css * Fix FillSignals pagination * Add default start and end time to aggregate data * Add warning message when trying to delete jurisdiction tied to signals * Bug fix for new signal creation * Add symbols to fillsignals table * Update get signals as queryable method, apply to action log * Add time buffer to ped delay metric * Update pedphase to look at previously selected timestamp instead of previous event * Add ped recall to chart * Add red to red cycles to ped delay metric * fix timebuffer * Add ped delay to chart * Add percentDelay, cycleLength, and pedBeginWalk to options * Change ped actuations to ped presses in pedPlan and pedDelayChart * Add imputedPedCalls to pedPlan and chart, add cycleLength average to chart * Left turn gap fixes (#31) * Fix custom option * pass cycles with ped call int to front end * Additional formatting * Fix Udot image path * Change getAveragesByBin * Fix custom option * pass cycles with ped call int to front end * Additional formatting * Fix Udot image path * Change getAveragesByBin * Fix image path issue * Change times for precheck * change <= to < for 15 minute thingies * small fixes * Fix split fail, add to chart * Fix PedActuationResultViewModel, rename ped cycles in chart * Add time buffer to ped delay metric * Update pedphase to look at previously selected timestamp instead of previous event * Add ped recall to chart * Add red to red cycles to ped delay metric * fix timebuffer * Add ped delay to chart * Add percentDelay, cycleLength, and pedBeginWalk to options * Change ped actuations to ped presses in pedPlan and pedDelayChart * Add imputedPedCalls to pedPlan and chart, add cycleLength average to chart * update configuration, move ped recall to top of chart * fix TBP * Remove duplicate error message for signal search * Fix ped begin walk data points * more changes. * Change pedActuations to PedRequests * Change YAxisMax default * actually change YAxisMax default * Add additional GetRedtoRedCycles function for ped delay chart * add event list property to plans, refactor pedphase * Use approach instead of phase numbers to create metric * remove unnecessarily added date * fix error if there are no red to red cycles found * Check last two events for 21s * make ped delay graph go to end of chart * make ped recall a property of ped plan * change from >= to > in ped plan events * Fix issues when there are no redToRedCycles or when there are two ped events at the same time * Remove extra } in PCD Metric * Prevent pushpins from zooming out if close up * Move image path and url, update seed file (#39) * Move image path and URL to migration * Remove FAQs, re-add links and manuals * Timing and actuations fix (#37) * Add time buffer to ped delay metric * Update pedphase to look at previously selected timestamp instead of previous event * Add ped recall to chart * Add red to red cycles to ped delay metric * fix timebuffer * Add ped delay to chart * Add percentDelay, cycleLength, and pedBeginWalk to options * Change ped actuations to ped presses in pedPlan and pedDelayChart * Add imputedPedCalls to pedPlan and chart, add cycleLength average to chart * Add time buffer to ped delay metric * Update pedphase to look at previously selected timestamp instead of previous event * Add ped recall to chart * Add red to red cycles to ped delay metric * fix timebuffer * Add ped delay to chart * Add percentDelay, cycleLength, and pedBeginWalk to options * Change ped actuations to ped presses in pedPlan and pedDelayChart * Add imputedPedCalls to pedPlan and chart, add cycleLength average to chart * update configuration, move ped recall to top of chart * fix TBP * Fix ped begin walk data points * more changes. * Change pedActuations to PedRequests * Change YAxisMax default * actually change YAxisMax default * Add additional GetRedtoRedCycles function for ped delay chart * add event list property to plans, refactor pedphase * Use approach instead of phase numbers to create metric * remove unnecessarily added date * fix error if there are no red to red cycles found * Check last two events for 21s * Create separate line for each ped detector * Delete commented out code * use ped phase to decide overlap codes * make ped delay graph go to end of chart * make ped recall a property of ped plan * Create separate line for each ped detector * Delete commented out code * use ped phase to decide overlap codes * Return no ped detectors if pedsAre1to1 and protected phase overlap is checked * Show no ped events if ped phase has a value, but nothing is in ped detectors. * Additonal Left turn fixes (#34) * left turn fixes * Fix GetSignalHeadType * Fix detectorEventCountAggregations * Make fonts smaller so both peaks appear on same page * Change getNumberOfOpposingLanes to only get thru movements * return error and alert user if no signal is selected (#33) return error and alert user if no signal is selected in LTGR * Fix YAxis parentheses on Charts (#32) When the default font's size is less than 9, any parentheses in the YAxis label will look like a vertical bar "|". This changes the default to 9. * Ped delay bug fixes * Changes for Split fail aggregation * fix * Add "new" keyword to methods because they're doing it already and I hate seeing it on the warning list * Aggregation update * fix for Data Check * Fix for Ped aggregation * New ped delay (#43) * Move dots on Ped Delay * Add ApproachID to PhasePedAggregation * Account for ped phase overlaps * Limit ped phases to only those which have at least 1 event * Update ped recall formula * Add ShowPedRecall and PedRecallThreshold options * Add timeBuffer key to config file * Fix indent in config * remove offset from bottom ped delay point * Update PhasePedAggregation.cs * Update PhasePedAggregation.cs * Update DataAggregation.cs * Update PedPhase.cs * Update PedPhase.cs * Update MOE.Common.csproj * Delete 202207061520118_AddApproachToPhasePedAgg.Designer.cs * Delete 202207061520118_AddApproachToPhasePedAgg.cs * Delete 202207061520118_AddApproachToPhasePedAgg.resx * Update PhasePedAggregation.cs * Update PhasePedAggregation.cs * Update DataAggregation.cs * Update Startup to use swagger in production * Readd approach id to ped agg (#44) * Move dots on Ped Delay * Add ApproachID to PhasePedAggregation * Account for ped phase overlaps * Limit ped phases to only those which have at least 1 event * Update ped recall formula * Add ShowPedRecall and PedRecallThreshold options * Add timeBuffer key to config file * Fix indent in config * remove offset from bottom ped delay point * Re add approach id to ped pphase * Update left turn approaches (#45) * Ped recall fix for when no red to red cycles are found * Fix left turn run checks error if no signal data check report view models exist * Fix Left Turn Gap Analysis to get correct signal version * Remove ability to check and uncheck checkboxes in signal detail * Add greater than sign to signal data check report * Fix Area bug * remove unnecessary line * Remove items from viewbag, change first -> firstOrDefault on signal data check * fix approach volume chart * update about page * Fix roles Co-authored-by: mstanley <mstanley@AVELT60> Co-authored-by: avetraffic <96312362+avetraffic@users.noreply.github.com> Co-authored-by: Nuzhat Azra <nazra@avenueconsultants.com> Co-authored-by: avetraffic <traffic@avenueconsultants.com>
dloweAvenueConsultants
pushed a commit
that referenced
this issue
Aug 16, 2022
* Move dots on Ped Delay * Add ApproachID to PhasePedAggregation * Account for ped phase overlaps * Limit ped phases to only those which have at least 1 event * Update ped recall formula * Add ShowPedRecall and PedRecallThreshold options * Add timeBuffer key to config file * Fix indent in config * remove offset from bottom ped delay point * Re add approach id to ped pphase
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I was working on a new install of 4.2 by following the ATSPM 4.2 Installation Manual documentation. When editing the web.config file, the documentation calls for updating the ImageLocation, LinkPivotImageLocation, and SPMImageLocation keys. However, these are not included in the code anymore. Is this intentional or should it match the code from 4.0.1?
The text was updated successfully, but these errors were encountered: