SAP Knowledge Base Article - Preview

2698989 - DTP job performance degradation post upgrading BW kernel PL 500 of release 749 - SAP IQ

Symptom

  • Data Transfer Process (DTP) jobs in BW that are making DataStore Object requests to pull in NLS archived data from SAP IQ  start running considerably slower post upgrading BW to Kernel release 749, Patch Level 500

  • ST12 tracing on the BW side shows these types of errors
    C *** ERROR => parse error at field 2; statement: INSERT INTO "/BIC/OMTLT_2018092409461154335" ( "DOC_NUMBER", "S_ORD_ITEM" )
    VALUES ( ? , ? )/*USE_IQ_LOAD*/
    /* R3:CL_SQL_STATEMENT==============CP:1114 T:/BIC/OMTLT_2018092409461154335 */
    [dbsyb.c 34532]
    C {root-id=D89D676186C81EE8AFFBC6C634572FE0}_{conn-id=00000000000000000000000000000000}_0
    C *** ERROR => meta data length 1 <= 1
    [dbsyb.c 55623]
    C *** ERROR => creation of load specification failed.
    [dbsyb.c 34532]
    C could not start iq load - failback to standard DML operation.
    C *** ERROR => could not lock table before array insert to IQ - table name is unknown.
    [dbsyb.c 34532

     

  • Looking at corresponding INSERT operation messages seen in the iqmsg file  or the srv server log on the SAP IQ side ,  batch inserts suddenly switch to single row inserts. For example…
    09/24 23:09:44. Insert for '/BIC/OMTLT_2018092421094454585' completed in 0 seconds.  31522 rows inserted.
    09/24 23:09:48. Insert for '/BIC/OMTLT_2018092421094840691' completed in 0 seconds.  32724 rows inserted.
    09/24 23:09:49. Insert for '/BIC/OMTLT_2018092409461154335' completed in 0 seconds.  1 rows inserted.<< ---- Single Array Inserts start instead of batch
    09/24 23:09:49. Insert for '/BIC/OMTLT_2018092409461154335' completed in 0 seconds.  1 rows inserted.
    09/24 23:09:49. Insert for '/BIC/OMTLT_2018092409461154335' completed in 0 seconds.  1 rows inserted.
     … etc.

     

  • SAP IQ request level logging for tracing the SQL executed shows that instead of requesting a write LOCK TABLE and running a batch  LOAD TABLE statement  only single row INSERT INTO is run.

Read more...

Environment

  • BW Kernel release 749, Patch Level 500, DBSL version 749.05,DBSL Patch Level 500 

  • SAP IQ 16.0 SP11.*

Product

PBS CBW NLS IQ 7.3 ; SAP IQ 16.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

sybase, slow, fails, 'BW/NLS', CR816778, CR#816778, 816778, DBSL, 'Job Work', failback, longer, locking, fetch, DBCO, 'trace data', ZMIEUO15, ZMIEUO20 , KBA , bidtpr , rsda_syb 011 , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.