Sybase ADO .NET - Sybase ADO.NET Provider, Version 1.1.376.0, Internal error: 30031

Author

Sybase ADO.NET Provider, Version 1.1.376.0, Internal error: 30031

Patrik Pí¹

2005-05-10, 7:24 am

Hi

I get a misterious error with this provider. Here is the story.

I upgrade database servers from ASE 12.5.0.3 to 12.5.2 yesterday.
Servers are running on WindowsXP, Linux and SUN.

WindowsXP
Adaptive Server Enterprise/12.5.2/EBF 12060 ESD#2/P/NT (IX86)/OS
4.0/ase1252/1844/32-bit/OPT/Thu Aug 12 00:13:38 2004

Linux:
Adaptive Server Enterprise/12.5.2/EBF 11799/P/Linux Intel/Enterprise
Linux/ase1252/1831/32-bit/OPT/Fri Apr 9 02:53:50 2004

Sun:
Adaptive Server Enterprise/12.5.2/EBF 11791/P/Sun_svr4/OS
5.8/ase1252/1831/64-bit/FBO/Fri Apr 9 12:47:36 2004

When the upgrade process was done, a try to test my
application, which is under development. An application was
tested with ASE on WindowsXP. I try to run my application
15 times about and i get 15 times error, as is described next,
exactly.

AD.Data.DataException: Internal Error: 30031
Failed to ExecuteNonQuery()
[PTCA.BLL.Dokument.V. UdajePravnehoBlokuV]
with sql INSERT INTO
UdajePravnehoBlokuV ( Data, Id, PravnyBlokVId, NahradenaSkoda,
ProspUcelySuma, ProspUcelyAdresat, SumaStatu, ZastavenieTSPodlaId )
VALUES ( @Data ,@Id ,@PravnyBlokVId ,@NahradenaSkoda,@Pr
ospUcelySuma,
@ProspUcelyAdresat ,@SumaStatu ,@ZastavenieTSPodlaI
d ) --->
Sybase.Data.AseClient.AseException: Internal Error: 30031

at Sybase.Data.AseClient.AseCommand.CheckResult(Int32 res)
at Sybase.Data.AseClient.AseCommand.PutBytes(Int32 ordinal, Byte[] bytes)
at Sybase.Data.AseClient.AseCommand.PutData(Int32 ordinal)
at Sybase.Data.AseClient.AseCommand.SendBlobs()
at Sybase.Data.AseClient.AseCommand.Execute()
at Sybase.Data.AseClient.AseCommand.ExecuteNonQuery()

I try to find any information about this error on the Internet,
Sybase web site including, but no information found. So I go
to home. Tommorow I start testing again, so I prepare more
detailed description of this error with complete list of Sybase
exception for a Sybase support. I try to run my application 30
times under same conditions as yesterday, but no error occurs.
I try using database on other OS withthe same result. No error
occurs.

What does this error mean?

Patrik Pis

Ashish Mahajan

2005-05-10, 1:24 pm

You have hit an issue where the application is trying to send a zero length
blob to ASE
You have two options
1) Upgrade to ASE 12.5.3 which can handle zero length blobs
OR
2) Before executing the statement see if you have a null blob... If so
change the parameter to binary...

Upgrade to ESD7 / ESD8 as well....(1.1.411.0 or 1.1.464???)

HTH,

Ashish

"Patrik Pí¹" <pis@isternet.sk> wrote in message
news:4280a0c1$1@foru
ms-1-dub...
> Hi
>
> I get a misterious error with this provider. Here is the story.
>
> I upgrade database servers from ASE 12.5.0.3 to 12.5.2 yesterday.
> Servers are running on WindowsXP, Linux and SUN.
>
> WindowsXP
> Adaptive Server Enterprise/12.5.2/EBF 12060 ESD#2/P/NT (IX86)/OS
> 4.0/ase1252/1844/32-bit/OPT/Thu Aug 12 00:13:38 2004
>
> Linux:
> Adaptive Server Enterprise/12.5.2/EBF 11799/P/Linux Intel/Enterprise
> Linux/ase1252/1831/32-bit/OPT/Fri Apr 9 02:53:50 2004
>
> Sun:
> Adaptive Server Enterprise/12.5.2/EBF 11791/P/Sun_svr4/OS
> 5.8/ase1252/1831/64-bit/FBO/Fri Apr 9 12:47:36 2004
>
> When the upgrade process was done, a try to test my
> application, which is under development. An application was
> tested with ASE on WindowsXP. I try to run my application
> 15 times about and i get 15 times error, as is described next,
> exactly.
>
> AD.Data.DataException: Internal Error: 30031
> Failed to ExecuteNonQuery()
> [PTCA.BLL.Dokument.V. UdajePravnehoBlokuV]
with sql INSERT INTO
> UdajePravnehoBlokuV ( Data, Id, PravnyBlokVId, NahradenaSkoda,
> ProspUcelySuma, ProspUcelyAdresat, SumaStatu, ZastavenieTSPodlaId )
> VALUES ( @Data ,@Id ,@PravnyBlokVId ,@NahradenaSkoda,@Pr
ospUcelySuma,
> @ProspUcelyAdresat ,@SumaStatu ,@ZastavenieTSPodlaI
d ) --->
> Sybase.Data.AseClient.AseException: Internal Error: 30031
>
> at Sybase.Data.AseClient.AseCommand.CheckResult(Int32 res)
> at Sybase.Data.AseClient.AseCommand.PutBytes(Int32 ordinal, Byte[] bytes)
> at Sybase.Data.AseClient.AseCommand.PutData(Int32 ordinal)
> at Sybase.Data.AseClient.AseCommand.SendBlobs()
> at Sybase.Data.AseClient.AseCommand.Execute()
> at Sybase.Data.AseClient.AseCommand.ExecuteNonQuery()
>
> I try to find any information about this error on the Internet,
> Sybase web site including, but no information found. So I go
> to home. Tommorow I start testing again, so I prepare more
> detailed description of this error with complete list of Sybase
> exception for a Sybase support. I try to run my application 30
> times under same conditions as yesterday, but no error occurs.
> I try using database on other OS withthe same result. No error
> occurs.
>
> What does this error mean?
>
> Patrik Pis
>
>

Sponsored Links