Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when trying to update model from database: SQL error code = -204 [DNET520] #502

Closed
firebird-automations opened this issue Sep 18, 2013 · 6 comments

Comments

@firebird-automations
Copy link

Submitted by: Anil Mujagic (anilmujagic)

Duplicates DNET518

After installation of .NET Provider 3.1.1.0, while trying to update EDMX model from database, I get following error:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.9426688.
Generating the model took 00:00:00.7034577.
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.3738484.
Generating the model took 00:00:00.2757544.
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.3802625.
Generating the model took 00:00:00.2500684.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Application can compile and work with current model, but I cannot update it to include four new columns (simple nullable varchar), which I added to the table.

@firebird-automations
Copy link
Author

Commented by: Anil Mujagic (anilmujagic)

Adding info about used Firebird version.

@firebird-automations
Copy link
Author

Modified by: Anil Mujagic (anilmujagic)

environment: Windows 8.1, Visual Studio 2012 Update 3 => Windows 8.1, Visual Studio 2012 Update 3, Firebird 2.5.2.26540

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue duplicates DNET518 [ DNET518 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue is related to DNET514 [ DNET514 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue is related to DNET514 [ DNET514 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants