I'm sorry, I don't understand what you're trying to do. You're trying to import data via the Spreadsheets API using SDC?
-Vic On Thu, Jun 23, 2011 at 6:42 AM, Injenia reseller < [email protected]> wrote: > Hi all i have that problem. When i try tu use Secure Data Connector in a > spreadsheet using importData command,the cell result is #N/A. I tested the > importData command in the spreadsheet appendend "?...Debux=text" and the > response is NO CLIENT CONNECTED. I report the error i have in agent.log file > also. > > How i can solve my problem? > Thank u in advance > > ******************************************************************* > Date: Thu Jun 23 12:36:38 CEST 2011 > Config directory: > Runtime directory: /home/checco/Scrivania/data-connector-agent > PID file: /home/checco/Scrivania/data-connector-agent/agent.pid > args = > Password file = > /home/checco/Scrivania/data-connector-agent/config/mypassword > Run: /usr/bin/java -Djava.net.preferIPv4Stack=true -jar > /home/checco/Scrivania/data-connector-agent/lib/sdc-agent.jar > -localConfigFile > "/home/checco/Scrivania/data-connector-agent/config/localConfig.xml" > -rulesFile > "/home/checco/Scrivania/data-connector-agent/config/resourceRules.xml" > -log4jPropertiesFile > "/home/checco/Scrivania/data-connector-agent/config/log4j.properties" > -passwordFile > "/home/checco/Scrivania/data-connector-agent/config/mypassword" > log4j:ERROR Could not find value for key log4j.appender.A.layout > 23 Jun 2011 10:36:39,540 [main] INFO > com.google.dataconnector.client.SdcConnection - Connecting to SDC server > 23 Jun 2011 10:36:39,542 [main] INFO > com.google.dataconnector.util.SSLSocketFactoryInit - Using SSL for client > connections. > Setting iddle timeout to 60000 ms. > Setting accept timeout to 60000 ms. > Setting udp timeout to 600000 ms. > 23 Jun 2011 10:36:39,552 [com.google.dataconnector.client.JsocksStarter] > INFO com.google.dataconnector.client.JsocksStarter - Starting JSOCKS > listener thread on port 1080 > 23 Jun 2011 10:36:39,555 [com.google.dataconnector.client.JsocksStarter] > INFO net.sourceforge.jsocks.socks.ProxyServer - Starting SOCKS Proxy on: > 127.0.0.1:1080 > 23 Jun 2011 10:36:40,674 [main] INFO > com.google.dataconnector.client.SdcConnection - Sending initial handshake > msg > 23 Jun 2011 10:36:40,674 [main] INFO > com.google.dataconnector.client.SdcConnection - Attemping login > 23 Jun 2011 10:36:41,231 [main] INFO > com.google.dataconnector.client.SdcConnection - Successful login > 23 Jun 2011 10:36:41,237 [main] INFO > com.google.dataconnector.registration.v4.Registration - Sending resources > info > agentId: "sdc1-client" > socksServerPort: 1080 > healthCheckPort: 65535 > resourceKey { > ip: "62.149.175.93" > port: 80 > key: -3480276187164863579 > } > resourcesXml: *etc..*. > > 23 Jun 2011 10:36:41,237 [main] INFO > com.google.dataconnector.util.SdcKeysManager - Adding rule for > Pair[62.149.175.93, 80] > 23 Jun 2011 10:36:41,243 [main] INFO > com.google.dataconnector.client.SdcConnection - Starting hearbeat/ health > check thread. > 23 Jun 2011 10:36:41,243 [main] INFO > com.google.dataconnector.client.SdcConnection - starting a thread to watch > resources file > 23 Jun 2011 10:36:41,244 > [com.google.dataconnector.client.HealthCheckHandler] INFO > com.google.dataconnector.client.HealthCheckHandler - healthcheck config is > not yet received from the SDC server. will check again in 5 sec > 23 Jun 2011 10:36:41,491 [main] FATAL > com.google.dataconnector.client.Client - Connection failed. > com.google.dataconnector.util.ConnectionException: > com.google.dataconnector.protocol.FramingException: Unexpected frame start > read > at > com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:213) > at > com.google.dataconnector.client.Client.parseFlagsValidateAndConnect(Client.java:119) > at com.google.dataconnector.client.Client.main(Client.java:178) > Caused by: com.google.dataconnector.protocol.FramingException: Unexpected > frame start read > at > com.google.dataconnector.protocol.FrameReceiver.readFrame(FrameReceiver.java:109) > at > com.google.dataconnector.protocol.FrameReceiver.startDispatching(FrameReceiver.java:75) > at > com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:209) > ... 2 more > 23 Jun 2011 10:36:41,492 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.client.ResourcesFileWatcher > 23 Jun 2011 10:36:41,492 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.client.JsocksStarter > 23 Jun 2011 10:36:41,492 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.protocol.FrameSender > 23 Jun 2011 10:36:41,492 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.client.HealthCheckHandler > java.net.SocketException: Socket closed > 23 Jun 2011 10:36:41,492 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.client.SdcConnection > at java.net.PlainSocketImpl.socketAccept(Native Method) > at java.net.PlainSocketImpl.accept(Unknown Source) > at java.net.ServerSocket.implAccept(Unknown Source) > at java.net.ServerSocket.accept(Unknown Source) > at net.sourceforge.jsocks.socks.ProxyServer.start(ProxyServer.java:166) > at > com.google.dataconnector.client.JsocksStarter.run(JsocksStarter.java:105) > 23 Jun 2011 10:36:41,492 [com.google.dataconnector.protocol.FrameSender] > INFO com.google.dataconnector.protocol.FrameSender - Sending frames > shutting down > java.lang.InterruptedException > at > java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(Unknown > Source) > at > java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown > Source) > at java.util.concurrent.LinkedBlockingQueue.take(Unknown Source) > at > com.google.dataconnector.protocol.FrameSender.run(FrameSender.java:148) > 23 Jun 2011 10:36:41,492 > [com.google.dataconnector.client.HealthCheckHandler] WARN > com.google.dataconnector.client.HealthCheckHandler - Health check sender > interrupted. Exiting. > 23 Jun 2011 10:36:41,492 > [com.google.dataconnector.client.ResourcesFileWatcher] INFO > com.google.dataconnector.client.ResourcesFileWatcher - Shutting down. > java.lang.InterruptedException: sleep interrupted > at java.lang.Thread.sleep(Native Method) > at com.google.dataconnector.util.SystemUtil.sleep(SystemUtil.java:34) > at > com.google.dataconnector.client.ResourcesFileWatcher.run(ResourcesFileWatcher.java:171) > 23 Jun 2011 10:36:41,493 > [com.google.dataconnector.client.ResourcesFileWatcher] INFO > com.google.dataconnector.client.ResourcesFileWatcher - FileWatcher thread > exiting. Any changes in resources file will require restarting agent > manually. > 23 Jun 2011 10:36:43,494 [main] INFO > com.google.dataconnector.client.Client - Starting agent after 1 > unsuccessful attempts. Next connect in 2000 milliseconds. > 23 Jun 2011 10:36:43,507 [main] INFO > com.google.dataconnector.client.SdcConnection - Connecting to SDC server > 23 Jun 2011 10:36:43,507 [main] INFO > com.google.dataconnector.util.SSLSocketFactoryInit - Using SSL for client > connections. > Setting iddle timeout to 60000 ms. > Setting accept timeout to 60000 ms. > Setting udp timeout to 600000 ms. > 23 Jun 2011 10:36:43,512 [com.google.dataconnector.client.JsocksStarter] > INFO com.google.dataconnector.client.JsocksStarter - Starting JSOCKS > listener thread on port 1080 > 23 Jun 2011 10:36:43,513 [com.google.dataconnector.client.JsocksStarter] > INFO net.sourceforge.jsocks.socks.ProxyServer - Starting SOCKS Proxy on: > 127.0.0.1:1080 > 23 Jun 2011 10:36:44,216 [main] INFO > com.google.dataconnector.client.SdcConnection - Sending initial handshake > msg > 23 Jun 2011 10:36:44,217 [main] INFO > com.google.dataconnector.client.SdcConnection - Attemping login > 23 Jun 2011 10:36:44,765 [main] INFO > com.google.dataconnector.client.SdcConnection - Successful login > 23 Jun 2011 10:36:44,767 [main] INFO > com.google.dataconnector.registration.v4.Registration - Sending resources > info > agentId: "sdc1-client" > socksServerPort: 1080 > healthCheckPort: 65535 > resourceKey { > ip: "62.149.175.93" > port: 80 > key: -4809391524834404346 > } > resourcesXml: *etc..* > > 23 Jun 2011 10:36:44,767 [main] INFO > com.google.dataconnector.util.SdcKeysManager - Adding rule for > Pair[62.149.175.93, 80] > 23 Jun 2011 10:36:44,767 [main] INFO > com.google.dataconnector.client.SdcConnection - Starting hearbeat/ health > check thread. > 23 Jun 2011 10:36:44,769 [main] INFO > com.google.dataconnector.client.SdcConnection - starting a thread to watch > resources file > 23 Jun 2011 10:36:44,769 > [com.google.dataconnector.client.HealthCheckHandler] INFO > com.google.dataconnector.client.HealthCheckHandler - healthcheck config is > not yet received from the SDC server. will check again in 5 sec > 23 Jun 2011 10:36:45,019 [main] FATAL > com.google.dataconnector.client.Client - Connection failed. > com.google.dataconnector.util.ConnectionException: > com.google.dataconnector.protocol.FramingException: Unexpected frame start > read > at > com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:213) > at > com.google.dataconnector.client.Client.parseFlagsValidateAndConnect(Client.java:119) > at com.google.dataconnector.client.Client.main(Client.java:178) > Caused by: com.google.dataconnector.protocol.FramingException: Unexpected > frame start read > at > com.google.dataconnector.protocol.FrameReceiver.readFrame(FrameReceiver.java:109) > at > com.google.dataconnector.protocol.FrameReceiver.startDispatching(FrameReceiver.java:75) > at > com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:209) > ... 2 more > 23 Jun 2011 10:36:45,019 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.client.ResourcesFileWatcher > 23 Jun 2011 10:36:45,019 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.client.JsocksStarter > 23 Jun 2011 10:36:45,020 > [com.google.dataconnector.client.ResourcesFileWatcher] INFO > com.google.dataconnector.client.ResourcesFileWatcher - Shutting down. > java.lang.InterruptedException: sleep interrupted > at java.lang.Thread.sleep(Native Method) > at com.google.dataconnector.util.SystemUtil.sleep(SystemUtil.java:34) > at > com.google.dataconnector.client.ResourcesFileWatcher.run(ResourcesFileWatcher.java:171) > 23 Jun 2011 10:36:45,020 > [com.google.dataconnector.client.ResourcesFileWatcher] INFO > com.google.dataconnector.client.ResourcesFileWatcher - FileWatcher thread > exiting. Any changes in resources file will require restarting agent > manually. > 23 Jun 2011 10:36:45,020 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.protocol.FrameSender > java.net.SocketException: Socket closed > 23 Jun 2011 10:36:45,020 [main] INFO > com.google.dataconnector.util.ShutdownManager - Issuing shutdown for > com.google.dataconnector.client.HealthCheckHandler > at java.net.PlainSocketImpl.socketAccept(Native Method) > at java.net.PlainSocketImpl.accept(Unknown Source)23 Jun 2011 > 10:36:45,020 [main] INFO com.google.dataconnector.util.ShutdownManager - > Issuing shutdown for com.google.dataconnector.client.SdcConnection > > at java.net.ServerSocket.implAccept(Unknown Source) > at java.net.ServerSocket.accept(Unknown Source) > at net.sourceforge.jsocks.socks.ProxyServer.start(ProxyServer.java:166) > at > com.google.dataconnector.client.JsocksStarter.run(JsocksStarter.java:105) > 23 Jun 2011 10:36:45,020 [com.google.dataconnector.protocol.FrameSender] > INFO com.google.dataconnector.protocol.FrameSender - Sending frames > shutting down > java.lang.InterruptedException > at > java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(Unknown > Source) > at > java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown > Source) > at java.util.concurrent.LinkedBlockingQueue.take(Unknown Source) > at > com.google.dataconnector.protocol.FrameSender.run(FrameSender.java:148) > 23 Jun 2011 10:36:45,020 > [com.google.dataconnector.client.HealthCheckHandler] WARN > com.google.dataconnector.client.HealthCheckHandler - Health check sender > interrupted. Exiting. > >
