SDC Service is crashing

[Dan B.]

06 Dec 2012 17:23:53,068 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - frame type recevd: AUTHORIZATION
06 Dec 2012 17:23:53,068 [main] INFO  com.google.dataconnector.client.SdcConnection  - Successful login
06 Dec 2012 17:23:53,070 [main] FATAL com.google.dataconnector.client.Client  - Connection failed.
com.google.dataconnector.util.RegistrationException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[49,1]
Message: XML document structures must start and end within the same entity.
    at com.google.dataconnector.registration.v4.Registration.createResourceKeys(Registration.java:163)
    at com.google.dataconnector.registration.v4.Registration.sendRegistrationInfo(Registration.java:126)
    at com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:175)
    at com.google.dataconnector.client.Client.parseFlagsValidateAndConnect(Client.java:119)
    at com.google.dataconnector.client.Client.main(Client.java:178)
Caused by: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[49,1]
Message: XML document structures must start and end within the same entity.
    at com.sun.org.apache.xerces.internal.impl.XMLStreamReaderImpl.next(XMLStreamReaderImpl.java:592)
    at com.google.dataconnector.registration.v4.ResourceRuleParser.parseResourcesFile(ResourceRuleParser.java:79)
    at com.google.dataconnector.registration.v4.Registration.createResourceKeys(Registration.java:150)
    ... 4 more
06 Dec 2012 17:23:53,071 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.client.ResourcesFileWatcher
06 Dec 2012 17:23:53,071 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.client.JsocksStarter
06 Dec 2012 17:23:53,071 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.protocol.FrameSender
java.net.SocketException: Socket closed
    at java.net.PlainSocketImpl.socketAccept(Native Method)
    at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:375)
    at java.net.ServerSocket.implAccept(ServerSocket.java:470)
    at java.net.ServerSocket.accept(ServerSocket.java:438)
06 Dec 2012 17:23:53,071 [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(AbstractQueuedSynchronizer.java:2017)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2052)
    at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:386)
    at com.google.dataconnector.protocol.FrameSender.run(FrameSender.java:148)
    at net.sourceforge.jsocks.socks.ProxyServer.start(ProxyServer.java:166)
    at com.google.dataconnector.client.JsocksStarter.run(JsocksStarter.java:105)

[Eric Pollmann]

Hi Dan,

I just reset the connections, please let me know if you're still having issues, thanks!

-Eric

--
You received this message because you are subscribed to the Google Groups "enterprise-data-questions" group.
To post to this group, send email to enterprise-d...@google.com.
To unsubscribe from this group, send email to enterprise-data-qu...@google.com.
For more options, visit this group at http://groups.google.com/a/google.com/group/enterprise-data-questions/?hl=en.

[Daniel Bachmann]

Thanks, Eric, but unfortunately it's still shutting down after login:

6 Dec 2012 18:04:52,553 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - frame type recevd: AUTHORIZATION
06 Dec 2012 18:04:52,553 [main] INFO  com.google.dataconnector.client.SdcConnection  - Successful login
06 Dec 2012 18:04:52,577 [main] FATAL com.google.dataconnector.client.Client  - Connection failed.

com.google.dataconnector.util.RegistrationException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[49,1]
Message: XML document structures must start and end within the same entity.
    at com.google.dataconnector.registration.v4.Registration.createResourceKeys(Registration.java:163)
    at com.google.dataconnector.registration.v4.Registration.sendRegistrationInfo(Registration.java:126)
    at com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:175)
    at com.google.dataconnector.client.Client.parseFlagsValidateAndConnect(Client.java:119)
    at com.google.dataconnector.client.Client.main(Client.java:178)
Caused by: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[49,1]
Message: XML document structures must start and end within the same entity.
    at com.sun.org.apache.xerces.internal.impl.XMLStreamReaderImpl.next(XMLStreamReaderImpl.java:592)
    at com.google.dataconnector.registration.v4.ResourceRuleParser.parseResourcesFile(ResourceRuleParser.java:79)
    at com.google.dataconnector.registration.v4.Registration.createResourceKeys(Registration.java:150)
    ... 4 more

06 Dec 2012 18:04:52,578 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.client.ResourcesFileWatcher
06 Dec 2012 18:04:52,578 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.client.JsocksStarter
06 Dec 2012 18:04:52,578 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.protocol.FrameSender
06 Dec 2012 18:04:52,579 [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(AbstractQueuedSynchronizer.java:2017)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2052)
    at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:386)
    at com.google.dataconnector.protocol.FrameSender.run(FrameSender.java:148)

