return code:4 error when releasing request to tranport BI query

[Former Member]

hi

I am getting error when i release a request containing a BI query.

here is the error log attached:

   Start export R3TRELEMD7IIQ7LI9TI4LX5YUCXVI6ZB1 ...                                                                                  |
     | scrap char 0x0000 found in RSZELTPROP.SWITCHID, it will be coerced to ' ' automatically                                             |
     -----------------------------------------------------------------------------------------------------------------------------------------
|   Start export R3TRELEMD7IITCMTYM6FXVJE3E36SNZ99 ...                                                                                  |
     | scrap char 0x0000 found in RSZELTPROP.SWITCHID, it will be coerced to ' ' automatically                                             |
     -----------------------------------------------------------------------------------------------------------------------------------------
|   Start export R3TRELEMD7IIU0FZ6B02L5CRVZ6462GJH ...                                                                                  |
     | scrap char 0x0000 found in RSZELTPROP.SWITCHID, it will be coerced to ' ' automatically                                             |
     ----------------------------------------------------------------------------------------------------------------------------------------                                                           
|   Start export R3TRELEMD8DSSE5HLJP02TCNEJW17U33X ...                                                                                  |
     | scrap char 0x0000 found in RSZELTPROP.SWITCHID, it will be coerced to ' ' automatically    

Start export R3TRSBEPDE9D246F7A4612F194C30050568E363D ...                                                                           |
     |     0 entries from TADIR exported (R3TRSBEPDE9D246F7A4612F194C30050568E363D        ).                                                 |
     |     0 entries from SMODILOG exported (SBEPDE9D246F7A4612F194C30050568E363D        *).                                                 |
     |     0 entries from SMODISRC exported (CISBEPDE9D246F7A4612F194C30050568E363D        *).                                               |
     |     0 entries from SMODISRC exported (CUSBEPDE9D246F7A4612F194C30050568E363D        *).                                               |
     |     0 entries from SMODISRC exported (CVSBEPDE9D246F7A4612F194C30050568E363D        *).                                               |
     |     0 entries from SMODISRC exported (PRSBEPDE9D246F7A4612F194C30050568E363D        *).                                               |
     |     0 entries from SMODISRC exported (SVSBEPDE9D246F7A4612F194C30050568E363D        *).                                               |
     |     1 entry from BDSPHIO8 exported (DE9D246F7A4612F194C30050568E363D).                                                                |
     |     0 entries from BDSCONT8 exported (DHDE9D246F7A4612F194C30050568E363D*).                                                           |
     |     1 entry from BDSCONT8 exported (IRDE9D246F7A4612F194C30050568E363D*).                                                             |
     |     1 entry from BDSPHF8 exported (DE9D246F7A4612F194C30050568E363D*).                                                                |
     |     1 entry from BDSPHPR8 exported (DE9D246F7A4612F194C30050568E363D*).                                                               |
     |     0 entries from BDSPHHR8 exported (DE9D246F7A4612F194C30050568E363D*).                                                             |
     |     0 entries from BDSPHRE8 exported (DE9D246F7A4612F194C30050568E363D*).                                                             |
     |     0 entries from BDSPHRI8 exported (DE9D246F7A4612F194C30050568E363D*).                                                             |
     |     0 entries from BDSPHNM8 exported (DE9D246F7A4612F194C30050568E363D*).                                                             |
     |     1 entry from BDSCONT8 exported (INDE9D246F7A4612F194C30050568E363D*).                                                             |
     |   End of export R3TRSBEPDE9D246F7A4612F194C30050568E363D                                                                              |
     |   NWDK900494 touched.                                                                                                                 |
     |   NWDK900494 released.                                                                                                                |
     |   15558511 bytes written.                                                                                                             |
     |   Transport overhead 58.4 %.                                                                                                          |
     |   Data compressed to 36.7 %.                                                                                                          |
     |   Duration: 2:07 min (122507 bytes/sec).                                                                                              |
     |     0 tables in P-buffer synchronized.                                                                                                |
     |     0 tables in R-buffer synchronized.                                                                                                |
     |   167424 167424                                                                                                                       |
     |                                                                                                                                       |
     |   Summary:                                                                                                                            |
     |                                                                                                                                       |
     |     1 COMML exported                                                                                                                  |
     |     1 COMMT exported                                                                                                                  |
     |   73701 DELETE commands exported                                                                                                      |
     |   Totally 8773 tabentries exported                                                                                                    |
     |                                                                                                                                       |
     |    [dev trc     ,00000]  Thu Jun 21 10:15:05 2012                                             121474161  127.479446                   |
     |    [dev trc     ,00000]  Disconnecting from ALL connections:                                       27  127.479473                     |
     |    [dev trc     ,00000]  Disconnecting from connection 0 ...                                       39  127.479512                     |
     |    [dev trc     ,00000]  Closing user session (con_hdl=0,svchp=0000000000314878,usrhp=0000000000313A08)                               |
     |                                                                                                  2225  127.481737                     |
     |    [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0000000000314878,srvhp=00000000062630E8)                           |
     |                                                                                                   803  127.482540                     |
     |    [dev trc     ,00000]  Now I'm disconnected from ORACLE                                         627  127.483167                     |
     |    [dev trc     ,00000]  Disconnected from connection 0                                            63  127.483230                     |
     |    [dev trc     ,00000]  statistics db_con_commit (com_total=2, com_tx=2)                          34  127.483264                     |
     |    [dev trc     ,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)                      31  127.483295                     |
     |   Disconnected from database.                                                                                                         |
     |   End of Transport (0004).                                                                                                            |
     |   date&time: 21.06.2012 - 10:15:05                                                                                                    |
     |   5 warnings occured.                                                                                                                 |
     |   Main export                                                                                                                         |
     |   End date and time : 20120621101505                                                                                                  |
     | Ended with return code:  ===> 4 <===                                                                                                |
     |   ######################################                                                                                              |
     ---------------------------------------------------

Please help me out

[csaba_goetz]

Hello Harish,

Error code 4 is not an error. It means that transport has succesful ended (with some warnings what you can ignore).

Best regards,

Adam Csaba Goetz