Hitachi Vantara Pentaho Community Forums
Results 1 to 15 of 15

Thread: Oracle Bulk Loader problem - LRM-00112

  1. #1

    Angry Oracle Bulk Loader problem - LRM-00112

    Hi Everyone!

    I have a terribly annoying issue, with the Oracle Bulk Loader. I always get LRM-00112 error, which stands for: Multiple values not allowed for parameter 'userid'

    See attached file, for my settings:
    Name:  sqlldr.jpg
Views: 347
Size:  24.7 KB

    My PDI version is 4.0.1, and SQL Loader is 10.2.0.3.0.

    My log always the same, even if I choose Row level logging: (Sorry, hungarian, and I deleted dates from it)
    Oracle Bulk Loader.0 - ERROR>LRM-00112: a(z) 'userid' paraméternek csak egyetlen érték adható
    Oracle Bulk Loader.0 - ERROR> Oracle Bulk Loader.0 - ERROR>SQL*Loader: Release 10.2.0.3.0 - Production on P. Febr. 25 11:36:58 2011
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>SQL*Loader-100: Szintaktikai hiba a parancssorban
    Oracle Bulk Loader.0 - Exit Value of sqlldr: 1
    Oracle Bulk Loader.0 - Finished processing (I=0, O=20592, R=20592, W=20592, U=0, E=0)

    What am I doing wrong?

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    What am I doing wrong?
    You posted an unreadable screenshot, nobody has any information.

  3. #3

    Default

    Damn Forum Engine. It resized my pic too little
    Here's a link for it:
    http://picturepush.com/public/5150192

  4. #4

    Default Additional info

    Hi there!

    Some additional info:
    If I check "Fail on error" check box, then my log looks like this:
    Oracle Bulk Loader.0 - ERROR>LRM-00112: a(z) 'userid' paraméternek csak egyetlen érték adható
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>SQL*Loader: Release 10.2.0.3.0 - Production on P. Febr. 25 17:56:03 2011
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>SQL*Loader-100: Szintaktikai hiba a parancssorban
    Oracle Bulk Loader.0 - Exit Value of sqlldr: 1
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error in step, asking everyone to stop because of:
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error while executing sqlldr 'C:\oracle\product\10.2.0\client_1\bin\sqlldr control='D:\Instal\Pentaho\4.0.1\data-integration\control0.cfg' userid=stage/******@orcl'
    Oracle Bulk Loader.0 - Finished processing (I=0, O=73308, R=73308, W=73308, U=0, E=1)
    Spoon - The transformation has finished!!
    PHE_RUS_fact_load - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Errors detected!
    PHE_RUS_fact_load - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Errors detected!

    If I choose Automatic load (on the fly) for load method, my log looks like this:
    Oracle Bulk Loader.0 - ERROR>LRM-00112: a(z) 'userid' paraméternek csak egyetlen érték adható
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>SQL*Loader: Release 10.2.0.3.0 - Production on P. Febr. 25 17:59:05 2011
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Oracle Bulk Loader.0 - ERROR>
    Oracle Bulk Loader.0 - ERROR>SQL*Loader-100: Szintaktikai hiba a parancssorban
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error in step, asking everyone to stop because of:
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : IO exception occured: A pipe használata befejeződött
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : A pipe használata befejeződött
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error while closing output
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.io.IOException: A pipe bezárása folyamatban van
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.io.FileOutputStream.writeBytes(Native Method)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.io.FileOutputStream.write(Unknown Source)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.io.BufferedOutputStream.write(Unknown Source)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : sun.nio.cs.StreamEncoder.writeBytes(Unknown Source)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : sun.nio.cs.StreamEncoder.implClose(Unknown Source)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : sun.nio.cs.StreamEncoder.close(Unknown Source)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.io.OutputStreamWriter.close(Unknown Source)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.io.BufferedWriter.close(Unknown Source)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.orabulkloader.OraBulkDataOutput.close(OraBulkDataOutput.java:100)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.orabulkloader.OraBulkLoader.dispose(OraBulkLoader.java:671)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
    Oracle Bulk Loader.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Unknown Source)

    So for me it looks like a bug. The PDI launches badly the Loader. I think.
    Matt other opinion?

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Darned cryptic Oracle error messages. <sigh>
    Try to turn on detailed or debugging logging to see if you get any more information on the commands that get executed.

  6. #6

    Default

    I tried both, but as I mentioned, it is always the same. Like I wrote in my first post.
    LRM-00112: Multiple values not allowed for parameter 'userid'

    But check my prevoius post, it says: Error while executing sqlldr 'C:\oracle\product\10.2.0\client_1\bin\sqlldr control='D:\Instal\Pentaho\4.0.1\data-integration\control0.cfg' userid=stage/******@orcl'
    So I guess this is the command, that doesn't want to run. But I can't believe, that it works for everybody, except me.
    Is there anyone, who has a working Oracle Bulk Loader in his/her transformation? If there is, please post your command, what executes the Loader.

  7. #7
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Something special with the password probably. Does it contain a space or something like that by any chance?
    It probably would be safer for the step to quote the "userid/pass@SID" combo.

  8. #8

    Default

    I use a normal JDBC connection, but my login creditentals are stored in the Kettle.properties file as parameters. (The password is encrypted). In the normal password there is no space or any special charachter. (I think _ doesn't count as a special one.) But I think if the password would be the problem, the Oracle error message will be other.

    How to do that? I mean the quoting, at the Database Connection windows, or where?

  9. #9
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The quoting thing would need to happen in PDI.
    Instead of

    Code:
    foo/-P5ss Word-@orcl
    We could generate

    Code:
    "foo/-P5ss Word-@orcl"
    I'm not sure it's going to solve all problems though.

  10. #10

    Default

    And where should I set this? I mean which window of Spoon, or which file should I edit to make this?

  11. #11
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    File a JIRA change request?

  12. #12

    Default

    Aha, now I understood it

    Yes please. But isn't it stange, that only I have this problem around the globe?
    Or am I the only one, who use Oracle Bulk Loader step?

  13. #13
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    You are right, I'm sure a lot of people are using it.
    Perhaps it's a code-page issue or something like that. If you Google for the error you'll find a lot of hits.
    Unfortunately Oracle isn't very good with reporting errors.

  14. #14

    Default

    I found a solution.
    The problem was a space character. In my kettle.properties the parameter looked like this: DB_PASSWORD = Encrypted 2be98afcxyzyxyxzyxzyxyz
    If I used plain text password, with no space (not recommended due to security reasons), or typed in, it worked fine.

    Thanks Matt for your help!

  15. #15
    Join Date
    Sep 2011
    Posts
    8

Tags for this Thread

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.