Skip to main content
Solved

Custom View Error


Forum|alt.badge.img

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

Best answer by Christian Hauggaard

@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

 

View original
Did this topic help you find an answer to your question?

6 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+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


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

 


Forum|alt.badge.img
  • Author
  • Contributor
  • 14 replies
  • January 17, 2024

IM USING SQL DB


Forum|alt.badge.img
  • Author
  • Contributor
  • 14 replies
  • January 17, 2024

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)


Christian Hauggaard
Community Manager
Forum|alt.badge.img+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

 


Forum|alt.badge.img
  • Author
  • Contributor
  • 14 replies
  • January 17, 2024

@Christian Hauggaard  thankyou it works.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings