Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
427
Views
29
Comments
13»

Answers

  • JustTheFacts
    JustTheFacts Rank 4 - Community Specialist

    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
    Christian Berg-0racle Rank 10 - Analytics Guru

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

  • JustTheFacts
    JustTheFacts Rank 4 - Community Specialist

    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
    Christian Berg-0racle Rank 10 - Analytics Guru

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

  • JustTheFacts
    JustTheFacts Rank 4 - Community Specialist

    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
    Christian Berg-0racle Rank 10 - Analytics Guru

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

  • JustTheFacts
    JustTheFacts Rank 4 - Community Specialist

    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
    Christian Berg-0racle Rank 10 - Analytics Guru

    Thanks for that update!

  • 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)