Using the 'Create Database Connection String' command fails for versioning workflows in Python.
上次发布: December 27, 2019ArcGIS Pro
漏洞 ID 编号
BUG-000127252
已提交
December 10, 2019
上次修改时间
December 12, 2024
适用范围
ArcGIS Pro
找到的版本
2.4.2
操作系统
Windows OS
操作系统版本
10.0
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
CreateDatabaseConnectionString can be used instead of connection files, when there is an automated geoprocessing workflow (script or model) that uses database or enterprise geodatabase datasets. Generate a connection string which can be used as input to any geoprocessing tool that supports the specified dataset type, rather than using a path to the database through the connection file workspace.
ListVersions requires the input to be either the path to a connection file as an argument to the function. Alternatively, set the workspace environment to the connection file.
CreateDatabaseConnection is the correct tool to use as an input for ListVersions:
e.g.
new_db_connection = arcpy.CreateDatabaseConnection_management("C:\\TEMP",
"connection_file.sde",
"SQL_SERVER",
"sql_server_instance",
"DATABASE_AUTH",
"gdb",
"gdb",
"SAVE_USERNAME",
"database_name",
"#",
"TRANSACTIONAL",
"dbo.DEFAULT")
versionList = arcpy.ListVersions(new_db_connection)
print (versionList)