Focal Point
[SOLVED] SYSCOLUMN Master causes Report Painter to barf

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/152103161

June 24, 2009, 09:50 AM
RickW
[SOLVED] SYSCOLUMN Master causes Report Painter to barf
We found an odd problem when having a Master named SYSCOLUMN anywhere in the search APP PATH, Report Painter will throw an "Error Parsing Master File ..." I've seen a few references to people using SYSCOLUMN, so I'm wondering if this is a bug...

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle
June 24, 2009, 11:00 AM
Darin Lee
SYSCOLUMN is an internal table to WF but does not usually show up when you view a list of available tables. It's more or les a reserved table name, so you should NOT have a table with this name in your path.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
June 24, 2009, 12:01 PM
RickW
yeah - we found that out - good to know - thanks!


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle
June 24, 2009, 05:47 PM
Brian Suter
Other table names to avoid:
systable, syscube, syscube2, sysfiles


Brian Suter
VP WebFOCUS Product Development
June 25, 2009, 07:18 AM
RickW
Thanks Brian - very good to know...


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle