Error when searching Serial Number Details

[Former Member]

Hi Experts,

I am getting this error when searching for Serial Numbers :

[Microsoft][SQL Server Native Client 10.0] [SQL Server] The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. 'Serial Numbers Master data' (OSRN) (OSRN)

Please can someone guide me how to fix this since I cannot change the design of the OSRN table.

Thanks in advance,

Greeshma

[kothandaraman_nagarajan]

Hi,

Please check if any stored procedure/FMS is added to the table.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

I've checked and there is nothing on FMS/Stored proc.

Thanks,

Greeshma

[kothandaraman_nagarajan]

Hi,

Is it possible post screen shot searching condition here to check? Also advice B1 version and PL.

Thanks & Regards,

Nagarajan

[Former Member]

Hi

We are on Version 9, PL12. and I get that error if i search on ANY of the Serial Number Details fields.

Thanks

g

[kothandaraman_nagarajan]

Hi,

Please refer SAP note 1388920 - Choose From list error

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Thanks for this note but I am trying to access Serial Number Master Data so there is no "Add" mode available - it does not behave the same way as on the Documents.

Thanks,

Greeshma

[kothandaraman_nagarajan]

Hi,

Are you working on this screen?

Thanks & Regards,

Nagarajan

[Former Member]

yes that is the screen

thanks,

G

[kothandaraman_nagarajan]

Do you have demo DB with same localization? if yes, check above scenario. let me know result.

[Former Member]

Hi Thanks for all your help. After logging a ticket with SAP they are able to provide me with a query which fixed the issue in table CHFL.

Thanks,

greeshma