Joinutility seperatorLogin utility separator Infobright.com
   
 
Cant load from Pentaho Community Edition to ICE
 
raghav
Posted: 24 December 2009 03:38 AM   [ Ignore ]  
Newbie
Rank
Total Posts:  32
Joined  2009-11-09

Hi,

I am running Pentaho Community Edition 3.2 (Kettle) and trying to load to Infobright Comm Edition on my laptop.
Things go fine till the time I attempt to run the job. Its test job with no functionality.

When run, the job fails with an error message as follows -

Error inserting/updating row
 Table storage engine for 'ppl2' doesnt have this option
 
 
     at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:422)
     at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
     at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
     at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
 Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 

The table storage engine is BrightHouse. The table creation script looks like this -

CREATE TABLE BH_RSI_Repository.ppl2
(
  Name VARCHAR(50),
  Place VARCHAR(50),
  BYear INTEGER
)
ENGINE = BRIGHTHOUSE; 


Also, when I am trying to insert from mysql query browser interface, I am not able to insert in the table, same error message comes.  The mysql error number is 1031, but I am unable to get any references/solutions to that, even google is not coming back with any details on that.  Here’s the exact error mesage -

Error: 1031 SQLSTATE: HY000  (ER_ILLEGAL_HA) 

Please help understand/resolve the problem…

[ Edited: 24 December 2009 03:42 AM by raghav]
Profile
 
Jakub Wroblewski
Posted: 24 December 2009 04:25 AM   [ Ignore ]   [ # 1 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  736
Joined  2008-08-18

Hi,

Youshould not use ‘BH_RSI_Repository’ to store your data - this is a special folder containing Infobright’s Knowledge Nodes and should not be used for other purposes.

However, this is probably not the cause of your problems. The root cause may be that you are using INSERT or UPDATE on Infobright Community Edition, which is not supported. ICE may only load data from files:
http://www.infobright.org/wiki/Data_Loading/

Full Insert/Update/Delete functionality is available in Enterprise Edition.

Regards,

Signature 
Profile
 
raghav
Posted: 28 December 2009 08:01 AM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  32
Joined  2009-11-09

Thanks a ton. Got to know that after quite a bit of reading. :(

Profile
 
CarlGelbart
Posted: 30 December 2009 12:50 PM   [ Ignore ]   [ # 3 ]  
Member
Avatar
RankRankRank
Total Posts:  191
Joined  2008-10-20

You can download a trial version of our enterprise edition (IEE) at http://www.Infobright.com. Click download in the upper right hand side of the home page and then use the userid/password from this site to log in.

Signature 
Profile
 
raghav
Posted: 20 January 2010 06:17 AM   [ Ignore ]   [ # 4 ]  
Newbie
Rank
Total Posts:  32
Joined  2009-11-09

Thanks to all for their help.

Learned the basiscs and found that ICE cant allow standard loads to tables.

Now I am trying out something afresh.

On my windows xp laptop, I have infobright ice running. The data source is a remote server running oracle.
While attempting to load using InfoBright loader built into Pentaho DI 3.2, I get the following error -

2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  : An error occurred intialising this step
2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  : org.pentaho.di.core.exception.KettleDatabaseException: 
2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  : java.lang.NullPointerException
2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  :     at java.lang.Thread.run (null:-1)
2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:48)
2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoader.init (InfobrightLoader.java:101)
2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderData.databaseSetup (InfobrightLoaderData.java:56)
2010/01/20 15:15:22 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderMeta.getInfobrightProductType (InfobrightLoaderMeta.java:69)

2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  : 
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderData.databaseSetup(InfobrightLoaderData.java:78)
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoader.init(InfobrightLoader.java:101)
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:48)
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  :     at java.lang.Thread.run(Unknown Source)
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  : Caused by: java.lang.NullPointerException
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderMeta.getInfobrightProductType(InfobrightLoaderMeta.java:69)
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  :     at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderData.databaseSetup(InfobrightLoaderData.java:56)
2010/01/20 15:51:18 - Infobright Loader.0 - ERROR  :     ... 3 more 

Already used advice from Geoffrey regarding updating the latest jar file for bulk loaders.
I have infobright-core-v3_0-remote and java version “1.6.0_17”

Any idea anybody ?

[ Edited: 20 January 2010 06:23 AM by raghav]
Profile
 
   
 
 
‹‹ Connecting to the remote server by jdbc      How to make Bulk loader work remotely ? ››