topic Database Error for SOOS insert in Application Development and Automation Discussions

Database Error for SOOS insert

Former Member — Thu, 09 Oct 2014 08:49:49 GMT

Hi All,

I am trying to send an email thru SBWP in PRD client 600, Client 500 is working,

The recipient type is Internet address but it show the error "No recipient specified - is the distribution list empty?"

I have tried running RSSODIAD - No inconsistencies found

also used FM EFG_GEN_SEND_EMAIL - the result was failed

error message "database error for <S00S> <insert>"

SCOT is properly configured

Please help

Re: Database Error for SOOS insert

former_member188724 — Thu, 09 Oct 2014 09:31:48 GMT

Hi,

The recipient type is Internet address but it show the error "No recipient specified - is the distribution list empty?"

As you say it is PRD System, whether it works in TST & DEV System.

Please check in debug mode whether recipient is populated in TST or DEV systems?

Also please check manually by passing recipient to check if helps.

For sending emails please check BCS_EXAMPLE_* reports. You can try the same looking at these reports.

Hope it helps.

Regards,

K.S

Re: Database Error for SOOS insert

Former Member — Thu, 09 Oct 2014 09:44:43 GMT

Hi K.S

The SBWP and email is working in DEV TES and PRD client 500 but not in PRD client 600

I have tested BCS_EXAMPLE_* reports in TES and all works i can see the result in SOST

but in PRD 600 see below result (no email generated in SOST)

BCS_EXAMPLE_1	Error Occurred Error Type
BCS_EXAMPLE_2	Error creating personalized copy for DE 09999-1234561
BCS_EXAMPLE_3	Document Sent Successfully
BCS_EXAMPLE_4	Error Occurred Error Type
BCS_EXAMPLE_5	Error Occurred Error Type
BCS_EXAMPLE_6	nothing happening
BCS_EXAMPLE_7	Message no. SO865 Error occurred during transmission - return code:

Re: Database Error for SOOS insert

former_member188724 — Thu, 09 Oct 2014 09:58:22 GMT

Hi,

As you say BCS_EXAMPLE_03 document is sent successfully

please check in SOST whether you have all check boxes checked for Tabs send Status & Options to check whether it is visible.

Regards,

K.S

Re: Database Error for SOOS insert

Former Member — Thu, 09 Oct 2014 10:04:58 GMT

Hi K.S

Still no values in SOST, but i found an entry in my inbox

test created by BCS_EXAMPLE_3

--------------------------------------------------------------------------------

This is my little note

Thanks!

Re: Database Error for SOOS insert

former_member188724 — Thu, 09 Oct 2014 11:25:29 GMT

Hi,

This may be because SCOT is configured like this.

I get mails to my inbox in PRD directly but in Test System I will find an entry in SOST.

When it is sent from BCS---03 please try to simulate the code and check what happens.

Errors in other bcs programs can be checked as I can see in 02 there is fax hard codes by SAP and they have asked to change it . thats the reason for error.similarly we can check for other programs also for the error type.

Please try and let me know.

Regards,

K.S

Re: Database Error for SOOS insert

shashikant_maurya — Thu, 09 Oct 2014 11:41:12 GMT

Hi for this FM, you have to provide the recipient, which is an importing parameter of the FM.

you have 2 possible options for RECIPIENT. one is it itself, the other one is the I_TAB_RECIPIENTS in table tab. Even if you dont use the latter one, it's perfectly ok. But you'll have to use the first parameter.

Example: you want to send the email to 2 user id's. So, the one to whom you want to send the email as primary will come to the receiver and the one which you wan to keep in CC, you can append the id's to the table and pass it to the FM . Try this and you'll not face the Error.

I'am replying just because your post is still now assumed answered or correct answer

Re: Database Error for SOOS insert

Former Member — Fri, 10 Oct 2014 01:01:26 GMT

Hi All,

Thanks for all the help!

the issue is now resolved, one of our ABAPers debug the FM and found we cannot insert new values in table SOES (but the error being generated was for table SOOS)

Resolution:

Fixed the number ranges for SO_OBJ_ADR - SAPoffice: Object to avoid duplicate