You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by "DaniLecx (via GitHub)" <gi...@apache.org> on 2025/05/02 14:11:49 UTC
[D] Oracle Bulk Loader: Invalid argument for username/password (hop)
GitHub user DaniLecx created a discussion: Oracle Bulk Loader: Invalid argument for username/password
Hello,
I'm having an issue when using Oracle Bulk Loader.
This is the error I get even though the Database Connection is successful.
2025/05/02 15:50:50 - Oracle bulk loader.0 - ERROR>SQL*Loader-101: Invalid argument for username/password
2025/05/02 15:50:50 - Oracle bulk loader.0 - Exit Value of sqlldr: 1
Previously I made an issue https://github.com/apache/hop/issues/4322
Some changes were made and merged into Hop 2.10 but now I still have the password issue and I don't get the detailed log with the full sqlldr command anymore.
Database connection is using variables (I tried hardcoding user/pass but it's the same error) and TNS for connecting, i have no issue with Table Input.
Any idea on how to address this ?
GitHub link: https://github.com/apache/hop/discussions/5247
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Oracle Bulk Loader: Invalid argument for username/password (hop)
Posted by "DaniLecx (via GitHub)" <gi...@apache.org>.
GitHub user DaniLecx added a comment to the discussion: Oracle Bulk Loader: Invalid argument for username/password
There's no special characters in the user/password, if try to run the command manually (even without quotes) with the .dat and .cfg generated by Hop then it works.
`sqlldr control=control0.cfg log=log.log userid=username/password@TNS_NAME`
```
SQL*Loader: Release 18.0.0.0.0 - Production on Mon May 5 09:02:43 2025
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Path used: Conventional
Commit point reached - logical record count 1000
Table OWS.TEMP_LOTS_CARD_PORTFOLIO:
1000 Rows successfully loaded.
```
Here's what my Oracle Bulk Loader looks like, it gets a single ID from a table input.
GitHub link: https://github.com/apache/hop/discussions/5247#discussioncomment-13036076
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Oracle Bulk Loader: Invalid argument for username/password (hop)
Posted by "shlxue (via GitHub)" <gi...@apache.org>.
GitHub user shlxue added a comment to the discussion: Oracle Bulk Loader: Invalid argument for username/password
I'll check this plugin later. Upload a screenshot of the Oracle bulk loader?
GitHub link: https://github.com/apache/hop/discussions/5247#discussioncomment-13015256
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Oracle Bulk Loader: Invalid argument for username/password (hop)
Posted by "shlxue (via GitHub)" <gi...@apache.org>.
GitHub user shlxue added a comment to the discussion: Oracle Bulk Loader: Invalid argument for username/password
Special Characters in Password: If your password contains special characters (like !, @, #, $, %, &, *, (, ), [, ], {, }, ;, :, ', ", <, >, ?, /, \, |, ,, .), they might be misinterpreted by the command-line interface or the loader itself. You might need to enclose the string in double quotes (") or escape the special characters depending on your operating system and the specific utility.
GitHub link: https://github.com/apache/hop/discussions/5247#discussioncomment-13016273
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Oracle Bulk Loader: Invalid argument for username/password (hop)
Posted by "DaniLecx (via GitHub)" <gi...@apache.org>.
GitHub user DaniLecx edited a comment on the discussion: Oracle Bulk Loader: Invalid argument for username/password
There's no special characters in the user/password, if try to run the command manually (even without quotes) with the .dat and .cfg generated by Hop then it works.
`sqlldr control=control0.cfg log=log.log userid=username/password@TNS_NAME`
```
SQL*Loader: Release 18.0.0.0.0 - Production on Mon May 5 09:02:43 2025
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Path used: Conventional
Commit point reached - logical record count 1000
Table xxxxxxx:
1000 Rows successfully loaded.
```
Here's what my Oracle Bulk Loader looks like, it gets a single ID from a table input.
GitHub link: https://github.com/apache/hop/discussions/5247#discussioncomment-13036076
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org