SPONSORS:






User Tag List

Results 1 to 9 of 9
  1. #1
    Junior Member
    Join Date
    Mar 2001
    Location
    philippines
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Error using DB_FetchNext on Silk Test

    I have been encountering an application error (partner.exe access violation)using Silk test when using DB_FetchNext to get the results of a SQL aggregate function(count, avg, etc).

    I connect to an Oracle database and use Silk to execute the Select Count(*) statement on it.

    Any help would be appreciated.

  2. #2
    Senior Member
    Join Date
    Jun 2000
    Location
    Waltham, MA
    Posts
    107
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    Maybe the amount of information is too large for SilkTest's memory handling, and causing Silk to crash.


  3. #3
    Senior Member
    Join Date
    Aug 1999
    Location
    Cambridge, UK
    Posts
    470
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    We had exactly this problem when our aut first started using Oracle at the database end. It really is nasty - SilkTest (the main app, not the agent) just crashes out when you try to do DB_FetchNext on such an aggregate query. We decided that we didn't really need to use these aggregate functions very much, so we could work round the problem (e.g. instead of 'select count (*) etc.', just do 'select * etc.' and use an extra line of the script to count the number of replies received.
    Probably worth complaining to segue tech support about this one.

  4. #4
    Member
    Join Date
    Jun 2000
    Location
    Derby, UK
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    I just tried this, and ive encountered no problems. Im Using W2K Server and 8i (8.1.6.0) and Silk 5.0.3.
    Could you supply more info on the query used?
    [-] testcase tester(STRING UID,STRING PWD) appstate none
    [ ] HDATABASE hdbcSQL
    [ ] HSQL hstmntSQL
    [ ] integer Count
    [ ]
    [ ] hdbcSQL = DB_Connect ("dsn=ewareora;UID="+UID+";PWD="+PWD+"")
    [ ]
    [ ] hstmntSQL = DB_ExecuteSql (hdbcSQL, "select count(*) from cases")
    [ ]
    [ ] //retrieve
    [ ] while ((DB_FetchNext (hstmntSQL, Count)))
    [ ]
    [ ] LogWarning (Str(Count))
    [ ]
    [ ] DB_FinishSQL (hstmntSQL)
    [ ] DB_Disconnect (hdbcSQL)

  5. #5
    Senior Member
    Join Date
    Aug 1999
    Location
    Cambridge, UK
    Posts
    470
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    I just tried it again, and silktest didn't crash. Maybe it's a bug that they knew about and fixed, but didn't tell us about?
    For reference, I am using Oracle 8.1.5, and silktest 5.0.3. I think when I first encountered the problem we were using Oracle 8.1.6 and silktest 5.0, so it could be a change in either of those I suppose.

  6. #6
    Junior Member
    Join Date
    Jul 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    i tried it with this:
    INTEGER sum
    hSQL = DB_ExecuteSql( hdb, "SELECT SUM ( CUR_AMT ) FROM CI_FT WHERE SA_ID = {sa}" )
    while (( DB_FetchNext( hSQL, sum ) ))

    and it gp faulted. i turned on odbc tracing and discovered that it's doing an sqldescribe on what silk thinks is the name of the column: SUM( CUR_AMT ). this may be the problem....

    i sent silk an email about this. they're still researching.

    ------------------
    a software developer interested in quality software
    a software developer interested in quality software

  7. #7
    Senior Member
    Join Date
    Aug 1999
    Location
    Cambridge, UK
    Posts
    470
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    Is that describe call being generated by silktest, or by the odbc driver? If it's the driver, then you could work around the problem by trying a different driver - for example, the microsoft odbc driver for oracle comes free as part of mdac.
    And if it's silk, what on earth is it trying to do?

    ------------------

  8. #8
    Junior Member
    Join Date
    Nov 2002
    Location
    Chennai, INDIA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    Still I am facing this problem (Silk crashes on using COUNT) ! Any one has a alternative ?

  9. #9
    Junior Member
    Join Date
    Nov 2002
    Location
    Chennai, INDIA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Error using DB_FetchNext on Silk Test

    Finally I got the answer through R&D, this happens because of the Oracle ODBC Driver ! The same code works fine with Microsoft ODBC for Oracle.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 05:39 AM.

Copyright BetaSoft Inc.