You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The error is:
"Failed to list jobs due to error (pytds.tds_base.ProgrammingError) ("\u5bf9\u8c61\u540d 'sys.sql_expression_dependencies' \u65e0\u6548\u3002", None)\n[SQL: \n SELECT DISTINCT\n coalesce(lower(referenced_database_name), db_name()) AS db,\n referenced_schema_name AS [schema],\n referenced_entity_name AS [name],\n o1.type_desc AS [type]\n FROM sys.sql_expression_dependencies AS sed\n INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id\n left join sys.objects o1 on sed.referenced_id = o1.object_id\n WHERE referencing_id = OBJECT_ID(N'xxx')\n AND referenced_schema_name is not null\n AND o1.type_desc in ('TABLE_TYPE', 'VIEW', 'SQL_STORED_PROCEDURE', 'USER_TABLE')\n ]\n(Background on this error at: https://sqlalche.me/e/14/f405)"
SQL server2008 is an old version that does not include sys.sql_expression_dependencies,so I cannot execute it:
USE 'DATA_DB_NAME'
GRANT VIEW DEFINITION TO 'USERNAME'
GRANT SELECT ON OBJECT::sys.sql_expression_dependencies TO 'USERNAME'
This is an old project and I dare not upgrade. What should I do?
Requesting help, thank you very much
The text was updated successfully, but these errors were encountered:
This issue is stale because it has been open for 30 days with no activity. If you believe this is still an issue on the latest DataHub release please leave a comment with the version that you tested it with. If this is a question/discussion please head to https://slack.datahubproject.io. For feature requests please use https://feature-requests.datahubproject.io
The error is:
"Failed to list jobs due to error (pytds.tds_base.ProgrammingError) ("\u5bf9\u8c61\u540d 'sys.sql_expression_dependencies' \u65e0\u6548\u3002", None)\n[SQL: \n SELECT DISTINCT\n coalesce(lower(referenced_database_name), db_name()) AS db,\n referenced_schema_name AS [schema],\n referenced_entity_name AS [name],\n o1.type_desc AS [type]\n FROM sys.sql_expression_dependencies AS sed\n INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id\n left join sys.objects o1 on sed.referenced_id = o1.object_id\n WHERE referencing_id = OBJECT_ID(N'xxx')\n AND referenced_schema_name is not null\n AND o1.type_desc in ('TABLE_TYPE', 'VIEW', 'SQL_STORED_PROCEDURE', 'USER_TABLE')\n ]\n(Background on this error at: https://sqlalche.me/e/14/f405)"
SQL server2008 is an old version that does not include sys.sql_expression_dependencies,so I cannot execute it:
This is an old project and I dare not upgrade. What should I do?
Requesting help, thank you very much
The text was updated successfully, but these errors were encountered: