on 02-29-2012 3:11 PM
Hi All,
There is a text file(.txt) which comes from mainframes team every Sunday between 11 AM to 6 PM and gets placed in AL11 inbound directory following which we manually trigger a process chain which uses this file.
The requirement is that this chain should trigger automatically after the file arrives in AL11 in BW.
Is it necessary for the mainframe team to send another control file or some other file in addition to the text file to trigger this process chain..?
Is there any other way the process chain can be triggered in BW without any changes required from the mainframe team.
Additional information:
Also I came to know that this can happen through some system command statements using SM49 we can schedule this chain.
Else can some ABAP Program code be used to make this process automatic?
Please help me.
Dear,
Let me make it more clear
The event process will only trigger the process chain if the preceeding event is finished.But if you want to trigger the process chain automatically when ever the flat file is placed in AL11(Al11 is nothing but the application server it just looks like a portal or a folder )when you place a file in the application server or AL11 depending on the recent time stamp the process chain has to trigger for that you need to maintain a program with the help of Abap.
The other way around is write a program that checks the Al11 for the specific mentioned path at regular intervals so when there is a check the programm will trigger the process chain .
Also you can create an event as said in the discussion and keep that variant in the start variant of the start process and you can make a condition in program saying that when the time stamp is changed trigger the respective variant.
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
I need an ABAP program to be inserted in the process chain.
This ABAP program should pick the flatfile from local workstation and paste in the Application server.
I have an ABAP program which runs succesfully when i execute it manually, However if i keep it in PC it is not working.
please suggest me solutions for my requirement.
Thanks & Regards,
Kavitha
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
we ha same requirement in our project.
we created Ztransaction and linked the process chain to that ztransaction.and gave authorization to the particular user for that transaction.
User placess the file in server and execute the transaction , then the process Chain will star and the file loads into the BW.
we took abaper help to create the trnsaction.
Thanks
HP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Adlin ,
In my previous Projects we were doing this .
1. Current Project has Control M for scheduling all the BW Batch Jobs for Process Chains etc. Control M is mainly used for scheduling the various jobs . Our Process chain Start variant has Event which is triggered from Control M when ever the file comes at the application year .Basically there are Control M Jobs defined to check whether the file is available or not .One the File if there it would trigger the BW Event which in turn would trigger the Process Chain like wise.
2. Similary in one of my previous Project we had Redwood to take care of all such dependencies and all the BW Jobs were scheduled from Redwood.
Hope it helps.
Thanks
Kamal
Hi,
We have created simple flat file datasource with Adapter property set to "Load Text-Type File from Local workstation" in extraction. this is PI interface.
It gives an option to preview the data in datasource itself. Then mention the file path from AL11 in infopackage. put immediate option in start variant of PC.
also contact BASIS team for an connection issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Who is maintaining this communication channel. Ask your Basis or PI team.
They can help you in this situation because you do not have control to this file.
As said above, once the file is placed in AL11; an event should be triggered which schedules your process chain.
Your part in this is to create an event and give it to the start variant of process chain.
XI/PI team can write an ABAP code to trigger the event once the file is placed in AL11.
Regards,
Sunil
The process chain has a start variant. In that start variant, you make it as 'AFTER EVENT'. Create an user-defined event in SM64/ SM62 and put this event name and parameter name at start variant.
Now when the file is available in Appl Server by mainframe, please use an os command to trigger that event. Then the pc will start automatically.
I did not face the same situation but pleae try this out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can do the following, in your process chain change the start variant and make it event dependent. Now you can do the following,
1) Create a table in SE11 which will have fields like Process chain name and execution date as primary fields. This table will be used further for checking purpose.
2) Now create a ABAP program as shown in below given article, in this program in addition to raising an event you will have to read the file from app server.
3) If program can read file from app server means you will raise an event and make entry in above table for preventing further execution of process chain. If program can't read file from app server then program will simply end without doing anything.
4) Now you can schedule this program after every hour or 30 min. as per your requirement, the program will first check if the process chain execution entry exists in the above 'Z' table or not. If entry exists means the process chain has been already executed and the program will be terminated.
5) You can use FM to read data from app server. You need to be careful while placing file on app server, because it has to be different naming convention or something else to identify that the current day file is available.
[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a01cc44a-5aac-2d10-3eaa-a3bbf645d25c?QuickLink=index&overridelayout=true]
Regards,
Durgesh.
Hi Durgesh,
Thanks a lot firstly for your response.
I want to clarify a few points in this.
Please correct me if wrong also please tell if the below points are possible.
The file name is same and it comes on every sunday. however i thought that while writing ABAP program we can have an additional condition to check for todays sysdate which will pick the file fpr particular day.
Is there a possibilty that the program will not be checking the file every 30 mnutes but will trigger only once after the arrival after file in AL11. Please suggest me if i can use system command (SM49) to achieve this.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.