SAP - Lumira - ECC 6.0 - Source by java connector - timeout

[Former Member]

Hi,

I try , to create a dataset for ERP 6.0 data by java connector ( SQL-Source).

After connection to ERP, I can select an ERP-infoset .

By selection of an infoset   a SQL-Statement is created .

( select * from "Local"."INFOSET"."id of erp-infoset" )

After click "preview"  and a long time I get " timeout....".

can anybody help me ?

Regards Wolfgang

[TammyPowlas · Accepted solution]

It is likely timing out based on your ECC backend settings (say 5 minutes for a dialog transaction)

Can you make your ECC infoset smaller?

[Former Member · Accepted solution]

Hi Tammy,

thanks for your quick answer.

Now it works.

But if I try to reduce the number of the selected records by where condition,

I don't get any data.

I applied several fields  in the condition.

Are there any restrictions for select-statements to an infoset in ERP ?

Regards

Wolfgang

[TammyPowlas · Accepted solution]

Hi Wolfgang - my recollection is that Lumira doesn't support selects on SQL; so this could be the cause.  It has been a while since I tried this.

In this case it *might* be better to create a universe against your InfoSet and then go that route (if you are on BI4.1).

[achab · Accepted solution]

Hi,

Normally SELECT and WHERE should be supported. See http://scn.sap.com/thread/3477775.

Best regards,

Antoine

[Former Member · Accepted solution]

Hi Tammy,

thanks !

I don't have access to BI.

I will try to use the JDBC-alternative.

Do you have any experience respectively do you know any restrictions.

Regards Wolfgang

[TammyPowlas · Accepted solution]

Take a look at Antoine's link:

"Normally SELECT and WHERE should be supported. Seehttp://scn.sap.com/thread/3477775."

[Former Member · Accepted solution]

Hi,

I work with version 1.15.

Without where - condition, I get the data.

(select * from Z_SD_ADR)

But by where  condition I see only the header line ( Field-names)

without data.

My select statement:

select * from Z_SD_ADR where 'KNVV-KUNNR' = '1000'

( I tried also with 6 leading-Zero).

The Query contains a join from KNVV to KNA1.

Regards Wolfgang

[achab · Accepted solution]

try the column name between brackets.

T is your table

C is your column

SELECT * from T where "C"='value'

Does it do any good?

Otherwise alias

SELECT * from T alias where alias."C"='value'

[Former Member · Accepted solution]

Hi,

thanks !

Both alternates are good.

It works ! ( with leading  zeros for customer number )

Best regards,

Wolfgang

[achab · Accepted solution]

Yeepee! It feels good.

Cheers

Antoine