Text fields in InfoSets restrict performance

[Former Member]

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.

[RamanKorrapati · Accepted solution]

Hi PC,

May be some text fields are part of your data source, that may cause this. have you checked again. is there any text fields with "T". please check and let us know.

Thanks

[Former Member · Accepted solution]

Yes, text fields for the different currencies were generated into the datasource. This is strange as I have deleted the text fields and generated the infoset before creating the datasource...

[RamanKorrapati · Accepted solution]

Hi Pc,

Generated different currencies text fields have marked as 'T', then above error may won't solve.

if possible try to create copy one and let see. whether text fields will be part of infoset or not.

Thanks

[former_member182470 · Accepted solution]

Hi PC,

Try this SQ02-->Select Infoset-->More Functions-->Adjust

SQ02-->Select Infoset-->goto-->More Functions-->Check and Generate , Consistency checks.

Perform all above and try ..

[Former Member · Accepted solution]

no success. Will check the whole problem/issue later. Thanks

[former_member182470]

Have you generated your infoset after deleting text fields?

[Former Member]

Yes, I have.

[former_member182470]

Logout and login again to see any change in the behavior.