May 7, 2009 at 2:04 pm
We use SQL SERVER 2005.
Getting the ‘The index 1 is out of range.’ error whenever we enter an incremental crawl query.
We looked at the http://support.microsoft.com/kb/919568
and applied hotfix and still getting this error:
Apr 23, 2009 1:19:07 PM com.google.enterprise.database.TableCrawler
INFO: Current local time: 2009/04/23 13:19:07 PDT
Apr 23, 2009 1:19:07 PM com.google.enterprise.database.Table getConnection
INFO: connecting to database tst on host sqltest via port 1433
Apr 23, 2009 1:19:07 PM com.google.enterprise.database.AbstractTableReader parse
INFO: incremental crawl
Apr 23, 2009 1:19:07 PM com.google.enterprise.database.TableCrawler main
SEVERE: exp thrown during crawling
javax.xml.transform.TransformerException: com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
at com.icl.saxon.IdentityTransformer.transform(IdentityTransformer.java:92)
at com.google.enterprise.database.TableCrawler.crawl(TableCrawler.java:234)
at com.google.enterprise.database.TableCrawler.main(TableCrawler.java:358)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
at com.google.enterprise.database.AbstractTableReader.parse(AbstractTableReader.java:326)
at com.icl.saxon.IdentityTransformer.transform(IdentityTransformer.java:90)
... 2 more
---------
com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
at com.google.enterprise.database.AbstractTableReader.parse(AbstractTableReader.java:326)
at com.icl.saxon.IdentityTransformer.transform(IdentityTransformer.java:90)
at com.google.enterprise.database.TableCrawler.crawl(TableCrawler.java:234)
at com.google.enterprise.database.TableCrawler.main(TableCrawler.java:358)
---------
com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setTimestampParam(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setTimestamp(Unknown Source)
at com.google.enterprise.database.AbstractTableReader.parse(AbstractTableReader.java:321)
at com.icl.saxon.IdentityTransformer.transform(IdentityTransformer.java:90)
at com.google.enterprise.database.TableCrawler.crawl(TableCrawler.java:234)
at com.google.enterprise.database.TableCrawler.main(TableCrawler.java:358)
May 7, 2009 at 4:11 pm
Did you perform datapurity checks after you restored the db ?
http://support.microsoft.com/kb/923247
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 7, 2009 at 7:55 pm
We didn't restore the database. Still should we run DBCC CHECKDB ?
May 8, 2009 at 12:20 am
I think in this case it is worth the try.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply