robert fuschetto Posted July 12 Share Posted July 12 We added a column to a the end of a sql table. I refreshed the meta data. The new column appears but is shown red. Why would that be? All reporting seems fine. Link to comment Share on other sites More sharing options...
Clayton Peacock Posted July 12 Share Posted July 12 (edited) You should be able to however over the field and figure out the error? I wouldn't worry to much about this if its generated by the reporting server and you can pull data from the column. Edited July 12 by Clayton Peacock Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted July 13 Share Posted July 13 @robert fuschetto If you right click the field - the Menü offers you “Error details“ showing you what exactly is wrong. how did you added the field ? Link to comment Share on other sites More sharing options...
robert fuschetto Posted July 16 Author Share Posted July 16 Thank you. I am back. I never noticed the Error Details. Thanks. It shows this: The field was added to the SQl table and the masterfile refreshed. Here are properties: Like I said, it seems to work on our reports.... Link to comment Share on other sites More sharing options...
David Briars Posted July 17 Share Posted July 17 Here is a further description of a 'FOC32447': Sounds like more of a warning regarding using the name 'MINUTES'. You could test, and change the column name to something like 'CASE_MINUTES' and see if the warning goes away. 1 Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted July 17 Share Posted July 17 @David Briars please post your Master File - seems to be something wrong with the master Link to comment Share on other sites More sharing options...
Solution Alexander Homer Posted July 17 Solution Share Posted July 17 Hi Robert, MINUTES does indeed seem to be on the list of reserved column names. Here's the full list below for those who are curious. Most of them I think have overlap with keywords, system variables, commands, or other syntax END COLFETCH CONCAT DATABASE DATETIME DAY DAYS EXPLAIN GRAPHIC HOUR HOURS IMAGE INCLUDE INDEX LOCK LOGICAL LONG MICROSECOND MICROSECONDS MILLISECOND MILLISECONDS MINUTE MINUTES MONEY MONTH MONTHS NUMBER OPTIMIZE PACKAGE PERCENT PLAN PROGRAM PURGE QUERYNO RAW RESET SECOND SECONDS SERIAL SMALLFLOAT STOGROUP SYNONYM SYSNAME TABLESPACE TEXT TRUNCATE USER_TYPE_NAME VARBINARY VARGRAPHIC YEAR YEARS 2 Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted July 18 Share Posted July 18 Agreed on the minutes but please share the text of your master - there might be additional issues Link to comment Share on other sites More sharing options...
robert fuschetto Posted July 22 Author Share Posted July 22 Well it seems to work and the column name won't change. Thaks for the list! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now