Getting errors while loading data from SAP Table using SAP Table connection

Praveena Uppalapati [ELB] 51

I am getting the below mentioned error while we are trying to pull data from SAP Table using SAP Table connector.

If given a small number in row count it is working fine. Please help us resolve this issue.

Source=Microsoft.DataTransfer.Common,''Type=System.FormatException,Message=Input string was not in a correct format.,Source=mscorlib

Thank you.

MartinJaffer-MSFT 26,051 Reputation points

2021-11-29T18:42:28.443+00:00

Hello @Praveena Uppalapati [ELB] and welcome to Microsoft Q&A.

Could you share the query or other options you are using? Input string was not in a correct format sounds like a malformed query. I might be wrong, but I need more information to work with.
Praveena Uppalapati [ELB] 51 Reputation points

2021-11-30T06:43:00.627+00:00

Hi @MartinJaffer-MSFT We are not using any query. Sharing the screen shot of the copy activity source configuration for your information.

If given row count as 5 or 6 we are able to read the data.

Thanks
MartinJaffer-MSFT 26,051 Reputation points

2021-12-01T19:42:27.083+00:00

@Praveena Uppalapati [ELB] I see nothing wrong or unusual in the picture you provided. If the problem was only in the row count, I might have an idea about what was wrong. However, when combined with this error message, things stop making sense. I'm afraid this is beyond my ability to diagnose. I'd like to refer you to another support method where an engineer with the tools to look into your specific case can help.

If you do not have a support plan, I can provide a 1-time free support ticket. Details on that will follow in a private message.
Praveena Uppalapati [ELB] 51 Reputation points

2021-12-07T06:56:22.687+00:00

Thanks @MartinJaffer-MSFT . We have a support plan and don't need a free ticket. Thanks for the response once again.