SGS

Spawning Ground Survey (SGS) Quality Assurance and Quality Control Presentation

This is the power point presentation of the Top Ten list of errors in the Spawning Ground Survey (SGS) database.  They were compiled and presented by Kristin Wright, Chris Harrington, and Evan Brown at the 2014 SGS Coordination meeting.

Install fails when selecting the Install button Error: Cannot Start Application

When installing the SGS application most users click on the Install button and the installation proceeds and the application opens when it is done.

If the install fails and you receive an error message like below, then there is a secondary install you can try.  You can do this by clicking on the hyperlink text that spells Launch in the paragraph above the Install button.

 

 

Name: Spawning Ground Survey 2
 
Version: 2.7.5.0
 
Publisher: IFWIS
 
The following prerequisites are required:
 
  • Windows Installer 3.1
  • .NET Framework 3.5 SP1 Client Profile
  • .NET Framework 3.5 SP1
  • Microsoft Office 2007 Primary Interop Assemblies
If these components are already installed, you can launch the application now. Otherwise, click the button below to install the prerequisites and run the application.
 
Install
 
 

Cannot Start Application

Cannot download the application.  The application is missing required files.  Contact application vendor for assistance.

Details...

Here are the details associated with the error message.

 

PLATFORM VERSION INFO

                Windows                                             : 6.1.7601.65536 (Win32NT)

                Common Language Runtime       : 2.0.50727.5456

                System.Deployment.dll                                : 2.0.50727.5420 (Win7SP1.050727-5400)

                mscorwks.dll                                      : 2.0.50727.5456 (Win7SP1GDR.050727-5400)

                dfdll.dll                                                 : 2.0.50727.4927 (NetFXspW7.050727-4900)

                dfshim.dll                                            : 4.0.40305.0 (Main.040305-0000)

 

SOURCES

                Deployment url                                                : file:///C:/Users/ktardy.SBT/Downloads/SGSA.application

 

ERROR SUMMARY

                Below is a summary of the errors, details of these errors are listed later in the log.

                * Activation of C:\Users\ktardy.SBT\Downloads\SGSA.application resulted in exception. Following failure messages were detected:

                                + Downloading file:///C:/Users/ktardy.SBT/Downloads/SGSA.applicationdid not succeed.

                                + Could not find file 'C:\Users\ktardy.SBT\Downloads\SGSA.application'.

                                + Could not find file 'C:\Users\ktardy.SBT\Downloads\SGSA.application'.

                                + Could not find file 'C:\Users\ktardy.SBT\Downloads\SGSA.application'.

 

COMPONENT STORE TRANSACTION FAILURE SUMMARY

                No transaction error was detected.

 

WARNINGS

                There were no warnings during this operation.

 

OPERATION PROGRESS STATUS

                * [9/25/2012 10:24:44 AM] : Activation of C:\Users\ktardy.SBT\Downloads\SGSA.application has started.

 

ERROR DETAILS

                Following errors were detected during this operation.

                * [9/25/2012 10:24:45 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)

                                - Downloading file:///C:/Users/ktardy.SBT/Downloads/SGSA.applicationdid not succeed.

                                - Source: System.Deployment

                                - Stack trace:

                                                at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

                                                at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()

                                                at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)

                                                at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)

                                                at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)

                                                at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)

                                                at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)

                                                at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)

                                --- Inner Exception ---

                                System.Net.WebException

                                - Could not find file 'C:\Users\ktardy.SBT\Downloads\SGSA.application'.

                                - Source: System

                                - Stack trace:

                                                at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)

                                                at System.Net.FileWebRequest.GetResponse()

                                                at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

                                --- Inner Exception ---

                                System.Net.WebException

                                - Could not find file 'C:\Users\ktardy.SBT\Downloads\SGSA.application'.

                                - Source: System

                                - Stack trace:

                                                at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)

                                                at System.Net.FileWebRequest.GetResponseCallback(Object state)

                                --- Inner Exception ---

                                System.IO.FileNotFoundException

                                - Could not find file 'C:\Users\ktardy.SBT\Downloads\SGSA.application'.

                                - Source: mscorlib

                                - Stack trace:

                                                at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

                                                at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)

                                                at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)

                                                at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)

                                                at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)

                                                at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)

 

COMPONENT STORE TRANSACTION DETAILS

                No transaction information is available.

 

Redd Detail Viewer

Starting Saturday 12/24/2011, an error message indicating a Time Out errror occured whenever the Redd Detail Viewer report and SQL query were run.

In SQL, the query would run successfully if a limited number of records were selected (e.g. Top 1,000, Year = 2011)

Unfortunately one cannot even select a subset of data from the Redd Detail Viewer as it times out before the page is loaded.

We will try to figure out a solution to this new error for a query which was previously running fine.

SGS Redd Count Summary Coordinator parameter selection ignored

When I select a Coordinator value in the Redd Count Summary, the query returns no data.

SGS Export line breaks divide records

When a selection of SGS data is exported to a csv file, the records with carriage returns and/or commas are divided in two parts and screws the filtering and pivoting of the data in excel.