EA with DBMS: Exceptions, Catastrophic Errors, etc

[spamalam]

I'm having a lot of problems integrating EA with any form of DBMS, this presents the following errors:
"Provider [-2147418113] Catastrophic failure"
"Provider [-2147418113]"

I've tried using Microsoft SQL Server 2010 with and without a WAN optimizer and MySQL.  In both cases I have been unable to connect or create models reliably.

I am using EA in a windows vm and via crossover.


Versions tried:
9.3
10


Version 9.3

MySQL configuration:
MySQL ODBC 5.2w driver

DataSource Name: EA
Description: EA
TCP/IP Server: hostname
Port: 3306
User: ea
password: Password
Test > Successful
Database: ea

Allow big results is checked.  This ODBC seems to be functioning.

Within EA:
Connect to Server>Connection Wizard
Microsoft OLE DB Provider for ODBC Drivers
Use Connection String:
DSN=EA;DESCRIPTION=EA;SERVER={hostname};UID=ea;PWD=password;DATABASE=ea;PORT=3306;BIG_PACKETS=1
Initial catalog is set to ea

"Test Connection" -> succeeded

EA --- DBType=0;Connect=Provider=MSDASQL.1;Password=password;Persist Security Info=True;User ID=ea;Data Source=EA;Initial Catalog=ea;LazyLoad=1;

I get the same issues when trying to use MS SQL Server.


Version 10

Same process, with connection string:
EA MySQL --- DBType=0;Connect=Provider=MSDASQL.1;Persist Security Info=False;User ID=ea;Data Source=EA MySQL;LazyLoad=1;

Crashes out completely:

Unhandled exception: page fault on read access to 0x0000000c in 32-bit code (0x1f46c272).
Register dump:
 CS:0023 SS:002b DS:002b ES:002b FS:0063 GS:006b
 EIP:1f46c272 ESP:031fc574 EBP:031fc59c EFLAGS:00010246(  R- --  I  Z- -P- )
 EAX:00000000 EBX:031fc648 ECX:031fc580 EDX:00000000
 ESI:031fc610 EDI:00000000
Stack dump:
0x031fc574:  00000001 00000000 1e567400 1f462b3c
0x031fc584:  00000004 00000000 00000000 00000000
0x031fc594:  1e567400 00000000 031fc65c 1f4634f4
0x031fc5a4:  031fc610 031fc648 031fc6dc 031fc758
0x031fc5b4:  1e567400 1f44161c 1f4a3748 0000160a
0x031fc5c4:  1f4a3730 1f462994 10cdf3ff 00000000
Backtrace:
=>0 0x1f46c272 in msado15 (+0x2c272) (0x031fc59c)
  1 0x1f4634f4 in msado15 (+0x234f3) (0x031fc65c)
0x1f46c272: movl      0xc(%eax),%eax
Modules:
Module      Address                  Debug info      Name (160 modules)
PE        400000- 2df1000      Deferred        ea
PE       94f0000- 966d000      Deferred        ter81
PE       9670000- 96a1000      Deferred        pdc81
PE       96b0000- 96ec000      Deferred        wthes432
PE       96f0000- 973e000      Deferred        ssce5532
PE       9b80000- 9b94000      Deferred        ssgp
PE       9cb0000- 9cc5000      Deferred        rps81
PE       9de0000- 9e0a000      Deferred        drawex
PE       a690000- a7d9000      Deferred        codeminer
PE       b0f0000- b22e000      Deferred        eamodelpublisher
PE       b340000- b46e000      Deferred        bpel
PE       c560000- c5cb000      Deferred        templateres80
PE       d660000- d665000      Deferred        msadcer
PE       d6e0000- d737000      Deferred        hts81
PE       d930000- d9e7000      Deferred        easimlib
PE       e380000- e467000      Deferred        easl
PE      10000000-1005d000      Deferred        ealayout
PE      1c5b0000-1c639000      Deferred        scilexer
PE      1f390000-1f400000      Deferred        oledb32
PE      1f400000-1f411000      Deferred        oledb32r
PE      1f420000-1f435000      Deferred        msdatl3
PE      1f440000-1f4be000      Export          msado15
PE      1f5d0000-1f61d000      Deferred        msadce
PE      1f670000-1f694000      Deferred        msdart
PE      1f6b0000-1f6fa000      Deferred        msdasql
PE      1f700000-1f704000      Deferred        msdasqlr
PE      1f7a0000-1f7da000      Deferred        odbc32
PE      1f7f0000-1f80a000      Deferred        odbccp32
PE      1f840000-1f857000      Deferred        odbcint
PE      28ac0000-28f50000      Deferred        myodbc5w
PE      69a20000-69a2b000      Deferred        mtxdm
PE      69b10000-69c5e000      Deferred        msxml4
ELF      7b800000-7ba29000      Deferred        kernel32<elf>
  \-PE      7b810000-7ba29000      \               kernel32
