104 [main] INFO org.eobjects.sassy.SasReader - (F:\2011\01\20110103.sas7bdat) page size=2097152, page count=256
106 [main] INFO org.eobjects.sassy.SasReader - (F:\2011\01\20110103.sas7bdat) Header: SasHeader [sasRelease=, sasHost=9.0202M0, pageSize=2097152, pageCount=256]
106 [main] INFO org.eobjects.sassy.SasReader - (F:\2011\01\20110103.sas7bdat) Reading page no. 0
151 [main] INFO org.eobjects.sassy.SasReader - (F:\2011\01\20110103.sas7bdat) page type supported: 0
151 [main] INFO org.eobjects.sassy.SasReader - (F:\2011\01\20110103.sas7bdat) Reading page no. 1
197 [main] INFO org.eobjects.sassy.SasReader - (F:\2011\01\20110103.sas7bdatt) page type supported: 0
Exception in thread "main" org.eobjects.sassy.SasReaderException: readBytes failed! data.length: 2097152, off: 538976288, len: 1142964256
at org.eobjects.sassy.IO.readBytes(IO.java:100)
at org.eobjects.sassy.SasReader.readPages(SasReader.java:187)
at org.eobjects.sassy.SasReader.read(SasReader.java:108)
at org.eobjects.sassy.metamodel.SasTable.getColumnsInternal(SasTable.java:71)
at org.eobjects.metamodel.schema.MutableTable.getColumns(MutableTable.java:102)
at org.eobjects.metamodel.schema.AbstractTable.getColumnByName(AbstractTable.java:56)
at org.eobjects.metamodel.query.builder.GroupedQueryBuilderImpl.findColumn(GroupedQueryBuilderImpl.java:136)
at org.eobjects.metamodel.query.builder.SatisfiedFromBuilderCallback.select(SatisfiedFromBuilderCallback.java:137)
--
Forum URL: <http://eobjects.org/trac/discussion/topic/317>
eobjects <http://eobjects.org/trac>
The eobjects project management system, based on the trac system.
This means that SassyReader was not able to read the data set. Unfortunately not all files are readable using SassyReader since the SAS format is very intricate and has no public spec for us to implement.
--
Message URL: <http://eobjects.org/trac/discussion/message/1101>
I'm getting this error two and I noticed for my file the pageSize is consistently 1024 but the offset is well beyond 1024.. ex: data.length: 1024, off: 6888, len: 52 and data.length: 1024, off: 6784, len: 52 etc.....
I'm wondering if we need to read multiple pages before trying to perform the readBytes for the headers with the data we read from the page? or if we need to wait till we've read 'offset' worth of page data before trying to perform the readBytes for the headers?? or maybe I'm completely misunderstanding the format (quite possible since this is my first time using it! :-) )
--
Message URL: <http://eobjects.org/trac/discussion/message/1416>
Examining my file further I see that I have a ton of unknown page types.. So now I'm wondering if it's reading things from the wrong spot or if I truly have a file that is very different than what sassyreader supports.. (for the record it's a legacy system that output the files.. not my system so not sure what it's doing.. but for now I'm moving onto something else.. :-(
--
Message URL: <http://eobjects.org/trac/discussion/message/1417>
Wondering if anyone had any thoughts on the comments? I'm going to get back into reading sas7bdat files in the near future... Was hoping Sassyreader could aid in this project but wanted some feedback before I start hacking the sassyreader code..
thanks
Gary
--
Message URL: <http://eobjects.org/trac/discussion/message/1418>