none
Connection Failed: SQLState: '01S00' RRS feed

  • Question

  • We have a client that is dropping their database connection a few times a day. It works most of the time, but at intermittent times during the day the connection drops to different workstation. We believe this is a network related issue as our application is used by many other clients that are not having this issue.

    To try to resolve this issue we used Microsoft Message Analyzer.  Using this we found a message that may be related, but are not sure what the message is point to.  The message is:

    Parsing\tActor: OpnGenerated.TDS_actor_TDSOverTCP+TDSOverTCP
    Exception: Cannot cast optional Microsoft.Opn.Runtime.Values.ArrayValue`1[OpnGenerated.TDS+ColumnData] to Microsoft.Opn.Runtime.Values.ArrayValue`1[OpnGenerated.TDS+ColumnData] because the value is 'nothing'.
    Hash Code: 17b34b2ab195ef5f5ff8bb2bdbb0a4f7
    Call Stack:
       at Microsoft.Opn.Runtime.Values.OptionalValue`1.get_Value()
       at OpnGenerated.TDS.DecodeAllColumnData(COLMETADATA colMetaDataTemp, StreamValue payloadStream, String fieldName, String messageName)
       at OpnGenerated.TDS.TabularResultPacketDataDecoder(StreamValue payloadStream, UInt32 tdsVersion, MessageValue msg)
       at OpnGenerated.TDS_CG.TabularResult_BinaryCodecCompiler.__Decode(StreamValue sv, Object[] args)
       at OpnGenerated.TDS.TDSDecodingCache.DecodeTDS(StreamValue s)
       at OpnGenerated.TCP.TCPDecodingCache.TryDecodeAndDispatchMessage()
       at OpnGenerated.TDS.TDSDecodingHelper.TryDecodeTdsAndTls(Segment s, Int32 direction)
       at Microsoft.Opn.Runtime.Actors.MessageEvent.Execute(MessageEventHandler handler, MessageEventArgs args)

    Our Client application is a MS Access 2010 Runtime application.  Is this the Runtime that is being referenced in this message?  I have tried many Internet searches on this and nothing of any value is produced.  I am hoping I can get some guidance on this from this forum.

    Regards,

    Robert

    Thursday, January 14, 2016 10:41 PM

All replies

  • Hi All,

    in our environment we observe issues making requests to MS SQL. Having installed the MS Message Analyzer we caught the message:

    Parsing\tActor: OpnGenerated.TDS_actor_TDSOverTCP+TDSOverTCP
    Exception: Cannot cast optional Microsoft.Opn.Runtime.Values.ArrayValue`1[OpnGenerated.TDS+ColumnData] to Microsoft.Opn.Runtime.Values.ArrayValue`1[OpnGenerated.TDS+ColumnData] because the value is 'nothing'.
    Hash Code: bc2687a4d9c184323bc19e847a8984f1
    Call Stack:
       в Microsoft.Opn.Runtime.Values.OptionalValue`1.get_Value()
       в OpnGenerated.TDS.DecodeAllColumnData(COLMETADATA colMetaDataTemp, StreamValue payloadStream, String fieldName, String messageName)
       в OpnGenerated.TDS.TabularResultPacketDataDecoder(StreamValue payloadStream, UInt32 tdsVersion, MessageValue msg)
       в OpnGenerated.TDS_CG.TabularResult_BinaryCodecCompiler.__Decode(StreamValue sv, Object[] args)
       в OpnGenerated.TDS.TabularResult.__BinaryDecoder(StreamValue p0, Object[] p1)
       в OpnGenerated.TDS.TDSDecodingCache.DecodeTDS(StreamValue s)
       в OpnGenerated.DecodingUtility.StreamDecodingCache.TryDecodeAndDispatchMessage()
       в Microsoft.Opn.Runtime.Actors.MessageEvent.Execute(MessageEventHandler handler, MessageEventArgs args)


    What could be the reason of the message?

    Additional information:

    • ADO DB is used by application client
    • Application client fails trying to access any property of the ADO ResultSet with the problem of memory insuffiency



    Friday, November 15, 2019 3:21 PM