Forum Discussion

Randyr's avatar
Randyr
Frequent Visitor
9 years ago
Solved

ODBC Error with Cache DB

Hello,

 

I am brand new to Power BI and I am trying to pull data in from Avaya Aura Contact Centre which is an Intersystems Cache DB.  I am able to see the tables however when I select one of the tables to actually view the data, I am getting the following error.

 

DataSource.Error: ODBC: ERROR [42000] [Cache ODBC][State : 37000][Native Code 1]
[C:\Program Files\Microsoft Power BI Desktop\bin\Microsoft.Mashup.Container.NetFX40.exe]
[SQLCODE: <-1>:<Invalid SQL statement>]
[Location: <Prepare>]
[%msg: < IDENTIFIER expected, LITERAL ('') found^select "Timestamp" , "ApplicationID" , "Application" , "CallsAbandoned" , "CallsAbandonedAftThreshold" , "CallsAbandonedDelay" , "CallsAnswered" , "CallsAnsweredAftThreshold" , "CallsAnsweredDelay" , "CallsAnsweredDelayAtSkillset" , "CallsConferencedIn" , "CallsCo
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=CCMS)CACHE

 

 

I am able to look at this data using Crystal Reports so I am not sure what what I am doing wrong.  I updated the ODBC driver (x64) but that did not work. I appreciate any assistance you can provide.

 

Thank you! 

 

RR

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Randyr,

    Glad to hear the issue is solved. You can accept your reply as answer, that way, other community members would benefit from your solutions once they get same issues.

    Thanks,
    Lydia Zhang

12 Replies

  • hugoberry's avatar
    hugoberry
    Responsive Resident
    9 years ago

    Try replacing " in your select query...

    select "Timestamp" , "ApplicationID" , "Application" , "CallsAbandoned" , "CallsAbandonedAftThreshold" , "CallsAbandonedDelay" , 

    • Randyr's avatar
      Randyr
      Frequent Visitor
      9 years ago

      Thank you Hugoberry, this makes perfect sense to me however I do not see anywhere in the Query editor where I can change this select query??

       

      Sorry for being a newbie

      • hugoberry's avatar
        hugoberry
        Responsive Resident
        9 years ago

        It is hard to tell without having access to your query.

        If you loaded the data from Get Data>ODBC  there is an Advanced option which you can use

  • Randyr's avatar
    Randyr
    Frequent Visitor
    9 years ago

    Hello,

     

    When you are setting your data source, under 'advanced options' you can add an SQL statement. I simply added

     

    select * from iAgentPerformanceStat  

     

    or

     

    select * from mApplicationStat  

     

    Depending on what data you are looking for. (Agent or Application data)

     

    I hope this is helpful

     

    RR