Error creating new project in PostgresQL

[Darren Barrett]

I have a new Postgres 8.4 database created on a Solaris operating system and have recently installed the 8.4.2 ODBC Driver on my PC. I have created the EA repository schema as per http://www.sparxsystems.com.au/resources/corporate/index.html#sql_scripts

I am running version 7.5.847 of Enterprise Architect.

I am wanting to create a new project in my Postgres repository, so I create a new project on my file system and attempt to transfer the empty project to Postgres. Part way through the project transfer exercise I get the following error

"An error has occurred: Microsoft Cursor Engine [-2147467259]

Data provider or other service returned an E_FAIL status.
[Select * from t_umlpattern]
Field: version

Press OK to continue to next row (this record will be lost). Cancel to abort"

[hd]

If you're not using the UML Patterns, open the empty eap project, delete the UML Patterns from the Resources view, and transfer again.

[KP]

The t_umlpattern table has been named as the culprit, so I suspect the problem is that one of the patterns in your database(*) has a preview image that is too big to save in the Postgres database. I have heard of this being a problem with OpenEdge repositories which have quite a small maximum field size.

Presumably you hit OK and everything else transferred without problem?


(*)My money's on the Gang of Four abstract factory pattern.

[Darren Barrett]

Thanks guys..... I will delete the uml patterns as you suggest and give it a try.

[Darren Barrett]

Unfortunately I am now getting a terminal error when I attempt the project transfer:

"Runtime Error!

Program: C:\Program Files\Sparx Systems\EA\EA.exe

abnormal program termination"

[hd]

I noticed you're using PostgreSQL 8.4.

Thers's a note in the EA User Guide...
http://www.sparxsystems.com/uml_tool_guide/uml_model_management/setupapostgresqlodbcdriver.html
Note: Do not use version 8.4.1 of the PostgreSQL ODBC Driver - it has issues transferring a project to a PostgreSQL repository.

Could that be your problem?

[Darren Barrett]

Hi.... thanks for the reply.

I also noticed the flag on the 8.4.1 version of the ODBC driver. The version of the Postgres database is 8.4 and I am using the 8.4.2 version of the ODBC driver. I have also tried the most recent 8.3 version of the driver with the same result.

Cheers,
Darren.

[Darren Barrett]

Found the fix to this problem. Following URL discusses how to configure the data source for use with EA.

http://www.sparxsystems.com/uml_tool_guide/uml_model_management/setupapostgresqlodbcdriver.html

Perhaps it would make sense to reference this in the DBMS Repository Setup Scripts instruction section for PostgresQL.