SAP Report connector. Target server selection

[mrybalko]

I use SAP report connector and I need to select sap application server for job execution. Unfortunately, SAP report connector does not have parameter "TargetServer".

I tried some connection string "tricks" but had no luck:

• Change MSHOST=mytargetservername
• Add parameter TargetServer=mytargetservername 

According SM37, job always starts on random application server.

Will be appreciated for any advice.

[fabrice_lawson]

which version of the SAP connector are you using?

I know that with the connector 5.8 SR1 you can do more configuration.

[Anonymous]

Hi Maxim

Please attach you Connection String and I will help you

Yaniv

[mrybalko]

I use version 5.5

[mrybalko]

Connection string:

CUSTOM CONNECT TO "Provider=QvSAPReportConnector.dll;MSHOST=SAPMessageServerHostName;R3NAME=00;GROUP=Group1;CLIENT=500;XUserId=user;XPassword=password;";

[Anonymous]

Hi Maxim

you need to write the name of the Application Server for paramter MSHOST (i.e. MSHOST=ECCPRD )

also, you need to write the System ID for parameter R3NAME (i.e. R3NAME=ECP)

No need to use parameter GROUP (unless you have a Cluster of Application Servers and you want to use Load Balancing)

Yaniv

[mrybalko]

Hello Yaniv

Could you please explain what is System ID?

For example, target server has parameters (transaction SM51):

• Server Name: er2ap01_ER2
• Host Name: er2ap01

I tried the following string:

CONNECT TO "Provider=QvSAPReportConnector.dll;ASHOST=er2ap01;R3NAME=er2ap01_er2;SYSNR=00;CLIENT=500;XUserId=user;XPassword=password;";

Then I started reload. After that I opened transaction sm37. According to SM37, job was executed on server er2ap12_ER2.

[Anonymous]

Hi Maxim

System ID is 3 Letters representing your system, for example: ECP

In order to figure out you system ID - just ask you Basis team and they will tell you.

I looked at your connection string, you need to put also the SYSNR value (usually it's not 00)

Yaniv

[mrybalko]

Thank you for explanation. I asked Basis team about system ID. 

Modified connection string:

CONNECT TO "Provider=QvSAPReportConnector.dll;ASHOST=er2ap01;R3NAME=ER2;SYSNR=00;CLIENT=500;XUserId=user;XPassword=password;";

Job was executed on er2ap06.

SYSNR=00 is correct parameter.

[Anonymous]

Great. Is the problem solved?