Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

XQE-DAT-0001 Data source adapter error: GeneralException

  • 1.  XQE-DAT-0001 Data source adapter error: GeneralException

    Posted Fri January 24, 2020 01:10 PM
    In the Cognos 11 dashboard my team uses we've suddenly started receiving the XQE-DAT-0001 Data source adapter error: GeneralException (more specifics below) on many of our visualizations when refreshing.    Which of the 6-10 visualization on each tab will have the error changes from refresh to refresh, occassionally it's only 1, sometimes it's all of them.  We upload our data to the team content folder in a csv format rather than having a direct feed to the data.  We've been using the same ETL scripts on the same data sources to produce the csv file for more than a month, and this has only recently started.

    There was an issue with the server around the same time as this started where a file was hung and the server was rebooted over the weekend.  We've not been able to confirm if anyone else using the server is having the same issue.

    We've tried...
    • recreating the visualizations within the same dashboard
      • with the same data (this would frequently allow us to get the visualizations to load, but they would not remain on refresh)
      • with the same data but converted from csv to xls, xlsx, and txt
      • with a refreshed data set from the same ETL process
      • a completely different and much smaller data set
    • creating a new dashboard
      • with the same data
      • with the same data but converted from csv to xls, xlsx, and txt
      • with a refreshed data set from the same ETL process
      • a completely different and much smaller data set

    XQE-DAT-0001 Data source adapter error: GeneralException ... following this is different for every time the error is refreshed, but a couple of examples of the first few lines are below.

    XQE-DAT-0001 Data source adapter error: GeneralException(requestId:5072abaf-d375-43c2-afa6-de51e3709fba, message:Failed to make output directory: file:/temp/disp5/temp/XQE/flint/resultCache/3aa376dc-7768-4870-a86d-ec8f4317d32b, trace:java.io.IOException: Failed to make output directory: file:/temp/disp5/temp/XQE/flint/resultCache/3aa376dc-7768-4870-a86d-ec8f4317d32b

    XQE-DAT-0001 Data source adapter error: GeneralException(requestId:a9262e17-c46b-4e53-9b50-0b41e3283dc7, message:Job aborted due to stage failure: Task 0 in stage 30.0 failed 1 times, most recent failure: Lost task 0.0 in stage 30.0 (TID 30, localhost, executor driver): java.lang.NoClassDefFoundError: org.xerial.snappy.Snappy (initialization failure)
    at java.lang.J9VMInternals.initializationAlreadyFailed(J9VMInternals.java:98)
    at org.apache.avro.file.SnappyCodec.compress(SnappyCodec.java:43)
    at org.apache.avro.file.DataFileStream$DataBlock.compressUsing(DataFileStream.java:361)

    ------------------------------
    ELIZABETH L.
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: XQE-DAT-0001 Data source adapter error: GeneralException

    Posted Tue January 28, 2020 09:20 PM

    The second error implies that your file system permissions have noexec on them.

    See admin guide re following.

    Should your admin claim permissions are not the issue, review space on file mount.

    Ensure file permissions do not prevent file uploads

    As of Cognos Analytics 11.1.x, queries involving data sets require that the temporary file location not use a Unix/Linux file system that was mounted with the NOEXEC option. If the file system was mounted with NOEXEC option, it will prevent the creation and subsequent querying of uploaded files/data sets.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message


Related Content