Troubleshooting

Numeric and Timestamp Filters

Submitted by cmathis430 on Fri, 2009-01-09 07:39.Troubleshooting

Hi,

I created my own interface for numberic and timestamp filters by modifying the narrowBy.ftl, however, I seem to have a problem with the searchResult.filterResult.filteredColumns object as it does not recognize filters from the query if they do not have a double quote around the value.

Query Examples:
A) revChange:[5000,)
B) revChange:"[5000,)"

While A works as far as searching goes, it is not recognized by the filteredColumns object. However, while B does not work as far as searching goes, it is recognized by the filteredColumns object.

What am I supposed to do? Is there a way for B to work for searching? If not, is there a way for the filteredColumns object to recognize filters without quotes? Either would be fine with me, I just need either one to work in both cases: searching and recognizing filters.

Concatenation

Submitted by cmathis430 on Tue, 2009-01-06 13:53.Troubleshooting

I'm trying to do the concatenation with a subsequent query, but it doesn't seem to be concatenating the values because when I go out to output the value in the Display Template like so:
${doc.get("concatenatedColumn")}
..it only outputs the first value.
If the values were {"a", "b", "c"}, I would expect something like "a,b,c" or "abc" but instead I just get "a".
Is there more that I have to do to get the rest of the values? And if so, how do I do that?

DB2 jdbc SQL Exception in Windows Service mode

Submitted by anazeem on Tue, 2009-01-06 07:48.Troubleshooting

We are using DB2 database and have successfully installed DB2 driver,
we can test the database connection succesfully when DBsight is started from command prompt
but when installed as service, we get following error
Test failed! [java.sql.SQLException: No suitable driver found for jdbc:db2:klein]
It seems class path is not recognized when DBsight is installed as service
Thanks
Ashik

how to get product attributes

Submitted by anazeem on Mon, 2009-01-05 13:26.Troubleshooting

A product may have one or more atrributes. Attribute table has product_id as foreign key. so given a product there may be many attributes.
If I get the attribute along with products in the main query it returns as many same products as many attributes associated with the product, for e.g.
search term (partnumber): PLR100
expected result: one PLR100 product with as many attribute values (may be 10)
actual result: Ten PLR100 products each with one attribute value
If i get attributes in sub query and map it to product_id then search returns products only with first attribute
e.g.
search term (partnumber): PLR100
result: One PLR100 with one attribute value (the first attribute value)

Ajax Spell suggestion not working

Submitted by anazeem on Mon, 2009-01-05 11:13.Troubleshooting

The latest beta version 2.0.8 is installed successfully and a full indexing is done. I can search on products
but the AJAX spell suggestion does not seem to work, do I have to enable any setting?

Thanks
Ashik

Error on creating sub query in Beta 2.0.8

Submitted by anazeem on Mon, 2009-01-05 09:17.Troubleshooting

Installed beta 2.0.8 successfully, Main query tested successfully but when clicked on "Create New Subsequent Query" throws following error.
--------------------------------
HTTP ERROR: 500
Internal Server Error
RequestURI=/dbsight/configContent.do
Powered by Jetty://
--------------------------------
(The same machine has 2.0.6 installed but the server is not started, hope that is ok)
Thanks
Ashik

Certain products not indexed

Submitted by anazeem on Mon, 2009-01-05 08:55.Troubleshooting

Category level 1
  |
  |-Products
  |
  |-Category level 2
    |
    |-Products
    |
    |-Category level 3
      |
      |-Products
 
MAIN QUERY: (CATENTRY -Products table, CATENTDESC - product description table)
select catPrd.catentry_id as productId, catPrd.lastupdate, catPrd.PARTNUMBER, catPrd.MFPARTNUMBER, catd.SHORTDESCRIPTION as Product_Description, catd.thumbnail, catPrd.discontinuedate from catentry catPrd, catentdesc catd where catPrd.catentry_id=catd.catentry_id;
 
SUBSEQUENT QUERY 1 (CATGPENREL - mapping between leaf level category and products )
select cgen.CATGROUP_ID as LEAF_CATGROUP_ID, cgd.NAME as LEAF_CATGROUP_NAME
from catgpenrel cgen, catgrpdesc cgd where cgen.CATGROUP_ID=cgd.CATGROUP_ID and catentry_id = ?;
--? = productId
 
SUBSEQUENT QUERY 2 (CATGRPREL - Mapping between parent and child categories)
select cgr.CATGROUP_ID_PARENT as CGRP_FIRST_PARENT_ID, cgd.NAME CGRP_FIRST_PARENT_NAME from catgrprel cgr, catgrpdesc cgd where cgr.CATGROUP_ID_PARENT=cgd.CATGROUP_ID and cgr.CATGROUP_ID_CHILD = ?
--? = LEAF_CATGROUP_ID
 
SUBSEQUENT QUERY 3 (CATGRPREL - Mapping between parent and child categories)
select cgr.CATGROUP_ID_PARENT as CGRP_SECOND_PARENT_ID, cgd.NAME CGRP_SECOND_PARENT_NAME from catgrprel cgr, catgrpdesc cgd where cgr.CATGROUP_ID_PARENT=cgd.CATGROUP_ID and cgr.CATGROUP_ID_CHILD = ?
--? = CGRP_FIRST_PARENT_ID
 
Problem:
With above queries, products under category that does not have any sub categories are not indexed and hence could not be searched
any suggestions?
Thanks
Ashik

returns results only that match whole word

Submitted by anazeem on Wed, 2008-12-31 08:39.Troubleshooting

I am sure there will be a way to achieve this,
Problem:
dbsight does not return results for partial words like for e.g.
Product description in database: "... side cutting.."
1)
searh term: "side cut"
results: 0
2)
searh term: "side cutting"
results: 11 (which is correct)
so I have to type whole word to get the expected results, how to configure DBSight to get results with partial words
Thanks
Ashik

upgrade from 1.4.8 to 2 error

Submitted by garyp on Sun, 2008-12-07 13:47.Troubleshooting

we have /var/lib/tomcat5/webapps/dbsight operating fine. I copy this folder (with perms) to /var/lib/tomcat5/webapps/dbsight2. I copy all files from upgrade.zip to this folder. I stop the tomcat5 server, then rename /var/lib/tomcat5/webapps/dbsight to dbsight1 and /var/lib/tomcat5/webapps/dbsight2 to dbsight and restart tomcat5.

I then get 404 Servlet action is not available.

Pls advise

License registration with 2.0

Submitted by Julie Green on Wed, 2008-10-15 06:20.Troubleshooting

I downloaded 2.0.1 today to do some testing and try out the new features. However, the license page has changed (xml now) and I don't know how to get my license information into the new format. It says "Copy Paste your license here", but I have nothing to copy/paste. We've had our license for years and I've got a customer number, key, etc. that I usually just copy into the fields. Can you tell me how to construct the proper XML? Or do I need to apply for another license for 2.0.1?

XML feed