java.net.SocketException: Socket closed
    at java.net.PlainSocketImpl.socketAccept(Native Method)
    at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:375)
    at java.net.ServerSocket.implAccept(ServerSocket.java:470)
    at java.net.ServerSocket.accept(ServerSocket.java:438)

    at net.sourceforge.jsocks.socks.ProxyServer.start(ProxyServer.java:166)
    at com.google.dataconnector.client.JsocksStarter.run(JsocksStarter.java:105)

[Daniel Bachmann]

Eric,
        It was up momentarily, but down again.


Thanks,
Dan



*******************************************************************
Date: Thu Dec  6 18:22:58 CST 2012
Config directory:
Runtime directory: /googlesdc/data-connector-agent
PID file: /googlesdc/data-connector-agent/agent.pid
args =
Password file = /googlesdc/data-connector-agent/config/mypassword
Run: /usr/bin/java -Djava.net.preferIPv4Stack=true -jar /googlesdc/data-connector-agent/lib/sdc-agent.jar  -localConfigFile "/googlesdc/data-connector-agent/config/localConfig.xml" -rulesFile "/googlesdc/data-connector-agent/config/resourceRules.xml" -log4jPropertiesFile "/googlesdc/data-connector-agent/config/log4j.properties" -passwordFile "/googlesdc/data-connector-agent/config/mypassword" 
log4j:ERROR Could not find value for key log4j.appender.A.layout
06 Dec 2012 18:22:59,408 [main] DEBUG com.google.dataconnector.util.ShutdownManager  - Managing shutdown for com.google.dataconnector.client.JsocksStarter
06 Dec 2012 18:22:59,410 [main] INFO  com.google.dataconnector.client.SdcConnection  - Connecting to SDC server
06 Dec 2012 18:22:59,410 [main] DEBUG com.google.dataconnector.client.SdcConnection  - setting up SSLSocket with customized SSLSocketFacory
06 Dec 2012 18:22:59,410 [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.
06 Dec 2012 18:22:59,417 [com.google.dataconnector.client.JsocksStarter] INFO  com.google.dataconnector.client.JsocksStarter  - Starting JSOCKS listener thread on port 1080
06 Dec 2012 18:22:59,420 [com.google.dataconnector.client.JsocksStarter] INFO  net.sourceforge.jsocks.socks.ProxyServer  - Starting SOCKS Proxy on:127.0.0.1:1080
06 Dec 2012 18:22:59,895 [main] INFO  com.google.dataconnector.client.SdcConnection  - Sending initial handshake msg
06 Dec 2012 18:22:59,895 [main] INFO  com.google.dataconnector.client.SdcConnection  - Attemping login
06 Dec 2012 18:22:59,897 [Thread-2] DEBUG com.google.dataconnector.util.ShutdownManager  - Managing shutdown for com.google.dataconnector.protocol.FrameSender
06 Dec 2012 18:23:00,038 [com.google.dataconnector.protocol.FrameSender] DEBUG com.google.dataconnector.protocol.FrameSender  - Start byte: 42
06 Dec 2012 18:23:00,038 [com.google.dataconnector.protocol.FrameSender] DEBUG com.google.dataconnector.protocol.FrameSender  - Magic: [B@3b4b1e
06 Dec 2012 18:23:00,038 [com.google.dataconnector.protocol.FrameSender] DEBUG com.google.dataconnector.protocol.FrameSender  - sequence: 0
06 Dec 2012 18:23:00,038 [com.google.dataconnector.protocol.FrameSender] DEBUG com.google.dataconnector.protocol.FrameSender  - payload length: 59
06 Dec 2012 18:23:00,038 [com.google.dataconnector.protocol.FrameSender] DEBUG com.google.dataconnector.protocol.FrameSender  - payload: [B@c0a9f9
06 Dec 2012 18:23:00,042 [com.google.dataconnector.protocol.FrameSender] DEBUG com.google.dataconnector.protocol.FrameSender  - frame:
sequence: 0
type: AUTHORIZATION
payload: "\n%secure-data-c...@flycfm.net\032\fCloudtunne7\n"

06 Dec 2012 18:23:00,042 [com.google.dataconnector.protocol.FrameSender] DEBUG com.google.dataconnector.protocol.FrameSender  - sending frame type: AUTHORIZATION
06 Dec 2012 18:23:00,167 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - Start byte: 42
06 Dec 2012 18:23:00,232 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - Magic: beefcake
06 Dec 2012 18:23:00,232 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - sequence: 0
06 Dec 2012 18:23:00,233 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - payload length: 57
06 Dec 2012 18:23:00,233 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - payload: [B@e33e18
06 Dec 2012 18:23:00,233 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - frame:
sequence: 0
type: AUTHORIZATION
payload: "\n%secure-data-c...@flycfm.net(\0012\bSuccess."

06 Dec 2012 18:23:00,233 [main] DEBUG com.google.dataconnector.protocol.FrameReceiver  - frame type recevd: AUTHORIZATION
06 Dec 2012 18:23:00,235 [main] INFO  com.google.dataconnector.client.SdcConnection  - Successful login
06 Dec 2012 18:23:00,268 [main] FATAL com.google.dataconnector.client.Client  - Connection failed.

com.google.dataconnector.util.RegistrationException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[49,1]
Message: XML document structures must start and end within the same entity.
    at com.google.dataconnector.registration.v4.Registration.createResourceKeys(Registration.java:163)
    at com.google.dataconnector.registration.v4.Registration.sendRegistrationInfo(Registration.java:126)
    at com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:175)
    at com.google.dataconnector.client.Client.parseFlagsValidateAndConnect(Client.java:119)
    at com.google.dataconnector.client.Client.main(Client.java:178)
Caused by: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[49,1]
Message: XML document structures must start and end within the same entity.
    at com.sun.org.apache.xerces.internal.impl.XMLStreamReaderImpl.next(XMLStreamReaderImpl.java:592)
    at com.google.dataconnector.registration.v4.ResourceRuleParser.parseResourcesFile(ResourceRuleParser.java:79)
    at com.google.dataconnector.registration.v4.Registration.createResourceKeys(Registration.java:150)
    ... 4 more

06 Dec 2012 18:23:00,269 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.client.ResourcesFileWatcher
06 Dec 2012 18:23:00,269 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.client.JsocksStarter
06 Dec 2012 18:23:00,269 [main] INFO  com.google.dataconnector.util.ShutdownManager  - Issuing shutdown for com.google.dataconnector.protocol.FrameSender

java.net.SocketException: Socket closed
    at java.net.PlainSocketImpl.socketAccept(Native Method)
    at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:375)
    at java.net.ServerSocket.implAccept(ServerSocket.java:470)
    at java.net.ServerSocket.accept(ServerSocket.java:438)

    at net.sourceforge.jsocks.socks.ProxyServer.start(ProxyServer.java:166)
    at com.google.dataconnector.client.JsocksStarter.run(JsocksStarter.java:105)

06 Dec 2012 18:23:00,270 [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(AbstractQueuedSynchronizer.java:2017)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2052)
    at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:386)
    at com.google.dataconnector.protocol.FrameSender.run(FrameSender.java:148)

[Eric Pollmann]

Hi Dan,

Upon closer inspection of your error messages, it looks like your config file may have invalid XML in it, see the message: "XML document structures must start and end within the same entity" -- can you take a look?  If it's not obvious and you don't mind sharing the file I'm happy to take a look.

Thanks,

-Eric

[Daniel Bachmann]

I wondered about that, but everything had been working.

Thanks,
Dan

[Eric Pollmann]

Hi Daniel,

Try adding a line with "</resourceRules>" to the end of resourceRules.xml, does that work?

Otherwise localConfig.xml and resourceRules.xml parse as valid XML...

Best,

-Eric

[Daniel Bachmann]

Eric,
Yes, I accidentally deleted the closing tag along with the last rule.

But, when this script still throws an exception of "Bad Request" in debug:

function fetchData() {

  var textContentUrlFetch = UrlFetchApp.fetch("http://localhost:8080/art/export/SDC_TEST_DATA.tsv",{use_Intranet:'yes'}).getContentText(); 
   
 Logger.log(textContentUrlFetch);
 
}

Thanks,
Dan

[Daniel Bachmann]

Eric,

In the spreadsheet, the same call returns data in the cells below:   =importdata("http://localhost:8080/art/export/SDC_TEST_DATA.tsv")

Thank you,

Dan

On Thu, Dec 6, 2012 at 7:04 PM, Eric Pollmann <poll...@google.com> wrote:

</resourceRules>

[Matthew Firtion]

I think you also need to use the appId from the Project Properties since the project name is not unique across the domain.

--

Matt Firtion

[Dan B.]

Thanks, Matt.

The Script AppId worked, I had used the spreadsheet tag AnyAppId, but obviously not accepted.

I still get response_size = 0 if the URL is a reportserver like MS-SSRS or a Jasper Report Server and not a physical file, unlike when I call FetchURL to an internet-based SSRS, whose response is complete.

I'm wondering if Google will ever go forward with JDBC through the SDC.

I inquired about the above in a separate post, but still no response.

-Dan