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:
According SM37, job always starts on random application server.
Will be appreciated for any advice.
which version of the SAP connector are you using?
I know that with the connector 5.8 SR1 you can do more configuration.
Please attach you Connection String and I will help you
I use version 5.5
CUSTOM CONNECT TO "Provider=QvSAPReportConnector.dll;MSHOST=SAPMessageServerHostName;R3NAME=00;GROUP=Group1;CLIENT=500;XUserId=user;XPassword=password;";
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)
Could you please explain what is System ID?
For example, target server has parameters (transaction SM51):
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.
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)
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.
Great. Is the problem solved?