cancel
Showing results for 
Search instead for 
Did you mean: 

Large records in JDBC adapter

Former Member
0 Kudos

Hi All,

What is the maximum number of records a sender JDBC adapter can process? I need to process very large number of records (may be 100,000). When I select 1000 records, the adapter works fine but when I try with 1500, it does nothing.

Can you share your ideas on this plz...

Thanks & Regards,

Jai Shankar.

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

Hi Jai,

there's a great possibility that with very large number

of records the flow will finish with errors

can you send many 1000?

this should be faster

and if an error will occure you will

need to correct only one small part

BTW

if you see an error you need to check it

(DB profiler or from jdbc adapter logs)

I don't think there are some constant limits

Regards,

michal

Former Member
0 Kudos

Hi Michal,

When you say many 1000's, do you mean by using SELECT UPTO 1000?? Is there a way I can do an update on these 1000's alone??

-AR

Former Member
0 Kudos

Hi Michal,

It is not possible to send in multiples of 1000 since this is a standard table where I dont have any authorization to update the table (no status field). Any other alternative for this??

Thanks & Regards,

Jai Shankar.

MichalKrawczyk
Active Contributor
0 Kudos

hi,

like I said check the error

on the jdbc adapter (from visual admin)

or check the error in the database if there is any

then you will know the real error

Regards,

michal

Former Member
0 Kudos

Thanks for the pointer Michal. Unfortunately, I cant access Visual admin. I will ask my BASIS team to do the same.

Can you suggest me some alternative approach for the same.

Thanks & Regards,

Jai Shankar.

MichalKrawczyk
Active Contributor
0 Kudos

hi,

that's the only place from which you can see

jdbc adapter logs I believe

every XI developer should have access to VA logs

(you can access it via standalone logviewer too)

ask your basis team about it so you'll

be able to see&examine the logs yourself

Regards,

michal

bhavesh_kantilal
Active Contributor
0 Kudos

>><i>When you say many 1000's, do you mean by using SELECT UPTO 1000?? Is there a way I can do an update on these 1000's alone??</i>

Answering Antonios question, this should be possible using the Select query in the JDBC adapter. An SQL guru should surely be able to filter records in such a way.

Regards,

Bhavesh

Former Member
0 Kudos

I can see adapter monitoing in RWB. It shows no error. Do I need access to VA logs also?

Thanks & Regards,

Jai Shankar.

MichalKrawczyk
Active Contributor
0 Kudos

hi,

if you won't no one will be able to help you

so it's your choice:)

Regards,

michal

Former Member
0 Kudos

Thanks Michal,

I will get the access to VAlogs.

Thanks & Regards,

Jai Shankar.

Answers (1)

Answers (1)

MichalKrawczyk
Active Contributor
0 Kudos

delated content