Business Object Data services - Clean table before load


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 :fr: (BOB member since 2020-02-25)


I got the same error when i try to insert data in another table,

Theo. :nonod:

tlawie :fr: (BOB member since 2020-02-25)

I resolved my problem.

SQL-7008 is an error about journaling database / table and you can bypass by disable commit instruction.

I found this instructions in DataStore parameter in BODS.

The translation in french wasn’t good and i didn’t notice the right checkbox title that was hiden very well.

I can finnaly continue to work ! 8)

tlawie :fr: (BOB member since 2020-02-25)