Processes not Showing in Work Center or Manage Section
Everytime i run publish a new change i see the new version appear but when i execute the new app nothing appears in Work Center inbox to run the task. When I go into manage section to view the process activity NOTHING shows for the last six process I started. Is there a max number of version numbers you can have or something. Why is there no record of anything in the Manage section of the last 6 processes that vanished and never appeared in the Work Center inbox. I've reboot my workstation and still my App shows nothing in Manage Section as though i never executed the initial form.
Help... any suggestions
Derek
-
I tracked down our System Admin in charge of the AWS Servers and he forward me email he got. I had him added me to Distro so I'll get emails. It looks like a data entity issue insert NULL value in TID_u sequence number field.
I'll send in emails because it doesn't format good in this comment box.
EventName = CreateProcessInstance
Sender = JPL\guillory
SentDate = 8/24/2020 12:53:24 PM
EndDate =
Status = Sent
Session = 1
TraceCount = 0
ClientData = AAA2023A2193461011AAE6437320B5AF
UserContext = C09880475ECF6EE4C242F937ADAC5519DB20236BFC7AECA7550E63265F47D0FA6E1853677734FAAC8C9771C4A8B98E192661E56DA8B557ED7136BE1E56852796EAEA2EC6B1B6A7AD293DBBDACC3453D8159D754CCDB3E156D8A43EF223E402013B510769265D6EC3A1C403D12950BB88786C6EDE5733DB6ADB01DA0205F9284B0B76CC7C148E8B142EA32BF74565C8A957F7B33341AE4B1A60F3B083E992F238157871E816DF9C38CCD8EAD5DE87C923E801BFC2755DA0DE64A5569BFC94C5EA5C11FEB1697EAD12C87A84B220CDBA135C663DE7CA9474BA60989860806A4F4F7E05FE70B1F04BF0C216C263CFE320AF8EBE379C797A2E47AA9FB647F74EAD4AD16F2324744C844FF295C6CFEFC5EA9D
AutoStart = True
UserID = 5A610AB247FF1FB9633233FDEA1A4D05214731995914E7A8FC2B063FEE124F47CE9E025D18D2F4249DB0B81686A3253C 0B51CB6848D15566DAB1C75F6F222B81384F2C4678DC9EB747F757E29A0C4D2DBA7E6007F54D10E959C7D54E14F6E202
ProcInstName = DG-Process-2020-08-24T12:53:24:116
WorkObjectID = AAA2023A2193461011AAE6437320B5AF
ProcDefID = AAA2023A2193461011AAE64360FC1852
HighPriority = False
ProcInstID = AAA2023A2193461011AAE6437320B5AE
Process Instance='DG-Process-2020-08-24T12:53:24:116'
Failed to publish InvokeSetCustomAttrEventHandlers, event=UpdatingCustomAttributes, before=//<?xml version="1.0" encoding="utf-8"?><pd:AP xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:pd="http://www.ascentn.com/bpm/XMLSchema"><pd:processFields><pd:RecordsProcessed /><pd:LoopAgain>false</pd:LoopAgain><pd:LoopingVariables><pd:PFAccountName /><pd:PFEmailID /><pd:PFPhone /><pd:PFCustomerPONumber /><pd:PFPOAmount /><pd:PFPaymentTerms /><pd:PFLoopIsOver>false</pd:PFLoopIsOver><pd:PFRecordID /></pd:LoopingVariables><pd:ProgOfcLoopDone>false</pd:ProgOfcLoopDone><pd:sDERecordID /><pd:dbResourceProcessVariables><pd:PVfk_CallSite /><pd:PVTitle /><pd:PV_URL /><pd:PV_Description /><pd:PV_Status /><pd:PV_ResourceType /><pd:PV_Source /><pd:PV_PostDate /><pd:PV_Ord /><pd:PV_RecID /><pd:PV_ListURL /><pd:Element1 /></pd:dbResourceProcessVariables><pd:dbCallSiteProcessVariables><pd:PV_idName /><pd:PV_CallSiteType /><pd:PV_Solicit_Title /><pd:PV_Solicit_No /><pd:PV_Solicit_URL /><pd:PV_Solicit_Type /><pd:PV_isNasaSponsor>false</pd:PV_isNasaSponsor><pd:PV_SponsorName /><pd:PV_SponsorURL /><pd:PV_RelatedInfo /><pd:PV_POCID /><pd:PV_POCName /><pd:PV_POCPhone /><pd:PV_SubmitterName /><pd:PV_PKState /><pd:PV_ApprovedDate /><pd:PV_NasaDirect /><pd:PV_NasaDivision /><pd:PV_CSRecordID /><pd:PV_Instructions /><pd:PV_SubmitterPhone /><pd:PV_ApprovedBy /><pd:PV_AwardExpAnnualBud /><pd:PV_AwardExpBudNotes /><pd:PV_AwdExpAnnBudNotes /><pd:PV_AwardDuration /><pd:PV_AwardDurationNotes /><pd:PV_AwardNumber /><pd:PV_AwardValue /><pd:PV_ConcurType /><pd:PV_FKCategory /><pd:PV_NewForm /><pd:PV_SolicitationOther /><pd:PV_nonNASASponsor /><pd:PV_NonNasaSponsorName /><pd:PV_AwardNumberNotes /><pd:PV_FKSubmitter /><pd:PV_ConCurType /><pd:PV_AltURL /><pd:PV_ArchiveDate /><pd:PV_RetiredDate /><pd:PV_SponsorNasCode /></pd:dbCallSiteProcessVariables><pd:dbCallSiteContactProcessVariables><pd:PV_fkCallSite /><pd:PV_Title /><pd:PV_Description /><pd:PV_fkBadge /><pd:PV_FullName /><pd:PV_Phone /><pd:PV_Email /><pd:PV_fkRoleType /><pd:PV_Ord /><pd:PV_CSContactRecID /></pd:dbCallSiteContactProcessVariables><pd:dbAnnouncementsProcessVariables><pd:PV_ID /><pd:PV_AnnounceFkCallSite /><pd:PV_Title /><pd:PV_Description /><pd:PV_submitted /><pd:PV_isEnabled>false</pd:PV_isEnabled><pd:PV_Ord /><pd:PV_RecordID /><pd:PV_TID /></pd:dbAnnouncementsProcessVariables><pd:LoopCount /><pd:PV_ResourceFileName /><pd:PV_WebFileName /><pd:dbWinnersProcessVariables><pd:PV_ID /><pd:PV_Title /><pd:PV_Org /><pd:PV_Name /><pd:PV_isInternal>false</pd:PV_isInternal><pd:PV_Affiliation /><pd:PV_CallID /></pd:dbWinnersProcessVariables><pd:dbCallSiteFocusAreaProcessVariables><pd:PV_FocusID /><pd:PV_fkCallSite /><pd:PV_ParentID /><pd:PV_Title /><pd:PV_Description /><pd:PV_Ord /></pd:dbCallSiteFocusAreaProcessVariables><pd:newGUID /></pd:processFields><pd:formFields><pd:InvoiceDate /><pd:PointofContact /><pd:CustomerPODate /><pd:Approve>false</pd:Approve><pd:CustomerPONumber /><pd:AccountName /><pd:EmailID /><pd:Phone /><pd:CustomerName></pd:CustomerName><pd:SalesInfo_SubForm><pd:SalesInfo><pd:SFAcctName></pd:SFAcctName><pd:SFEmailID></pd:SFEmailID><pd:SFPhone></pd:SFPhone><pd:SFPOAmount></pd:SFPOAmount><pd:SFCustPONumber></pd:SFCustPONumber><pd:SFPaymentterms></pd:SFPaymentterms></pd:SalesInfo></pd:SalesInfo_SubForm><pd:sfProgramOffice_SubForm><pd:sfProgramOffice><pd:sfCallSiteID /><pd:sfProgOfcID /><pd:sfSigLevel /><pd:sfsigBadge /><pd:sfsigName /><pd:sfDir /></pd:sfProgramOffice></pd:sfProgramOffice_SubForm><pd:hCallSiteID /><pd:hProgOfcID /><pd:hSigLevel /><pd:hsigBadge /><pd:hsigName /><pd:hDir /><pd:sfResource_SubForm><pd:sfResource><pd:sfResourceCallSiteID /><pd:sfTitle /><pd:sfResourceDescription /><pd:sfResourceURL /><pd:sfResourceStatus /><pd:sfResourceType /><pd:sfResourceSource /><pd:sfResourcePostDate /><pd:sfResourceOrd /><pd:sfRecID /></pd:sfResource></pd:sfResource_SubForm><pd:sffProgramOffice_SubForm><pd:sffProgramOffice><pd:sffCallSiteID /><pd:sffFocusArea /><pd:sffProgramOfcID /><pd:sffSigLevel /><pd:sffSigRole /><pd:sffSigBadge /><pd:sffSigName /><pd:sffDir /><pd:sfRCID /></pd:sffProgramOffice></pd:sffProgramOffice_SubForm><pd:CallSiteID /><pd:FocusArea /><pd:ProgramOfcID /><pd:SigLevel /><pd:sigRole /><pd:SigBadge /><pd:SigName /><pd:Dir /><pd:SPISTable></pd:SPISTable><pd:sfCallSite_SubForm><pd:sfCallSite><pd:sfIDName /><pd:sfCSiteType /><pd:sfSolicitTitle /><pd:sfSolicitNo /><pd:sfSolicitURL /><pd:sfSolicitType /><pd:sfSponsorName /><pd:sfSponsorURL /><pd:sfRelatedInfo /><pd:sfPOCID /><pd:sfPOCName /><pd:sfPOCPhone /><pd:sfSubmitterName /><pd:sfFKState /><pd:sfApproveDate /><pd:sfNASADirect /><pd:sfNasaDivision /><pd:sfCSID /><pd:sfConcurType /><pd:sfFKCategory /><pd:sfSolicitationOther /><pd:sfnonNASASponsor /><pd:sfnonNasaSponsorName /><pd:sfInstructions /><pd:SubmitterPhone /><pd:sfApprovedBy /><pd:sfAwardExpAnnualBudget /><pd:sfAwardNumberNotes /><pd:sfAwardExpAnnualBudgetNotes /><pd:sfAwardDuration /><pd:sfAwardDurationNotes /><pd:sfAwardNumber /><pd:sfAwardValue /><pd:sfisNasaSponsor>false</pd:sfisNasaSponsor><pd:sffk_submitter /><pd:sfFKSubmitter /><pd:sfSponsorNasCode /><pd:sfAltURL /><pd:sfArchiveDate /><pd:sfRetiredDate /><pd:NewForm /><pd:sfNewForm /></pd:sfCallSite></pd:sfCallSite_SubForm><pd:WritetoWhere>AG</pd:WritetoWhere><pd:sfCallSiteContact_SubForm><pd:sfCallSiteContact><pd:sfFKCallSite /><pd:sfCallTitle /><pd:sfDescription /><pd:sfFKBadge /><pd:sfFullName /><pd:sfCSContactPhone /><pd:sfEmail /><pd:sfFKRoleType /><pd:sfORD /><pd:sfContactID /></pd:sfCallSiteContact></pd:sfCallSiteContact_SubForm><pd:sfExcelImport_SubForm><pd:sfExcelImport><pd:sfAccountName /><pd:sfExcelEmail /><pd:sfExcelPhone /><pd:sfExcelPOamount /><pd:sfExcelCustomerPOAmount /><pd:sfExcelPaymentTerms /></pd:sfExcelImport></pd:sfExcelImport_SubForm><pd:sfAnnouncements_SubForm><pd:sfAnnouncements><pd:sfRecordID /><pd:sfAnnounceFKCallSite /><pd:sfAnnounceTitle /><pd:sfAnnounceDesc /><pd:sfAnnounceSubmitDate /><pd:sfAnnounceOrd /><pd:sfAnnounceIsEnabled>false</pd:sfAnnounceIsEnabled></pd:sfAnnouncements></pd:sfAnnouncements_SubForm><pd:RecordNo /><pd:ListSubForm_SubForm><pd:ListSubForm><pd:URL1 /></pd:ListSubForm></pd:ListSubForm_SubForm><pd:Requestor>Derek</pd:Requestor><pd:RequestDate /><pd:RequestDateTime>2020-08-24T19:53:08.000Z</pd:RequestDateTime><pd:RequestDocName>CallSite26</pd:RequestDocName><pd:resourceFileName /><pd:TestMode>false</pd:TestMode><pd:CSTestMode>false</pd:CSTestMode><pd:TestModeAnnouncements>false</pd:TestModeAnnouncements><pd:sfFocusArea_SubForm><pd:sfFocusArea><pd:sfFocusAreaID /><pd:sfFocusAreafkCallSite /><pd:sfFocusAreaParentID /><pd:sfFocusAreaTitle /><pd:sfFocusAreaDesc /><pd:sfFocusAreaOrd /></pd:sfFocusArea></pd:sfFocusArea_SubForm><pd:Winners_SubForm><pd:Winners /></pd:Winners_SubForm><pd:currentWinWID /><pd:currentWinCallSiteID /><pd:currentWinIsInternal>false</pd:currentWinIsInternal><pd:currentWinName /><pd:currentWinTitle /><pd:currentWinAffiliation /><pd:currentWinOrg /><pd:sfbpConcOpen_SubForm><pd:sfbpConcOpen><pd:sfbpConcOpenbcoID /><pd:sfbpConcOpenCallSiteID /><pd:sfbpConcOpenActivityID /><pd:sfbpConcOpenbpOpen>false</pd:sfbpConcOpenbpOpen><pd:sfbpConcOpenConOpen>false</pd:sfbpConcOpenConOpen></pd:sfbpConcOpen></pd:sfbpConcOpen_SubForm><pd:frmbpbcoID /><pd:frmbpCallSite /><pd:frmbpActivityID /><pd:frmbpOpen>false</pd:frmbpOpen><pd:frmbpConcOpen>false</pd:frmbpConcOpen><pd:sfWinners_SubForm><pd:sfWinners><pd:NumberBox4 /><pd:sfWinnersID /><pd:sfWinnersCallID /><pd:sfWinnersIsInternal>false</pd:sfWinnersIsInternal><pd:sfWinnersName /><pd:sfWinnersTitle /><pd:sfWinnersAffiliation /><pd:sfWinnersOrg /></pd:sfWinners></pd:sfWinners_SubForm><pd:calTitle /><pd:calStartTime /><pd:calEndTime /><pd:calLocation /><pd:calCategory /><pd:ppEmail></pd:ppEmail><pd:ppUsername></pd:ppUsername><pd:ppManager></pd:ppManager><pd:sfSPAnnouncement_SubForm><pd:sfSPAnnouncement><pd:sfSPAnnounceDesc /><pd:sfSPAnnounceCallSiteID /><pd:sfSPAnnounceID /><pd:sfSPAnnounceIsEnabled>false</pd:sfSPAnnounceIsEnabled><pd:sfSPAnnounceSubmitDate /><pd:sfSPAnnounceOrd /><pd:sfSPAnnounceRecordID /><pd:sfSPAnnounceTID /></pd:sfSPAnnouncement></pd:sfSPAnnouncement_SubForm><pd:frmIDName /><pd:frmCallSiteType /><pd:frmSolicitTitle /><pd:frmSolictNo /><pd:frmSolictURL /><pd:frmSolicitType /><pd:frmIsNasaSponsor>false</pd:frmIsNasaSponsor><pd:frmSponsorName /><pd:frmSponsorURL /><pd:frmRelatedInfo /><pd:frmPOCName /><pd:frmmPOCName /><pd:frmPOCPhone /><pd:frmSubmitterName /><pd:frmRecordID /><pd:frmNasaDiv /><pd:frmApproveDate /><pd:frmNasaDirect /><pd:frmState /><pd:frmConcurType /><pd:frmCategory /><pd:frmNewForm /><pd:frmSolicitOther /><pd:frmNonNasaSponsorType /><pd:frmNonNasaSponsorName /><pd:frmInstructions /><pd:frmSubmitterPhone /><pd:frmApprovedBy /><pd:frmAwardExpAnlBudget /><pd:frmAwardNumNotes /><pd:frmAwardExpAnlNotes /><pd:frmAwardDuration /><pd:frmAwardDurationNotes /><pd:frmAwardNumber /><pd:frmAwardValue /><pd:frmSubmitter /><pd:frmSponsorNasCode /><pd:frmAltURL /><pd:frmArchiveDate /><pd:frmRetiredDate /><pd:frmPOCID /></pd:formFields><pd:dataSource><pd:APDataEntity><pd:DGCallSiteContact><pd:CallSiteContact__u><pd:CID__u /><pd:description__u /><pd:email__u /><pd:fkbadge__u /><pd:fkcallsite__u /><pd:fkroletype__u /><pd:fullname__u /><pd:id__u /><pd:ID /><pd:ord__u /><pd:phone__u /><pd:title__u /></pd:CallSiteContact__u></pd:DGCallSiteContact><pd:DGSalesDB><pd:DGSales__u><pd:AccountName__u></pd:AccountName__u><pd:CustomerPONumber__u></pd:CustomerPONumber__u><pd:EmailID__u></pd:EmailID__u><pd:ID>cdb52073-43e6-ea11-aaa2-023a21934610</pd:ID><pd:PaymentTerms__u></pd:PaymentTerms__u><pd:Phone__u></pd:Phone__u><pd:POAmount__u></pd:POAmount__u><pd:TID__u>290</pd:TID__u></pd:DGSales__u></pd:DGSalesDB><pd:dgResource><pd:dgResource__u><pd:Description__u></pd:Description__u><pd:fkCallSite__u></pd:fkCallSite__u><pd:fkResourceType__u></pd:fkResourceType__u><pd:ID>e1b52073-43e6-ea11-aaa2-023a21934610</pd:ID><pd:Ord__u></pd:Ord__u><pd:PostDate__u></pd:PostDate__u><pd:RecordID__u></pd:RecordID__u><pd:RecordID__u__DisplayName /><pd:Source__u></pd:Source__u><pd:Status__u></pd:Status__u><pd:TID__u></pd:TID__u><pd:Title__u></pd:Title__u><pd:URL__u></pd:URL__u></pd:dgResource__u></pd:dgResource><pd:DGProgOffice><pd:DGPrgOffice__u><pd:CallSiteID__u></pd:CallSiteID__u><pd:Dir__u></pd:Dir__u><pd:FocusArea__u></pd:FocusArea__u><pd:ID>efb52073-43e6-ea11-aaa2-023a21934610</pd:ID><pd:ProgOfcID__u></pd:ProgOfcID__u><pd:SigRole__u></pd:SigRole__u><pd:SigBadge__u></pd:SigBadge__u><pd:SigLevel__u></pd:SigLevel__u><pd:SigName__u></pd:SigName__u><pd:TID__u></pd:TID__u></pd:DGPrgOffice__u></pd:DGProgOffice></pd:APDataEntity><pd:Database><pd:AgileCallSite><pd:DGSPIS__u><pd:ID /><pd:CREATED_DATE /><pd:LAST_MODIFIED_DATE /><pd:CREATED_BY /><pd:LAST_MODIFIED_BY /><pd:TID__u /><pd:idname__u /><pd:solicittitle__u /><pd:SolicitNumber__u /><pd:fkSolicitType__u /><pd:sponsorname__u /><pd:sponsorurl__u /><pd:instructions__u /><pd:fkpoc__u /><pd:pocname__u /><pd:pocphone__u /><pd:submittername__u /><pd:SubmitterPhone__u /><pd:ApprovedBy__u /><pd:ApprovedDate__u /><pd:fkstate__u /><pd:awardexpAnnaulaBudgetNotes__u /><pd:AwardNumbersNotes__u /><pd:awardvalue__u /><pd:AwardExpAnnualBudget__u /><pd:AwardsNumber__u /><pd:AwardsDurationNotes__u /><pd:AwardsDuration__u /><pd:NasaDirectorate__u /><pd:NasaDivision__u /><pd:SolicitatationOther__u /><pd:NonSponsorNasaType__u /><pd:NonNasaSponsorName__u /><pd:NewForm__u /><pd:fkcategory__u /><pd:SolicitURL__u /><pd:RecordID__u /><pd:RelatedInfo__u /><pd:ConcurFormType__u /><pd:isNasaSponsor__u>false</pd:isNasaSponsor__u><pd:FKsubmitter__u /><pd:CallSiteID__u /><pd:FKCallSiteType__u /></pd:DGSPIS__u></pd:AgileCallSite></pd:Database></pd:dataSource><pd:DataSourceChangeLogs><pd:AgileCallSite>[]</pd:AgileCallSite></pd:DataSourceChangeLogs></pd:AP>, after=,exception=System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'TID__u', table 'AP_Data_Entities_DB_dev.dbo.DGSPIS__u'; column does not allow nulls. INSERT fails.
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.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at AgilePoint.Workflow.DataSources.SqlServerAccess.DoInsertWithOutput(SqlConnection conn, String schemaName, String tableName, Hashtable values, List`1 outputColumns, Int32 timeout)
at AgilePoint.Workflow.DataSources.SqlServerAccess.InsertWithOutput(String schemaName, String tableName, Hashtable values, List`1 outputColumns, Int32 timeout)
at AgilePoint.AgileExtender.DataSources.DatabaseDataSourceExtender.AgilePoint2DatabaseEx(Object sender, WFUpdateCustomAttributesEventArgs args)
at AgilePoint.AgileExtender.DataSources.DatabaseDataSourceExtender.OnUpdatingCustomAttributes(Object sender, EventArgs e)
at Ascentn.Workflow.Base.WFProcessPluggableAdapter.OnUpdatingCustomAttributes(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at an.t(cr A_0, String A_1, WFProcessInstance A_2, WFCustomAttributes A_3, WFCustomAttributes A_4, IWFActivityInstance A_5, NameValue[] A_6, String A_7, String A_8, String A_9, String A_10, WFUserContext A_11)
ClientConnectionId:ba7b582b-4f96-4d5b-8cca-896f03242084
Error Number:515,State:2,Class:16.
StackTrace:
at an.t(cr A_0, String A_1, WFProcessInstance A_2, WFCustomAttributes A_3, WFCustomAttributes A_4, IWFActivityInstance A_5, NameValue[] A_6, String A_7, String A_8, String A_9, String A_10, WFUserContext A_11)
at bj.t(ct A_0, String A_1, String A_2, String A_3, String A_4, String A_5, String A_6, String A_7, String A_8, String A_9, NameValue[] A_10, String A_11, String A_12)
at a3.g(WFEvent A_0, ct A_1)
at de.e(WFEvent A_0)
-
I got a email to System Admin to find out when first email fired. Just found out System Admin had a slew of emails that would of directed me to the problem from last Wednesday. He was working on another server problem and didn't see these emails.
I'll look at all these email so see what is happening.
Derek.
請登入寫評論。
評論
4 條評論