Re: TeraScript-Talk: First time doing Direct_DBMS
Wayne,
I recall needing to adjust datatype(s) in FM databases to work correctly
with Wtango and JDBC/ODBC.
Perhaps a test FM db with only integer columns.
- Steve K
On 7/10/19 7:06 PM, ubslab wrote:
> Wayne,
>
> Are you able to connect to FM table.columns in the Terascribe editor
> JDBC/ODBC panel?
>
> - Steve K
>
> On 7/10/19 6:45 PM, Wayne Irvine wrote:
>>> On 11 Jul 2019, at 12:38 am, Robert Shubert wrote:
>>>
>>> Wayne,
>>>
>>> First do a simple query like "SELECT 1" just to double check the DBMS.
>> I tried:
>> SELECT 1
>> SELECT 1 FROM Packages
>>
>> both gave an error.
>>> Then try grabbing just one row "SELECT packagename FROM Packages WHERE
>>> packagename = '{known name}’"
>> SELECT packagename FROM Packages WHERE packagename = 'Kessell Run’
>>
>> Error
>>> If that works, then we may be looking for a bug dealing with non-value. Try
>>> "SELECT packagename FROM Packages WHERE packagename IS NOT NULL”
>> SELECT packagename FROM Packages WHERE packagename IS NOT NULL
>>
>> Error
>>> What version of TS are you running? There was a JDBC fix in 7.1.1 and I
>>> have another fix (which may be your problem) coming in 7.1.5.
>> 7.1.3.1
>>
>> Wayne
>>
>> Byteserve Pty Ltd
>> w: http://www.byteserve.com.au/
>> e: i...@byteserve.com.au
>> p: +61 02 9960 6099
>> m: 0409 960 609
>> f: +61 02 9960 6088
>>
>>
>>
>>
>>
>>
>> To unsubscribe from this list, please send an email to
>> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>>
>
>
>
> To unsubscribe from this list, please send an email to
> lists...@terascript.com with "unsubscribe terascript-talk" in the body.
>
To unsubscribe from this list, please send an email to lists...@terascript.com
with "unsubscribe terascript-talk" in the body.
Re: TeraScript-Talk: First time doing Direct_DBMS
> On 11 Jul 2019, at 12:38 am, Robert Shubert wrote:
>
> Wayne,
>
> First do a simple query like "SELECT 1" just to double check the DBMS.
I tried:
SELECT 1
SELECT 1 FROM Packages
both gave an error.
>
> Then try grabbing just one row "SELECT packagename FROM Packages WHERE
> packagename = '{known name}’"
SELECT packagename FROM Packages WHERE packagename = 'Kessell Run’
Error
>
> If that works, then we may be looking for a bug dealing with non-value. Try
> "SELECT packagename FROM Packages WHERE packagename IS NOT NULL”
SELECT packagename FROM Packages WHERE packagename IS NOT NULL
Error
>
> What version of TS are you running? There was a JDBC fix in 7.1.1 and I have
> another fix (which may be your problem) coming in 7.1.5.
7.1.3.1
Wayne
Byteserve Pty Ltd
w: http://www.byteserve.com.au/
e: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088
To unsubscribe from this list, please send an email to lists...@terascript.com
with "unsubscribe terascript-talk" in the body.
Re: TeraScript-Talk: First time doing Direct_DBMS
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 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 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: i...@byteserve.com.au >> p: +61 02 9960 6099 >> m: 0409 960 609 >> f: +61 02 9960 6088 >> >> >> >> >> >> >> To unsubscribe from this list, please send an email to >> lists...@terascript.com with "unsubscribe terascript-talk" in the body. >> > > > > > To unsubscribe from this list, please send an email to > lists...@terascript.com with "unsubscribe terascript-talk" in the body. > Byteserve
RE: TeraScript-Talk: First time doing Direct_DBMS
Wayne,
First do a simple query like "SELECT 1" just to double check the DBMS.
Then try grabbing just one row "SELECT packagename FROM Packages WHERE
packagename = '{known name}'"
If that works, then we may be looking for a bug dealing with non-value. Try
"SELECT packagename FROM Packages WHERE packagename IS NOT NULL"
What version of TS are you running? There was a JDBC fix in 7.1.1 and I have
another fix (which may be your problem) coming in 7.1.5.
Robert
-Original Message-
From: Wayne Irvine [mailto:wa...@byteserve.com.au]
Sent: Tuesday, July 09, 2019 11:34 PM
To: TeraScript-Talk@terascript.com
Subject: Re: TeraScript-Talk: First time doing Direct_DBMS
> On 10 Jul 2019, at 4:26 pm, ubslab 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: i...@byteserve.com.au
p: +61 02 9960 6099
m: 0409 960 609
f: +61 02 9960 6088
To unsubscribe from this list, please send an email to lists...@terascript.com
with "unsubscribe terascript-talk" in the body.
To unsubscribe from this list, please send an email to lists...@terascript.com
with "unsubscribe terascript-talk" in the body.
Re: TeraScript-Talk: First time doing Direct_DBMS
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 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: i...@byteserve.com.au > p: +61 02 9960 6099 > m: 0409 960 609 > f: +61 02 9960 6088 > > > > > > > To unsubscribe from this list, please send an email to > lists...@terascript.com with "unsubscribe terascript-talk" in the body. > To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.
Re: TeraScript-Talk: First time doing Direct_DBMS
> On 10 Jul 2019, at 4:26 pm, ubslab 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: i...@byteserve.com.au p: +61 02 9960 6099 m: 0409 960 609 f: +61 02 9960 6088 To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.
