Skip to main content

Below is error message when trying to create custom view, how can i sove it
@Christian Hauggaard 

@Karankadam please confirm which type of data warehouse storage you are using (SQL DB, snowflake, etc), and the version of timextender you are using


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)


@Karankadam do not drag in the data area from the right when writing the view name as this will use the database name for the data area

Simply type the name of the schema in brackets i.e. DOTiTables]

In order to fix this:

  1. Remove the ÂDOTiTables] in the script and retype manually
  2. Remove the parameter by highlighting the parameter and pressing delete on your keyboard

 


@Christian Hauggaard  thankyou it works.


Reply