Page 2 of 2 < 1 2
Topic Options
#55339 - 09/25/17 10:13 AM Re: VBscript not working with high volume of data [Re: SSimon]
SSimon Offline
OL Newbie

Registered: 09/05/17
Posts: 14
Loc: Ireland
Hi Philippe

There are 1700 lines of code. If you send me on private message with your email address I will be able to send you the test script or even a whole configuration.

Regards
Simon

Top
#55341 - 09/25/17 01:58 PM Re: VBscript not working with high volume of data [Re: SSimon]
Philippe F. Offline
OL Expert

Registered: 09/06/00
Posts: 1931
Loc: Objectif Lune, Montreal, Qc
Remember that the Scripting task in Workflow instantiates the Windows Scripting Engine, so it's not a custom engine we embedded inside the application but rather just a call to the OS-provided engine. Issues with code that has been working for a while but that suddenly stops working could be a reflection of , for instance, increased volume or size of the jobs being processed the the Windows Engine is unable to handle.

As a general pointer, though, you should pay particular attention to how you use external objects (XMLDOM, FileSytemObject, WMI, etc). These may not always be suited for use inside a highly threaded environement like workflow.

I unfortunately can't pour through 1700 lines of code, I do have a job to atend to... smirk ... But it's probably safe to assume that if you need 1700 lines of code to achieve what you want to do, then the memory issue most likely lies with that code.
_________________________
Technical Product Manager
I don't want to achieve immortality through my work; I want to achieve immortality through not dying - Woody Allen

Top
#55342 - 09/26/17 05:37 AM Re: VBscript not working with high volume of data [Re: SSimon]
SSimon Offline
OL Newbie

Registered: 09/05/17
Posts: 14
Loc: Ireland
Hi Hunt3r/Philippe

Thank you for your help and suggestions.

I have already reduced the log level, but no luck.

I have also set all outstanding objects in VBscript to Nothing, no luck.

After my tests, I am pretty sure this is a problem with VBScript. In both processes, I have a VB script plugins. When I turned off script plugins in the second process
everything was ok in the first process - no error occurred.
When I turned on all script plugins back, the problem has appeared again.

We did not have this problem before and we do not have this problem on our test server.

Regards
Simon

Top
#55344 - 09/26/17 09:16 AM Re: VBscript not working with high volume of data [Re: SSimon]
Philippe F. Offline
OL Expert

Registered: 09/06/00
Posts: 1931
Loc: Objectif Lune, Montreal, Qc
Setting the objects to nothing won't change anything becasue VBScript's garbage collector already takes care of that efficiently. However, if you are using ActiveX Objects (through the CreateObject()) method, then some of those objects may not be thread-safe. That depends on the version of Windows you're running, which updates were installed, what drivers were updated, and so on.

For instance, there are several versions of the Microsost.XMLHTTP available, just like there are different versions of the DAO/ADO/OLEDB drivers. Those would be the prime suspects, along with application objects like Microsoft.Excel or Microsoft.Word.

If you are using an Access Database, the drivers used to access that DB are notoriously flaky in multi-threaded environments.

I am not pointing the finger at any particular object, just attempting to give you pointers to help you determine what could cause the issues you're running into.
_________________________
Technical Product Manager
I don't want to achieve immortality through my work; I want to achieve immortality through not dying - Woody Allen

Top
#55350 - 09/26/17 12:49 PM Re: VBscript not working with high volume of data [Re: SSimon]
SSimon Offline
OL Newbie

Registered: 09/05/17
Posts: 14
Loc: Ireland
Hi again

I have compared once again processes on the Production server and Test Server. On prod serv I have noticed that during processing files memory for process PPWatchService.exe*32 was increasing per every file - which should not. As on the test server, Memory was all the time between 100K and 110K.

In terms of the objects in Vbscript I use FileSystemObject and
ADODB for MS Access only. But I switched off MS access VBscripts and the error was still there.

Regards
Simon

Top
#55353 - 09/26/17 03:35 PM Re: VBscript not working with high volume of data [Re: SSimon]
Philippe F. Offline
OL Expert

Registered: 09/06/00
Posts: 1931
Loc: Objectif Lune, Montreal, Qc
At this stage I suggest you open a ticket with our Support team as this will probably require more hands-on investigation than what we can provide through this forum.
_________________________
Technical Product Manager
I don't want to achieve immortality through my work; I want to achieve immortality through not dying - Woody Allen

Top
#55357 - 09/28/17 06:03 AM Re: VBscript not working with high volume of data [Re: SSimon]
SSimon Offline
OL Newbie

Registered: 09/05/17
Posts: 14
Loc: Ireland
Hi Philippe

I have opened a ticket and I am waiting for a response now.
Thank you for your help.

Regards
Simon

Top
Page 2 of 2 < 1 2