EAssertionFailed error V6.1 D2009 Pro

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
PaulC
Posts: 8
Joined: Fri 04 Jan 2013 16:53

EAssertionFailed error V6.1 D2009 Pro

Post by PaulC » Fri 04 Jan 2013 17:13

After upgrading to 6.1 for D2009 Pro I'm getting the following error when running my application:
Project XXXXXXX raise exception class EAssertionFailed with message 'Subtype fldstFIXED used to detect GUID NULL Value in SetParameter method (D:\Projects\Delphi\Dbx\SqlServer\Source\dbxsda.pas, line 1183)'.
This did not happen with the prior version of the drivers (5.0.3). Also, the stated path "D:\Projects\Delphi\Dbx\..." is not part of our system setup so must be something related to devart's setup.

Also, after installing 6.1 I received an error starting Delphi:
Cannot load package 'DBXDevartSQLServerDriver120.' It contains unit 'DBXDevartSQLServer,'which is also contained in the package 'dcldbxsda120'.
I selected to delete the package and Delphi started but my applications still failed with the first error.

Is there some installation problem I need to fix or is this a bug in 6.1 under D2009Pro (CodeGear™ RAD Studio 2009 Version 12.0.3420.21218)?

PaulC
Posts: 8
Joined: Fri 04 Jan 2013 16:53

Re: EAssertionFailed error V6.1 D2009 Pro

Post by PaulC » Fri 04 Jan 2013 17:47

I reverted back to 5.0.3 and problem went away, my application is working again.

We will be transitioning to XE3 but would like to have 6.1 working in D2009 if possible.

maubuso
Posts: 30
Joined: Wed 02 Jan 2013 23:53

Re: EAssertionFailed error V6.1 D2009 Pro

Post by maubuso » Mon 07 Jan 2013 11:37

We have here same problem with XE3 .

jerduval
Posts: 23
Joined: Mon 13 Sep 2010 08:33
Location: Colombes, France

Re: EAssertionFailed error V6.1 D2009 Pro

Post by jerduval » Tue 08 Jan 2013 09:07

We have the same problem with the 6.1.2 version and Delphi XE2:
Classe d'exception EAssertionFailed avec le message 'Subtype fldstFIXED used to detect GUID NULL Value in SetParameter method (D:\Projects\Delphi\Dbx\SqlServer\Source\dbxsda.pas, line 1183)
when execute query with sql :

Code: Select all

SELECT * FROM HSYS_Domaines;
For information, here is the sql table creation :

Code: Select all

Create TABLE HSYS_Domaines (
DomRowId NUMERIC(18,0) NOT Null,
DomNom NVARCHAR(50) NOT Null);

Code: Select all

ALTER TABLE HSYS_Domaines ADD CONSTRAINT PK_ HSYS_Domaines PRIMARY KEY NONCLUSTERED (DomRowId);
regards,

Jerome DUVAL
Holy-Dis

AndreyZ

Re: EAssertionFailed error V6.1 D2009 Pro

Post by AndreyZ » Tue 08 Jan 2013 10:03

Thank you for the information. We will fix this problem in the next dbExpress driver for SQL Server build.

maubuso
Posts: 30
Joined: Wed 02 Jan 2013 23:53

Re: EAssertionFailed error V6.1 D2009 Pro

Post by maubuso » Tue 08 Jan 2013 19:11

AndreyZ wrote:Thank you for the information. We will fix this problem in the next dbExpress driver for SQL Server build.
You already have release date? It is impossible to use the new version.

PeterWK
Posts: 15
Joined: Tue 08 Jan 2013 19:21

Re: EAssertionFailed error V6.1 D2009 Pro

Post by PeterWK » Wed 09 Jan 2013 09:49

I'm having the same problem with de version 6.1.2, DELHI XE3.
So, about the release date that maubuso asked... do you have any?...

AndreyZ

Re: EAssertionFailed error V6.1 D2009 Pro

Post by AndreyZ » Fri 11 Jan 2013 16:22

