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.
