Encore Pro -- Card error

mindy · Post by **mindy** » Mon Sep 10, 2007 3:09 pm

ib and goose,

Sorry to hear your troubles continue! Goose - did you look at the Microsoft fix? Or does that not describe the problem?

I've been downloading daily and no problems so far (knock on wood!). I'll keep my ears open.

Mindy

Wulfman... · Post by **Wulfman...** » Mon Sep 10, 2007 3:10 pm

There are some "error logs" in one of those subdirectories in the "Program Files" directory. Maybe the one I mentioned earlier in this thread.

You might check them to see if it gives you a clue as to what the error message is pointing to.

Den

Wulfman... · Post by **Wulfman...** » Mon Sep 10, 2007 3:13 pm

If you do your "View" (in the folder) by "Details", it'll give you the list by date of creation.

Den

goose · Post by **goose** » Mon Sep 10, 2007 3:15 pm

Hey Den -- I'll have to look at that -- thanks for the suggestion.

Mindy -- yup -- describes the problem exactly. Points to MDAC 2.5 sp3 but XP is already at MDAC 2.8 which should incorporate all those fixes. Says 2.5 sp3 fixes that problem that caused the errors, so there's something else going on....

I'm going to search for those logs that Den suggests and see if they give me any clues......

Thanks again folks -- appreciate the suggestions and info!!!!

cheers
goose

goose · Post by **goose** » Mon Sep 10, 2007 3:22 pm

latest log file leads me here:
(Still reading info)

http://support.microsoft.com/default.as ... -us;896373

cheers
goose

mindy · Post by **mindy** » Mon Sep 10, 2007 3:55 pm

Goose,

Good find! Please keep us posted .....

Mindy

goose · Post by **goose** » Mon Sep 10, 2007 4:40 pm

Ok -- Here's what I find so far (my comments are after the pastes):

SYMPTOMS
When you use a Microsoft .NET Framework SqlClient class, you receive the following error message in the Microsoft SQL Server 2000 error log:
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
You receive the following corresponding error messages in the Microsoft .NET Framework client application:
System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded

CAUSE
This behavior occurs if one of the following scenarios is true:
• You use a SqlClient class in a Finalize method or in a C# destructor.
• You do not specify an explicit SQLDbType enumeration when you create a SqlParameter object. When you do not specify an explicit SQLDbType enumeration, the Microsoft .NET Framework Data Provider for SQL Server (SqlClient) tries to select the correct SQLDbType enumeration based on the data that is passed. SqlClient is unsuccessful.
• You declare an instance of the SqlClient class to be static in C# or to be shared in Visual Basic. The instance can be accessed concurrently from more than one thread in the application.

Note In the ASP.NET environment or in some other environments, concurrent access is possible even if no additional threads are created explicitly in the application code.
• The size of the parameter that you explicitly specify in the .NET Framework code is more than the maximum size that you can use for the data type in SQL Server.

For example, according to SQL Server Books Online, nvarchar is a variable-length Unicode character data of n characters. "n" must be a value from 1 through 4000. If you specify a size that is more than 4000 for an nvarchar parameter, you receive the error message that is described in the "Symptoms" section.
<snip -- example code>

RESOLUTION
To resolve these errors, make sure that you do the following:
• Do not use a SqlClient class in a Finalize method or in a C# destructor.
• Specify the SqlDbType enumeration for the SqlParameter object so that there is no inferred type.
• Specify a parameter size that is within the limits of the data type.

I do see the error message in the ERRORLOG file in SPID51 as follows:
2007-09-08 18:07:06.71 spid51 Starting up database 'EncorePro'.
2007-09-08 18:07:08.76 spid51 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
2007-09-08 18:07:08.89 spid51 Starting up database 'EncorePro'.
2007-09-08 18:07:09.40 spid51 Starting up database 'EncorePro'.
2007-09-08 18:07:09.56 spid51 Starting up database 'EncorePro'.
2007-09-08 18:08:11.71 spid51 Error: 17805, Severity: 20, State: 3
2007-09-08 18:08:11.71 spid51 Invalid buffer received from client..
2007-09-08 21:25:38.48 spid51 Starting up database 'EncorePro'.