ELF      7bc00000-7bcc4000      Deferred        ntdll<elf>
  \-PE      7bc10000-7bcc4000      \               ntdll
ELF      7bf00000-7bf03000      Deferred        <wine-loader>
ELF      7e61f000-7e625000      Deferred        libxfixes.so.3
ELF      7e625000-7e630000      Deferred        libxcursor.so.1
ELF      7e6ab000-7e6d5000      Deferred        libexpat.so.1
ELF      7e6d5000-7e709000      Deferred        libfontconfig.so.1
ELF      7e709000-7e719000      Deferred        libxi.so.6
ELF      7e719000-7e71d000      Deferred        libxcomposite.so.1
ELF      7e71d000-7e726000      Deferred        libxrandr.so.2
ELF      7e726000-7e730000      Deferred        libxrender.so.1
ELF      7e730000-7e736000      Deferred        libxxf86vm.so.1
ELF      7e736000-7e73a000      Deferred        libxinerama.so.1
ELF      7e73a000-7e75b000      Deferred        libxcb.so.1
ELF      7e75b000-7e88f000      Deferred        libx11.so.6
ELF      7e88f000-7e8a1000      Deferred        libxext.so.6
ELF      7e8a1000-7e8bb000      Deferred        libice.so.6
ELF      7e8bb000-7e8c4000      Deferred        libsm.so.6
ELF      7e8c4000-7e959000      Deferred        winex11<elf>
  \-PE      7e8d0000-7e959000      \               winex11
ELF      7e959000-7e96f000      Deferred        libz.so.1
ELF      7e96f000-7ea09000      Deferred        libfreetype.so.6
ELF      7ea29000-7ea8a000      Deferred        advapi32<elf>
  \-PE      7ea40000-7ea8a000      \               advapi32
ELF      7ea8a000-7eb49000      Deferred        gdi32<elf>
  \-PE      7eaa0000-

[MrTrigger]

I have the same problem trying to access MySQL on a Windows7 machine.

Using:
Windows7 x64
Tested with both EA 9.3.935 and EA 10.0.1005
Tested with both MySQL ODBC 5.2w 32-bit driver and 5.1 32-bit
MySQL server is located on the same machine

Testing the data source connection in "ODBC data source administrator" (32-bit version) is successful.

In EA I select "Connect to Server" and use the conenction above. When testing the connection in EA I get a popup saying "Test connection failed because of an error in initializing provider. Catastrophic failure".
 
If I then try to use that connection anyway I get a popup saying ""Provider [-2147418113] Catastrophic failure"

Using connection string (build from within EA using the above data source) gives the same error:
DSN=MySQL_EA_32;SERVER=localhost;UID=root;PWD=pass;DATABASE=ea;PORT=3306;FOUND_ROWS=1;BIG_PACKETS=1;MULTI_STATEMENTS=1


This was all working on a windows XP machine a few weeks ago, but since I migrated to Win7 i get this problem.

Any ideas on how to tackle this problem??? URGENT!

[Stefan Bolleininger]

Hi,

two ideas:

Did you entered your ODBC-Data with Start->System Control -> ..... Data Sources?

If YES: You may did it wrong.

Remove your settings if they are within this Area and try it with the win32 implementation: C:\WINDOWS\SYSWOW64/odbcat32.exe

Second idea:

Remove the initial catalog from your EA-sql settings and leave it blank.

Regards

Stefan

[MrTrigger]

I used the 32-bit version in:
C:\WINDOWS\SYSWOW64/odbcat32.exe

Remove the initial catalog from your EA-sql settings and leave it blank.

If I leave the catalog field blank and test the connection it succeeds from within EA as well. But as soon as I select a catalog it fails as above. But I need to set this though, right?

[Stefan Bolleininger]

Ok, and without the inital catalog it is working?

[MrTrigger]

yes, but how do I connect to the correct database schema (catalog).

[MrTrigger]

Ok, so I selected "Connect to Server" and left the initial catalog blank, the connection then succeeds. I noticed that it then uses the default catalog from the connection set up in "ODBC data source administrator".

With that I can now modify my model and see that the changes end up in the database. But if I try to connect again it will fail as soon as i select a initial catalog from EA.

The error is still there but atleast I now have a workaround, thanks!!!  

[spamalam]

In crossover this results in a crash:

Code: [Select]

Unhandled exception: page fault on read access to 0x0000000c in 32-bit code (0x1f46c272).
Register dump:
 CS:0023 SS:002b DS:002b ES:002b FS:0063 GS:006b
 EIP:1f46c272 ESP:031fc350 EBP:031fc378 EFLAGS:00010246(  R- --  I  Z- -P- )
 EAX:00000000 EBX:031fc424 ECX:031fc35c EDX:00000000
 ESI:031fc3ec EDI:00000000
