Skip to Content
0
Former Member
Jun 12, 2013 at 09:18 AM

Text fields in InfoSets restrict performance

151 Views

Hi experts

I have created with SQ02 an infoset on logical database FTI_TR_POSITIONS in ECC.

Under menu "InfoSet" -> "More functions" -> "Delete Text fields" you can delete unnecessary text fields which are generated into the set.

Thereafter you can create a datasource on this infoset.

Unfortunately you get this information message, although all these advises has been done in advance:

Any ideas where the problem is? Procedure done as described in this note.

Text fields in InfoSets restrict performance

Message no. RSUQ138

Diagnosis

The InfoSet used by the extractor contains text fields generated by the system. Filling these text fields during runtime is resource-intensive. Therefore, it is advisable to remove the automatically generated text fields from the InfoSet, especially when loading large amounts of data.

Procedure

Automatically generated text fields are marked with a 'T' on the icon in the InfoSet. You can remove the automatically generated text fields from the InfoSet in the initial screen of the InfoSet maintenance under Further Functions -> Delete Text Fields. Cancel the DataSource creation on the next screen and delete the text fields in the InfoSet maintenance transaction.

If you cannot do this (since the fields are already in use), copy the InfoSet, delete the text fields from the copy and create the extractor again using the copy.