Running Script Causes loss to gateway

I have a user that receives a gateway loss connection when clicking a button with a script that loops through and executes several insert statements. then when the user tries to launch the project off the gateway page the user receives a cannot connect message.

when I run the script from my computer i do not receive a gateway loss message.

here is the java console when trying to launch the project again.

[quote]Java Web Start 1.6.0_17
Using JRE version 1.6.0_17-b04 Java HotSpot™ Client VM
User home directory = \harvest\Redirected\rhonda

c: clear console window
f: finalize objects on finalization queue
g: garbage collect
h: display this help message
m: print memory usage
o: trigger logging
p: reload proxy configuration
q: hide console
r: reload policy configuration
s: dump system and deployment properties
t: dump thread list
v: dump thread stack
0-5: set trace level to

java.net.SocketException: Unexpected end of file from server
at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)
at sun.net.www.http.HttpClient.parseHTTP(Unknown Source)
at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)
at sun.net.www.http.HttpClient.parseHTTP(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at com.sun.deploy.net.proxy.AbstractAutoProxyHandler.getJSFileFromURL(Unknown Source)
at com.sun.deploy.net.proxy.AbstractAutoProxyHandler.init(Unknown Source)
at com.sun.deploy.net.proxy.DynamicProxyManager.reset(Unknown Source)
at com.sun.deploy.net.proxy.DeployProxySelector.reset(Unknown Source)
at com.sun.javaws.Main.initializeExecutionEnvironment(Unknown Source)
at com.sun.javaws.Main.continueInSecureThread(Unknown Source)
at com.sun.javaws.Main$1.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Reading certificates from 25727 ignition:80/main/system/launchbi … client.jar | C:\Users\rhonda.SIERRANEVADA\AppData\LocalLow\Sun\Java\Deployment\cache\6.0\16\6f95a9d0-41fb2dee.idx
Starting Bootstrap Loader v2.0
Connect Step [attempt 1] connecting to: 10.2.2.111:80/main….
Connect successful.
Connect attempt 0 for address 10.2.2.111:80/main failed.
java.net.SocketException: Unexpected end of file from server
at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)
at sun.net.www.http.HttpClient.parseHTTP(Unknown Source)
at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)
at sun.net.www.http.HttpClient.parseHTTP(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at java.net.HttpURLConnection.getResponseCode(Unknown Source)
at com.inductiveautomation.ignition.client.launch.steps.ConnectStep.downloadManifest(ConnectStep.java:103)
at com.inductiveautomation.ignition.client.launch.steps.ConnectStep.downloadManifest(ConnectStep.java:72)
at com.inductiveautomation.ignition.client.launch.steps.ConnectStep.run(ConnectStep.java:46)
at com.inductiveautomation.ignition.client.launch.AbstractStepRunner.run(AbstractStepRunner.java:32)
at java.lang.Thread.run(Unknown Source)
Connect Step [attempt 1] connecting to: 10.2.2.112:80/main….
Connect successful.
Successfully downloaded launch manifest:

<?xml version="1.0" encoding="UTF-8"?> Claiming id in \\harvest\Redirected\rhonda\.ignition\cache\gw10.2.2.112_80_443_main... ... obtaining lock ... lock obtained. ... claimed id 0 Calculated necessary downloads: <?xml version="1.0" encoding="UTF-8"?> Successfully read project CPDepletions.proj from cache. Edit Count = 47, UUID = d3655069-8438-596c-ceac-26a793af5fba Cache file CPDepletions.proj loaded sucessfully from cache, downloading diff... Downloading "http://10.2.2.112:80/main/system/project/C/P/47/d3655069-8438-596c-ceac-26a793af5fba/Depletions"... Connect successful. Starting download of 328 bytes Download successful Creating classloader with JAR files: [file://harvest/Redirected/rhonda/.ignition/cache/gw10.2.2.112_80_443_main/C0/temp/jython217071519193064395631.jar, [file://harvest/Redirected/rhonda/.ignit ... 701086.jar](file://harvest/Redirected/rhonda/.ignition/cache/gw10.2.2.112_80_443_main/C0/temp/mobile-common6289924343804701086.jar)] Starting class: com.inductiveautomation.factorypmi.application.runtime.ClientLaunchHook INFO [ClientLaunchHook-Thread-9] Ignition Client v7.3.2 (b533) WARN [GatewayConnectionManager-Thread-9] Connection to Gateway lost, due to exception. com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Connection reset at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:283) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:401) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:289) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.ping(GatewayInterface.java:785) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.publicPing(GatewayInterface.java:778) at com.inductiveautomation.ignition.client.gateway_interface.AbstractGatewayConnection.testComm(AbstractGatewayConnection.java:322) at com.inductiveautomation.ignition.client.gateway_interface.AbstractGatewayConnection.fishForAliveServer(AbstractGatewayConnection.java:376) at com.inductiveautomation.ignition.client.gateway_interface.AbstractGatewayConnection.setClusterAddressList(AbstractGatewayConnection.java:224) at com.inductiveautomation.ignition.client.gateway_interface.AbstractGatewayConnection.connect(AbstractGatewayConnection.java:188) at com.inductiveautomation.factorypmi.application.runtime.ClientLaunchHook.setup(ClientLaunchHook.java:162) at com.inductiveautomation.ignition.client.launch.steps.StartupStep.run(StartupStep.java:127) at com.inductiveautomation.ignition.client.launch.AbstractStepRunner.run(AbstractStepRunner.java:32) at java.lang.Thread.run(Unknown Source) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source) at java.io.BufferedInputStream.read1(Unknown Source) at java.io.BufferedInputStream.read(Unknown Source) at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source) at sun.net.www.http.HttpClient.parseHTTP(Unknown Source) at sun.net.www.http.HttpClient.parseHTTP(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at java.net.HttpURLConnection.getResponseCode(Unknown Source) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:333) ... 11 more INFO [GatewayConnectionManager-Thread-9] Disconnecting com.inductiveautomation.ignition.client.launch.steps.ValidationException: Unable to communicate with gateway. at com.inductiveautomation.factorypmi.application.runtime.ClientLaunchHook.setup(ClientLaunchHook.java:171) at com.inductiveautomation.ignition.client.launch.steps.StartupStep.run(StartupStep.java:127) at com.inductiveautomation.ignition.client.launch.AbstractStepRunner.run(AbstractStepRunner.java:32) at java.lang.Thread.run(Unknown Source) [/quote]

I’m thinking something’s up with the network between that client and the gateway. That log shows a variety of transient networking errors (unexpected end-of-file, connection resets) that go away after a retry. I’dtry testing network cables, switches between this client and the gateway.

I have found some time to try testing out different scenarios. The problem only seems to occur under a specific username. Which computer and location do not seem to matter. Any other users do not have this problem when running the same script.

I am guessing it is something in the specific users profile. any ideas of what steps I should take?

I cannot think of anything specific to a user that would do this. It’s got to be something with your domain?

Is there a difference in permission levels between your problem username and the others?
I mean windows permission levels btw.
You might try running filemon as that user and starting the project. Look for access denied events on cache files.

  1. Are you using roaming profiles?
    1a. Is there anything else obvious about that users permissions from others?
  2. Try logging on with that user, opening the Java settings from the control panel. Clearing temporary files, then manually setting the location to a folder on the local hard drive that the user has full access to. Launch the client and see what happens.