SSISDB Folder creation Error

  • 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)

  • 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