Stack dump:
0x031fc350:  00000001 00000000 1c82a6a0 1f462b3c
0x031fc360:  00000004 00000000 00000000 00000000
0x031fc370:  1c82a6a0 00000000 031fc438 1f4634f4
0x031fc380:  031fc3ec 031fc424 031fc4b8 031fc534
0x031fc390:  1c82a6a0 1f44161c 1f4a3748 0000160a
0x031fc3a0:  1f4a3730 1f462994 10c52fff 00000000
Backtrace:
=>0 0x1f46c272 in msado15 (+0x2c272) (0x031fc378)
  1 0x1f4634f4 in msado15 (+0x234f3) (0x031fc438)
0x1f46c272: movl      0xc(%eax),%eax
Modules:
Module      Address                  Debug info      Name (160 modules)
PE        400000- 2df1000      Deferred        ea
PE       94f0000- 966d000      Deferred        ter81
PE       9670000- 96a1000      Deferred        pdc81
PE       96b0000- 96ec000      Deferred        wthes432
PE       96f0000- 973e000      Deferred        ssce5532
PE       9b80000- 9b94000      Deferred        ssgp
PE       9cb0000- 9cc5000      Deferred        rps81
PE       9de0000- 9e0a000      Deferred        drawex
PE       a690000- a7d9000      Deferred        codeminer
PE       b0f0000- b22e000      Deferred        eamodelpublisher
PE       b340000- b46e000      Deferred        bpel
PE       c560000- c5cb000      Deferred        templateres80
PE       da30000- da87000      Deferred        hts81
PE       e530000- e5e7000      Deferred        easimlib
PE       e750000- e837000      Deferred        easl
PE      10000000-1005d000      Deferred        ealayout
PE      1a8a0000-1a929000      Deferred        scilexer
PE      1ddc0000-1ddd5000      Deferred        msdatl3
PE      1dde0000-1e270000      Deferred        myodbc5w
PE      1f320000-1f36d000      Deferred        msadce
PE      1f370000-1f375000      Deferred        msadcer
PE      1f440000-1f4be000      Export          msado15
PE      1f670000-1f694000      Deferred        msdart
PE      1f6b0000-1f6fa000      Deferred        msdasql
PE      1f700000-1f704000      Deferred        msdasqlr
PE      1f7a0000-1f7da000      Deferred        odbc32
PE      1f7f0000-1f80a000      Deferred        odbccp32
PE      1f840000-1f857000      Deferred        odbcint
PE      1f890000-1f900000      Deferred        oledb32
PE      1f900000-1f911000      Deferred        oledb32r
PE      69a20000-69a2b000      Deferred        mtxdm
PE      69b10000-69c5e000      Deferred        msxml4
ELF      7b800000-7ba29000      Deferred        kernel32<elf>
  \-PE      7b810000-7ba29000      \               kernel32
ELF      7bc00000-7bcc4000      Deferred        ntdll<elf>
  \-PE      7bc10000-7bcc4000      \               ntdll
ELF      7bf00000-7bf03000      Deferred        <wine-loader>
ELF      7e621000-7e627000      Deferred        libxfixes.so.3
ELF      7e627000-7e632000      Deferred        libxcursor.so.1
ELF      7e6ad000-7e6d7000      Deferred        libexpat.so.1
ELF      7e6d7000-7e70b000      Deferred        libfontconfig.so.1
ELF      7e70b000-7e71b000      Deferred        libxi.so.6
ELF      7e71b000-7e71f000      Deferred        libxcomposite.so.1
ELF      7e71f000-7e728000      Deferred        libxrandr.so.2
ELF      7e728000-7e732000      Deferred        libxrender.so.1
ELF      7e732000-7e738000      Deferred        libxxf86vm.so.1
ELF      7e738000-7e73c000      Deferred        libxinerama.so.1
ELF      7e73c000-7e743000      Deferred        libxdmcp.so.6
ELF      7e743000-7e764000      Deferred        libxcb.so.1
ELF      7e764000-7e898000      Deferred        libx11.so.6
ELF      7e898000-7e8aa000      Deferred        libxext.so.6
ELF      7e8aa000-7e8c4000      Deferred        libice.so.6
ELF      7e8c4000-7e959000      Deferred        winex11<elf>
  \-PE      7e8d0000-7e959000      \               winex11
ELF      7e959000-7e96f000      Deferred        libz.so.1
ELF      7e96f000-7ea09000      Deferred        libfreetype.so.6
ELF      7ea29000-7ea8a000      Deferred        advapi32<elf>
  \-PE      7ea40000-7ea8a000      \               advapi32
ELF      7ea8a000-7eb49000      Deferred        gdi32<elf>
  \-PE      7eaa0000-7eb49000      \               gdi32
