Refresh a master file

[robert fuschetto]

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.

[Clayton Peacock]

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

[Patrick Huebgen]

@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 ?

[robert fuschetto]

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....

[David Briars]

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.  

 

[Patrick Huebgen]

@David Briars please post your Master File - seems to be something wrong with the master

[Alexander Homer]

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

[Patrick Huebgen]

Agreed on the minutes but please share the text of your master - there might be additional issues

[robert fuschetto]

Well it seems to work and the column name won't change. Thaks for the list!