DBIF_RSQL_SQL_ERROR

[Former Member]

This is the first time that I am posting in sdn.But utilized more than any one else.Thanks to everyone

This dump is coming in Solman system under a Diagnostics User and Iam unable to find out the reason ...

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Short text

SQL error in the database when accessing a table.

What can you do?

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

How to correct the error

Database error text........: "ORA-14400: inserted partition key does not map to

any partition"

Internal call code.........: "[RSQL/INSR//BI0/F0CCMSATPH ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

Thanks for a quickhelp

[raguraman_c · Accepted solution]

Hi,

Paste the complete ST22 dump error. If you are a BASIS consultant you must be aware that we cannot incur anything from the info you provided.

Provide all possible info.

Feel free to revert back.

--Ragu

[Former Member]

Resolved and closing as this is very old

[Former Member]

What was the resolution?

[Former Member]

Hi Shrikanth,

I will really appreciate you if you will share the solution for the above mentioned problem.

As we are facing the same problem.

Regards,

Arun Pathak

[Former Member]

hi,

can you provide resolution to this?

Regards,

Dhanya

[former_member584656]

Try checking the objects involved on transaction RSRV..

Also check notes 991181 and 1236334 (BW7).

Good luck

[Former Member]

Hi srikanth,

I am also facing the same problem.

Please let me know if you have any solution regarding the same.

Regards,

Suresh Babu Gade

[Former Member]

Hi,

Not yet solved.

Problem is on SAP's court.No specific note for BI 7.0 but we can find out an exact hit for next BI version.

Srikanth

[markus_doehr2]

It seems you have some inconsistencies concerning partitioned tables. What support package (SAP_BW) do you use?

Markus

[Former Member]

Thanks Raghuraman/nagaraju/Markus,

Mark - BW support pack level 16 for 7.00.

Db people changed an init paramater fixcontrol=4728348:OFF and as soon this problem persisting they reverted it to "default" recently but no use.

Raghuraman - Yeah , but thought it will be okay for this run time er.

Client.............. 400

User................ "SMD_RFC"

Transaction......... " "

Call Program........."SAPLE2E_FUNC"

Function Module..... "SMD_DATA_LOADER100"

Call Destination.... "NONE"

Additional information on RFC logon:

Trusted Relationship " "

Logon Return Code... 0

Trusted Return Code. 0

Note: For releases < 4.0, information on the RFC caller are often

only partially available.

Information on where terminated

Termination occurred in the ABAP program "GP49K6BEV8THQAQSGP02XSKWSVW" - in

"WRITE_ICFACT".

The main program was "SAPMSSY1 ".

In the source code you have the termination point in line 5424

of the (Include) program "GP49K6BEV8THQAQSGP02XSKWSVW".

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

procedure "WRITE_ICFACT" "(FORM)", but it was neither handled locally nor

declared

in the RAISING clause of its signature.

The procedure is in program "GP49K6BEV8THQAQSGP02XSKWSVW "; its source code

[Former Member]

Hi,

I think your table doesn't have a partition that can

accommodate the partition key of the new record being inserted. You can either add a new partition with a NEW and HIGHER partition key "exclusive_upper_limit" or simply a catch-all "MAXVALUE". But If I were you, I will go for the first option...

alter table <table_name>

add partition <new_partition_name> value less than

(<exclusive_upper_limit>);

Please check the manual, I am not very sure about the syntax...

Pl reward points if it helps.

Thanks,

Naga