Finally, its working. We have versioning enabled in v8, where I am a first time user. The issue was due to some of my source tables not being checked-in.
The infa scheduler requires all its components to be 'CHECKED-IN', otherwise it fails the session.
This is how I found out my items which...
Hi Artichoke,
The workflow/session is running correctly, when its run manually. No errors.
But, session is failing when I schedule it. And there are no session logs generated. Its on v8.6.0.
Is it still a session or mapping invalid issue ?
Hi,
I have scheduled the workflow, but the sessions are failing.
All my objects are also checked-in, as suggested by some to check. Can anyone tell me whats happening by giving a look at my workflow error log. I have 2 session task for this workflow (tester1, tester2).
LM_36435 Starting...
Hi RasETL / Blom,
The volume of data is very less. I am implementing the truncate and load method now. This is working very well.
Also, will be trying what Blom has suggested in the earlier post of composite key. (just curious to see how it can be implemented)
ThankYou !
Hi Blom,
Thanks for replying back.
For the 1st day, Target is null and I insert all the records. Now for the 2nd day(problem starts here), Number(1) has an update to Appointment State, updated to ‘FL’ and there are 2 new records, Number(5). Other records, no change.
Number (PK) Name State...
Hello Everyone,
My Source data is structured as below,
Number (PK) Name State AppointedState Lines
1 Michael CO CO A
1 Michael CO CO H
2 George HI AZ A
2 George HI AZ H
3 Cindy AR AR H
3 Cindy AR CA A
3 Cindy AR CA H
3 Cindy AR IA A
3 Cindy AR IA H
3 Cindy AR ID A
3 Cindy AR KY A
3 Cindy AR OH...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.