Recently, i migrating from BODI to BODS and i got a problem after migration.
When i execute my job in BODS, i got an error that say :
Data flow D2_7_Xtraction_Abennp|Loader Q_Distinct_XADOSOC
The SQL query submitted to the ODBC data source <QDSN_S3> generated an error <[IBM][Pilote ODBC System i Access][DB2 for i5/OS]SQL7008 - Table XADOSOC of DWRECPTDEV incorrect for this operation.>. RequÃªte SQL soumise : <DELETE FROM “DWRECPTDEV”.“XADOSOC” >.
It goes with this error :
The execution of for target failed.
I’ve searched on google and it seems to be a Journaling issues, but my database / table is already Journalised.
And when i checked about the user right to delete the table data, everything was already good, i can delete the table’s data with SQL command.
I don’t know what to do anymore.
tlawie (BOB member since 2020-02-25)