CPI-C Initialization Failure

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is the service name ("sapgw00") correct? The error message suggests that it can not be found.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
anusha
Premium Member
Premium Member
Posts: 37
Joined: Wed Nov 28, 2007 1:29 am
Location: pune

Post by anusha »

ray.wurlod wrote:Is the service name ("sapgw00") correct? The error message suggests that it can not be found. ...
service name ("sapgw00") is correct and having a valid entry in services file... plz give me some tips how to resolve this problem...
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Post by PhilHibbs »

Have your SAP basis team (DBAs) installed the DataStage RFC on the SAP box? This should be in a file ZDSRFC.txt (ZDSRFCU.txt for Unicode SAP systems) on the DS SAP PACK CD.
Phil Hibbs | Capgemini
Technical Consultant
anusha
Premium Member
Premium Member
Posts: 37
Joined: Wed Nov 28, 2007 1:29 am
Location: pune

Post by anusha »

1)
I had forwarded the ZDSRFC.txt and ZDSRFCU.txt files to SAP basis team. In those files I found 'Z_RFC_DS_SERVICE' function module only. They had created that function module but still getting the same errors.

2)
Parallely I had created a new job which is using RFC Data Transfer method; I am getting a syntax error in ABAP Program as:

Line = 48
Offset = 26
Error Message = The type "ZETLTRSF" is unknown.

Part of program where I get error:

* Step 3 & 4. Table data and structure for RFC
DATA:
ETLTRSFTAB TYPE TABLE OF ZETLTRSF INITIAL SIZE 320 WITH HEADER LINE,
ETLTRSFSTRUCTURE TYPE ZETLSTR,
ETLTRSFSTRUCTURE_START TYPE ZETLSTR,
RFCTABLESIZE TYPE I,
RFCDEST(32) TYPE C,
RFCDESTC(32) TYPE C,
RFCQUEUE(24) TYPE C,
D_PACK(32000) TYPE C,
D_OFFSET_TMP TYPE I,
D_OFFSET TYPE I,
D_LEN TYPE I.

I checked for ZETLTRSF, but haven't found it in SAP system or in pack. Do anyone know about function/structure of ZETLTRSF. If then please provide me information or guide me from where can I get it.

Any solution on anyone of above two problems would be highly appreciated...

Thank you.
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Post by PhilHibbs »

Is the user (in the original case) a CPI-C user? You can't use a dialog user to do a CPI-C query. I don't know about RFC queries.
Phil Hibbs | Capgemini
Technical Consultant
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Post by PhilHibbs »

Ooh, this is taking me back a bit, I do remember something about setting up services with names like "sapgw00" on the DataSTage server but I wasn't directly involved in it. Let me see if I can dig anything out, will update this post if I can.

Found it - see page A13 of the dsr3.pdf document, I don't understand a word of it but it seems to be relevant.
Phil Hibbs | Capgemini
Technical Consultant
anusha
Premium Member
Premium Member
Posts: 37
Joined: Wed Nov 28, 2007 1:29 am
Location: pune

Post by anusha »

I have updated the services file with a valid entry on DataStage Server long back...

sapgw00 3300/tcp // check whether you are talking about the same entry.

I haven't found dsr3.pdf file anywhere, Can you please guide me from where can I get it?? or if possible post the relevent content here.
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Post by PhilHibbs »

It should be on your SAP PACK Installation CD, in client/ENU (not sure about where that folder actually is on the CD, I just have a copy of the installation files on a server).
Configuring the SAP/Dispatch/Gateway Service
In order to use the DataStage PACK for SAP R/3 correctly, you must add entries
for the SAP Dispatch/Gateway service to the services file for your DataStage client
and server systems. If SAP R/3 is already configured on the DataStage client and
server systems, these entries may already be added.
The location of the services file depends on your platform:
Windows NT: \winnt\system32\drivers\etc\services
Unix: /etc/services
Add the following entries to the services file:
#
# SAP Port
#
sapdp00 3200/tcp
sapdp01 3201/tcp
sapdp02 3202/tcp
sapdp03 3203/tcp
...
sapdp98 3298/tcp
sapdp99 3299/tcp
sapgw00 3300/tcp
sapgw01 3301/tcp
sapgw02 3302/tcp
...
So if you already have sapgw00 3300/tcp then this has already been done. I'm a bit stumped.
Phil Hibbs | Capgemini
Technical Consultant
Post Reply