Below is error message when trying to create custom view, how can i sove it
Also can you please select show translation and send a screenshot similar to below
Â
IM USING SQL DB
I have corrected Create Spelling,
Â
and also im getting this below error, if you see schema name in screenshot i have take correct schema name,
Â
The specified schema name "Tranter Pune Plant Data Transformation" either does not exist or you do not have permission to use it.
Details:
SQL Server: 'localhost'
SQL Procedure: 'vw_Lineno'
SQL Line Number: 1
SQL Error Number: 2760
The specified schema name "Tranter Pune Plant Data Transformation" either does not exist or you do not have permission to use it.
Module: .Net SqlClient Data Provider
System.Data.SqlClient.SqlException
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  at TimeXtender.DataManager.StepViewDeploy.DoAbstractStep(IStepSetup stepSetup)
Simply type the name of the schema in brackets i.e. DOTiTables]
In order to fix this:
- Remove the ÂDOTiTables] in the script and retype manually
- Remove the parameter by highlighting the parameter and pressing delete on your keyboard
Â
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.