We have uploaded the new build of dbExpress driver for SQL Server with the fix to the site. You can download it from Registered Users' Area.

PaulC
Posts: 8
Joined: Fri 04 Jan 2013 16:53

Re: EAssertionFailed error V6.1 D2009 Pro

Post by PaulC » Mon 21 Jan 2013 17:52

Tested new version download from the customer download site. It no longer reports the error:
Subtype fldstFIXED used to detect GUID NULL Value in SetParameter method
But I still have the issue around:
Cannot load package 'DbxDevartSQLServeDrive120.' It contains unit 'DBXDevartSQLSever,' which is also contained in package 'cdldbxsda120'. Do you want to attempt to load this package the next time a project is loaded?
This seems to be the same problem as this person was having:

http://forums.devart.com/viewtopic.php?f=10&t=19335

I see the "dcldbxsda120.bpl" file in the "..\RAD Studio\6.0\bin" folder, it's dated 2012-03-20 4:51 PM. Which suggests it's an old version (not 6.1.x). I've renamed it so delphi won't find it and the project still runs, but I'm worried that it's not 100% correct to not have that file available to Delphi.

When I look at the list of installed packaged (In Delphi: Component\Installed Packages..." I see "dcldbxsda120.bpl" AND "DbxDevartSQLServerDriver120.bpl".

When I renamed "dcldbxsda120.bpl" it no longer shows up under "Installed Packages..." but when I try to enable "DbxDevartSQLServerDriver120.bpl" it won't stay enabled after restarting Delphi (suggesting maybe it shouldn't be in the "Installed Packages..." list in the first place).

I can't find "dcldbxsda120.bpl" anywhere in the "dbxsda61src.zip" or "dbxsda61.exe" installation.

So I'm wondering if it was accidently lost from the installer "dbxsda61.exe" and "DbxDevartSQLServerDriver120.bpl" is being installed in its place by mistake (IE "DbxDevartSQLServerDriver120.bpl" shouldn't be installed under "Component\Installed Packages..." and "dcldbxsda120.bpl" is missing from the installer but should be installed under "Installed Packaged...".

Finally, it is not possible to tell if "dbxsda61.exe" is actually the "new fixed version" of the installer because the website download area has no notes saying it is; nor does the readme and version history have any information about the fixes in this "fixed" version of dbxsda61.exe installer. So it doesn't really give much confidence that things are being prepared and presented in a clear manor making it easy to know you're getting the right update with the important fix. I appreciate the effort to rush out this new version, but not updating things like the read me, history files and version makes it hard to even know if you're getting the correct files.

AndreyZ

Re: EAssertionFailed error V6.1 D2009 Pro

Post by AndreyZ » Tue 22 Jan 2013 12:42

The dbExpress driver for SQL Server version 6.1.2 does not have dcldbxsda120.bpl , it is left from the old version of dbExpress driver for SQL Server. To solve this problem, you should perform the following steps:
- uninstall dbExpress driver for SQL Server;
- remove all dcldbxsda120.bpl files from your computer;
- remove all references to the dcldbxsda120 file from all files of your project (you can use any file manager for this);
- install dbExpress driver for SQL Server 6.1.2.

PaulC
Posts: 8
Joined: Fri 04 Jan 2013 16:53

Re: EAssertionFailed error V6.1 D2009 Pro

Post by PaulC » Tue 22 Jan 2013 15:35

Thank you for the clarification and instructions.

AndreyZ

Re: EAssertionFailed error V6.1 D2009 Pro

Post by AndreyZ » Wed 23 Jan 2013 09:28

Was the problem solved? If not, please contact us.

PaulC
Posts: 8
Joined: Fri 04 Jan 2013 16:53

Re: EAssertionFailed error V6.1 D2009 Pro

Post by PaulC » Wed 23 Jan 2013 14:25

Yes, problem solved, thanks.

AndreyZ

Re: EAssertionFailed error V6.1 D2009 Pro

Post by AndreyZ » Wed 23 Jan 2013 15:56

Glad I could help.

Post Reply