Solved

Custom View Error

  • 17 January 2024
  • 6 replies
  • 55 views

Badge

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

icon

Best answer by Christian Hauggaard 17 January 2024, 11:52

View original

6 replies

Userlevel 6
Badge +5

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

Userlevel 6
Badge +5

Also can you please select show translation and send a screenshot similar to below

 

Badge

IM USING SQL DB

Badge

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)

Userlevel 6
Badge +5

@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

 

Badge

@Christian Hauggaard  thankyou it works.

Reply