I do not see the verbiage from the application (second bold section in first section). I love the way it says "....Error in the current command", without defining what that command is (Mindy - reminds me of SYSDUMPS on VM and MVS....they'll tell you the system died and where, but the command that actually caused the abend is usually long gone.....)

If I read the "Resolution" correctly -- there's really nothing I can do without the ID and Password to modify the code. (Code written wrong/badly)

I'm guessing that the problem is the first one:
You use a SqlClient class in a Finalize method or in a C# destructor.
The reason I say that is because it appears to happen after the data has been collected and while it is being written (from the buffer) to the DB which would equate (in my non-SQL mind) to a Finalize method (or sequence)......

If there are any clues in there I don't see 'em, but again, I'm not an SQL kinda guy.....I know enough to be dangerous

There's also something in the pages about a parameter being set to over a value of 4000 which is defined to have a range of 1 to 4000, but I don't see that in any part of any error messages so I've kind of discounted it (still points to sloppy code as it should be variable length if there is any possibility of it being set over the limit).....

Now for the conspiracy bunch -- Could this be a way that Respironics has coded the software to disable it at some point -- even for Doc's and DME's but knowing doc's and DME's can get support???? Makes one wonder!!!! <Twilight Zone music with Rod Serling inserted here>

That's it for now....
cheers
goose

mindy · Post by **mindy** » Mon Sep 10, 2007 4:49 pm

goose wrote:Ok -- Here's what I find so far (my comments are after the pastes):
.......

Now for the conspiracy bunch -- Could this be a way that Respironics has coded the software to disable it at some point -- even for Doc's and DME's but knowing doc's and DME's can get support???? Makes one wonder!!!! <Twilight Zone music with Rod Serling inserted here>

That's it for now....
cheers
goose

Hmmm, well Goose, here's the dilemma: I've heard comments that the Respironics programmers are not too awfully bright .... so if this is a conspiracy, that would imply at least a modicum of intelligence on their part

I vote for a bug!

And oh my ... SYSDUMPS ... had them on VSE, too and we also had VM. It's a miracle I have working eyes after thousands of pages of uninteruppted hexadecimal! Between them and Rod Serling, I think we're showing our age, Goose!

Good sleuthing!
Mindy

goose · Post by **goose** » Mon Sep 10, 2007 5:02 pm

yeah -- I just had to throw the conspiracy thing in for a chuckle.....

When we were running the 2 MVT machines on VM (underpowered Amdahl V6) it used to crash 3-4 times a day -- take a dump and IPL (can you imagine that level of performance being tolerated today???). My office was FULL of sysdumps......
Hee hee, Ha Ha, to the funny farm, where life is wonderful all the time.........

Age?? What's that???

Now I have to figure out how to get my data -- I think you're right -- just PPCode.....

cheers
goose

mindy · Post by **mindy** » Mon Sep 10, 2007 6:14 pm

goose wrote:Hee hee, Ha Ha, to the funny farm, where life is wonderful all the time.........

Now I have to figure out how to get my data -- I think you're right -- just PPCode.....

I know I've heard that one before ... but my memory fails me

It took a few minutes to figure out "PPCode" but I hate to admit that it's obvious

And since I'm on the East coast, it's my snooze/cpap time!

Mindy

goose · Post by **goose** » Mon Sep 10, 2007 7:28 pm

Sleep well -- Here's the whole chorus:

They're coming to take me away, HA HA
They're coming to take me away, HO HO HEE HEE HA HA
To the funny farm
Where life is beautiful all the time
And I'll be happy to see
Those nice, young men
In their clean, white coats
And they're coming to take me away, Ha-haaa!

cheers
goose

mindy · Post by **mindy** » Tue Sep 11, 2007 4:29 am

goose wrote:Sleep well -- Here's the whole chorus:

They're coming to take me away, HA HA
They're coming to take me away, HO HO HEE HEE HA HA
To the funny farm
Where life is beautiful all the time
And I'll be happy to see
Those nice, young men
In their clean, white coats
And they're coming to take me away, Ha-haaa!

Ah yes, thanks goose - I especially remember the sound effects. Wasn't that on the radio many, many moons ago?

Mindy

ibthebest · Post by **ibthebest** » Tue Sep 11, 2007 7:01 am

Tried to download my data from the card this afternoon. No issues since I made the card reader auto start in the services -- this afternoon I got the following two errors:

Error Source: Microsoft OLE DB Provider for SQL Server
Error Number: 8000FFFF

Error Source: Dalphin
Error Number: 800402CD

I still have this problem, except I have never been able to download any data. Any more fix suggestions?

Mikey

mindy · Post by **mindy** » Tue Sep 11, 2007 7:05 am

ibthebest wrote: I still have this problem, except I have never been able to download any data. Any more fix suggestions?

Mikey

Sorry Mikey - I'm fresh out of ideas. Hopefully someone else on the forum may have a fresh perspective.

Mindy

ibthebest · Post by **ibthebest** » Tue Sep 11, 2007 4:27 pm