To homepage To homepage
Solved

SAP Table Data Source in ODX Server v21 - table filtering doesn't work properly

  • 31 October 2023
  • 3 replies
  • 45 views
erik.van.mastrigt
Rank
Userlevel 3
Badge +2

I’m struggling with the TimeXtender SAP Table Data Source version 18 in ODX Server v6429.1. In our current setup we use Table Name filtering like this:

 

Please see the wildcards used. How does this translate to ODX Server v21? I have these three rules:

 

The latter does not seem to work. I tried many variations (and did a sync data source consecutively), but when I click Select Tables under a transfer task, it only comes up with the tables matchin an equal-rule. Tables that should match a like-rule never show up:

 

Using equal and wildcards doesn’t work either

 

Any advice on how I should filter tables properly?

icon

Best answer by bas.hopstaken 31 October 2023, 16:19

View original

3 replies

bas.hopstaken
Rank
Userlevel 3
Badge +4

Hi @erik.van.mastrigt ,

Did you try to use ‘%’ as a wildcard combined with the like operator?

Bas Hopstaken (2Foqus)
erik.van.mastrigt
Rank
Userlevel 3
Badge +2

@bas.hopstaken  Yes, among many other variations. Had also issues with the Search button not working properly. 

Just updated to 6436 and tried the % as wildcard again. Works fine now. Search button works fine too. Don’t know whether it’s the update, I messed things up or something was happening in the background, but so far it seems ok now.

Thanks for the quick response tho :)

bas.hopstaken
Rank
Userlevel 3
Badge +4

Hi @erik.van.mastrigt ,

Some V20.10 versions also had this problem. This was fixed in V20.10.40.64.:
 

I had this issue for customers running version V20.10.x. After clicking the search button in the Select tables, I directly checked the Event Viewer and I noticed an error about the System.Memory.dll. 

Maybe this was the same issue as the one you are facing. 

Bas Hopstaken (2Foqus)

Reply


Terms and ConditionsCookie settings