topic Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException in Talend Studio

tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Wchan1594662165 — Sat, 16 Nov 2024 01:24:53 GMT

I'm using a working DEV env trying out tMongoDBBulkLoad component from JSON file following Talend's scenario guide (https://help.talend.com/reader/ywFNwfAK5Tww4ABGvi5PrQ/GT43dlXDtEuuirlA8BSKPw). However I keep getting the following error and cannot figure out what is causing it. I have the appropriate certs to access db set from JVM arguments to use cacerts. Any experienced similar error and had any luck resolving it? Thanks, help is much appreciated!

Exception in thread "Thread-2" java.lang.StringIndexOutOfBoundsException: String index out of range: -20

at java.lang.String.substring(Unknown Source)

at pocs.mongodb_poc_0_1.MongoDB_POC$2.run(MongoDB_POC.java:475)

2020-09-22T11:04:58.219-0400 Failed: (Unauthorized) there are no users authenticated

2020-09-22T11:04:58.219-0400 0 document(s) imported successfully. 0 document(s) failed to import.

Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Anonymous — Wed, 23 Sep 2020 08:35:45 GMT

Hello,

Your index is out of range. Did you fill in MongoDB directory field with the MongoDB home directory? Could you share your tMongoDBBulkLoad component setting screenshot here and mask your sensitive data?

Best regards

Sabrina

Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Wchan1594662165 — Wed, 23 Sep 2020 13:42:13 GMT

Hi Sabrina,

Yes, I set it to where my monogoDB home directory is. Is the index out of range in my JSON file or other?

In addition, I noticed in Talend's component guide for tMongoDBBulkLoad (https://help.talend.com/reader/ywFNwfAK5Tww4ABGvi5PrQ/_eESGZatUg0YPq8FcgA1gg) it says there's the "NEGOTIATION" option when "required authentication" is checked. However, I don't have that option in my Talend and I think that is also affecting the authentication as this is what I select in tMongoDBInput job and it works fine to access db. Thanks!

Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Anonymous — Thu, 24 Sep 2020 09:14:58 GMT

Hello,

What's your mongodb version? V 2.6? Components were all updated with appropriate authentication capabilities depending on mongodb version.

Best regards

Sabrina

Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Wchan1594662165 — Thu, 24 Sep 2020 13:39:14 GMT

I'm using MongoDB 3.6.5 Enterprise. I think I found the cause of the issue but I'm unable to fix it. It seems in tMongoDBBulkLoad, I'm missing the option to "Set Authentication Database" but according to Talend's 7.3 guide, this component should have this setting. (see image below)(https://help.talend.com/reader/ywFNwfAK5Tww4ABGvi5PrQ/_eESGZatUg0YPq8FcgA1gg)

How would I get this setting available in tMongoDBBulkLoad? Thanks!

Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Anonymous — Fri, 25 Sep 2020 06:41:36 GMT

Hello,

Could you please clarify in which Talend version/edition you are? Here exists a jira issue about "Authentication Fields missing in tMongoDBBulkLoad" and it is fixed in 7.2.2, 7.4.1, 7.3.2, 7.3.1-R2020-06

Best regards

Sabrina

Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Wchan1594662165 — Fri, 25 Sep 2020 13:47:51 GMT

Hi Sabrina,

I'm using Talend Data Fabric 7.3.1 (licensed) that was installed a few week ago. Thanks!

Re: tMongoDBBulkLoad Exception in Thread-2 java.lang.StringIndexOutofBoundsException

Anonymous — Sun, 27 Sep 2020 06:48:26 GMT

Hello,

With your subscription solution, could you please create a support case on talend support portal so that our colleagues from support team will deliver a patch to you if needed.

Best regards

Sabrina