Hi, every body
Is The VB in BCA stable?
I have 4 or 5 documents with VBA action in the BCA.
Since 4 days, no documents want to run. They crash, when they try to open or declare a BO variable.
I try this :
Nothing of this want to run???
Do you have any idea?
This may be a bit of an obvious question, but if it stopped working 4 or 5 days ago, did anything in your BCA environment change at that time? Remember that BCA is nothing more than a “normal” BusObj session running on your behalf. Assuming the installations are the same as on the workstation, the VBA behavior should be the same as well.
That said, debugging VBA problems on a BCA server is problematic, since you have no interaction. A suggestion is to add logging functionality to your error handling routines. When an error is triggered, write something out to a text file in a persistent location that you can review later.
You didn’t state which release you are on. I would occasionally have problems on older releases like 5.1.2 but since we have been on 5.1.6 we haven’t had any of these problems.
configuration :
windows 2000 server sp4
B.O. 5.1.8
oracle 8i
in each action i write :
If Err.Number <> 0 Then
WriteError (Now & " " & Err.Description)
Else
WriteError (Now & "XXX sucess ")
End If
nothing change in the environement. that is my real problem to understand where the problem is.
There is no log. no file was created (normaly created by WriteError).
I write and test my prog on my computer(local).
I send it to the BCA when it’s a local success
each doc is a success on my computer (local) and failed on the server.
If it never even gets to the point of creating the log, I have only one other suggestion. If you can physically log on to the BCA server (not submit a job, but log on to the server as a regular user), try running it that way. This way it will be interactive, and hopefully you will learn more that way.