October 29, 2024 at 9:19 pm
We recently installed SSIS on SQL Server 2022 machine. Trying to create a folder under SSISDB integration Services catalog is giving this below error.
Operation 'Create' on object 'CatalogFolder[@Name='Testing1']' failed during execution. (Microsoft.SqlServer.Management.Sdk.Sfc)
Cannot find either column "internal" or the user-defined function or aggregate "internal.is_valid_name", or the name is ambiguous.
Cannot find the folder 'Testing1' because it does not exist or you do not have sufficient permissions. (Framework Microsoft SqlClient Data Provider)
I do have sysadmin and ssis_admin access on that box.
Error trace:
Operation 'Create' on object 'CatalogFolder[@Name='Testing1']' failed during execution. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=17.100.40.0&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.CRUDImplWorker(String operationName, SfcObjectState requiredState, SfcDependencyAction depAction, SfcObjectState finalState, Object extraParam)
at Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder.Create()
at Microsoft.SqlServer.IntegrationServices.UITasks.CreateObjectController.CreateObject()
at Microsoft.SqlServer.IntegrationServices.UITasks.CreateObjectController.Perform(ITaskExecutionContext taskExecutionContext)
at Microsoft.SqlServer.Management.TaskForms.TaskExecutionManager.ExecuteTaskSequence(ISfcScriptCollector collector)
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcTSqlExecutor.Execute(ServerConnection connection, String script, ExecutionMode mode, ExecutionTypes type)
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcTSqlExecutionEngine.Microsoft.SqlServer.Management.Sdk.Sfc.ISfcExecutionEngine.Execute(ISfcScript script)
at Microsoft.SqlServer.Management.Sdk.Sfc.SfcInstance.CRUDImplWorker(String operationName, SfcObjectState requiredState, SfcDependencyAction depAction, SfcObjectState finalState, Object extraParam)
===================================
Cannot find either column "internal" or the user-defined function or aggregate "internal.is_valid_name", or the name is ambiguous.
Cannot find the folder 'Testing1' because it does not exist or you do not have sufficient permissions. (Framework Microsoft SqlClient Data Provider)
------------------------------
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-4121-database-engine-error
------------------------------
Server Name: SQLServerName
Error Number: 4121
Severity: 16
State: 1
Procedure: SSISDB.catalog.create_folder
Line Number: 67
------------------------------
Program Location:
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
October 30, 2024 at 10:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply