I hadn’t noticed the user vars previously. They are left over from previous searches with the Search action. I added a Purge as the first action and they no longer appear.
I also changed the Select to retrieve a field that is not user generated, so more predictable and alphanumeric. Still gives an error. Error An error occurred while processing your request: File: SQLfindpkgs.taf Position: Direct_DBMS Class: Internal Main Error Number: -101 General error during data source operation. [Application File] [2] START /sandbox/SQLfindpkgs.taf TeraScript Server 7 [Results Action] [2] Results1 [Direct DBMS Action] [2] Direct_DBMS : over60_db [Datasource] [286] No existing connection to the data source found, creating a new connection. DSN: jdbc.over60_db; User: witango; [Query] [2636] SELECT PackageUID FROM Packages [Error] [4900] -101 General error during data source operation. [request$ Vars] [4900] variableTimeout=30; > On 10 Jul 2019, at 10:33 pm, ubslab <[email protected]> wrote: > > If the expected result set is in the range of "[Array:553x36]" I would > suspect characters that the ODBC/JDBC connector can't pass or parse. > > Is it reasonable to refill the database with values not containing > special, symbol, or punctuation characters to diagnose? > > Had a similar issue with a FM Witango configuration years ago; Can't > recall specifics, but involved filtering/substitution to solve. > > - Steve K > > On 7/9/19 11:33 PM, Wayne Irvine wrote: >>> On 10 Jul 2019, at 4:26 pm, ubslab <[email protected]> wrote: >>> >>> Wayne, >>> So none the following forms will work in the action? >>> >>> SELECT packagename FROM Packages >>> >> Error >> >> An error occurred while processing your request: >> >> File: SQLfindpkgs.taf >> Position: Direct_DBMS >> Class: Internal >> Main Error Number: -101 >> >> General error during data source operation. >> >> >> >> [Application File] [2] START /sandbox/SQLfindpkgs.taf TeraScript >> Server 7 >> [user$ Vars] [2] variableTimeout=30; foundset=[Array:553x36]; >> elcount=20; endpoint=20; >> [Direct DBMS Action] [2] Direct_DBMS : over60_db >> [Datasource] [288] No existing connection to the data source found, >> creating a new connection. DSN: jdbc.over60_db; User: witango; >> [Query] [2580] SELECT packagename FROM Packages >> [Error] [4965] -101 General error during data source operation. >> [user$ Vars] [4965] variableTimeout=30; foundset=[Array:553x36]; >> elcount=20; endpoint=20; >> [request$ Vars] [4965] variableTimeout=30; >> >>> SELECT P1.packagename FROM Packages P1 >>> >> Error >> >> An error occurred while processing your request: >> >> File: SQLfindpkgs.taf >> Position: Direct_DBMS >> Class: Internal >> Main Error Number: -101 >> >> General error during data source operation. >> >> >> >> [Application File] [2] START /sandbox/SQLfindpkgs.taf TeraScript >> Server 7 >> [user$ Vars] [2] variableTimeout=30; foundset=[Array:553x36]; >> elcount=20; endpoint=20; >> [Direct DBMS Action] [2] Direct_DBMS : over60_db >> [Datasource] [289] No existing connection to the data source found, >> creating a new connection. DSN: jdbc.over60_db; User: witango; >> [Query] [2635] SELECT P1.packagename FROM Packages P1 >> [Error] [5055] -101 General error during data source operation. >> [user$ Vars] [5055] variableTimeout=30; foundset=[Array:553x36]; >> elcount=20; endpoint=20; >> [request$ Vars] [5055] variableTimeout=30; >> >>> SELECT P1.packagename FROM Packages AS P1 >>> >> Error >> >> An error occurred while processing your request: >> >> File: SQLfindpkgs.taf >> Position: Direct_DBMS >> Class: Internal >> Main Error Number: -101 >> >> General error during data source operation. >> >> >> >> [Application File] [1] START /sandbox/SQLfindpkgs.taf TeraScript >> Server 7 >> [user$ Vars] [1] variableTimeout=30; foundset=[Array:553x36]; >> elcount=20; endpoint=20; >> [Direct DBMS Action] [1] Direct_DBMS : over60_db >> [Datasource] [304] No existing connection to the data source found, >> creating a new connection. DSN: jdbc.over60_db; User: witango; >> [Query] [2608] SELECT P1.packagename FROM Packages AS P1 >> [Error] [5006] -101 General error during data source operation. >> [user$ Vars] [5007] variableTimeout=30; foundset=[Array:553x36]; >> elcount=20; endpoint=20; >> [request$ Vars] [5007] variableTimeout=30; >> >> >> >> >> >> >> Byteserve Pty Ltd >> w: http://www.byteserve.com.au/ >> e: [email protected] >> p: +61 02 9960 6099 >> m: 0409 960 609 >> f: +61 02 9960 6088 >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> [email protected] with "unsubscribe terascript-talk" in the body. >> > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > Byteserve Pty Ltd w: http://www.byteserve.com.au/ e: [email protected] p: +61 02 9960 6099 m: 0409 960 609 f: +61 02 9960 6088 ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
