Hi Narendra, Thanks.
I looked a little bit more after I sent out the email and found some of the source Java directory was removed in my build, which explains why the 1st jar file in your list is not there. Once I restored it, then the jar -tf did find the HBaseClient class. Thanks again. --Qifan On Fri, Aug 26, 2016 at 11:11 AM, Narendra Goyal <[email protected]> wrote: > Hi Qifan, > > The HBaseClient should be in one of the following jars: > > trafodion-sql-2.2.0.jar > trafodion-sql-apache1_0_2-2.2.0.jar > trafodion-sql-hdp2_3-2.2.0.jar > > I see the following in my env: > $ jar -tf trafodion-sql-2.1.0.jar | grep HBase > org/trafodion/sql/HBaseClient.class > org/trafodion/sql/HBaseClient$ChangeFlags.class > > > If a 'jar -tf' on the above jars do not show an HBaseClient class, then > most > likely there is some build issue. > > Thanks, > -Narendra > > > -----Original Message----- > From: Qifan Chen [mailto:[email protected]] > Sent: Friday, August 26, 2016 8:38 AM > To: dev <[email protected]> > Subject: Re: Getting class not found error on latest Trafodion > > Hi, > > I experienced the similar problem with EsgynDB2.2 today. It looks like the > HBaseClient class is not present in any of the jar files built, and > trafodion-sql-cdh-2.1.0.jar is not there. > > I reinstalled the local hadoop, rebuilt everything, sqgen, sqstart. Also > ran ilh_traf_restart. > > Just wonder if trafodion-sql-cdh-2.1.0.jar should be built for the latest > esgynDB2.2? > > Thanks --Qifan > > [qfc@adev04 scripts]$ sqlci > EsgynDB Advanced Conversational Interface 2.2.0 Copyright (c) 2015-2016 > Esgyn Corporation > >>initialize trafodion; > > *** ERROR[1398] Error 706 occured while accessing the hbase subsystem. Fix > that error and make sure hbase is up and running. Error Details: > java.lang.NoClassDefFoundError: org/trafodion/sql/HBaseClient . > > --- SQL operation failed with errors. > > [qfc@adev04 lib]$ sh t > hbase-trx-apache1_0_2-2.2.0.jar > hbase-trx-apache1_1_2-2.2.0.jar > hbase-trx-cdh5_4-2.2.0.jar > hbase-trx-cdh5_5-2.2.0.jar > hbase-trx-hdp2_3-2.2.0.jar > jdbcT2.jar > jdbcT4-2.2.0.jar > jdbcT4.jar > lib_mgmt.jar > sqmanvers.jar > trafodion-dtm-2.2.0.jar > trafodion-dtm-apache1_0_2-2.2.0.jar > trafodion-dtm-hdp2_3-2.2.0.jar > trafodion-sql-2.2.0.jar > trafodion-sql-apache1_0_2-2.2.0.jar > trafodion-sql-hdp2_3-2.2.0.jar > trafodion-utility-2.2.0.jar > [qfc@adev04 lib]$ cat t > for i in `ls *.jar` > do > echo $i > jar tf $i | grep -i HBaseClient > done > [qfc@adev04 lib]$ ls *jar > hbase-trx-apache1_0_2-2.2.0.jar sqmanvers.jar > hbase-trx-apache1_1_2-2.2.0.jar trafodion-dtm-2.2.0.jar > hbase-trx-cdh5_4-2.2.0.jar trafodion-dtm-apache1_0_2-2.2.0.jar > hbase-trx-cdh5_5-2.2.0.jar trafodion-dtm-hdp2_3-2.2.0.jar > hbase-trx-hdp2_3-2.2.0.jar trafodion-sql-2.2.0.jar > jdbcT2.jar trafodion-sql-apache1_0_2-2.2.0.jar > jdbcT4-2.2.0.jar trafodion-sql-hdp2_3-2.2.0.jar > jdbcT4.jar trafodion-utility-2.2.0.jar > lib_mgmt.jar > > > On Wed, Aug 24, 2016 at 2:57 PM, Anoop Sharma <[email protected]> > wrote: > > > It is usually a good idea to run the script ilh_traf_restart after a > > rebase or these kind of changes. > > It internally does some hbase/zookeeper cleanup, resqgen and sqstarts. > > > > This script was added by Narendra a while back. > > > > anoop > > > > -----Original Message----- > > From: Dave Birdsall [mailto:[email protected]] > > Sent: Wednesday, August 24, 2016 1:54 PM > > To: [email protected] > > Subject: RE: Getting class not found error on latest Trafodion > > > > Hi Narendra, > > > > Indeed! That was my problem. > > > > A recent check-in renamed the SQL and DTM Jar files. Of course the ". > > ./env.sh" picks up the new name. But my ms.env file had the old. > > > > Removing etc/ms.env, then doing an sqgen, then starting again from a > > new shell solved the problem. > > > > Many thanks! > > > > Dave > > > > -----Original Message----- > > From: Narendra Goyal [mailto:[email protected]] > > Sent: Wednesday, August 24, 2016 1:35 PM > > To: [email protected] > > Subject: RE: Getting class not found error on latest Trafodion > > > > Another suggestion base on what I have encountered in the past. > > > > Please check the CLASSPATH in $MY_SQROOT/etc/ms.env - looking for the > > trafodion-sql JAR. Is it 'exactly' the same name as the one that is in > > $MY_SQROOT/export/lib? > > > > If it does not match then you might want to re-sqgen. You could also > > simply modify ms.env so that the name matches. > > > > - stop the Trafodion env > > - restart the shell > > - delete $MY_SQROOT/etc/ms.env > > - sqgen > > - restart Trafodion > > > > > > Thanks, > > -Narendra > > > > -----Original Message----- > > From: Dave Birdsall [mailto:[email protected]] > > Sent: Wednesday, August 24, 2016 1:20 PM > > To: [email protected] > > Subject: RE: Getting class not found error on latest Trafodion > > > > Hi Narendra, > > > > Here's what I get: > > > > [birdsall@edev05 incubator-trafodion]$ cp_search /HBaseClient.class > > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > > trafodion-sql-cdh-2.1.0.jar: > > org/trafodion/sql/HBaseClient.class > > [birdsall@edev05 incubator-trafodion]$ jar tf > > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > > trafodion-sql-cdh-2.1.0.jar > > | grep HBaseClient > > org/trafodion/sql/HBaseClient$ChangeFlags.class > > org/trafodion/sql/HBaseClient.class > > [birdsall@edev05 incubator-trafodion]$ > > > > Thanks, > > > > Dave > > > > -----Original Message----- > > From: Narendra Goyal [mailto:[email protected]] > > Sent: Wednesday, August 24, 2016 1:19 PM > > To: [email protected] > > Subject: RE: Getting class not found error on latest Trafodion > > > > Hi Dave, > > > > Could you please try: > > > > cp_search /HBaseClient.class > > > > It will tell us the JAR name where the class can be found. > > > > If it does not find the class in the JAR, please double check in the > > JAR as > > follows: > > > > jar tf > > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > > trafodion-sql-cdh-2.1.0.jar > > | grep HBaseClient > > > > If it is still not there then there may be some issue with the build > > of the trafodion sql JAR. > > > > Thanks, > > -Narendra > > > > > > -----Original Message----- > > From: Dave Birdsall [mailto:[email protected]] > > Sent: Wednesday, August 24, 2016 12:54 PM > > To: [email protected] > > Subject: Getting class not found error on latest Trafodion > > > > Hi, > > > > > > > > Today I set up a new branch on latest Trafodion to do some development > > work. > > > > > > > > I made some code changes to some C++ modules, did a make clean + a > > make all. > > > > > > > > I then bring up the instance. When I try to bring up sqlci, I get the > > following: > > > > > > > > [birdsall@edev05 incubator-trafodion]$ sqlci > > > > Apache Trafodion Conversational Interface 2.1.0 > > > > Copyright (c) 2015-2016 Apache Software Foundation > > > > >>get tables; > > > > > > > > *** ERROR[1398] Error 706 occured while accessing the hbase subsystem. > > Fix that error and make sure hbase is up and running. Error Details: > > > > java.lang.NoClassDefFoundError: org/trafodion/sql/HBaseClient > > > > . > > > > > > > > *** ERROR[8822] The statement was not prepared. > > > > >> > > > > > > > > I checked my $CLASSPATH: It does have > > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > > trafodion-sql-cdh-2.1.0.jar > > in it. > > > > > > > > Any ideas? > > > > > > > > Thanks, > > > > > > > > Dave > > > > > > -- > Regards, --Qifan > -- Regards, --Qifan
