Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Database Error for SOOS insert

Former Member
0 Likes
2,900

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

7 REPLIES 7
Read only

former_member188724
Contributor
0 Likes
2,117

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

Read only

0 Likes
2,117

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_1Error Occurred                                     Error Type
BCS_EXAMPLE_2Error creating personalized copy for DE 09999-1234561
BCS_EXAMPLE_3Document Sent Successfully
BCS_EXAMPLE_4Error Occurred                                     Error Type
BCS_EXAMPLE_5Error Occurred                                     Error Type
BCS_EXAMPLE_6nothing happening
BCS_EXAMPLE_7Message no. SO865 Error occurred during transmission - return code:
Read only

0 Likes
2,117

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


Read only

0 Likes
2,117

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!

Read only

0 Likes
2,117

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


Read only

0 Likes
2,117

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

Read only

Former Member
0 Likes
2,117

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