Stored Procedure Failed

Legacy Poster

• January 29, 2016 12:47

Bartender Version is BT2016 EA

SQL Server is SQL Server 2014 STD on Server 2012 R2 

 

1. When I try to make a backup or to start the configuerd maintanance plan from BT Adminstration Console (wich is installed on the same machine than the SQL Server) nothing happens.
   But in application eventlog I can see the following error:
   
   
   Stored Procedure Failed; Innere Nachricht: Incorrect syntax near '-'.
   Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
   
   How to solve this error?
    
2. Where is this configuration for the maintanance plan stored and how it is triggered? I neither can find any jobs or maintanance plans within the SQL Server nor any scheduled tasks in the OS? 

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • February 12, 2016 16:29

  Found a soluton:

   

  Problem was the name of the system-db. In my case 'BT2016-SYSDB'. For some reasons BT can not handle the '-' in the DB-Name.

  Deployed a new System-DB called 'BT2016' and now it works like expected.

  0

Please sign in to leave a comment.