soldd returns error 23007 when exporting database schema
Symptom
When exporting database schema, soldd returns error 23007.
For example:
Solid Data Dictionary List fatal error: [Solid][SOLID ODBC Driver] [SOLID]SOLID Procedure Error 23007: Procedure name SOLDD_GET_SEQUENCE_VAL conflicts with an existing entity
Causes
The error 23007 is a generic solidDB procedure that is returned when you attempt to create a stored procedure with a name that exists in the database. soldd creates system stored procedures to export the current value of a database sequence object and drops those stored procedures after the sequence object is exported. If soldd is interrupted during the schema export, dropping the system stored procedures might fail. When soldd is rerun, error 23007 is returned.
Resolving the problem
To resolve the problem, complete the following steps:
1 Check the error message for the name of the system stored procedure that is causing the error.