cancel
Showing results for 
Search instead for 
Did you mean: 

JCO Error - Refresh has failed HDB 00102

Former Member
0 Kudos

Hi,

I'm trying to acquire some data from SAP ERP infosets using the JCO connector. It's a basic infoset with a join of two tables: VBRK and VBRP.

If I restrict the SQL call with the date field so there are cca. 20k rows, the upload in Lumira takes 20min (I don't know if this is normal performance, however it is really slow).

When I widen the SQL call so it collects cca. 70k rows, the upload in Lumira ends with an error (after nearly 2 hours!). The error is - Refresh has failed (HDB 00102).

Anyone already hit this error?

Thanks,

Borut

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Hi Borut - before looking at how it runs in Lumira, have you created a SAP Query back in ERP - and does it run successfully without error?  That would be my first test before trying running it in Lumira

Former Member
0 Kudos

Hi Tammy,

the query for this infoset works fine. It loads the 70k record in seconds.

Also as I said for a more limited range with less records I have no error in Lumira.

TammyPowlas
Active Contributor
0 Kudos

Hi Borut - on a thread with a similar error, Henry Banks recommended doing a trace - see note http://service.sap.com/sap/support/notes/1782007 - is that something you could try with Lumira Desktop?

Are you using Lumira Desktop 1.25.1?

Answers (0)