STRING/XTRING types used Not supported by currently selected access method UDCGEN; cannot use this method

[Former Member]

BPM Experts,

I have created custom reporting data source in my BPM, where my parameter defined is of type "STRING'. This data source is accessed by BW system for reporting purpose where they get an error as below -

"STRING/XTRING types used Not supported by currently selected access method UDCGEN; cannot use this method"

It looks like BW does not support string type, how can we make this datatype compatible to SAP BW system?

Please share if you have any idea.

Thanks,

Amit

[Former Member]

BPM Team,

I will give some more details about my issue.

We have requirement to create custom BPM datasource to fulfill BW reporting requirements. Our BPM consultant created fields with datatype "string ". However, in BPM datasource we don't have any option to create char or varchar datatypes, which is compatible with BW datatypes.

Using UD connect, we are trying to extract data from BPM custom datasource, to BW system . However in SAP BW system, while creating datasource we are getting message that "String" data type is not supported.

"STRING/XTRING types used Not supported by currently selected access method UDCGEN; cannot use this method".

Anybody worked on above scenario, please share there input on the same.

Regards

Amit

[junwu]

I think most of the attributes will be  string type.

I am not familiar with BW, but in my last project, it has no problem with string attributes.

can you check with your bw team to see if there is other accessing method, not UDCGEN.

[Former Member]

Hi Jun,

Thanks for quick reply.

As per SAP recomandation to access data from BPM to BW system, we have only option is UD connect ( UDCGEN ).

I used standard BPM datasources ( Process and Task), in that we don’t have any “STRING” datatype fields. However while creation of custom BPM datasource, I am seeing there is no option to choose CHAR or VARCHAR in BPM system. We left with only option of “STRING”.

Is there any way to create field as CHAR/VarChar or NUMC datatype in BPM system instead of “string” datatype?

Regards

Amit

[junwu]

maybe you can add some conversion at bw side