I have an application written is Visual Basic 6 which was designed to run inside the SalesLogix 5.2 MDI environment. The application is having sporadic issues after the upgrade of the database to SalesLogix 7.5.2 and now utilising a SQL 2008 rather than a SQL 2000 database.
The error from the client application is “run time error: automation failure” however the same error does not occur every time, from my statistics gained it only happens 25% of the time. If I reproduce the exact steps on the same machine from a clean start I still get sporadic results.
When running the code against a SalesLogix 5.2 system I cannot reproduce the error
When running against a SalesLogix 7.5.2 system I get the same error message at various different points in the application, and I always get the same error i.e. the clients are sporadic but development machine is consistent.
Points where the code fails
-
Private Sub SLXGlobalVariableSet(ByVal vsGlobalVariable As String, ByVal vsGlobalValue As String)
Dim pvGlobalValue As Variant
If Me.gobjSLX.GlobalInfoExists(vsGlobalVariable) Then
Me.gobjSLX.GlobalInfoClear vsGlobalVariable
End If
pvGlobalValue = vsGlobalValue
Me.gobjSLX.GlobalInfoSet vsGlobalVariable, pvGlobalValue
End Sub
Where gobjSLX has been created as a global object
Error is the object Me.gObjSLX no longer exists
-
Set X = CreateObject("SalesLogix.ClientObjix")
X.DoInvoke "Basic", "System:c_RefreshViews"
Set X = Nothing
Where application is trying to create a new temporary slx object to talk with
Error is automation error when trying to create the object, I have also attempted to use SalesLogix.SlxApplication which appears a later version as outlined in the following article http://www.slxdeveloper.com/forum.aspx?forumid=3001&postid=339 , however I get the same result
Both procedures run fine against a SalesLogix 5.2 database but not a SalesLogix 7.2 database and both procedures run fine on both development and client machines in most circumstances
