[
https://issues.apache.org/jira/browse/TRAFODION-2462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15874087#comment-15874087
]
Alex Peng commented on TRAFODION-2462:
--------------------------------------
There are several issues with trafci
1. GUI installer on Windows does not work. Bascially the browse button to
upload the T4 jar file and to specify the location of trafci install dir does
not function. hence installation does not proceed
comments: Reproduced, will commit fix.
2. After a successful install of trafci on Windows or *nix we notice that lib
file contains jdbcT4 and jline jar files.. There is no need to pre-package
these files with the product
comments: we think trafci should manage it in case the version conflict.
3. Running any sql statements from TRAF_HOME folder returns the following
error
SQL>get tables;
*** ERROR[1394] *** ERROR[16001] No message found for SQLCODE -1394.
MXID11000029297212351890017731933000000000906U3333300_877_SQL_CUR_2 [2017-01-25
20:44:03]
But executing the same statement when you are in $TRAF_HOME/sql/scripts folder
works.
comments: this issue could not be reproduced.
4. Executing the wrapper script 'trafci' returns and message as below and
proceeds with successful connection. You don't see this messagewhen executing
trafci.sh
<your workspace>/core/sqf/sql/local_hadoop/dcs-2.1.0/bin/dcs-config.sh: line
90: .: sqenv.sh: file not found
COMMENTS: it seems fixed by other people.
5. Executing sql statements in multiples lines causes additional SQL prompt to
be displayed
Reproduced org/trafodion/ci/Vproc
Connected to Apache Trafodion
SQL>get tables
+>SQL>
comments: still checking the cause.
6. on successful connect and disconnect when new mxosrvrs are picked up the
default schema is changed from 'SEABASE' to 'USR' (This might be a server side
issue too but will need to debug and find out)
comments: reproduced once, next time reinstall trafodion, it could not be
reproduced.
7. FC command does not work. Look at trafci manual for examples on how FC
command was displayed back, It was shown back with the SQL prompt
SQL>fc
show remoteprocess;
SQL> i
show re moteprocess;
SQL>
Reproduced
comments: could not repduced again.
8. Did the error message format change? This should have been syntax error
SQL>gett;
*** ERROR[15001] *** ERROR[16001] `
gett;
^ (4 characters from start of SQL statement)
MXID11000008622212352138256875503000000000206U3333300_493_SQL_CUR_4 [2017-01-25
21:14:18]
comments: could not reproduced with latest version.
> TRAFCI gui installer does not work
> ----------------------------------
>
> Key: TRAFODION-2462
> URL: https://issues.apache.org/jira/browse/TRAFODION-2462
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-ci
> Affects Versions: 2.1-incubating
> Reporter: Anuradha Hegde
> Assignee: Alex Peng
> Fix For: 2.1-incubating
>
>
> There are several issues with trafci
> 1. GUI installer on Windows does not work. Bascially the browse button to
> upload the T4 jar file and to specify the location of trafci install dir does
> not function. hence installation does not proceed
> 2. After a successful install of trafci on Windows or *nix we notice that
> lib file contains jdbcT4 and jline jar files.. There is no need to
> pre-package these files with the product
> 3. Running any sql statements from TRAF_HOME folder returns the following
> error
> SQL>get tables;
> *** ERROR[1394] *** ERROR[16001] No message found for SQLCODE -1394.
> MXID11000029297212351890017731933000000000906U3333300_877_SQL_CUR_2
> [2017-01-25 20:44:03]
> But executing the same statement when you are in $TRAF_HOME/sql/scripts
> folder works.
> 4. Executing the wrapper script 'trafci' returns and message as below and
> proceeds with successful connection. You don't see this messagewhen executing
> trafci.sh
> <your workspace>/core/sqf/sql/local_hadoop/dcs-2.1.0/bin/dcs-config.sh: line
> 90: .: sqenv.sh: file not found
> 5. Executing sql statements in multiples lines causes additional SQL prompt
> to be displayed
> Connected to Apache Trafodion
> SQL>get tables
> +>SQL>
> 6. on successful connect and disconnect when new mxosrvrs are picked up the
> default schema is changed from 'SEABASE' to 'USR' (This might be a server
> side issue too but will need to debug and find out)
> 7. FC command does not work. Look at trafci manual for examples on how FC
> command was displayed back, It was shown back with the SQL prompt
> SQL>fc
> show remoteprocess;
> SQL> i
> show re moteprocess;
> SQL>
> 8. Did the error message format change? This should have been syntax error
>
> SQL>gett;
> *** ERROR[15001] *** ERROR[16001] No message found for SQLCODE -15001.
> gett;
> ^ (4 characters from start of SQL statement)
> MXID11000008622212352138256875503000000000206U3333300_493_SQL_CUR_4
> [2017-01-25 21:14:18]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
