Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Unknown column ID_PROFILE error

  1. #1

    Default Unknown column ID_PROFILE error

    While trying to login into an existing repository (as user 'admin') via Kettle (Pentaho Data Integration 3.2) we get the below error Unknown column 'ID_PROFILE' ...

    org.pentaho.di.core.exception.KettleValueException:
    Unknown column 'ID_PROFILE'

    at org.pentaho.di.core.RowMetaAndData.getInteger(RowMetaAndData.java:147)
    at org.pentaho.di.repository.UserInfo.<init>(UserInfo.java:78)
    at org.pentaho.di.ui.repository.dialog.RepositoryDialog.create(RepositoryDialog.java:432)
    at org.pentaho.di.ui.repository.dialog.RepositoryDialog.access$600(RepositoryDialog.java:66)
    at org.pentaho.di.ui.repository.dialog.RepositoryDialog$5.handleEvent(RepositoryDialog.java:270)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:294)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog$4.widgetSelected(RepositoriesDialog.java:330)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:427)
    at org.pentaho.di.ui.spoon.Spoon.openRepository(Spoon.java:2747)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
    at org.pentaho.xul.swt.menu.MenuBar.handleMenuEvent(MenuBar.java:52)
    at org.pentaho.xul.swt.menu.Menu.handleMenuEvent(Menu.java:117)
    at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77)
    at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:945)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116)

    This same error occurs, even we try to remove the repository...

    Can someone help me on this???

    TIA,
    Senthil.

  2. #2

    Default

    Hi,

    Have you updated pdi/repo at all recently? or did this just appear out of the blue? I'm on PDI4 here and I don't have an ID_PROFILE column in my repository's r_user table, I'm guessing installing PDI4 might have amended your existing repository.
    Regards,

    Mark, Cloud2Land

    http://www.cloud2land.com

  3. #3
    Join Date
    Dec 2011
    Posts
    124

    Default

    Hi,

    we have got same error with my kettle 4.3.0 repository(my repository was upgraded from 3.2 to 4.3.o version). But when i got this error, i have restarted my system and working fine. I will be post later if at all i get same error.

    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.