ELF      7eb49000-7ec8a000      Deferred        user32<elf>
  \-PE      7eb60000-7ec8a000      \               user32
ELF      7ec8a000-7ed81000      Deferred        comctl32<elf>
  \-PE      7ec90000-7ed81000      \               comctl32
ELF      7ed81000-7ed8e000      Deferred        libnss_files.so.2
ELF      7ed8e000-7ed9a000      Deferred        libnss_nis.so.2
ELF      7ed9a000-7edb4000      Deferred        libnsl.so.1
ELF      7efb4000-7efe0000      Deferred        libm.so.6
ELF      7efe2000-7efe8000      Deferred        libuuid.so.1
ELF      7efe8000-7f000000      Deferred        version<elf>
  \-PE      7eff0000-7f000000      \               version
ELF      f5b41000-f5b6b000      Deferred        netapi32<elf>
  \-PE      f5b50000-f5b6b000      \               netapi32
ELF      f5b6b000-f5b96000      Deferred        secur32<elf>
  \-PE      f5b70000-f5b96000      \               secur32
ELF      f625f000-f627d000      Deferred        libgcc_s.so.1
ELF      f627d000-f6300000      Deferred        urlmon<elf>
  \-PE      f6290000-f6300000      \               urlmon
ELF      f6409000-f6410000      Deferred        libnss_dns.so.2
ELF      f6433000-f646b000      Deferred        usp10<elf>
  \-PE      f6440000-f646b000      \               usp10
ELF      f646b000-f6490000      Deferred        mpr<elf>
  \-PE      f6470000-f6490000      \               mpr
ELF      f6490000-f6500000      Deferred        wininet<elf>
  \-PE      f64a0000-f6500000      \               wininet


[Stefan Bolleininger]

you have to set the initial dialog within the ODBC-Connector. So for each different initial dialog, - you need to set an own datasource.

Maybe you can see it as some kind of universal connector from windows to the database, while EA just connects to the ODBC

regards

Stefan

[Stefan Bolleininger]

To be honest: It is no workaround

The odbc got its direct adress to the initial dialog and establishes a connection to the initial dialog.

if EA tried to find an dialog called "ea-database" within the allready opened initial dialog it will fail by "WOW i'm worried, i cannot resolve the catalog... *shock*" and turn out as castastrophic failure  

It is like using a navigation system and entering some complete adress with street and house-ID and then trieing to find the house-ID within the house-id(which would now be the floor-id )

i hope this clarifies it a bit more abstracted  

regards

stefan  

[spamalam]

Strangeness abound:

Within a windows 7vm, created ODBC datasources:
EA MySQL
EA MSSQL

For the former, I put the database, the latter i use the SQL Server connector, a domain account and the wan optimizer.  Both work, although i am unable to apply the patches provided on the sparx DBMS page, i assume they are redundent as the schemas are different.


For MySQL I create an ODBC at the OS level, then connect to these without specifying much:
EA MySQL --- DBType=0;Connect=Provider=MSDASQL.1;Password=testing;Persist Security Info=True;User ID=ea;Data Source=EA MySQL;LazyLoad=1;

EAdb --- DBType=1;Connect=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=EAdb;Data Source=A_DB_SERVER;WanOpt=A_DB_SERVER:4242;LazyLoad=1;


Doing exactly the same in the latest crossover causes EA to crash out with the above error, not sure what I'm missing but working under crossover/wine would be a major selling point for this product.

Does anyone have:
Crossover
EA 10
and a DBMS working?

[Stefan Bolleininger]

Could you give me a link to these DBMS patches?

is your user "ea" allowed to access the ea-repository?

Is the windows7-vm correctly working?

I would try to shorten up the connection string and remove all information unnecessary to connect to the db.

It would be:

EA MySQL --- DBType=0;Connect=Provider=MSDASQL.1;Persist Security Info=false;Data Source=EA MySQL; Initial Catalog = XXXXXX

In all of my cases, it didn't end up with ";" semicolon.

You may need to remove the initial catalog from your ODBC connector and add the initial catalog into your connection string.

regards

Stefan

[Thomas Kunst]

I had a similar problem with a "catastrophic" failure, when trying to connect to a MySQL database. By accident I found that the problem was in the name of the ODBC datasource that I declared. That name initially contained blanks. As soon as I removed the blanks, the problem disappeared.

[Rhys Lewis]

I had this problem with both Windows 7 and on OSX with Crossover.  In the end I found that the problem with connecting went away when I downloaded the 3.51 ODBC driver from Oracle, and installed that into the Crossover bottle.  In windows the solution was to install the full developer edition of MySQL, which also included a different ODBC driver version.

Go here to choose versions of driver to download: http://www.mysql.com/downloads/connector/odbc/5.1.html#downloads