Retour
-
Titre
The Action Center tab is empty and shows that is the database is linked successfully, although none of the database objects are committed to the repository -
Description
When trying to link a database to the Git repository hosted on Azure DevOps, the Action center tab is opened and it shows that the databaseis linked successfully.Although the Action center tab shows that the database is linked successfully, there are two problems:1. None of the database objects are committed to the repository.2. The Git repository on which the database is linked is empty. -
Cause
This issue appears because of the following error:Parse error: [Incorrect syntax near '@locale'] at [position: 820, line: 26, column: 53]Parse error: [ WHEN TRY_PARSE(@uncleaned_date AS datetime USING @locale) IS NOT NULL] at [position: 820, line: 26, column: 53] -
Résolution
WORKAROUND:Find the database objects which contain the following statement:TRY_PARSE(@uncleaned_date AS datetime USING @locale)
When the database objects with that statement are found, if it is possible, then change that statement in the database objects with the following statement:
TRY_PARSE(@uncleaned_date AS datetime USING 'en-GB')
STATUS:
Waiting for a fix in a future release of ApexSQL Source Control
-
Identifiant du défaut
221327