Data missing in random columns in Analyses (12c 12.2.1.2)

JustTheFacts

Thanks for the suggestion, Matt, but it's not "a" column. Which column will show up as empty changes depending on how I change the request, and a column which was blank before might show data if I change the request slightly. The first post has the details.

Christian Berg-0racle

If it does a merge for you rather than a replace you can always use the datamodel command with the -D option.

JustTheFacts

Yeah, well it's weird. It definitely replaces the webcat and the jazn. Just the RPD is left alone. Not even "merged", I'd say. At least, it didn't add any Sample App subject area(s) into it. Just my little baby test model was in there.

To use datamodel, I'd need just the RPD from the SampleApp BAR file, right? I'll Google how to get that extracted.

At the suggestion of our client rep, we submitted a priority 1 SR on this issue, and we have a webex with the tech tomorrow. I'm keen to see if this is a "duh, just do X" solution or if we stump the support tech also.

Christian Berg-0racle

Yes you need the RPD from the BAR. You can simply open any BAR with 7z and get the RPD out.

JustTheFacts

Oracle support's determination: "Hmm...that's strange."

I was very impressed that we skipped past all of the usual "do A, then B, then C" stuff - stuff which we've already eliminated as a cause - and got right down to a demo of the issue. One of my best Oracle Support experiences so far. The rep clearly understands what the issue is and, more importantly, what it is not.

We were able to test this issue on a Windows 12c installation, and could not reproduce it. So, Teradata only, Linux only. We're talking to Teradata now about recommended ODBC parameters in Linux. Maybe we've got some obscure setting wrong, even though the SQL does return the correct results if run directly using tdxodbc64.sh.

Christian Berg-0racle

Wow. That's bad. But thanks for updating us!

JustTheFacts

Final comment for anybody who happens upon this thread later:

This is a KNOWN BUG and there is a patch available for 12.2.1.2 (but not, as I understand it, for previous versions). Look for "Patch 25887247: TRACKING BUG FOR DATADIRECT 8.0.1 ODBC DRIVER MANAGER". Bug # is 25887247 however this does not appear to be publicly available.

After installing the patch, the problem went away.

Christian Berg-0racle

Thanks for that update!

Gianni Ceresa

Can you flag your last post as the correct one? So people will not have to read everything and will directly see the answer (and it will also close the thread which is This question is Not Answered. for now)