thanks for your answer. i tried it, but it got error. Invalid Query External search command 'dbxquery' returned error code 1. Script output = "RuntimeError: Failed to run query: "SELECT * FROM (SELECT * FROM (SELECT XXX FROM WHERE XXX IS NOT NULL) AS tmp) t", params: "None", caused by: Exception(' java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ... View more

I am not sure if it is buggy behavior or not, but it seems it could be come from db connect python script to determine indexes of the string in the db table. Example: >>>string = 'hi' >>>print string[0] Output is 'h' as a first string. If you run the similar command , but string index is string instead of integer, >>>string = 'hi' >>>print string['hi'] Output is : File "<pyshell#12>", line 1, in <module> print string['hi'] TypeError: string indices must be integers, not str You can have the same error, Therefore it is more likely incompatibility of the column types with db-connect. As I mentioned it before, blob object is causing such kind of issue as well. Make sure that there is no blob object in your table. If you have, please take a look the link for it. link text ... View more

You should use quotes: mvlist="SessionEventNet PN" ... View more

I set TIME_PREFIX TIME_FORMAT and plus LOOK_AHEAD(how long the time string is) then ,it works well. ... View more