An error has occurred

We apologize. Staff has been notified so that we may make corrections. This problem could be related to data you submitted.
« Return to home page.

Refresh

Only visible to us developers:
System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@Id nvarchar(4000))
SELECT [Application].[id], [Ap' expects the parameter '@Id', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Webitects.Lib.DbUtility.getDataTable(String sql, ArrayList parameterList, String connString) in D:\jenkins-workspace\Chicago Laborers Staging\Lib\DbUtility.cs:line 93
ClientConnectionId:5d5c8170-0c5d-4bb2-8090-3b2fb8a0dd14
Error Number:8178,State:1,Class:16

SQL statement:

SELECT [Application].[id], [Application].[guid], [Application].[applicationTypeId], [Application].[contractorId], [Application].[contractorAddress], [Application].[contractorCity], [Application].[contractorState], [Application].[contractorPostalCode], [Application].[contactFirstName], [Application].[contactMiddleInitial], [Application].[contactLastName], [Application].[contactTitle], [Application].[contactPhoneNumber], [Application].[contactEmail], [Application].[address], [Application].[city], [Application].[state], [Application].[postalCode], [Application].[county], [Application].[sponsoredFirstName], [Application].[sponsoredMiddleInitial], [Application].[sponsoredLastName], [Application].[sponsoredPhoneNumber], [Application].[sponsoredEmail], [Application].[sponsoredAddress], [Application].[sponsoredCity], [Application].[sponsoredState], [Application].[sponsoredPostalCode], [Application].[sponsoredLastFourSSN], [Application].[sponsoredBirthday], [Application].[sponsoredEthnicity], [Application].[sponsoredRace], [Application].[sponsorshipLetterFile], [Application].[sponsorshipEducationFile], [Application].[dateSubmitted], [Application].[deleted], [Application].[referenceNumber], [Application].[statusId], [Application].[appointmentDate], [Application].[noShow], [Application].[ssCardProvided], [Application].[secondaryEducationProvided], [Application].[driversLicenseProvided], [Application].[speaksEnglish], [Application].[nonDelinquent], [Application].[bonded], [Application].[meetsRatio], [Application].[compliantWithNoGrievances], [Application].[currentOnDues], [Application].[compliantDC], [Application].[compliantPW], [Application].[localId], [Application].[projectName], [Application].[initialWorkAssignmentId], [Application].[apprenticeProgramExemptReasons], [Application].[verificationOfHours], [Application].[typeOfWorkExperience], [Application].[typeOfWorkToBePerformed], [Application].[comment], [Application].[documentationCommentsByTF], [Application].[documentationCommentsByDC], [Application].[approvedByLocal], [Contractor].[contractorName], [Contractor].[contractorNumber], [ApplicationStatus].[status], [ApplicationActivity].[id] AS ApplicationActivity_id, [ApplicationActivity].[apprenticeFormId] AS ApplicationActivity_apprenticeFormId, [ApplicationActivity].[activityDateTime] AS ApplicationActivity_activityDateTime, [ApplicationActivity].[userId] AS ApplicationActivity_userId, [ApplicationActivity].[statusId] AS ApplicationActivity_statusId, [ApplicationActivity].[additionalNotes] AS ApplicationActivity_additionalNotes, [User].[firstname] + ' ' + [User].[lastname] AS 'UserName', [UnionLocal].[id] AS UnionLocal_id, [UnionLocal].[name] AS UnionLocal_name, [UnionLocal].[address1] AS UnionLocal_address1, [UnionLocal].[address2] AS UnionLocal_address2, [UnionLocal].[city] AS UnionLocal_city, [UnionLocal].[state] AS UnionLocal_state, [UnionLocal].[zip] AS UnionLocal_zip, [UnionLocal].[phone] AS UnionLocal_phone, [UnionLocal].[email] AS UnionLocal_email, [UnionLocal].[website] AS UnionLocal_website, [UnionLocal].[contactName] AS UnionLocal_contactName, [UnionLocal].[contactEmail] AS UnionLocal_contactEmail, [UnionLocal].[showForApprenticeshipApp] AS UnionLocal_showForApprenticeshipApp, [UnionLocal].[showForPermitWorkerApp] AS UnionLocal_showForPermitWorkerApp, [UnionLocal].[showForInstructorApp] AS UnionLocal_showForInstructorApp, [ApplicationInitialWorkAssignment].[workAssignment], [ApplicationType].[slug] AS 'typeSlug', [ApplicationExperienceReview].[id] AS ApplicationExperienceReview_id, [ApplicationExperienceReview].[applicationId] AS ApplicationExperienceReview_applicationId, [ApplicationExperienceReview].[workedLaborers] AS ApplicationExperienceReview_workedLaborers, [ApplicationExperienceReview].[workedOutsideDC] AS ApplicationExperienceReview_workedOutsideDC, [ApplicationExperienceReview].[workedBTU] AS ApplicationExperienceReview_workedBTU, [ApplicationExperienceReview].[priorApprentice] AS ApplicationExperienceReview_priorApprentice, [ApplicationExperienceReview].[other] AS ApplicationExperienceReview_other, [ApplicationExperienceReview].[comment] AS ApplicationExperienceReview_comment, [ApplicationExperienceReview].[dateTimeSubmitted] AS ApplicationExperienceReview_dateTimeSubmitted, [ApplicationEmployee].[id] AS ApplicationEmployee_id, [ApplicationEmployee].[applicationId] AS ApplicationEmployee_applicationId, [ApplicationEmployee].[firstName] AS ApplicationEmployee_firstName, [ApplicationEmployee].[middleName] AS ApplicationEmployee_middleName, [ApplicationEmployee].[lastName] AS ApplicationEmployee_lastName, [ApplicationEmployee].[email] AS ApplicationEmployee_email, [ApplicationEmployee].[last4SSN] AS ApplicationEmployee_last4SSN, [ApplicationEmployee].[unionLocalId] AS ApplicationEmployee_unionLocalId, [ApplicationAdditionalContact].[id] AS ApplicationAdditionalContact_id, [ApplicationAdditionalContact].[applicationId] AS ApplicationAdditionalContact_applicationId, [ApplicationAdditionalContact].[firstName] AS ApplicationAdditionalContact_firstName, [ApplicationAdditionalContact].[middleInitial] AS ApplicationAdditionalContact_middleInitial, [ApplicationAdditionalContact].[lastName] AS ApplicationAdditionalContact_lastName, [ApplicationAdditionalContact].[title] AS ApplicationAdditionalContact_title, [ApplicationAdditionalContact].[phone] AS ApplicationAdditionalContact_phone, [ApplicationAdditionalContact].[email] AS ApplicationAdditionalContact_email, employeeUnionLocal.[name] AS 'employeeUnionLocalName'
FROM [Application]
JOIN [Contractor] ON [Contractor].[Id] = [Application].ContractorId
JOIN [ApplicationStatus] ON [ApplicationStatus].[Id] = [Application].StatusId
JOIN [ApplicationType] ON [ApplicationType].[Id] = [Application].ApplicationTypeId
LEFT JOIN [ApplicationActivity] ON [ApplicationActivity].[apprenticeFormId] = [Application].Id
LEFT JOIN [UnionLocal] ON [UnionLocal].[Id] = [Application].LocalId AND [UnionLocal].[showForApprenticeshipApp]=1
LEFT JOIN [ApplicationInitialWorkAssignment] ON [ApplicationInitialWorkAssignment].[Id] = [Application].InitialWorkAssignmentId
LEFT JOIN [ApplicationExperienceReview] ON [ApplicationExperienceReview].[applicationId] = [Application].Id
LEFT JOIN [ApplicationEmployee] ON [ApplicationEmployee].[applicationId] = [Application].Id
LEFT JOIN [ApplicationAdditionalContact] ON [ApplicationAdditionalContact].[applicationId] = [Application].Id
LEFT JOIN [UnionLocal] employeeUnionLocal ON employeeUnionLocal.[id]=[ApplicationEmployee].[unionLocalId]
LEFT JOIN [User] ON [User].[id]=[ApplicationActivity].[userId]
WHERE [Application].Guid = @Id
AND [Application].deleted = 0
ORDER BY [ApplicationActivity].[activityDateTime] DESC


Occured at: https://chicagolaborers.spinudev.com/apprentice-program/graceperiod/complete


Stack trace:
at Webitects.Lib.DbUtility.throwCustomException(SqlException e, String sql) in D:\jenkins-workspace\Chicago Laborers Staging\Lib\DbUtility.cs:line 239
at Webitects.Lib.DbUtility.getDataTable(String sql, ArrayList parameterList, String connString) in D:\jenkins-workspace\Chicago Laborers Staging\Lib\DbUtility.cs:line 98
at CMS.Models.ApplicationManager.GetForDetails(String typeSlug, Nullable`1 Id, String referenceNumber, String guid) in D:\jenkins-workspace\Chicago Laborers Staging\Models\Application\ApplicationManager.cs:line 398
at CMS.Controllers.ApplicationController.CompleteGracePeriodApplication(String guid) in D:\jenkins-workspace\Chicago Laborers Staging\Controllers\ApplicationController.cs:line 72
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass42.b__41()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<>c__DisplayClass39.b__33()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass4f.b__49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass4f.b__49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<>c__DisplayClass2a.b__20()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.b__22(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.<>c__DisplayClass1d.b__18(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.b__3(IAsyncResult ar)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.b__3(IAsyncResult ar)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<>c__DisplayClass8.b__3(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.b__3(IAsyncResult ar)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)