11 Replies Latest reply: Apr 1, 2014 11:52 AM by Scott Summers RSS

Database error 7719 at EXE

Scott Summers
Currently Being Moderated

Hi community,

 

We are running SAP EHP 1 for SAP Solution Manager 7.0 on MS SQL Server 2005 Release 9.00.3042  DB.

 

From this morning without install/update/change nothing, we have got on systemlog and trace data, lot of entries with this detail:

 

Database error 7719 at EXE

 

ExecuteAndFlush return code: 0x80040e14 Stmt: [ALTER PARTITION FUNCTION [/BI0/F0SMD_PE2H_PFUN0]() SPLIT RANGE (0000001009) ]

sloledb.cpp [ExecuteAndFlush,line 6678]: Error/Message: (err 7719, sev 0), CREATE/ALTER partition function failed as only a maxim

Procname: [ExecuteAndFlush - no proc]

DbSlExecute - Error 99 (dbcode 7719) on DDLExecute

DbSlExecute - <ALTER PARTITION FUNCTION [/BI0/F0SMD_PE2H_PFUN0]() SPLIT RANGE (0000001009) >

dbdsmss: DBSL99 SQL7719

CREATE/ALTER partition function failed as only a maximum of 1000 partitions can be created.

***LOG BY2=> sql error 7719       performing EXE        [dbds#2 @ 699] [dbds    0699 ]

***LOG BY0=> CREATE/ALTER partition function failed as only a maximum of 1000 partitions can be created. [dbds#2 @ 699] [dbds

***LOG BY2=> sql error 7719       performing EXE        [dbacds#2 @ 893] [dbacds  0893 ]

 

On SE14 I found anything whit the name /BI0/F0SMD_PE2H table and function /BI0/F0SMD_PE2H_PFUN0. Check option was succesfully but indicates number of partitions =1000.

 

After look for any similar situation, I didn't found nothing except this SDN Thread: BI : msg " Database error 7719 at EXE " during loading Here the solution applied is not valid to our system because the OSS Note 1494789 - Enabling 1000+ partitions support on SQL Server is by SQL Server 2008 SP2 (not our version).

 

On OSS Note 1010854 - Table with too many partitions on SQL Server 2005/2008 I am not really sure about if the solution(symptom2)  fits to our problem.

 

And on OSS Note Note 869407 - Partitioning on Microsoft SQL Server i didn't correct with tool RSDD_MSSQL_CUBEANALYZE because we don't have enabled the (vardecimal) compression.

 

Do you know how can I achive this error???

Thanks in advance!

 

Scottie

  • Re: Database error 7719 at EXE
    Scott Summers
    Currently Being Moderated

    By OSS Note 991014 (Vardecimal) Compression for SQL Server 2005 SP2 I have undertood I should use "BW compression" to reduce the number of partitions of the Infocube identified before.

     

    Vardecimal compression is not enabled on our DB.

     

    Wiht execution of  RSDD_MSSQL_CUBEANALYZE report I can not repear this.....

     

    How can I do this with MSSQL 2005 SP2 ???

     

    Thanks again mates

    Scottie

  • Re: Database error 7719 at EXE
    Roger Duarte
    Currently Being Moderated

    Hi Scott,

     

    Which note have you used to solve this problem?

     

    1010854, 1494789  ??

     

     

    Thanks in advance

    Roger.

  • Re: Database error 7719 at EXE
    Leslie Moser
    Currently Being Moderated

    Hi Roger,

     

    We recently released SAP Note 1637822 which discusses the 7719 error message specifically when it occurs in SAP Solution Manager systems (see Issue and Solution 2 in the Note). SAP Solution Manager uses the SAP NetWeaver BW functionality in a different way than a pure BW system so there are some administrative tasks you absolutely must perform on an SAP Solution Manager system. This is true whether you have the 1000 partition limit or the 15000 partition limit.

     

    The SAP Note will be updated whenever something specific for SAP Solution Manager on MS SQL Server arises.

     

    Also, just as an FYI to everyone...we release SQL Server specific Solution Manager and CCMS (RZ20) Notes in the queue BC-DB-MSS-CCM. Be sure that you search for Notes with the component filter BC-DB-MSS* if you have an issue in one of those areas. If you specify only BC-DB-MSS then you will not get Notes from the subqueue.

     

    Best regards,

    Leslie

    ___________________________

    Leslie Moser

    Developer, Microsoft Platforms U.S.

    Netweaver Development Tools

    SAP Labs, LLC

  • Re: Database error 7719 at EXE
    Scott Summers
    Currently Being Moderated

    Hi all,

     

    I didn't received any notification about your answers...hope it arrives on time...

     

    When i said "Solved by collapse infocube with more than 1000 partitions", was doing this:

     

    SOLMAN, TCODE RSA1, locate the infoprovider which is appearing on the system log, then select Manage and go Request tab and check the number of the problematic request and go to collapse tab and release the Request ID in a job_name "BI_COMP" + request ID...

     

    That worked for me....

     

    Scottie

  • Re: Database error 7719 at EXE
    Ravi Pandey
    Currently Being Moderated

    Hi Scot,

     

    In my Solman system we are getting exaclty same error.
    Could you please let me know how you figured out which Info provider we need to compress in RSA1.

    How to find out the which info provider we need to compress not able to ge tthe details from SM21.

    Also let us know by increasing the partions value from 1000 to 15000 will help in resolving this issue.

    Appreciate your response on this.

     

    Thanks & Regards

    Ravi

     

    Message was edited by: Ravi Pandey

    • Re: Database error 7719 at EXE
      Scott Summers
      Currently Being Moderated

      Dear Ravi,

       

      Please check at sm21 tcode the error, look for the number of dialog process involved, and go to ST11 tcode to open the trace and here you get the detail.

       

      About increase partitions.... it depends of the MS SQL server version you are running. Check it at oss notes restrictions on 2005 and lower versions....

       

      Regards

  • Re: Database error 7719 at EXE
    Ravi Pandey
    Currently Being Moderated

    Dear Scott,

    Below is the detail from St11. I searched with "/BI0/F0SMD_PE2H_PFUN000" with these in RSA1 tcode but was not able to find the any info provider.

    By looking at the below details would you be able to tell me which info provider i should be considering for compression let me know if more details is required in this regards.

     

    Your Help is very much appreciated.

     

    Mon Mar 24 09:33:18 2014

    ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 6828]

    (7719) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE/ALTER partition function failed as only a maximum of

    DbSlExecute - Error 99 (dbcode 7719) on DDLExecute

    DbSlExecute - <ALTER PARTITION FUNCTION [/BI0/F0SMD_PE2H_PFUN000]() SPLIT RANGE (0000001069) >

    dbdsmss: DBSL99 SQL7719

    CREATE/ALTER partition function failed as only a maximum of 1000 partitions can be created.

    ***LOG BY2=> sql error 7719       performing EXE        [dbds         578]

    ***LOG BY0=> CREATE/ALTER partition function failed as only a maximum of 1000 partitions can be created. [dbds         578]

    ***LOG BY2=> sql error 7719       performing EXE        [dbacds       1131]

    • Re: Database error 7719 at EXE
      Scott Summers
      Currently Being Moderated

      Dear Ravi,

       

      Please check sap notes and documentation before you proceed.

       

      In my situation, i solved doing this:

      Go to RSA1 and select infoprovider node, then as you pasted here from ST11, go to node SAP solution Manager Infroprovider /tech name(0SM_SSM) and expand it, as you pasted, the infocube is F0SMD_PE2H.... so go to the specified node and expand it (In your case, Sap solution manager diagnostics and SMD performance data hour -PE2H- ), right click and select Manage, then go to "collapse" tab and check it and if is it the case, release a collapse job for it. Check the job execution.

       

      Please, look for OSS notes or help docs or SDN forums before you execute any task to be safe with your DB & SAP version.

       

      Scottie

Actions