Forum Discussion

jessi82315's avatar
jessi82315
Helper I
4 years ago
Solved

random ODBC error DAY INF LAG NAN NOT RID ROW RRN CASE CAST CHAR DATE

Hello,

 

My report had been running without problem but recently, after hitting the refresh button, I keep getting error message below: 

 

ODBC: ERROR [42000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token  was not valid. Valid tokens: ( + - ? : DAY INF LAG NAN NOT RID ROW RRN CASE CAST CHAR DATE.

 

and it is random. I could refresh the data successfully in like every 2 or 3 attempts.

 

I already tried re-entering the username and password to the DB, it worded for half day and now I still get the error messages...

I've seen people saying merging external and internal (already in the query editor) data source could cause problem but the two tables I have are all internal for the merged table that has the problem.

 

My Power BI is also up to date. (Feb 2022 version)

 

Any ideas how to fix this? 

 

Thanks

Jessie

  • you could have a really sketchy network connection that is randomly dropping or distorting packets. Or maybe your data source has gone crazy and may need a restart. Doesn't look like this error is related to Power BI

2 Replies

  • you could have a really sketchy network connection that is randomly dropping or distorting packets. Or maybe your data source has gone crazy and may need a restart. Doesn't look like this error is related to Power BI

    • jessi82315's avatar
      jessi82315
      Helper I

      lbendlin 

      Thanks !! I ended up discovering some typos in the SQL statement. The error is gone after I fix the SQL statement!

      But still thanks for providing the input!