Community
Showing results for 
Search instead for 
Do you mean 
Reply

Error on Delete SubEntity is back in gold 301

Bronze Super Contributor
Posts: 1,231
Country: USA

Error on Delete SubEntity is back in gold 301

[ Edited ]

Matt,

The error when deleting the custom sub entity had regressed in build 301.

I tested this in one of the pre-gold build and it worked. I remember somebody ( i think stan) found the error in one of the later beta builds.

 

Steps to recreate:

1) Create a custom SubEntity named 'test'

2) Delete the custom SubEntity named 'test'

 

Stack below.

 

-- Jim Durkin

 

 

ExceptionToStringSmiley SadInner Exception)
(Inner Exception)
Exception Source:      .Net SqlClient Data Provider
Exception Type:        System.Data.SqlClient.SqlException
Exception Message:     Invalid column name 'OPPORTUNITYID'.
Exception Target Site: OnError

---- Stack Trace ----
Stack:0:    System.Data.SqlClient.SqlConnection.OnError(exception As SqlException, breakConnection As Boolean)
       ACTSage.exe: N 2073486
Stack:1:    System.Data.SqlClient.SqlInternalConnection.OnError(exception As SqlException, breakConnection As Boolean)
       ACTSage.exe: N 5064444
Stack:2:    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       ACTSage.exe: N 00234
Stack:3:    System.Data.SqlClient.TdsParser.Run(runBehavior As RunBehavior, cmdHandler As SqlCommand, dataStream As SqlDataReader, bulkCopyHandler As BulkCopySimpleResultSet, stateObj As TdsParserStateObject)
       ACTSage.exe: N 02275
Stack:4:    System.Data.SqlClient.SqlCommand.FinishExecuteReader(ds As SqlDataReader, runBehavior As RunBehavior, resetOptionsString As String)
       ACTSage.exe: N 00215
Stack:5:    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(cmdBehavior As CommandBehavior, runBehavior As RunBehavior, returnStream As Boolean, async As Boolean)
       ACTSage.exe: N 00987
Stack:6:    System.Data.SqlClient.SqlCommand.RunExecuteReader(cmdBehavior As CommandBehavior, runBehavior As RunBehavior, returnStream As Boolean, method As String, result As DbAsyncResult)
       ACTSage.exe: N 00162
Stack:7:    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(result As DbAsyncResult, methodName As String, sendToPipe As Boolean)
       ACTSage.exe: N 00178
Stack:8:    System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       ACTSage.exe: N 00137
Stack:9:    Act.Data.ActDb.ActDbCommand.ExecuteNonQuery()
       ACTSage.exe: N 00045

 

(Outer Exception)
Exception Source:      Act.Data
Exception Type:        Act.Data.ActDb.ActDbException
Exception Message:     Invalid column name 'OPPORTUNITYID'.
Exception Target Site: ExecuteNonQuery

---- Stack Trace ---
Stack:0:    Act.Data.CommandProcessor.ExecuteNonQuery(command As Command)
       ACTSage.exe: N 00438
Stack:1:    Act.Framework.Database.DefineEntityManagerDB.EntityDeleteEntity(entityId As Guid&)
       ACTSage.exe: N 00104

 

(Outer Exception)
Exception Source:      Durkin.Common.Classes.v4
Exception Type:        System.Exception
Exception Message:     Failed to execute 'DeleteEntity' command.
Exception Target Site: SubEntityDelete

---- Stack Trace ----%0A
Stack:0:    Durkin.Common.Classes.CustomSubEntity.SubEntityDelete(HostFramework As ActFramework, sEntityName As String)
       ACTSage.exe: N 00316
Stack:1:    Durkin.Common.Classes.frmEntityDefine.TableDelete()
       ACTSage.exe: N 00771

%0A

 

Employee
Posts: 1,163
Country: USA

Re: Error on Delete SubEntity is back in gold 301

[ Edited ]

Thanks Jim,

 

I'll pass this along and I apologize for any inconvenience it is or has caused.

 

If you have any questions or need an update refer to issue ID 100849.

Matthew Wood
Act! SDK Support
Community Moderator