I've tried a bunch of tests/work arounds without luck, so hopefully some folks who are much brighter than me can figure out what I'm doing wrong!
I have a DB2 set up with Cognos 10.2, pushing DB2 views through Framework Manager into Cognos. No issues with all but one.
I have stripped the view in question down to two varchar fields. If I drop the fields in a list box in Report studio, I can run the report and/or view tabular data.
If I attempt to put a Detail filter on either field with [FIELD_NAME] = ?FIELD_NAME?, I get a XQE-DAT-0001 Data source adatpor error...Invalid character found in a character string argument of the function "DECFLOAT" SQLCODE = -420, SQLSTATE=22018 error when attempting to run the report or view tabular data.
The data is text - occasion & , . and numbers, but nothing bizarre. I'm able to filter on the same data via another object/view/table without issues.
I can also export the DB2 view data via Datastudio without any issue. The export is clean when viewed in Notepad.
Any thoughts? Thank you in advance for your help!
Resolved:
Downstream there was a left outer join that resulted in some nulls in an integer field. Even though the integer field wasn't being queried upstream into Cognos, it was still throwing that error.
I ended up splitting the left outer joins, with the second one looking for null values in the right table, and populating those with 0, then union-ing them together.