Hi Richard: I cant run ij and dont know where derby is installed. And I try to reconfigure sqoop and ran it without the exceptions I posted earlier. but with the exceptions I sent on the first email.
On Wed, Jul 15, 2015 at 10:16 AM, Zhou, Richard <[email protected]> wrote: > Hi, > > > > There is no need to install derby in advance. > > For the sqoop.log, > > > > [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:196)] > Can't fetch repository structure version. > > Caused by: java.sql.SQLException: Schema 'SQOOP' does not exist > > > > This error is correct. It’s fine. As it’s your first time to start a Sqoop > server, it will generate DB automatically (also log this error) if it does > not exists. > > > > org.apache.sqoop.common.SqoopException: COMMON_0000:Unable to run > specified query - CREATE TABLE "SQOOP"."SQ_INPUT" ("SQI_ID" BIGINT > GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY, > "SQI_NAME" VARCHAR(64), "SQI_FORM" BIGINT, "SQI_INDEX" SMALLINT, "SQI_TYPE" > VARCHAR(32), "SQI_STRMASK" BOOLEAN, "SQI_STRLENGTH" SMALLINT, > "SQI_ENUMVALS" VARCHAR(100),CONSTRAINT "SQOOP"."FK_SQI_SQF" FOREIGN KEY > ("SQI_FORM") REFERENCES "SQOOP"."SQ_FORM" ("SQF_ID")) > > Caused by: java.sql.SQLSyntaxErrorException: Syntax error: BOOLEAN. > > > > This seems to be the root cause. There is “Syntax error: BOOLEAN” when > running generate scripts. Would you run this script using “ij” of derby to > see whether this script runs correctly in your env? > > > > Regards > > Richard > > > > *From:* Lee S [mailto:[email protected]] > *Sent:* Tuesday, July 14, 2015 10:56 PM > *To:* [email protected] > *Subject:* sqoop2-tool verify with exception: The database was created by > or upgraded by version 10.8 > > > > Hi all: > > I verify the configuration with the exception below: > > > > ERROR XSLAN: Database at > /root/lcy/sqoop-1.99.6-bin-hadoop200/repository/db has an incompatible > format with the current version of the software. The database was created > by or upgraded by version 10.8. > > at > org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > > at > org.apache.derby.impl.store.raw.log.LogToFile.readControlFile(Unknown > Source) > > at org.apache.derby.impl.store.raw.log.LogToFile.boot(Unknown > Source) > > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown > Source) > > at > org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) > > at > org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown > Source) > > at > org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown > Source) > > at > org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(Unknown > Source) > > at > org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(Unknown > Source) > > at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) > > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown > Source) > > at > org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) > > > > It seems that db in repository is not created with derby version 10.8 , > but I dont know how to fix it . I've checked that derby jar in WEB-INF/lib > is 10.8.2.2. > > I'm working with sqoop-1.99.6, any idea? >
