Highlighted
Consultant

BA error: Data types ntext and ntext are incompatible in the equal to operator

Hi ,

while building a business adapter using the BA studio using vendor and contract nodes getting the below error.

"Data types ntext and ntext are incompatible in the equal to operator"

Attached the snapshot and BA studio is 2020R1 version.

Any suggestions what to verify.

Regards

0 Kudos
8 Replies
Highlighted
Community Manager Community Manager
Community Manager

Re: BA error: Data types ntext and ntext are incompatible in the equal to operator

If you set the log file to generate a "debug" log (rather than "info"), then you will get much more information which will point more precisely to what is going on here.

(This assumes that you're using FlexNet Manager Suite On-premises - I don't think debug logging can be done with Cloud imports.)
(Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".)
Highlighted
Consultant

Re: BA error: Data types ntext and ntext are incompatible in the equal to operator

Hi,

Thank you for the suggestion ,Yes using an on prem setup, and will change the log Detail level to Debug.

Thanks

0 Kudos
Highlighted
Consultant

Re: BA error: Data types ntext and ntext are incompatible in the equal to operator

Hi @winvarma ,

What is your source for your BA import, is a xls file or sql table?

If it's a sql table may be you can change the column type in nvarchar.

The ntext data type is deprecated in favor of the nvarchar(max) data type. If you can change the data type in the table, that would be the best solution.

0 Kudos
Highlighted
Consultant

Re: BA error: Data types ntext and ntext are incompatible in the equal to operator

Hi @adrian_ritz1 ,

The source is an xls file.

0 Kudos