Answers about

• Error no Dates In Calendar Transaction in Overnight Cycle in Administration; SQL/Database
  Users are seeing Error no Dates in calendar transaction (followed by the transaction id) in the overnight cycle error. This error is usually caused because the component is calendar deferral and there...
• Last Updated: 6/7/2017

• The Execute permission was denied on the object 'proc_clientGetProductDisplayCategory', database RTPOneLocal, schema dbo in Installation/Update; SQL/Database
  After taking the 2012.1.1 release if a customer uses local offline they might get this error. To fix this error: -navigate to the local store server the client points to -find the SP -right click and...
• Last Updated: 8/27/2016

• Finding Out What Database Version is Running in Installation/Update; SQL/Database
  This query will tell you what version a database is on. This can be handy, among other things, for knowing if your database version is in line with the rest of the application. This is also a good ite...
• Last Updated: 7/16/2016

• Syntax Error Converting the Varchar Value ... to a Column of Data Type Int in SQL/Database
  This is a SQL error and means that a alphanumeric value is trying to be entered into a column in the database that can only accept numeric values. RTP will need to be contacted to find what value is ...
• Last Updated: 7/16/2016

• Finding Client Studio Panel Types in Client Studio; SQL/Database
  To find out what Client Studio Panel Type a particular client is, run the Query: select * from clientstudioclientXML. In the XML text column for the particular client you wish to find the Panel type...
• Last Updated: 7/16/2016

• Manually Executing a Report Stored Procedure in Report Navigator; SQL/Database
  Question: Will executing a Stored Procedure that corresponds to a RTP report using a SQL editor, such as Query Analyzer or SQL Management Studio, affect the performance of the application? Answer: ...
• Last Updated: 7/16/2016

• SQL Replication Error: Could not continue scan with NOLOCK due to data movement. in SQL/Database
  Replication is failing with the following error: Could not continue scan with NOLOCK due to data movement. This error has to do with rows missing or being deleted while replication is running. There ...
• Last Updated: 7/16/2016

• RTPOne System and Database Maintenance Guide in SQL/Database
  Please see the attached document for an RTP review of recommended system and database maintenance.
• Last Updated: 7/12/2016

• FoodPOS: 'Cannot Retrieve POS Transaction ID' in Food and Beverage; SQL/Database
  Received the error message 'Error finishing transaction, cannot retrieve POS transaction ID' when trying to finish a sale at a Food POS. Cause: This message appears when the POS is not properly commu...
• Last Updated: 7/5/2016

• RTP - XML Parsing Error in Replication Database Tools. in SQL/Database
  Users are getting Unable to Execute: XML parsing: line 2, character 0, incorrect document syntax.....exec proc_systemReplicationAddSQLServerAgentUser" error message when running the Replication Databa...
• Last Updated: 7/5/2016